APPS.POS_BATCH_IMPORT_PKG dependencies on HZ_IMP_CONTACTS_INT

Line 494: INSERT INTO hz_imp_contacts_int

490: END IF;
491:
492: l_insert_count := 0;
493:
494: INSERT INTO hz_imp_contacts_int
495: (batch_id,
496: contact_orig_system,
497: contact_orig_system_reference,
498: sub_orig_system,

Line 535: FROM hz_imp_contacts_int hp

531: AND sdh_batch_id = p_batch_id
532: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
533: AND NOT EXISTS
534: (SELECT *
535: FROM hz_imp_contacts_int hp
536: WHERE hp.batch_id = supp.sdh_batch_id
537: AND hp.contact_orig_system = supp.contact_orig_system
538: AND hp.contact_orig_system_reference =
539: supp.contact_orig_system_reference)

Line 563: FROM hz_imp_contacts_int hp

559: AND sdh_batch_id = p_batch_id
560: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
561: AND NOT EXISTS
562: (SELECT *
563: FROM hz_imp_contacts_int hp
564: WHERE hp.batch_id = supp.sdh_batch_id
565: AND hp.contact_orig_system = supp.contact_orig_system
566: AND hp.contact_orig_system_reference =
567: supp.contact_orig_system_reference);

Line 574: ' Rows inserted in hz_imp_contacts_int: ' ||

570:
571: fnd_file.put_line(fnd_file.log,
572: ' Message: Inside PROCEDURE check_party_contact_exist' ||
573: ' Parameters: ' || ' p_batch_id: ' || p_batch_id ||
574: ' Rows inserted in hz_imp_contacts_int: ' ||
575: l_insert_count);
576:
577: IF (l_insert_count > 0) THEN
578: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.

Line 904: FROM hz_imp_contacts_int party

900: WHERE sdh_batch_id = p_batch_id
901: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
902: AND NOT EXISTS
903: (SELECT 1
904: FROM hz_imp_contacts_int party
905: WHERE batch_id = p_batch_id
906: AND supp.sdh_batch_id = party.batch_id
907: AND supp.party_orig_system = party.obj_orig_system
908: AND supp.party_orig_system_reference =

Line 1552: FROM hz_imp_contacts_int hz

1548:
1549: CURSOR contact_int_cur IS
1550: SELECT contact_orig_system,
1551: contact_orig_system_reference
1552: FROM hz_imp_contacts_int hz
1553: WHERE batch_id = p_batch_id
1554: /* Status for the data should not be E or C
1555: i.e. Errored out or Completed */
1556: AND interface_status IS NULL

Line 3758: FROM hz_imp_contacts_int party

3754: AND sdh_batch_id = p_batch_id
3755: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
3756: AND NOT EXISTS
3757: (SELECT 1
3758: FROM hz_imp_contacts_int party
3759: WHERE batch_id = p_batch_id
3760: AND supp.sdh_batch_id = party.batch_id
3761: AND supp.party_orig_system = party.obj_orig_system
3762: AND supp.party_orig_system_reference =

Line 3847: FROM hz_imp_contacts_int party

3843: WHERE sdh_batch_id = p_batch_id
3844: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
3845: AND EXISTS
3846: (SELECT 1
3847: FROM hz_imp_contacts_int party
3848: WHERE batch_id = p_batch_id
3849: AND supp.sdh_batch_id = party.batch_id
3850: AND supp.party_orig_system = party.obj_orig_system
3851: AND supp.party_orig_system_reference =

Line 3861: ' records. Reason interface_status in hz_imp_contacts_int = R');

3857:
3858: fnd_file.put_line(fnd_file.log,
3859: ' Message: Inside PROCEDURE IMPORT_VENDOR_CONTACTS' ||
3860: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
3861: ' records. Reason interface_status in hz_imp_contacts_int = R');
3862:
3863: INSERT INTO pos_supplier_int_rejections
3864: (SELECT p_batch_id,
3865: l_request_id,

Line 4206: FROM hz_imp_contacts_int

4202:
4203: BEGIN
4204: SELECT nvl(insert_update_flag, 'U')
4205: INTO l_insert_update_flag
4206: FROM hz_imp_contacts_int
4207: WHERE batch_id = p_batch_id
4208: AND obj_orig_system = contact_int_rec.party_orig_system
4209: AND obj_orig_system_reference =
4210: contact_int_rec.party_orig_system_reference