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.

[Home] [Help]

APPS.PO_ASL_API_PUB dependencies on PO_SUPPLIER_ITEM_TOLERANCE_GT

Line 161: DELETE FROM po_supplier_item_tolerance_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;
165: po_asl_api_pvt.Log('session key:' || x_session_key);

Line 317: FROM po_supplier_item_tolerance_gt

313: l_progress := 75;
314: --Raise exception in case user_key not found in parent table
315: SELECT Count(*)
316: INTO invalids
317: FROM po_supplier_item_tolerance_gt
318: WHERE NOT EXISTS
319: (SELECT user_key
320: FROM po_approved_supplier_list_gt);
321:

Line 396: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_tolerance_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;
398: x_return_msg := 'Unexpected while dumping to po_supplier_item_tolerance_gt';
399:
400: WHEN OTHERS THEN

Line 398: x_return_msg := 'Unexpected while dumping to po_supplier_item_tolerance_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;
398: x_return_msg := 'Unexpected while dumping to po_supplier_item_tolerance_gt';
399:
400: WHEN OTHERS THEN
401: po_asl_api_pvt.log('create_update_asl : when others exception at '
402: || l_progress || ';' || SQLERRM );

Line 474: --updating po_supplier_item_tolerance_gt to derive id fields

470: x_return_msg => x_return_msg
471: );
472: l_progress := 40;
473:
474: --updating po_supplier_item_tolerance_gt to derive id fields
475: derive_ids_sup_tol(
476: x_return_status => x_return_status,
477: x_return_msg => x_return_msg
478: );

Line 1247: -- po_supplier_item_tolerance_gt

1243: --NAME: dump_to_tolerance_gtt
1244:
1245: --FUNCTION:
1246: -- this will dump all the data FROM p_capacity_rec to
1247: -- po_supplier_item_tolerance_gt
1248:
1249: --parameters:
1250:
1251: --IN:

Line 1274: INSERT INTO po_supplier_item_tolerance_gt (

1270: po_asl_api_pvt.log(p_tolerance_rec);
1271: x_return_msg := NULL;
1272:
1273: FORALL l_index IN 1 .. p_tolerance_rec.user_key.Count
1274: INSERT INTO po_supplier_item_tolerance_gt (
1275: session_key ,
1276: user_key ,
1277: process_action ,
1278: asl_id ,

Line 1857: -- po_supplier_item_tolerance_gt, which ever applicabale

1853: --NAME: derive_ids_sup_tol
1854:
1855: --FUNCTION:
1856: -- this will derive ids for the display fields in
1857: -- po_supplier_item_tolerance_gt, which ever applicabale
1858:
1859: --parameters:
1860:
1861: --OUT:

Line 1877: UPDATE po_supplier_item_tolerance_gt poit

1873:
1874: BEGIN
1875: po_asl_api_pvt.log('START ::: derive_ids_sup_tol');
1876:
1877: UPDATE po_supplier_item_tolerance_gt poit
1878: SET poit.using_organization_id =
1879: (SELECT hout.organization_id
1880: FROM hr_all_organization_units_tl hout
1881: WHERE hout.name = poit.using_organization_dsp

Line 1886: po_asl_api_pvt.log('derive_ids_sup_tol UPDATE po_supplier_item_tolerance_gt rowcount:'

1882: AND hout.language = UserEnv('lang')
1883: AND ROWNUM < 2)
1884: WHERE poit.using_organization_dsp IS NOT NULL;
1885:
1886: po_asl_api_pvt.log('derive_ids_sup_tol UPDATE po_supplier_item_tolerance_gt rowcount:'
1887: || SQL%ROWCOUNT);
1888: po_asl_api_pvt.log('END ::: derive_ids_sup_tol');
1889: EXCEPTION
1890:

Line 2299: -- po_supplier_item_tolerance_gt, po_asl_documents_gt tables.

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:
2303: -- p_user_key_tbl po_tbl_number

Line 2428: 'po_supplier_item_tolerance_gt' AS entity ,

2424: UNION ALL
2425: --Reject records if ASL Process action is create and tolerance's process
2426: --action is delete/update
2427: SELECT TOL.user_key ,
2428: 'po_supplier_item_tolerance_gt' AS entity ,
2429: fnd_message.get_string('PO','INVALID_TOL_ACTION') AS msg
2430: FROM po_supplier_item_tolerance_gt TOL,
2431: po_approved_supplier_list_gt ASL
2432: WHERE ASL.user_key = TOL.user_key

Line 2430: FROM po_supplier_item_tolerance_gt TOL,

2426: --action is delete/update
2427: SELECT TOL.user_key ,
2428: 'po_supplier_item_tolerance_gt' AS entity ,
2429: fnd_message.get_string('PO','INVALID_TOL_ACTION') AS msg
2430: FROM po_supplier_item_tolerance_gt TOL,
2431: po_approved_supplier_list_gt ASL
2432: WHERE ASL.user_key = TOL.user_key
2433: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2434: AND TOL.process_action <> PO_ASL_API_PUB.g_ACTION_ADD

Line 2480: 'po_supplier_item_tolerance_gt' AS entity,

2476:
2477: UNION ALL
2478:
2479: SELECT user_key ,
2480: 'po_supplier_item_tolerance_gt' AS entity,
2481: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2482: FROM po_supplier_item_tolerance_gt
2483: WHERE using_organization_dsp IS NOT NULL
2484: AND using_organization_id IS NULL

Line 2482: FROM po_supplier_item_tolerance_gt

2478:
2479: SELECT user_key ,
2480: 'po_supplier_item_tolerance_gt' AS entity,
2481: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2482: FROM po_supplier_item_tolerance_gt
2483: WHERE using_organization_dsp IS NOT NULL
2484: AND using_organization_id IS NULL
2485: );
2486: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 2539: 'po_supplier_item_tolerance_gt' AS entity ,

2535:
2536: UNION
2537:
2538: SELECT user_key ,
2539: 'po_supplier_item_tolerance_gt' AS entity ,
2540: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2541: FROM po_supplier_item_tolerance_gt
2542: WHERE process_action NOT IN
2543: (PO_ASL_API_PUB.g_ACTION_ADD ,

Line 2541: FROM po_supplier_item_tolerance_gt

2537:
2538: SELECT user_key ,
2539: 'po_supplier_item_tolerance_gt' AS entity ,
2540: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2541: FROM po_supplier_item_tolerance_gt
2542: WHERE process_action NOT IN
2543: (PO_ASL_API_PUB.g_ACTION_ADD ,
2544: PO_ASL_API_PUB.g_ACTION_UPDATE,
2545: PO_ASL_API_PUB.g_ACTION_DELETE)