Oracle Apps Technical Information

/* Formatted on 12/24/2011 4:13:07 PM (QP5 v5.115.810.9015) */ CREATE OR REPLACE PROCEDURE APPS.lmw_asset_activity_insert IS    CURSOR c1    IS       SELECT   *         FROM   lmw_asset_activity_data        WHERE   activity = '1A00501';    l_asset_activity_id          NUMBER;    l_inventory_item_id          NUMBER;    l_organization_id            NUMBER;    l_owningdepartment_id        NUMBER;    l_creation_organization_id   NUMBER;    p_return_status              VARCHAR2 (100);    p_msg_count                  NUMBER;    p_msg_data                   VARCHAR2 (2000);  ...

STEP 1 : xx_combination_error_status CREATE TABLE APPS.XX_COMBINATION_ERROR_STATUS (   CODE       VARCHAR2(2000 BYTE),   STATUS     VARCHAR2(2000 BYTE),   ERROR_MSG  VARCHAR2(4000 BYTE) ) create table XX_ACCOUNT_COMBINATIONS (CODE VARCHAR2(2000)) edit      XX_ACCOUNT_COMBINATIONS --where CODE='11.01010.H123.0000.00.00' insert into   XX_ACCOUNT_COMBINATIONS values ('11.82804.6006.0000.00.00') Select * from     GL_CODE_COMBINATIONS_KFV where CONCATENATED_SEGMENTS in ('11.00000.6006.0000.00.00' , '11.82804.6006.0000.00.00', '18.00000.3020.0000.00.00') CREATE OR REPLACE FUNCTION APPS.XXX_CREATE_CCID ( P_CONCAT_SEGS IN VARCHAR2 ) RETURN VARCHAR2 IS L_STATUS BOOLEAN; L_COA_ID NUMBER; BEGIN SELECT CHART_OF_ACCOUNTS_ID INTO L_COA_ID FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS_ID = 2023;-- –UPDATE THIS WITH SET OF BOOKS ID L_STATUS := FND_FLEX_KEYVAL.VALIDATE_SEGS( 'CREATE_COMBINATION', 'S...

-- Query to find operating units for a legal entity : select    organization_id operating_unit,    name,    business_group_id,    substr(set_of_books_id,1,10),    substr(legal_entity_id,1,10),    date_from,    date_to from hr_operating_units where legal_entity_id=204 --Query to find SOBs set up in the instance : select    set_of_books_id,    name sob_name,    chart_of_accounts_id,    chart_of_accounts_name,    period_set_name calendar_period,    accounted_period_type,    user_period_type,    currency_code from gl_sets_of_books_v where set_of_books_id=1 --Query to find few business groups set up in the instance : select    business_group_id,name from per_business_groups where 1=1--lower(name) like '%vision corporation%' order by name --Query to find leg...

Purpose : To load the data from staging to oracle CREATE OR REPLACE PROCEDURE APPS . xxbilt_ebs_sale_ord_creation_n (    errbuf    VARCHAR2 ,    retcode   VARCHAR2 -- p_ordernumber    VARCHAR2 -- by hs ) IS --DECLARE    l_h_order_source               VARCHAR2 ( 2000 );    l_api_version_number           NUMBER                                := 1.0 ;    error_msgs                     VARCHAR2 ( 2000 );    l_return_status            ...