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_SUPPLIER_SITES_INT

Line 239: UPDATE ap_supplier_sites_int supp

235:
236: -- Check for the existence of the site and location from the hz cross ref table
237: -- and update the ap_supplier_sites_in table using below query
238:
239: UPDATE ap_supplier_sites_int supp
240: SET party_site_id =
241: (SELECT owner_table_id
242: FROM hz_orig_sys_references hr
243: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'

Line 254: --Bug 13086851 language code issue: The input language that we get from ap_supplier_sites_int will be NLS_LANGUAGE(varchar 30)

250: WHERE party_site_id IS NULL
251: AND sdh_batch_id = p_batch_id
252: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
253:
254: --Bug 13086851 language code issue: The input language that we get from ap_supplier_sites_int will be NLS_LANGUAGE(varchar 30)
255: --and will not be language code((varchar 4). So it needs to be converted to language_code before inserting to hz_imp_addresses_int .
256:
257: --bug 12689121 missing address_line4, county, language during insert to interface
258:

Line 341: FROM ap_supplier_sites_int supp, FND_LANGUAGES LANG

337: hz_utility_v2pub.last_update_login,
338: LANG.LANGUAGE_CODE,
339: party_id,
340: dense_rank() over(PARTITION BY sdh_batch_id, party_site_orig_system, party_site_orig_sys_reference, party_id ORDER BY SUPP.ROWID) rnk
341: FROM ap_supplier_sites_int supp, FND_LANGUAGES LANG
342: WHERE /* party_site_id IS NULL AND */
343: sdh_batch_id = p_batch_id AND supp.language = lang.nls_language(+)
344: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
345: AND NOT EXISTS

Line 1086: UPDATE ap_supplier_sites_int supp

1082:
1083: -- Initialize API return status to success
1084: x_return_status := fnd_api.g_ret_sts_success;
1085:
1086: UPDATE ap_supplier_sites_int supp
1087: SET supp.party_id =
1088: (SELECT party_id
1089: FROM hz_orig_sys_references hr
1090: WHERE hr.owner_table_name = 'HZ_PARTIES'

Line 1099: UPDATE ap_supplier_sites_int supp

1095: AND nvl(hr.end_date_active, SYSDATE) >= SYSDATE)
1096: WHERE supp.party_id IS NULL
1097: AND supp.sdh_batch_id = p_batch_id;
1098:
1099: UPDATE ap_supplier_sites_int supp
1100: SET party_site_id =
1101: (SELECT owner_table_id
1102: FROM hz_orig_sys_references hr
1103: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'

Line 1707: UPDATE ap_supplier_sites_int

1703: suppliers_inserted = suppliers_inserted + 1,
1704: suppliers_imported = suppliers_imported + 1
1705: WHERE batch_id = p_batch_id;
1706:
1707: UPDATE ap_supplier_sites_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:

Line 2667: UPDATE ap_supplier_sites_int

2663: x_location_id => l_location_id);
2664:
2665: IF l_return_status = fnd_api.g_ret_sts_success THEN
2666:
2667: UPDATE ap_supplier_sites_int
2668: SET status = 'PROCESSED'
2669: WHERE vendor_site_interface_id = p_site_rec.vendor_site_interface_id
2670: AND sdh_batch_id = p_batch_id;
2671:

Line 2797: UPDATE ap_supplier_sites_int

2793: IF l_rollback_vendor_site = 'Y' THEN
2794:
2795: ROLLBACK TO import_vendor_sites_pub2;
2796:
2797: UPDATE ap_supplier_sites_int
2798: SET status = 'REJECTED'
2799: WHERE vendor_site_interface_id =
2800: p_site_rec.vendor_site_interface_id
2801: AND sdh_batch_id = p_batch_id;

Line 2809: 'AP_SUPPLIER_SITES_INT',

2805: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
2806:
2807: IF (insert_rejections(p_batch_id,
2808: l_request_id,
2809: 'AP_SUPPLIER_SITES_INT',
2810: p_site_rec.vendor_site_interface_id,
2811: 'AP_INVALID_BANK_ACCT_INFO',
2812: g_user_id,
2813: g_login_id,

Line 2843: 'AP_SUPPLIER_SITES_INT',

2839: ELSE
2840: -- Payee Creation API
2841: IF (insert_rejections(p_batch_id,
2842: l_request_id,
2843: 'AP_SUPPLIER_SITES_INT',
2844: p_site_rec.vendor_site_interface_id,
2845: 'AP_PAYEE_CREATION',
2846: g_user_id,
2847: g_login_id,

Line 2877: 'AP_SUPPLIER_SITES_INT',

2873: ELSE
2874: -- Payee Validation API
2875: IF (insert_rejections(p_batch_id,
2876: l_request_id,
2877: 'AP_SUPPLIER_SITES_INT',
2878: p_site_rec.vendor_site_interface_id,
2879: 'AP_INVALID_PAYEE_INFO',
2880: g_user_id,
2881: g_login_id,

Line 2936: UPDATE ap_supplier_sites_int

2932: END IF; -- Payee Validation API
2933:
2934: ELSE
2935: -- Supplier Site Creation API
2936: UPDATE ap_supplier_sites_int
2937: SET status = 'REJECTED'
2938: WHERE vendor_site_interface_id = p_site_rec.vendor_site_interface_id
2939: AND sdh_batch_id = p_batch_id;
2940:

Line 2966: WHERE parent_table = 'AP_SUPPLIER_SITES_INT'

2962: last_update_login,
2963: created_by,
2964: creation_date
2965: FROM ap_supplier_int_rejections
2966: WHERE parent_table = 'AP_SUPPLIER_SITES_INT'
2967: AND parent_id = p_site_rec.vendor_site_interface_id;
2968:
2969: IF (g_level_procedure >= g_current_runtime_level) THEN
2970: fnd_log.string(g_level_procedure,

Line 3036: FROM ap_supplier_sites_int supp

3032: l_party_id NUMBER;
3033:
3034: CURSOR site_int_cur IS
3035: SELECT *
3036: FROM ap_supplier_sites_int supp
3037: WHERE import_request_id = l_request_id
3038: AND (org_id IS NOT NULL OR operating_unit_name IS NOT NULL)
3039: AND sdh_batch_id = p_batch_id
3040: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')

Line 3087: WHERE parent_table = 'AP_SUPPLIER_SITES_INT';

3083: -- Initialize API return status to success
3084: x_return_status := fnd_api.g_ret_sts_success;
3085:
3086: DELETE ap_supplier_int_rejections
3087: WHERE parent_table = 'AP_SUPPLIER_SITES_INT';
3088:
3089: -- API body
3090:
3091: -- This update statement resets the unprocessed rows so

Line 3093: UPDATE ap_supplier_sites_int api

3089: -- API body
3090:
3091: -- This update statement resets the unprocessed rows so
3092: -- that they get picked in the current run.
3093: UPDATE ap_supplier_sites_int api
3094: SET import_request_id = NULL
3095: WHERE import_request_id IS NOT NULL
3096: AND sdh_batch_id = p_batch_id
3097: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 3105: UPDATE ap_supplier_sites_int

3101: AND fcr.phase_code = 'C');
3102:
3103: -- Updating Interface Record with request id
3104:
3105: UPDATE ap_supplier_sites_int
3106: SET import_request_id = l_request_id
3107: WHERE import_request_id IS NULL
3108: AND sdh_batch_id = p_batch_id
3109: AND nvl(status, 'ACTIVE') <> 'PROCESSED';

Line 3111: UPDATE ap_supplier_sites_int

3107: WHERE import_request_id IS NULL
3108: AND sdh_batch_id = p_batch_id
3109: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
3110:
3111: UPDATE ap_supplier_sites_int
3112: SET status = 'REJECTED',
3113: import_request_id = l_request_id
3114: WHERE (operating_unit_name IS NULL AND org_id IS NULL)
3115: AND sdh_batch_id = p_batch_id

Line 3121: 'AP_SUPPLIER_SITES_INT',

3117:
3118: INSERT INTO pos_supplier_int_rejections
3119: (SELECT p_batch_id,
3120: l_request_id,
3121: 'AP_SUPPLIER_SITES_INT',
3122: vendor_site_interface_id,
3123: 'AP_ORG_INFO_NULL',
3124: g_user_id,
3125: SYSDATE,

Line 3129: FROM ap_supplier_sites_int

3125: SYSDATE,
3126: g_login_id,
3127: g_user_id,
3128: SYSDATE
3129: FROM ap_supplier_sites_int
3130: WHERE status = 'REJECTED'
3131: AND import_request_id = l_request_id
3132: AND (operating_unit_name IS NULL AND org_id IS NULL)
3133: AND sdh_batch_id = p_batch_id);

Line 3135: UPDATE ap_supplier_sites_int supp

3131: AND import_request_id = l_request_id
3132: AND (operating_unit_name IS NULL AND org_id IS NULL)
3133: AND sdh_batch_id = p_batch_id);
3134:
3135: UPDATE ap_supplier_sites_int supp
3136: SET status = 'REMOVED',
3137: import_request_id = l_request_id
3138: WHERE sdh_batch_id = p_batch_id
3139: AND nvl(status, 'ACTIVE') <> 'PROCESSED'

Line 3161: 'AP_SUPPLIER_SITES_INT',

3157:
3158: INSERT INTO pos_supplier_int_rejections
3159: (SELECT p_batch_id,
3160: l_request_id,
3161: 'AP_SUPPLIER_SITES_INT',
3162: vendor_site_interface_id,
3163: 'POS_INVALID_PARTY_ORIG_SYSTEM',
3164: g_user_id,
3165: SYSDATE,

Line 3169: FROM ap_supplier_sites_int

3165: SYSDATE,
3166: g_login_id,
3167: g_user_id,
3168: SYSDATE
3169: FROM ap_supplier_sites_int
3170: WHERE status = 'REMOVED'
3171: AND import_request_id = l_request_id
3172: AND sdh_batch_id = p_batch_id);
3173:

Line 3213: UPDATE ap_supplier_sites_int

3209: WHERE supp.party_id = l_party_id;
3210:
3211: EXCEPTION
3212: WHEN OTHERS THEN
3213: UPDATE ap_supplier_sites_int
3214: SET status = 'REJECTED'
3215: WHERE vendor_site_interface_id =
3216: site_int_rec.vendor_site_interface_id
3217: AND sdh_batch_id = p_batch_id;

Line 3221: 'AP_SUPPLIER_SITES_INT',

3217: AND sdh_batch_id = p_batch_id;
3218:
3219: IF (insert_rejections(p_batch_id,
3220: l_request_id,
3221: 'AP_SUPPLIER_SITES_INT',
3222: site_int_rec.vendor_site_interface_id,
3223: 'AP_VENDOR_ID_NULL',
3224: g_user_id,
3225: g_login_id,

Line 3509: UPDATE ap_supplier_sites_int

3505: l_vendor_site_id);
3506:
3507: IF l_return_status = fnd_api.g_ret_sts_success THEN
3508:
3509: UPDATE ap_supplier_sites_int
3510: SET status = 'PROCESSED'
3511: WHERE vendor_site_interface_id =
3512: site_rec.vendor_site_interface_id
3513: AND sdh_batch_id = p_batch_id;

Line 3522: UPDATE ap_supplier_sites_int

3518: sites_updated = sites_updated + 1,
3519: sites_imported = sites_imported + 1
3520: WHERE batch_id = p_batch_id;
3521: ELSE
3522: UPDATE ap_supplier_sites_int
3523: SET status = 'REJECTED'
3524: WHERE vendor_site_interface_id =
3525: site_rec.vendor_site_interface_id
3526: AND sdh_batch_id = p_batch_id;

Line 3550: WHERE parent_table = 'AP_SUPPLIER_SITES_INT'

3546: last_update_login,
3547: created_by,
3548: creation_date
3549: FROM ap_supplier_int_rejections
3550: WHERE parent_table = 'AP_SUPPLIER_SITES_INT'
3551: AND parent_id = site_rec.vendor_site_interface_id;
3552:
3553: IF (g_level_procedure >= g_current_runtime_level) THEN
3554: fnd_log.string(g_level_procedure,

Line 10344: FROM ap_supplier_sites_int

10340: retcode := 1;
10341: ELSE
10342: SELECT COUNT(1)
10343: INTO l_error_count
10344: FROM ap_supplier_sites_int
10345: WHERE sdh_batch_id = p_batch_id
10346: AND nvl(status, 'ACTIVE') = 'REJECTED'
10347: AND rownum = 1;
10348: