APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on OZF_TP_TERRUSG_MAP

Line 1209: l_store_insert_sql := 'INSERT INTO OZF_TP_TERRUSG_MAP('||

1205: --TRAY
1206:
1207: IF l_store_final_sql IS NOT NULL THEN
1208: write_conc_log('############### Store Insert SQL >>> START');
1209: l_store_insert_sql := 'INSERT INTO OZF_TP_TERRUSG_MAP('||
1210: 'OZF_TP_TERRUSG_MAP_ID, '||
1211: 'last_update_date, '||
1212: 'last_updated_by,';
1213: l_store_insert_sql := l_store_insert_sql ||

Line 1210: 'OZF_TP_TERRUSG_MAP_ID, '||

1206:
1207: IF l_store_final_sql IS NOT NULL THEN
1208: write_conc_log('############### Store Insert SQL >>> START');
1209: l_store_insert_sql := 'INSERT INTO OZF_TP_TERRUSG_MAP('||
1210: 'OZF_TP_TERRUSG_MAP_ID, '||
1211: 'last_update_date, '||
1212: 'last_updated_by,';
1213: l_store_insert_sql := l_store_insert_sql ||
1214: 'creation_date, '||

Line 1232: ' SELECT OZF_TP_TERRUSG_MAP_S.nextval, '||

1228: 'site_use_code, '||
1229: 'user_added, '||
1230: 'location_id )';
1231: l_store_insert_sql := l_store_insert_sql ||
1232: ' SELECT OZF_TP_TERRUSG_MAP_S.nextval, '||
1233: 'SYSDATE, '||
1234: 'FND_GLOBAL.user_id, ';
1235: l_store_insert_sql := l_store_insert_sql ||
1236: 'SYSDATE, '||

Line 1303: DELETE FROM OZF_TP_TERRUSG_MAP

1299: END IF;
1300: END IF;
1301: END LOOP;
1302:
1303: DELETE FROM OZF_TP_TERRUSG_MAP
1304: WHERE market_qualifier_type = 'TERRITORY'
1305: AND market_qualifier_reference = p_terr_id
1306: AND user_added = 'N';
1307:

Line 1503: FROM ozf_tp_terrusg_map

1499: BILL_TO_SITE_USE_ID,
1500: ROLLUP_PARTY_ID,
1501: SITE_USE_ID,
1502: l_client_info
1503: FROM ozf_tp_terrusg_map
1504: WHERE MARKET_QUALIFIER_REFERENCE = p_terr_id;
1505: write_conc_log('############### Copy Store from ozf mapping table to ams table >>> DONE');
1506: end if;
1507: