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 CHV_AUTHORIZATIONS_GT

Line 158: DELETE FROM chv_authorizations_gt;

154: po_asl_api_pvt.Log('p_commit:' || p_commit);
155: --Empty GT tables
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:

Line 261: FROM chv_authorizations_gt

257: l_progress := 55;
258: --Raise exception in case user_key not found in parent table
259: SELECT Count(*)
260: INTO invalids
261: FROM chv_authorizations_gt
262: WHERE NOT EXISTS
263: (SELECT user_key
264: FROM po_approved_supplier_list_gt);
265:

Line 386: po_asl_api_pvt.log('Unexpected while dumping to chv_authorizations_gt');

382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: x_return_msg := 'Unexpected while dumping to po_asl_documents_gt';
384:
385: WHEN unexp_err_chv THEN
386: po_asl_api_pvt.log('Unexpected while dumping to chv_authorizations_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

Line 388: x_return_msg := 'Unexpected while dumping to chv_authorizations_gt';

384:
385: WHEN unexp_err_chv THEN
386: po_asl_api_pvt.log('Unexpected while dumping to chv_authorizations_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;

Line 453: --updating chv_authorizations_gt to derive id fields

449: x_return_msg => x_return_msg
450: );
451: l_progress := 20;
452:
453: --updating chv_authorizations_gt to derive id fields
454: derive_ids_ch_auth(
455: x_return_status => x_return_status,
456: x_return_msg => x_return_msg
457: );

Line 1017: -- this will dump all the data from p_chv_auth_rec to chv_authorizations_gt

1013:
1014: --NAME: dump_to_chv_auth_gtt
1015:
1016: --FUNCTION:
1017: -- this will dump all the data from p_chv_auth_rec to chv_authorizations_gt
1018:
1019: --parameters:
1020:
1021: --IN:

Line 1044: INSERT INTO chv_authorizations_gt (

1040: po_asl_api_pvt.log(p_chv_auth_rec);
1041: x_return_msg := NULL;
1042:
1043: FORALL l_index IN 1 .. p_chv_auth_rec.user_key.Count
1044: INSERT INTO chv_authorizations_gt (
1045: session_key ,
1046: user_key ,
1047: process_action ,
1048: reference_id ,

Line 1577: -- this will derive ids for the display fields in chv_authorizations_gt

1573:
1574: --NAME: derive_ids_ch_auth
1575:
1576: --FUNCTION:
1577: -- this will derive ids for the display fields in chv_authorizations_gt
1578: -- which ever applicabale
1579:
1580: --parameters:
1581:

Line 1599: UPDATE chv_authorizations_gt chv

1595:
1596: BEGIN
1597: po_asl_api_pvt.log('START ::: derive_ids_ch_auth');
1598:
1599: UPDATE chv_authorizations_gt chv
1600: SET chv.authorization_code =
1601: (SELECT polc.lookup_code
1602: FROM po_lookup_codes polc
1603: WHERE polc.lookup_type = 'AUTHORIZATION_TYPE'

Line 1609: UPDATE chv_authorizations_gt chv

1605: AND ROWNUM < 2)
1606: WHERE chv.authorization_code_dsp IS NOT NULL;
1607: l_progress := 50;
1608:
1609: UPDATE chv_authorizations_gt chv
1610: SET chv.using_organization_id =
1611: (SELECT hout.organization_id
1612: FROM hr_all_organization_units_tl hout
1613: WHERE hout.name = chv.using_organization_dsp

Line 1619: po_asl_api_pvt.log('derive_ids_ch_auth update chv_authorizations_gt rowcount:'

1615: AND ROWNUM < 2)
1616: WHERE chv.using_organization_dsp IS NOT NULL;
1617: l_progress := 100;
1618:
1619: po_asl_api_pvt.log('derive_ids_ch_auth update chv_authorizations_gt rowcount:'
1620: || SQL%ROWCOUNT);
1621: po_asl_api_pvt.log('END ::: derive_ids_ch_auth');
1622: EXCEPTION
1623:

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 2340: 'chv_authorizations_gt' AS entity ,

2336: l_entity_name ,
2337: l_rejection_reason
2338: FROM
2339: (SELECT user_key ,
2340: 'chv_authorizations_gt' AS entity ,
2341: fnd_message.get_string('PO','AUTH_CODE_NOT_FOUND') AS msg
2342: FROM chv_authorizations_gt
2343: WHERE authorization_code_dsp IS NOT NULL
2344: AND authorization_code IS NULL

Line 2342: FROM chv_authorizations_gt

2338: FROM
2339: (SELECT user_key ,
2340: 'chv_authorizations_gt' AS entity ,
2341: fnd_message.get_string('PO','AUTH_CODE_NOT_FOUND') AS msg
2342: FROM chv_authorizations_gt
2343: WHERE authorization_code_dsp IS NOT NULL
2344: AND authorization_code IS NULL
2345:
2346: UNION ALL

Line 2404: 'chv_authorizations_gt' AS entity ,

2400: UNION ALL
2401: --Reject records if ASL Process action is create and authorization's process
2402: --action is delete/update
2403: SELECT CHV.user_key ,
2404: 'chv_authorizations_gt' AS entity ,
2405: fnd_message.get_string('PO','INVALID_CHV_ACTION') AS msg
2406: FROM chv_authorizations_gt CHV,
2407: po_approved_supplier_list_gt ASL
2408: WHERE ASL.user_key = CHV.user_key

Line 2406: FROM chv_authorizations_gt CHV,

2402: --action is delete/update
2403: SELECT CHV.user_key ,
2404: 'chv_authorizations_gt' AS entity ,
2405: fnd_message.get_string('PO','INVALID_CHV_ACTION') AS msg
2406: FROM chv_authorizations_gt CHV,
2407: po_approved_supplier_list_gt ASL
2408: WHERE ASL.user_key = CHV.user_key
2409: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2410: AND CHV.process_action <> PO_ASL_API_PUB.g_ACTION_ADD

Line 2462: 'chv_authorizations_gt' AS entity ,

2458:
2459: UNION ALL
2460:
2461: SELECT user_key ,
2462: 'chv_authorizations_gt' AS entity ,
2463: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2464: FROM chv_authorizations_gt
2465: WHERE using_organization_dsp IS NOT NULL
2466: AND using_organization_id IS NULL

Line 2464: FROM chv_authorizations_gt

2460:
2461: SELECT user_key ,
2462: 'chv_authorizations_gt' AS entity ,
2463: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2464: FROM chv_authorizations_gt
2465: WHERE using_organization_dsp IS NOT NULL
2466: AND using_organization_id IS NULL
2467:
2468: UNION ALL

Line 2515: 'chv_authorizations_gt' AS entity ,

2511:
2512: UNION
2513:
2514: SELECT user_key ,
2515: 'chv_authorizations_gt' AS entity ,
2516: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2517: FROM chv_authorizations_gt
2518: WHERE process_action NOT IN
2519: (PO_ASL_API_PUB.g_ACTION_ADD ,

Line 2517: FROM chv_authorizations_gt

2513:
2514: SELECT user_key ,
2515: 'chv_authorizations_gt' AS entity ,
2516: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2517: FROM chv_authorizations_gt
2518: WHERE process_action NOT IN
2519: (PO_ASL_API_PUB.g_ACTION_ADD ,
2520: PO_ASL_API_PUB.g_ACTION_UPDATE,
2521: PO_ASL_API_PUB.g_ACTION_DELETE)