eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_BATCH_IMPORT_PKG dependencies on AP_SUP_SITE_CONTACT_INT

Line 401: UPDATE ap_sup_site_contact_int supp

397:
398: -- Initialize API return status to success
399: x_return_status := fnd_api.g_ret_sts_success;
400:
401: UPDATE ap_sup_site_contact_int supp
402: SET per_party_id =
403: (SELECT party_id
404: FROM hz_orig_sys_references hr
405: WHERE hr.owner_table_name = 'HZ_PARTIES'

Line 461: FROM ap_sup_site_contact_int supp

457: supp.prefix,
458: dense_rank() over(PARTITION BY sdh_batch_id, contact_orig_system, contact_orig_system_reference, party_id ORDER BY ROWID) rnk
459: --num_1099,
460: --vat_registration_num
461: FROM ap_sup_site_contact_int supp
462: WHERE /* per_party_id IS NULL AND */
463: sdh_batch_id = p_batch_id
464: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
465: AND NOT EXISTS

Line 529: FROM ap_sup_site_contact_int supp

525: SYSDATE,
526: 'I',
527: department,
528: title
529: FROM ap_sup_site_contact_int supp
530: WHERE per_party_id IS NULL
531: AND sdh_batch_id = p_batch_id
532: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
533: AND NOT EXISTS

Line 557: FROM ap_sup_site_contact_int supp

553: SYSDATE,
554: 'U',
555: department,
556: title
557: FROM ap_sup_site_contact_int supp
558: WHERE per_party_id IS NOT NULL
559: AND sdh_batch_id = p_batch_id
560: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
561: AND NOT EXISTS

Line 899: FROM ap_sup_site_contact_int supp

895: l_org_contact_id NUMBER(15);
896:
897: CURSOR supp_contact_int_cur IS
898: SELECT *
899: FROM ap_sup_site_contact_int supp
900: WHERE sdh_batch_id = p_batch_id
901: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
902: AND NOT EXISTS
903: (SELECT 1

Line 933: UPDATE ap_sup_site_contact_int

929: IF (supp_contact_int_rec.party_id IS NULL) THEN
930: l_org_party_id := get_party_id(supp_contact_int_rec.party_orig_system,
931: supp_contact_int_rec.party_orig_system_reference);
932:
933: UPDATE ap_sup_site_contact_int
934: SET party_id = l_org_party_id
935: WHERE vendor_contact_interface_id =
936: supp_contact_int_rec.vendor_contact_interface_id
937: AND sdh_batch_id = p_batch_id;

Line 959: UPDATE ap_sup_site_contact_int

955: supp_contact_int_rec.party_orig_system_reference*/
956:
957: END IF;
958:
959: UPDATE ap_sup_site_contact_int
960: SET per_party_id = l_per_party_id
961: WHERE vendor_contact_interface_id =
962: supp_contact_int_rec.vendor_contact_interface_id
963: AND sdh_batch_id = p_batch_id;

Line 981: UPDATE ap_sup_site_contact_int

977: AND subject_type = 'ORGANIZATION'
978: AND object_id = l_per_party_id
979: AND object_type = 'PERSON';
980:
981: UPDATE ap_sup_site_contact_int
982: SET relationship_id = l_relationship_id,
983: rel_party_id = l_rel_party_id
984: WHERE vendor_contact_interface_id =
985: supp_contact_int_rec.vendor_contact_interface_id

Line 999: UPDATE ap_sup_site_contact_int

995: INTO l_org_contact_id
996: FROM hz_org_contacts
997: WHERE party_relationship_id = l_relationship_id;
998:
999: UPDATE ap_sup_site_contact_int
1000: SET org_contact_id = l_org_contact_id
1001: WHERE vendor_contact_interface_id =
1002: supp_contact_int_rec.vendor_contact_interface_id
1003: AND sdh_batch_id = p_batch_id;

Line 1712: UPDATE ap_sup_site_contact_int

1708: SET vendor_id = l_vendor_id
1709: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1710: AND sdh_batch_id = p_batch_id;
1711:
1712: UPDATE ap_sup_site_contact_int
1713: SET vendor_id = l_vendor_id
1714: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1715: AND sdh_batch_id = p_batch_id;
1716:

Line 2679: UPDATE ap_sup_site_contact_int

2675: sites_inserted = sites_inserted + 1,
2676: sites_imported = sites_imported + 1
2677: WHERE batch_id = p_batch_id;
2678:
2679: UPDATE ap_sup_site_contact_int
2680: SET vendor_site_id = l_vendor_site_id
2681: WHERE vendor_id = p_site_rec.vendor_id
2682: AND vendor_site_code = p_site_rec.vendor_site_code
2683: AND (org_id = p_site_rec.org_id OR

Line 3750: FROM ap_sup_site_contact_int supp

3746: l_count NUMBER;
3747:
3748: CURSOR contact_int_cur IS
3749: SELECT *
3750: FROM ap_sup_site_contact_int supp
3751: WHERE import_request_id = l_request_id
3752: AND (org_id IS NOT NULL OR operating_unit_name IS NOT NULL)
3753: AND last_name IS NOT NULL
3754: AND sdh_batch_id = p_batch_id

Line 3777: WHERE parent_table = 'AP_SUP_SITE_CONTACT_INT';

3773: -- Initialize API return status to success
3774: x_return_status := fnd_api.g_ret_sts_success;
3775:
3776: DELETE ap_supplier_int_rejections
3777: WHERE parent_table = 'AP_SUP_SITE_CONTACT_INT';
3778:
3779: -- API body
3780:
3781: -- This update statement resets the unprocessed rows so

Line 3783: UPDATE ap_sup_site_contact_int api

3779: -- API body
3780:
3781: -- This update statement resets the unprocessed rows so
3782: -- that they get picked in the current run.
3783: UPDATE ap_sup_site_contact_int api
3784: SET import_request_id = NULL
3785: WHERE import_request_id IS NOT NULL
3786: AND sdh_batch_id = p_batch_id
3787: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 3795: UPDATE ap_sup_site_contact_int

3791: AND fcr.phase_code = 'C');
3792:
3793: -- Updating Interface Record with request id
3794:
3795: UPDATE ap_sup_site_contact_int
3796: SET import_request_id = l_request_id
3797: WHERE import_request_id IS NULL
3798: AND sdh_batch_id = p_batch_id
3799: AND nvl(status, 'ACTIVE') <> 'PROCESSED';

Line 3801: UPDATE ap_sup_site_contact_int

3797: WHERE import_request_id IS NULL
3798: AND sdh_batch_id = p_batch_id
3799: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
3800:
3801: UPDATE ap_sup_site_contact_int
3802: SET status = 'REJECTED',
3803: import_request_id = l_request_id
3804: WHERE ((operating_unit_name IS NULL AND org_id IS NULL) OR
3805: (last_name IS NULL))

Line 3811: 'AP_SUP_SITE_CONTACT_INT',

3807:
3808: INSERT INTO pos_supplier_int_rejections
3809: (SELECT p_batch_id,
3810: l_request_id,
3811: 'AP_SUP_SITE_CONTACT_INT',
3812: vendor_contact_interface_id,
3813: 'AP_ORG_INFO_NULL',
3814: g_user_id,
3815: SYSDATE,

Line 3819: FROM ap_sup_site_contact_int

3815: SYSDATE,
3816: g_login_id,
3817: g_user_id,
3818: SYSDATE
3819: FROM ap_sup_site_contact_int
3820: WHERE status = 'REJECTED'
3821: AND import_request_id = l_request_id
3822: AND sdh_batch_id = p_batch_id
3823: AND (operating_unit_name IS NULL AND org_id IS NULL)) UNION

Line 3826: 'AP_SUP_SITE_CONTACT_INT',

3822: AND sdh_batch_id = p_batch_id
3823: AND (operating_unit_name IS NULL AND org_id IS NULL)) UNION
3824: (SELECT p_batch_id,
3825: l_request_id,
3826: 'AP_SUP_SITE_CONTACT_INT',
3827: vendor_contact_interface_id,
3828: 'AP_LAST_NAME_NULL',
3829: g_user_id,
3830: SYSDATE,

Line 3834: FROM ap_sup_site_contact_int

3830: SYSDATE,
3831: g_login_id,
3832: g_user_id,
3833: SYSDATE
3834: FROM ap_sup_site_contact_int
3835: WHERE status = 'REJECTED'
3836: AND import_request_id = l_request_id
3837: AND sdh_batch_id = p_batch_id
3838: AND last_name IS NULL);

Line 3840: UPDATE ap_sup_site_contact_int supp

3836: AND import_request_id = l_request_id
3837: AND sdh_batch_id = p_batch_id
3838: AND last_name IS NULL);
3839:
3840: UPDATE ap_sup_site_contact_int supp
3841: SET status = 'REMOVED',
3842: import_request_id = l_request_id
3843: WHERE sdh_batch_id = p_batch_id
3844: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')

Line 3866: 'AP_SUP_SITE_CONTACT_INT',

3862:
3863: INSERT INTO pos_supplier_int_rejections
3864: (SELECT p_batch_id,
3865: l_request_id,
3866: 'AP_SUP_SITE_CONTACT_INT',
3867: vendor_contact_interface_id,
3868: 'POS_INVALID_PARTY_ORIG_SYSTEM',
3869: g_user_id,
3870: SYSDATE,

Line 3874: FROM ap_sup_site_contact_int

3870: SYSDATE,
3871: g_login_id,
3872: g_user_id,
3873: SYSDATE
3874: FROM ap_sup_site_contact_int
3875: WHERE status = 'REMOVED'
3876: AND import_request_id = l_request_id
3877: AND sdh_batch_id = p_batch_id);
3878:

Line 3932: UPDATE ap_sup_site_contact_int

3928: WHERE supp.party_id = contact_int_rec.party_id;
3929:
3930: EXCEPTION
3931: WHEN OTHERS THEN
3932: UPDATE ap_sup_site_contact_int
3933: SET status = 'REJECTED'
3934: WHERE vendor_contact_interface_id =
3935: contact_int_rec.vendor_contact_interface_id
3936: AND sdh_batch_id = p_batch_id;

Line 3940: 'AP_SUP_SITE_CONTACT_INT',

3936: AND sdh_batch_id = p_batch_id;
3937:
3938: IF (insert_rejections(p_batch_id,
3939: l_request_id,
3940: 'AP_SUP_SITE_CONTACT_INT',
3941: vendor_contact_rec.vendor_contact_interface_id,
3942: 'AP_VENDOR_ID_NULL',
3943: g_user_id,
3944: g_login_id,

Line 3996: UPDATE ap_sup_site_contact_int

3992: AND nvl(hr.end_date_active, SYSDATE) >= SYSDATE;
3993:
3994: EXCEPTION
3995: WHEN OTHERS THEN
3996: UPDATE ap_sup_site_contact_int
3997: SET status = 'REJECTED'
3998: WHERE vendor_contact_interface_id =
3999: contact_int_rec.vendor_contact_interface_id
4000: AND sdh_batch_id = p_batch_id;

Line 4004: 'AP_SUP_SITE_CONTACT_INT',

4000: AND sdh_batch_id = p_batch_id;
4001:
4002: IF (insert_rejections(p_batch_id,
4003: l_request_id,
4004: 'AP_SUP_SITE_CONTACT_INT',
4005: vendor_contact_rec.vendor_contact_interface_id,
4006: 'POS_INV_PARTY_SITE_ORIG_SYS',
4007: g_user_id,
4008: g_login_id,

Line 4099: UPDATE ap_sup_site_contact_int

4095: AND hzr.relationship_id = hoc.party_relationship_id;
4096:
4097: EXCEPTION
4098: WHEN OTHERS THEN
4099: UPDATE ap_sup_site_contact_int
4100: SET status = 'REJECTED'
4101: WHERE vendor_contact_interface_id =
4102: contact_int_rec.vendor_contact_interface_id
4103: AND sdh_batch_id = p_batch_id;

Line 4107: 'AP_SUP_SITE_CONTACT_INT',

4103: AND sdh_batch_id = p_batch_id;
4104:
4105: IF (insert_rejections(p_batch_id,
4106: l_request_id,
4107: 'AP_SUP_SITE_CONTACT_INT',
4108: vendor_contact_rec.vendor_contact_interface_id,
4109: 'POS_INVALID_PERSON_PARTY_REL',
4110: g_user_id,
4111: g_login_id,

Line 4155: UPDATE ap_sup_site_contact_int

4151: AND party_site_name = vendor_contact_rec.party_site_name;
4152:
4153: EXCEPTION
4154: WHEN OTHERS THEN
4155: UPDATE ap_sup_site_contact_int
4156: SET status = 'REJECTED'
4157: WHERE vendor_contact_interface_id =
4158: contact_int_rec.vendor_contact_interface_id
4159: AND sdh_batch_id = p_batch_id;

Line 4163: 'AP_SUP_SITE_CONTACT_INT',

4159: AND sdh_batch_id = p_batch_id;
4160:
4161: IF (insert_rejections(p_batch_id,
4162: l_request_id,
4163: 'AP_SUP_SITE_CONTACT_INT',
4164: vendor_contact_rec.vendor_contact_interface_id,
4165: 'POS_INVALID_PARTY_SITE_NAME',
4166: g_user_id,
4167: g_login_id,

Line 4197: UPDATE ap_sup_site_contact_int

4193: p_vendor_contact_rec => vendor_contact_rec);
4194: END IF;
4195:
4196: IF l_return_status = fnd_api.g_ret_sts_success THEN
4197: UPDATE ap_sup_site_contact_int
4198: SET status = 'PROCESSED'
4199: WHERE vendor_contact_interface_id =
4200: vendor_contact_rec.vendor_contact_interface_id
4201: AND sdh_batch_id = p_batch_id;

Line 4239: UPDATE ap_sup_site_contact_int

4235: ELSE
4236: fnd_file.put_line(fnd_file.log,
4237: 'Record Rejected :' ||
4238: vendor_contact_rec.vendor_contact_interface_id);
4239: UPDATE ap_sup_site_contact_int
4240: SET status = 'REJECTED'
4241: WHERE vendor_contact_interface_id =
4242: vendor_contact_rec.vendor_contact_interface_id
4243: AND sdh_batch_id = p_batch_id;

Line 4267: WHERE parent_table = 'AP_SUP_SITE_CONTACT_INT'

4263: last_update_login,
4264: created_by,
4265: creation_date
4266: FROM ap_supplier_int_rejections
4267: WHERE parent_table = 'AP_SUP_SITE_CONTACT_INT'
4268: AND parent_id = vendor_contact_rec.vendor_contact_interface_id;
4269: END IF;
4270: x_return_status := l_return_status;
4271: x_msg_count := l_msg_count;

Line 10382: FROM ap_sup_site_contact_int

10378: retcode := 1;
10379: ELSE
10380: SELECT COUNT(1)
10381: INTO l_error_count
10382: FROM ap_sup_site_contact_int
10383: WHERE sdh_batch_id = p_batch_id
10384: AND nvl(status, 'ACTIVE') = 'REJECTED'
10385: AND rownum = 1;
10386: