APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on OZF_TP_TERRUSG_MAP

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

1212: --TRAY
1213:
1214: IF l_store_final_sql IS NOT NULL THEN
1215: write_conc_log('############### Store Insert SQL >>> START');
1216: l_store_insert_sql := 'INSERT INTO OZF_TP_TERRUSG_MAP('||
1217: 'OZF_TP_TERRUSG_MAP_ID, '||
1218: 'last_update_date, '||
1219: 'last_updated_by,';
1220: l_store_insert_sql := l_store_insert_sql ||

Line 1217: 'OZF_TP_TERRUSG_MAP_ID, '||

1213:
1214: IF l_store_final_sql IS NOT NULL THEN
1215: write_conc_log('############### Store Insert SQL >>> START');
1216: l_store_insert_sql := 'INSERT INTO OZF_TP_TERRUSG_MAP('||
1217: 'OZF_TP_TERRUSG_MAP_ID, '||
1218: 'last_update_date, '||
1219: 'last_updated_by,';
1220: l_store_insert_sql := l_store_insert_sql ||
1221: 'creation_date, '||

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

1235: 'site_use_code, '||
1236: 'user_added, '||
1237: 'location_id )';
1238: l_store_insert_sql := l_store_insert_sql ||
1239: ' SELECT OZF_TP_TERRUSG_MAP_S.nextval, '||
1240: 'SYSDATE, '||
1241: 'FND_GLOBAL.user_id, ';
1242: l_store_insert_sql := l_store_insert_sql ||
1243: 'SYSDATE, '||

Line 1316: DELETE FROM OZF_TP_TERRUSG_MAP

1312: END IF;
1313: END IF;
1314: END LOOP;
1315: Ozf_Utility_pvt.write_conc_log('############### Timestamp after for loop: '||to_char(sysdate,'DD-MM-YYYY HH24:MI:SS'));
1316: DELETE FROM OZF_TP_TERRUSG_MAP
1317: WHERE market_qualifier_type = 'TERRITORY'
1318: AND market_qualifier_reference = p_terr_id
1319: AND user_added = 'N';
1320:

Line 1516: FROM ozf_tp_terrusg_map

1512: BILL_TO_SITE_USE_ID,
1513: ROLLUP_PARTY_ID,
1514: SITE_USE_ID,
1515: l_client_info
1516: FROM ozf_tp_terrusg_map
1517: WHERE MARKET_QUALIFIER_REFERENCE = p_terr_id;
1518: write_conc_log('############### Copy Store from ozf mapping table to ams table >>> DONE');
1519: end if;
1520: