APPS.ONT_ITM_PKG dependencies on WSH_ITM_PARTIES

Line 1303: -- Inserting Records in to wsh_itm_parties

1299: END IF;
1300:
1301: END IF;
1302:
1303: -- Inserting Records in to wsh_itm_parties
1304: -- Records inserted are equal to number of source types(parties)
1305:
1306: FOR J in 1..Address_table.COUNT LOOP
1307:

Line 1311: SELECT wsh_itm_parties_s.NEXTVAL

1307:
1308:
1309: IF Address_table(J).add_source_orgid IS NOT NULL THEN
1310:
1311: SELECT wsh_itm_parties_s.NEXTVAL
1312: INTO l_party_id
1313: FROM dual;
1314:
1315: INSERT INTO WSH_ITM_PARTIES (

Line 1315: INSERT INTO WSH_ITM_PARTIES (

1311: SELECT wsh_itm_parties_s.NEXTVAL
1312: INTO l_party_id
1313: FROM dual;
1314:
1315: INSERT INTO WSH_ITM_PARTIES (
1316: PARTY_ID,
1317: REQUEST_CONTROL_ID,
1318: ORIGINAL_SYSTEM_REFERENCE,
1319: ORIGINAL_SYSTEM_LINE_REFERENCE,

Line 1449: oe_debug_pub.add( 'INSERTED '||J||' RECORDS IN TO WSH_ITM_PARTIES...' ) ;

1445: Address_Table(J).add_contact_hz_party_number
1446: );
1447:
1448: IF l_debug_level > 0 THEN
1449: oe_debug_pub.add( 'INSERTED '||J||' RECORDS IN TO WSH_ITM_PARTIES...' ) ;
1450: END IF;
1451:
1452: END IF; -- Check for Org id
1453:

Line 1502: wsh_itm_parties wp

1498:
1499: CURSOR C_Resp_Lines(cp_response_header_id NUMBER) IS
1500: SELECT wl.Error_Text,wl.denied_party_flag,wp.Party_name
1501: FROM wsh_itm_response_lines wl,
1502: wsh_itm_parties wp
1503: WHERE wl.Response_header_id = cp_response_header_id
1504: AND wp.party_id = wl.party_id;
1505:
1506: CURSOR C_Get_Responses(cp_request_control_id NUMBER,