APPS.ONT_ITM_PKG dependencies on WSH_ITM_PARTIES

Line 1111: -- Inserting Records in to wsh_itm_parties

1107: END IF;
1108:
1109: END IF;
1110:
1111: -- Inserting Records in to wsh_itm_parties
1112: -- Records inserted are equal to number of source types(parties)
1113:
1114: FOR J in 1..Address_table.COUNT LOOP
1115:

Line 1119: SELECT wsh_itm_parties_s.NEXTVAL

1115:
1116:
1117: IF Address_table(J).add_source_orgid IS NOT NULL THEN
1118:
1119: SELECT wsh_itm_parties_s.NEXTVAL
1120: INTO l_party_id
1121: FROM dual;
1122:
1123: INSERT INTO WSH_ITM_PARTIES (

Line 1123: INSERT INTO WSH_ITM_PARTIES (

1119: SELECT wsh_itm_parties_s.NEXTVAL
1120: INTO l_party_id
1121: FROM dual;
1122:
1123: INSERT INTO WSH_ITM_PARTIES (
1124: PARTY_ID,
1125: REQUEST_CONTROL_ID,
1126: ORIGINAL_SYSTEM_REFERENCE,
1127: ORIGINAL_SYSTEM_LINE_REFERENCE,

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

1241: FND_GLOBAL.USER_ID
1242: );
1243:
1244: IF l_debug_level > 0 THEN
1245: oe_debug_pub.add( 'INSERTED '||J||' RECORDS IN TO WSH_ITM_PARTIES...' ) ;
1246: END IF;
1247:
1248: END IF; -- Check for Org id
1249:

Line 1298: wsh_itm_parties wp

1294:
1295: CURSOR C_Resp_Lines(cp_response_header_id NUMBER) IS
1296: SELECT wl.Error_Text,wl.denied_party_flag,wp.Party_name
1297: FROM wsh_itm_response_lines wl,
1298: wsh_itm_parties wp
1299: WHERE wl.Response_header_id = cp_response_header_id
1300: AND wp.party_id = wl.party_id;
1301:
1302: CURSOR C_Get_Responses(cp_request_control_id NUMBER,