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_SUPPLIERS

Line 140: -- source id, source reference in cross reference table and update the ap_suppliers_int table

136: -- Initialize API return status to success
137: x_return_status := fnd_api.g_ret_sts_success;
138:
139: -- Check if party is present for the perticular batch id,
140: -- source id, source reference in cross reference table and update the ap_suppliers_int table
141: UPDATE ap_suppliers_int supp
142: SET party_id =
143: (SELECT party_id
144: FROM hz_orig_sys_references hr

Line 141: UPDATE ap_suppliers_int supp

137: x_return_status := fnd_api.g_ret_sts_success;
138:
139: -- Check if party is present for the perticular batch id,
140: -- source id, source reference in cross reference table and update the ap_suppliers_int table
141: UPDATE ap_suppliers_int supp
142: SET party_id =
143: (SELECT party_id
144: FROM hz_orig_sys_references hr
145: WHERE hr.owner_table_name = 'HZ_PARTIES'

Line 156: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.

152: AND sdh_batch_id = p_batch_id
153: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
154:
155: -- If the party record is not present insert data into
156: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.
157: INSERT INTO hz_imp_parties_int
158: (batch_id,
159: party_orig_system,
160: party_orig_system_reference,

Line 173: 'AP_SUPPLIERS_API',

169: ceo_title)
170: SELECT sdh_batch_id,
171: party_orig_system,
172: party_orig_system_reference,
173: 'AP_SUPPLIERS_API',
174: --200,
175: 'ORGANIZATION',
176: vendor_name,
177: vendor_name_alt,

Line 182: FROM ap_suppliers_int supp

178: num_1099,
179: vat_registration_num,
180: ceo_name,
181: ceo_title
182: FROM ap_suppliers_int supp
183: WHERE /* party_id IS NULL AND */
184: sdh_batch_id = p_batch_id
185: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
186: AND NOT EXISTS (SELECT *

Line 416: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.

412: AND sdh_batch_id = p_batch_id
413: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
414:
415: -- If the party record is not present insert data into
416: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.
417: INSERT INTO hz_imp_parties_int
418: (batch_id,
419: party_orig_system,
420: party_orig_system_reference,

Line 438: 'AP_SUPPLIERS_API',

434: )
435: SELECT sdh_batch_id,
436: contact_orig_system,
437: contact_orig_system_reference,
438: 'AP_SUPPLIERS_API',
439: 'PERSON',
440: org_name,
441: org_name_alt,
442: first_name,

Line 449: 'AP_SUPPLIERS_API',

445: prefix
446: FROM (SELECT sdh_batch_id,
447: contact_orig_system,
448: contact_orig_system_reference,
449: 'AP_SUPPLIERS_API',
450: --200,
451: 'PERSON',
452: supp.first_name || ' ' || supp.last_name org_name,
453: supp.first_name_alt || ' ' || supp.last_name_alt org_name_alt,

Line 521: 'AP_SUPPLIERS_API',

517: contact_orig_system_reference,
518: party_orig_system,
519: party_orig_system_reference,
520: SYSDATE,
521: 'AP_SUPPLIERS_API',
522: supp.first_name || ' ' || supp.last_name,
523: 'CONTACT',
524: 'CONTACT_OF',
525: SYSDATE,

Line 549: 'AP_SUPPLIERS_API',

545: contact_orig_system_reference,
546: party_orig_system,
547: party_orig_system_reference,
548: SYSDATE,
549: 'AP_SUPPLIERS_API',
550: supp.first_name || ' ' || supp.last_name,
551: 'CONTACT',
552: 'CONTACT_OF',
553: SYSDATE,

Line 653: FROM ap_suppliers_int supp

649: AND interface_status IS NULL
650: AND party_type = 'ORGANIZATION'
651: AND NOT EXISTS
652: (SELECT *
653: FROM ap_suppliers_int supp
654: WHERE hp.batch_id = supp.sdh_batch_id
655: AND hp.party_orig_system = supp.party_orig_system
656: AND hp.party_orig_system_reference =
657: supp.party_orig_system_reference);

Line 666: FROM ap_suppliers

662:
663: CURSOR check_vendor_exsists(cp_party_id IN NUMBER) IS
664: SELECT 1,
665: vendor_id
666: FROM ap_suppliers
667: WHERE party_id = cp_party_id;
668:
669: l_vendor_exists NUMBER := 0;
670: BEGIN

Line 675: WHERE parent_table = 'AP_SUPPLIERS_INT';

671: -- Initialize API return status to success
672: x_return_status := fnd_api.g_ret_sts_success;
673:
674: DELETE ap_supplier_int_rejections
675: WHERE parent_table = 'AP_SUPPLIERS_INT';
676:
677: fnd_file.put_line(fnd_file.log,
678: ' Validating vendor record before the party is created. ');
679: OPEN party_int_cur;

Line 803: WHERE parent_table = 'AP_SUPPLIERS_INT';

799: last_update_login,
800: created_by,
801: creation_date
802: FROM ap_supplier_int_rejections
803: WHERE parent_table = 'AP_SUPPLIERS_INT';
804:
805: IF (g_level_procedure >= g_current_runtime_level) THEN
806: fnd_log.string(g_level_procedure,
807: g_module_name || l_api_name,

Line 1045: UPDATE ap_suppliers_int supp

1041:
1042: -- Initialize API return status to success
1043: x_return_status := fnd_api.g_ret_sts_success;
1044:
1045: UPDATE ap_suppliers_int supp
1046: SET supp.party_id =
1047: (SELECT party_id
1048: FROM hz_orig_sys_references hr
1049: WHERE hr.owner_table_name = 'HZ_PARTIES'

Line 1270: FROM ap_suppliers_int supp

1266: AND interface_status IS NULL
1267: AND party_type = 'ORGANIZATION'
1268: AND NOT EXISTS
1269: (SELECT *
1270: FROM ap_suppliers_int supp
1271: WHERE hp.batch_id = supp.sdh_batch_id
1272: AND hp.party_orig_system = supp.party_orig_system
1273: AND hp.party_orig_system_reference =
1274: supp.party_orig_system_reference);

Line 1291: SELECT 1 FROM ap_suppliers WHERE party_id = cp_party_id;

1287: -- bug 9049391
1288: -- Check if the supplier exists for the party
1289: --
1290: CURSOR check_vendor_exsists(cp_party_id IN NUMBER) IS
1291: SELECT 1 FROM ap_suppliers WHERE party_id = cp_party_id;
1292:
1293: l_vendor_exists NUMBER := 0;
1294: BEGIN
1295: -- Initialize API return status to success

Line 1299: WHERE parent_table = 'AP_SUPPLIERS_INT';

1295: -- Initialize API return status to success
1296: x_return_status := fnd_api.g_ret_sts_success;
1297:
1298: DELETE ap_supplier_int_rejections
1299: WHERE parent_table = 'AP_SUPPLIERS_INT';
1300:
1301: OPEN party_int_cur;
1302:
1303: LOOP

Line 1358: -- If the record is being updated in that case the AP suppliers data

1354: --
1355: ap_vendor_pub_pkg.g_source := 'IMPORT';
1356:
1357: -- bug 9049391
1358: -- If the record is being updated in that case the AP suppliers data
1359: -- has to be synchronized with the TCA repository. This is done by making
1360: -- a call to the TCA Sync API
1361: --
1362: /*IF (nvl(party_int_rec.insert_update_flag, 'I') = 'U') THEN*/

Line 1421: WHERE parent_table = 'AP_SUPPLIERS_INT';

1417: last_update_login,
1418: created_by,
1419: creation_date
1420: FROM ap_supplier_int_rejections
1421: WHERE parent_table = 'AP_SUPPLIERS_INT';
1422:
1423: IF (g_level_procedure >= g_current_runtime_level) THEN
1424: fnd_log.string(g_level_procedure,
1425: g_module_name || l_api_name,

Line 1482: WHERE parent_table = 'AP_SUPPLIERS_INT';

1478: last_update_login,
1479: created_by,
1480: creation_date
1481: FROM ap_supplier_int_rejections
1482: WHERE parent_table = 'AP_SUPPLIERS_INT';
1483:
1484: IF (g_level_procedure >= g_current_runtime_level) THEN
1485: fnd_log.string(g_level_procedure,
1486: g_module_name || l_api_name,

Line 1591: l_party_usg_rec.created_by_module := 'AP_SUPPLIERS_API';

1587:
1588: l_party_usg_validation_level := hz_party_usg_assignment_pvt.g_valid_level_none;
1589: l_party_usg_rec.party_id := l_party_id;
1590: l_party_usg_rec.party_usage_code := 'SUPPLIER_CONTACT';
1591: l_party_usg_rec.created_by_module := 'AP_SUPPLIERS_API';
1592:
1593: /* Enable party contact as supplier contact by
1594: setting usage code as SUPPLIER_CONTACT */
1595: hz_party_usg_assignment_pvt.assign_party_usage(p_validation_level => l_party_usg_validation_level,

Line 1695: UPDATE ap_suppliers_int

1691: x_party_id => l_party_id);
1692:
1693: IF l_return_status = fnd_api.g_ret_sts_success THEN
1694:
1695: UPDATE ap_suppliers_int
1696: SET status = 'PROCESSED'
1697: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1698: AND sdh_batch_id = p_batch_id;
1699:

Line 1893: 'AP_SUPPLIERS_INT',

1889:
1890: ELSE
1891: IF (insert_rejections(p_batch_id,
1892: l_request_id,
1893: 'AP_SUPPLIERS_INT',
1894: p_vendor_rec.vendor_interface_id,
1895: 'AP_PAYEE_CREATION',
1896: g_user_id,
1897: g_login_id,

Line 1927: 'AP_SUPPLIERS_INT',

1923:
1924: ELSE
1925: IF (insert_rejections(p_batch_id,
1926: l_request_id,
1927: 'AP_SUPPLIERS_INT',
1928: p_vendor_rec.vendor_interface_id,
1929: 'AP_INVALID_PAYEE',
1930: g_user_id,
1931: g_login_id,

Line 1959: UPDATE ap_suppliers_int

1955: END IF; -- Payee Validation API
1956:
1957: ELSE
1958:
1959: UPDATE ap_suppliers_int
1960: SET status = 'REJECTED'
1961: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1962: AND sdh_batch_id = p_batch_id;
1963:

Line 1986: WHERE parent_table = 'AP_SUPPLIERS_INT'

1982: last_update_login,
1983: created_by,
1984: creation_date
1985: FROM ap_supplier_int_rejections
1986: WHERE parent_table = 'AP_SUPPLIERS_INT'
1987: AND parent_id = p_vendor_rec.vendor_interface_id;
1988:
1989: IF (g_level_procedure >= g_current_runtime_level) THEN
1990: fnd_log.string(g_level_procedure,

Line 2055: FROM ap_suppliers_int supp

2051: l_vendor_id NUMBER;
2052:
2053: CURSOR vendor_int_cur IS
2054: SELECT *
2055: FROM ap_suppliers_int supp
2056: WHERE import_request_id = l_request_id
2057: AND vendor_interface_id IS NOT NULL
2058: AND sdh_batch_id = p_batch_id
2059: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')

Line 2083: FROM ap_suppliers

2079:
2080: CURSOR check_vendor_exsists(cp_party_id IN NUMBER) IS
2081: SELECT 1,
2082: vendor_id
2083: FROM ap_suppliers
2084: WHERE party_id = cp_party_id;
2085:
2086: l_vendor_exists NUMBER := 0;
2087:

Line 2096: WHERE parent_table = 'AP_SUPPLIERS_INT';

2092: -- Standard Start of API savepoint
2093: SAVEPOINT import_vendor_pub;
2094:
2095: DELETE ap_supplier_int_rejections
2096: WHERE parent_table = 'AP_SUPPLIERS_INT';
2097:
2098: -- API body
2099:
2100: -- This update statement resets the unprocessed rows so

Line 2102: UPDATE ap_suppliers_int api

2098: -- API body
2099:
2100: -- This update statement resets the unprocessed rows so
2101: -- that they get picked in the current run.
2102: UPDATE ap_suppliers_int api
2103: SET import_request_id = NULL
2104: WHERE import_request_id IS NOT NULL
2105: AND sdh_batch_id = p_batch_id
2106: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 2113: UPDATE ap_suppliers_int

2109: WHERE fcr.request_id = api.import_request_id
2110: AND fcr.phase_code = 'C');
2111:
2112: -- Updating Interface Record with request id
2113: UPDATE ap_suppliers_int
2114: SET import_request_id = l_request_id
2115: WHERE import_request_id IS NULL
2116: AND sdh_batch_id = p_batch_id
2117: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED');

Line 2119: UPDATE ap_suppliers_int supp

2115: WHERE import_request_id IS NULL
2116: AND sdh_batch_id = p_batch_id
2117: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED');
2118:
2119: UPDATE ap_suppliers_int supp
2120: SET status = 'REMOVED',
2121: import_request_id = l_request_id
2122: WHERE sdh_batch_id = p_batch_id
2123: AND nvl(status, 'ACTIVE') <> 'PROCESSED'

Line 2142: 'AP_SUPPLIERS_INT',

2138:
2139: INSERT INTO pos_supplier_int_rejections
2140: (SELECT p_batch_id,
2141: l_request_id,
2142: 'AP_SUPPLIERS_INT',
2143: vendor_interface_id,
2144: 'POS_INVALID_PARTY_ORIG_SYSTEM',
2145: g_user_id,
2146: SYSDATE,

Line 2150: FROM ap_suppliers_int

2146: SYSDATE,
2147: g_login_id,
2148: g_user_id,
2149: SYSDATE
2150: FROM ap_suppliers_int
2151: WHERE status = 'REMOVED'
2152: AND import_request_id = l_request_id
2153: AND sdh_batch_id = p_batch_id);
2154:

Line 2200: UPDATE ap_suppliers_int

2196: vendor_rec.hold_reason := vendor_int_rec.hold_reason;
2197:
2198: IF length(vendor_int_rec.num_1099) > 20 THEN
2199:
2200: UPDATE ap_suppliers_int
2201: SET status = 'REJECTED'
2202: WHERE vendor_interface_id = vendor_int_rec.vendor_interface_id
2203: AND sdh_batch_id = p_batch_id;
2204:

Line 2207: 'AP_SUPPLIERS_INT',

2203: AND sdh_batch_id = p_batch_id;
2204:
2205: IF (insert_rejections(p_batch_id,
2206: l_request_id,
2207: 'AP_SUPPLIERS_INT',
2208: vendor_rec.vendor_interface_id,
2209: 'AP_INVALID_NUM_1099',
2210: g_user_id,
2211: g_login_id,

Line 2378: UPDATE ap_suppliers_int

2374: vendor_rec.party_id := vendor_int_rec.party_id;
2375: END IF;
2376:
2377: IF (vendor_rec.party_id IS NULL OR vendor_rec.party_id = 0) THEN
2378: UPDATE ap_suppliers_int
2379: SET status = 'REJECTED'
2380: WHERE vendor_interface_id = vendor_rec.vendor_interface_id
2381: AND sdh_batch_id = p_batch_id;
2382:

Line 2385: 'AP_SUPPLIERS_INT',

2381: AND sdh_batch_id = p_batch_id;
2382:
2383: IF (insert_rejections(p_batch_id,
2384: l_request_id,
2385: 'AP_SUPPLIERS_INT',
2386: vendor_rec.vendor_interface_id,
2387: 'POS_INVALID_PARTY_ORIG_SYSTEM',
2388: g_user_id,
2389: g_login_id,

Line 2479: UPDATE ap_suppliers_int

2475: l_vendor_id);
2476:
2477: IF l_return_status = fnd_api.g_ret_sts_success THEN
2478:
2479: UPDATE ap_suppliers_int
2480: SET status = 'PROCESSED'
2481: WHERE vendor_interface_id = vendor_rec.vendor_interface_id
2482: AND sdh_batch_id = p_batch_id;
2483:

Line 2491: UPDATE ap_suppliers_int

2487: suppliers_updated = suppliers_updated + 1,
2488: suppliers_imported = suppliers_imported + 1
2489: WHERE batch_id = p_batch_id;
2490: ELSE
2491: UPDATE ap_suppliers_int
2492: SET status = 'REJECTED'
2493: WHERE vendor_interface_id = vendor_rec.vendor_interface_id
2494: AND sdh_batch_id = p_batch_id;
2495:

Line 2518: WHERE parent_table = 'AP_SUPPLIERS_INT'

2514: last_update_login,
2515: created_by,
2516: creation_date
2517: FROM ap_supplier_int_rejections
2518: WHERE parent_table = 'AP_SUPPLIERS_INT'
2519: AND parent_id = vendor_rec.vendor_interface_id;
2520:
2521: IF (g_level_procedure >= g_current_runtime_level) THEN
2522: fnd_log.string(g_level_procedure,

Line 3208: FROM ap_suppliers supp

3204:
3205: BEGIN
3206: SELECT vendor_id
3207: INTO site_rec.vendor_id
3208: FROM ap_suppliers supp
3209: WHERE supp.party_id = l_party_id;
3210:
3211: EXCEPTION
3212: WHEN OTHERS THEN

Line 3927: FROM ap_suppliers supp

3923: IF (contact_int_rec.vendor_id IS NULL) THEN
3924: BEGIN
3925: SELECT vendor_id
3926: INTO vendor_contact_rec.vendor_id
3927: FROM ap_suppliers supp
3928: WHERE supp.party_id = contact_int_rec.party_id;
3929:
3930: EXCEPTION
3931: WHEN OTHERS THEN

Line 4080: FROM ap_suppliers pv,

4076:
4077: BEGIN
4078: SELECT 1
4079: INTO l_count
4080: FROM ap_suppliers pv,
4081: hz_relationships hzr,
4082: hz_org_contacts hoc
4083: WHERE pv.vendor_id = vendor_contact_rec.vendor_id
4084: AND hzr.relationship_type = 'CONTACT'

Line 4935: FROM ap_suppliers supp

4931: IF (vendor_int_prod_srv_rec.vendor_id IS NULL) THEN
4932: BEGIN
4933: SELECT vendor_id
4934: INTO vendor_prod_srv_rec.vendor_id
4935: FROM ap_suppliers supp
4936: WHERE supp.party_id = l_party_id;
4937:
4938: EXCEPTION
4939: WHEN OTHERS THEN

Line 5693: FROM ap_suppliers supp

5689: IF (vendor_int_buss_class_rec.vendor_id IS NULL) THEN
5690: BEGIN
5691: SELECT vendor_id
5692: INTO vendor_buss_class_rec.vendor_id
5693: FROM ap_suppliers supp
5694: WHERE supp.party_id = l_party_id;
5695:
5696: EXCEPTION
5697: WHEN OTHERS THEN

Line 9039: ap_suppliers vendor

9035: party_site_id
9036: INTO l_vendor_site_id,
9037: l_party_site_id
9038: FROM ap_supplier_sites_all site,
9039: ap_suppliers vendor
9040: WHERE vendor.vendor_id = site.vendor_id
9041: AND (site.inactive_date > SYSDATE OR site.inactive_date IS NULL)
9042: AND vendor.party_id = l_party_id
9043: AND site.vendor_site_code =

Line 10306: FROM ap_suppliers_int

10302: retcode := 1;
10303: ELSE
10304: SELECT COUNT(1)
10305: INTO l_error_count
10306: FROM ap_suppliers_int
10307: WHERE sdh_batch_id = p_batch_id
10308: AND nvl(status, 'ACTIVE') = 'REJECTED'
10309: AND rownum = 1;
10310: