APPS.OKI_LOAD_TERR_PVT dependencies on OKI_JTF_TERRITORIES_STG

Line 108: l_sql_string := 'TRUNCATE TABLE '|| g_oki_schema ||'.OKI_JTF_TERRITORIES_STG';

104: EXECUTE IMMEDIATE l_sql_string;
105: rlog( 'Truncated Table OKI_JTF_TERRITORIES',2);
106: END IF;
107:
108: l_sql_string := 'TRUNCATE TABLE '|| g_oki_schema ||'.OKI_JTF_TERRITORIES_STG';
109: EXECUTE IMMEDIATE l_sql_string;
110: rlog( 'Truncated Table OKI_JTF_TERRITORIES_STG',2);
111:
112: DELETE FROM OKI_DBI_WORKER_STATUS

Line 110: rlog( 'Truncated Table OKI_JTF_TERRITORIES_STG',2);

106: END IF;
107:
108: l_sql_string := 'TRUNCATE TABLE '|| g_oki_schema ||'.OKI_JTF_TERRITORIES_STG';
109: EXECUTE IMMEDIATE l_sql_string;
110: rlog( 'Truncated Table OKI_JTF_TERRITORIES_STG',2);
111:
112: DELETE FROM OKI_DBI_WORKER_STATUS
113: WHERE OBJECT_NAME = 'OKI_JTF_TERRITORIES';
114: COMMIT;

Line 239: UPDATE OKI_JTF_TERRITORIES_STG

235:
236:
237: FOR worker_no IN 1 .. l_no_of_workers LOOP
238:
239: UPDATE OKI_JTF_TERRITORIES_STG
240: SET worker_number = worker_no
241: WHERE worker_number IS NULL
242: AND ROWNUM <= CEIL(l_terr_count/l_no_of_workers);
243:

Line 342: INSERT /* + APPEND */ INTO OKI_JTF_TERRITORIES_STG

338: rlog('Loading of Staging Table Started - ' || fnd_date.date_to_displayDT(sysdate),1);
339:
340: IF g_load_type ='INIT' THEN
341:
342: INSERT /* + APPEND */ INTO OKI_JTF_TERRITORIES_STG
343: ( authoring_org_id
344: , party_id
345: , party_name
346: , country_code

Line 395: INSERT /* + APPEND */ INTO OKI_JTF_TERRITORIES_STG

391: AND ro.rle_code IN ('CUSTOMER','LICENSEE','BUYER')
392: AND NVL(ro.primary_yn,'Y') = 'Y'
393: );
394: ELSE
395: INSERT /* + APPEND */ INTO OKI_JTF_TERRITORIES_STG
396: ( authoring_org_id
397: , party_id
398: , party_name
399: , country_code

Line 451: l_tab_name := 'OKI_JTF_TERRITORIES_STG';

447: p_terr_count := SQL%ROWCOUNT;
448: COMMIT;
449: rlog('No of records inserted into Staging table - ' || p_terr_count,1);
450:
451: l_tab_name := 'OKI_JTF_TERRITORIES_STG';
452: fnd_stats.gather_table_stats( ownname=> g_table_owner
453: , tabname=> l_tab_name
454: , percent=> 10);
455: rlog('Loading of Staging Table Completed - ' || fnd_date.date_to_displayDT(sysdate),1);

Line 788: from OKI_JTF_TERRITORIES_STG t

784: , party_name
785: , country_code
786: , state_code
787: , record_id
788: from OKI_JTF_TERRITORIES_STG t
789: where worker_number = l_worker_number
790: ;
791:
792: get_org_customer_codes_rec get_org_customer_codes%ROWTYPE;

Line 866: UPDATE OKI_JTF_TERRITORIES_STG

862: --FOR i IN l_gen_return_rec.trans_object_id.FIRST .. l_gen_return_rec.trans_object_id.LAST
863: FOR i IN 1 .. l_gen_return_rec.trans_object_id.COUNT
864: LOOP
865: BEGIN
866: UPDATE OKI_JTF_TERRITORIES_STG
867: SET terr_id = l_gen_return_rec.terr_id(i),
868: resource_id = l_gen_return_rec.resource_id(i)
869: WHERE authoring_org_id = l_gen_return_rec.trans_detail_object_id(i)
870: AND record_id = l_gen_return_rec.trans_object_id(i);

Line 907: FROM OKI_JTF_TERRITORIES_STG

903: , g_user_id
904: , l_sysdate
905: , g_user_id
906: , g_login_id
907: FROM OKI_JTF_TERRITORIES_STG
908: WHERE worker_number = p_worker_number
909: AND terr_id IS NOT NULL;
910:
911: ELSE

Line 919: FROM OKI_JTF_TERRITORIES_STG

915: ( SELECT authoring_org_id
916: , party_id
917: , terr_id
918: , resource_id
919: FROM OKI_JTF_TERRITORIES_STG
920: WHERE worker_number = p_worker_number
921: AND terr_id IS NOT NULL
922: ) s
923: ON