Bill of Entry Process after GST Implementation
Bill of Entry Process after GST Implementation: Item Needs to be assigned as GST & GST customs and recoverable tax to be given as Y Item Definition -> Define Item…
Read MoreSales Order Loader API from Blanket Sales Agreement
CREATE OR REPLACE PACKAGE XX_SO_PROG_PKG as –*************************************************************************************************** — — All rights reserved –*************************************************************************************************** — — Package Name …
Read MoreOracle Blanket Sales Agreement Loader API
CREATE OR REPLACE PACKAGE XX_BSA_LOAD_PKG IS –================= — Global Variables –================= gn_request_id NUMBER := apps.fnd_global.conc_request_id; gn_prog_appl_id NUMBER := apps.fnd_global.prog_appl_id;…
Read MoreUpdate and assign project Roles using PA_PROJECT_PARTIES_PUB
DECLARE l_project_id_PREM PA_PROJECT_PARTIES.PROJECT_ID%TYPE :=NULL; l_project_role VARCHAR2(240) :=NULL; l_resource_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE :=NULL; l_start_date_active DATE :=NULL; l_end_date_active …
Read MoreUpdate Task Information using PA_TASKS_PKG.UPDATE_ROW, PA_PROJ_TASK_STRUC_PUB.UPDATE_TASK_STRUCTURE2 in Oracle Projects
DECLARE l_return_status VARCHAR(10); l_msg_count VARCHAR(240); l_MSG_DATA …
Read MoreCreate Project party in oracle projects accounting using PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY
DECLARE l_project_id_PREM PA_PROJECT_PARTIES.PROJECT_ID%TYPE :=NULL; l_project_role VARCHAR2(240) :=NULL; l_resource_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE :=NULL; l_start_date_active DATE :=NULL; l_end_date_active …
Read MoreCreate or Update HR location in oracle apps
SET DEFINE OFF; CREATE OR REPLACE PACKAGE apps.xxal_hr_location_cre_upd_api AUTHID DEFINER IS l_count NUMBER; l_location_id NUMBER; PROCEDURE create_location ( p_validate …
Read MoreAPI to create projects in Oracle Project Accounting using PA_PROJECT_PUB
SET DEFINE OFF; create or replace PACKAGE apps.xxal_pa_project_creation AUTHID DEFINER IS PROCEDURE create_project ( p_api_version_number IN …
Read MoreUpdate Oracle Project information using PA_PROJECT_PUB.
SET DEFINE OFF; CREATE OR REPLACE PACKAGE BODY apps.xxal_pa_project_creation AS PROCEDURE create_project ( p_api_version_number IN NUMBER …
Read MoreiExpenses – change the lable name in template
From Sysadmin Responsibility: 1. Navigate to the Functional Administrator responsibility à Personalization. 2. Provide Document path like “/oracle/apps/ap/oie/webui/OIEREVIEWSUMMARY” and click on GO tab and from search results Personalize Page icon…
Read More