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.PO_ASL_API_PUB dependencies on PO_SUPPLIER_ITEM_CAPACITY_GT

Line 160: DELETE FROM po_supplier_item_capacity_gt;

156: DELETE FROM po_approved_supplier_list_gt;
157: DELETE FROM po_asl_documents_gt ;
158: DELETE FROM chv_authorizations_gt;
159: DELETE FROM po_asl_attributes_gt;
160: DELETE FROM po_supplier_item_capacity_gt;
161: DELETE FROM po_supplier_item_tolerance_gt;
162:
163: --generate the session key.
164: SELECT po_session_gt_s.NEXTVAL INTO x_session_key FROM dual;

Line 289: FROM po_supplier_item_capacity_gt

285: l_progress := 65;
286: --Raise exception in case user_key not found in parent table
287: SELECT Count(*)
288: INTO invalids
289: FROM po_supplier_item_capacity_gt
290: WHERE NOT EXISTS
291: (SELECT user_key
292: FROM po_approved_supplier_list_gt);
293:

Line 391: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_capacity_gt');

387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: x_return_msg := 'Unexpected while dumping to chv_authorizations_gt';
389:
390: WHEN unexp_err_psic THEN
391: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_capacity_gt');
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: x_return_msg := 'Unexpected while dumping to po_supplier_item_capacity_gt';
394:
395: WHEN unexp_err_psit THEN

Line 393: x_return_msg := 'Unexpected while dumping to po_supplier_item_capacity_gt';

389:
390: WHEN unexp_err_psic THEN
391: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_capacity_gt');
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: x_return_msg := 'Unexpected while dumping to po_supplier_item_capacity_gt';
394:
395: WHEN unexp_err_psit THEN
396: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_tolerance_gt');
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 467: --updating po_supplier_item_capacity_gt to derive id fields

463: x_return_msg => x_return_msg
464: );
465: l_progress := 35;
466:
467: --updating po_supplier_item_capacity_gt to derive id fields
468: derive_ids_sup_cap(
469: x_return_status => x_return_status,
470: x_return_msg => x_return_msg
471: );

Line 1132: -- po_supplier_item_capacity_gt

1128: --NAME: dump_to_capacity_gtt
1129:
1130: --FUNCTION:
1131: -- this will dump all the data from p_capacity_rec to
1132: -- po_supplier_item_capacity_gt
1133:
1134: --parameters:
1135:
1136: --IN:

Line 1159: INSERT INTO po_supplier_item_capacity_gt (

1155: po_asl_api_pvt.log(p_capacity_rec);
1156: x_return_msg := NULL;
1157:
1158: FORALL l_index IN 1 .. p_capacity_rec.user_key.Count
1159: INSERT INTO po_supplier_item_capacity_gt (
1160: session_key ,
1161: user_key ,
1162: process_action ,
1163: capacity_id ,

Line 1808: -- po_supplier_item_capacity_gt, which ever applicabale

1804: --NAME: derive_ids_sup_cap
1805:
1806: --FUNCTION:
1807: -- this will derive ids for the display fields in
1808: -- po_supplier_item_capacity_gt, which ever applicabale
1809:
1810: --parameters:
1811:
1812: --OUT:

Line 1828: UPDATE po_supplier_item_capacity_gt poic

1824:
1825: BEGIN
1826: po_asl_api_pvt.log('START ::: derive_ids_sup_cap');
1827:
1828: UPDATE po_supplier_item_capacity_gt poic
1829: SET poic.using_organization_id =
1830: (SELECT hout.organization_id
1831: FROM hr_all_organization_units_tl hout
1832: WHERE hout.name = poic.using_organization_dsp

Line 1837: po_asl_api_pvt.log('derive_ids_sup_cap UPDATE po_supplier_item_capacity_gt rowcount:'

1833: AND hout.language = UserEnv('lang')
1834: AND ROWNUM < 2)
1835: WHERE poic.using_organization_dsp IS NOT NULL;
1836:
1837: po_asl_api_pvt.log('derive_ids_sup_cap UPDATE po_supplier_item_capacity_gt rowcount:'
1838: || SQL%ROWCOUNT);
1839: po_asl_api_pvt.log('END ::: derive_ids_sup_cap');
1840: EXCEPTION
1841:

Line 2298: -- in chv_authorizations_gt, po_supplier_item_capacity_gt,

2294: --NAME: collect_invalids_in_other_gt
2295:
2296: --FUNCTION:
2297: -- This will collect userkeys for which ids not found for the descriptions
2298: -- in chv_authorizations_gt, po_supplier_item_capacity_gt,
2299: -- po_supplier_item_tolerance_gt, po_asl_documents_gt tables.
2300:
2301: --PARAMETERS:
2302: --IN:

Line 2416: 'po_supplier_item_capacity_gt' AS entity ,

2412: UNION ALL
2413: --Reject records if ASL Process action is create and capacity's process
2414: --action is delete/update
2415: SELECT CAP.user_key ,
2416: 'po_supplier_item_capacity_gt' AS entity ,
2417: fnd_message.get_string('PO','INVALID_CAP_ACTION') AS msg
2418: FROM po_supplier_item_capacity_gt CAP,
2419: po_approved_supplier_list_gt ASL
2420: WHERE ASL.user_key = CAP.user_key

Line 2418: FROM po_supplier_item_capacity_gt CAP,

2414: --action is delete/update
2415: SELECT CAP.user_key ,
2416: 'po_supplier_item_capacity_gt' AS entity ,
2417: fnd_message.get_string('PO','INVALID_CAP_ACTION') AS msg
2418: FROM po_supplier_item_capacity_gt CAP,
2419: po_approved_supplier_list_gt ASL
2420: WHERE ASL.user_key = CAP.user_key
2421: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2422: AND CAP.process_action <> PO_ASL_API_PUB.g_ACTION_ADD

Line 2471: 'po_supplier_item_capacity_gt' AS entity ,

2467:
2468: UNION ALL
2469:
2470: SELECT user_key ,
2471: 'po_supplier_item_capacity_gt' AS entity ,
2472: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2473: FROM po_supplier_item_capacity_gt
2474: WHERE using_organization_dsp IS NOT NULL
2475: AND using_organization_id IS NULL

Line 2473: FROM po_supplier_item_capacity_gt

2469:
2470: SELECT user_key ,
2471: 'po_supplier_item_capacity_gt' AS entity ,
2472: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2473: FROM po_supplier_item_capacity_gt
2474: WHERE using_organization_dsp IS NOT NULL
2475: AND using_organization_id IS NULL
2476:
2477: UNION ALL

Line 2527: 'po_supplier_item_capacity_gt' AS entity ,

2523:
2524: UNION
2525:
2526: SELECT user_key ,
2527: 'po_supplier_item_capacity_gt' AS entity ,
2528: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2529: FROM po_supplier_item_capacity_gt
2530: WHERE process_action NOT IN
2531: (PO_ASL_API_PUB.g_ACTION_ADD ,

Line 2529: FROM po_supplier_item_capacity_gt

2525:
2526: SELECT user_key ,
2527: 'po_supplier_item_capacity_gt' AS entity ,
2528: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2529: FROM po_supplier_item_capacity_gt
2530: WHERE process_action NOT IN
2531: (PO_ASL_API_PUB.g_ACTION_ADD ,
2532: PO_ASL_API_PUB.g_ACTION_UPDATE,
2533: PO_ASL_API_PUB.g_ACTION_DELETE)