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_GRP dependencies on CHV_AUTHORIZATIONS

Line 138: UPDATE chv_authorizations_gt CHV

134:
135: l_progress := 25;
136: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
137:
138: UPDATE chv_authorizations_gt CHV
139: SET reference_id = (SELECT asl_id
140: FROM po_approved_supplier_list_gt PASL
141: WHERE PASL.user_key = CHV.user_key
142: AND ROWNUM < 2);

Line 376: 'chv_authorizations_gt' ,

372: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
373: --Reject records if authorization process mode is add, asl mode is update
374: --and authorization code or sequence already exists for that org
375: SELECT CHVGT.user_key ,
376: 'chv_authorizations_gt' ,
377: fnd_message.get_string('PO','DUPLICATE_AUTHORIZATION')
378: BULK COLLECT INTO
379: l_user_key_tbl ,
380: l_entity_name ,

Line 382: FROM chv_authorizations_gt CHVGT,

378: BULK COLLECT INTO
379: l_user_key_tbl ,
380: l_entity_name ,
381: l_reject_reason
382: FROM chv_authorizations_gt CHVGT,
383: po_approved_supplier_list_gt ASLGT
384: WHERE EXISTS
385: (SELECT 1
386: FROM chv_authorizations CHV

Line 386: FROM chv_authorizations CHV

382: FROM chv_authorizations_gt CHVGT,
383: po_approved_supplier_list_gt ASLGT
384: WHERE EXISTS
385: (SELECT 1
386: FROM chv_authorizations CHV
387: WHERE CHVGT.reference_id = CHV.reference_id
388: AND CHVGT.using_organization_id = CHV.using_organization_id
389: AND (CHVGT.authorization_code = CHV.authorization_code
390: OR

Line 404: 'chv_authorizations_gt' ,

400: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
401: --Reject records if authorization process mode is delete, asl mode is update
402: --and authorization code and sequence not exists for that org
403: SELECT CHVGT.user_key ,
404: 'chv_authorizations_gt' ,
405: fnd_message.get_string('PO','AUTHORIZATION_NOT_EXIST')
406: BULK COLLECT INTO
407: l_user_key_tbl ,
408: l_entity_name ,

Line 410: FROM chv_authorizations_gt CHVGT,

406: BULK COLLECT INTO
407: l_user_key_tbl ,
408: l_entity_name ,
409: l_reject_reason
410: FROM chv_authorizations_gt CHVGT,
411: po_approved_supplier_list_gt ASLGT
412: WHERE NOT EXISTS
413: (SELECT 1
414: FROM chv_authorizations CHV

Line 414: FROM chv_authorizations CHV

410: FROM chv_authorizations_gt CHVGT,
411: po_approved_supplier_list_gt ASLGT
412: WHERE NOT EXISTS
413: (SELECT 1
414: FROM chv_authorizations CHV
415: WHERE CHVGT.reference_id = CHV.reference_id
416: AND CHVGT.using_organization_id = CHV.using_organization_id
417: AND CHVGT.authorization_code = CHV.authorization_code
418: AND CHVGT.authorization_sequence_dsp=CHV.authorization_sequence

Line 432: 'chv_authorizations_gt' ,

428: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
429: --Reject records if authorization process mode is add, asl mode is create
430: --and authorization code or sequence already exists for that org
431: SELECT CHVGT.user_key ,
432: 'chv_authorizations_gt' ,
433: fnd_message.get_string('PO','DUPLICATE_AUTHORIZATION')
434: BULK COLLECT INTO
435: l_user_key_tbl ,
436: l_entity_name ,

Line 438: FROM chv_authorizations_gt CHVGT ,

434: BULK COLLECT INTO
435: l_user_key_tbl ,
436: l_entity_name ,
437: l_reject_reason
438: FROM chv_authorizations_gt CHVGT ,
439: po_approved_supplier_list_gt ASLGT
440: WHERE 2 <=
441: (SELECT Count(user_key)
442: FROM chv_authorizations_gt CHV

Line 442: FROM chv_authorizations_gt CHV

438: FROM chv_authorizations_gt CHVGT ,
439: po_approved_supplier_list_gt ASLGT
440: WHERE 2 <=
441: (SELECT Count(user_key)
442: FROM chv_authorizations_gt CHV
443: WHERE CHVGT.reference_id = CHV.reference_id
444: AND CHVGT.using_organization_id = CHV.using_organization_id
445: AND (CHVGT.authorization_code = CHV.authorization_code
446: OR CHVGT.authorization_sequence_dsp =

Line 815: FROM chv_authorizations_gt CHV

811: AND PAA.user_key = ASLGT.user_key)
812: OR
813: EXISTS
814: (SELECT 1
815: FROM chv_authorizations_gt CHV
816: WHERE CHV.reference_id = ASLGT.asl_id
817: AND CHV.user_key = ASLGT.user_key)
818: OR
819: EXISTS

Line 1098: --there is an entry for chv_authorizations in case of CREATE

1094: l_entity_name ,
1095: l_reject_reason
1096: FROM (
1097: --Reject records if authorization flag is not checked and
1098: --there is an entry for chv_authorizations in case of CREATE
1099: SELECT user_key ,
1100: 'po_asl_attributes_gt' AS entity ,
1101: fnd_message.get_string('PO','INVALID_AUTHORIZATION_ENTRY') AS msg
1102: FROM po_asl_attributes_gt PAAGT

Line 1106: FROM chv_authorizations_gt CHV

1102: FROM po_asl_attributes_gt PAAGT
1103: WHERE NVL(PAAGT.enable_authorizations_flag_dsp,'N') <> 'Y'
1104: AND EXISTS
1105: (SELECT 1
1106: FROM chv_authorizations_gt CHV
1107: WHERE CHV.reference_id = PAAGT.asl_id
1108: AND CHV.using_organization_id = PAAGT.using_organization_id
1109: AND CHV.user_key = PAAGT.user_key
1110: AND CHV.process_action = PO_ASL_API_PUB.g_ACTION_ADD)

Line 1469: FROM chv_authorizations_gt CHV

1465: OR PAAGT.scheduler_id IS NOT NULL
1466: OR PAAGT.enable_authorizations_flag_dsp = 'Y'
1467: OR EXISTS
1468: (SELECT 1
1469: FROM chv_authorizations_gt CHV
1470: WHERE CHV.reference_id = PAAGT.asl_id
1471: AND CHV.using_organization_id = PAAGT.using_organization_id
1472: AND CHV.user_key = PAAGT.user_key))
1473:

Line 1619: -- This will validate data in chv_authorizations_gt table

1615:
1616: --Name: validate_chv_auth_gt
1617:
1618: --Function:
1619: -- This will validate data in chv_authorizations_gt table
1620:
1621: --Parameters:
1622:
1623: --OUT:

Line 1653: 'chv_authorizations_gt' AS entity ,

1649: l_reject_reason
1650: FROM (
1651: --Reject records if sequence number is empty or not in 1,2,3,4
1652: SELECT user_key ,
1653: 'chv_authorizations_gt' AS entity ,
1654: fnd_message.get_string('PO','INVALID_AUTH_SEQUENCE') AS msg
1655: FROM chv_authorizations_gt CHVGT
1656: WHERE CHVGT.authorization_sequence_dsp IS NULL
1657: OR CHVGT.authorization_sequence_dsp NOT IN (1,2,3,4)

Line 1655: FROM chv_authorizations_gt CHVGT

1651: --Reject records if sequence number is empty or not in 1,2,3,4
1652: SELECT user_key ,
1653: 'chv_authorizations_gt' AS entity ,
1654: fnd_message.get_string('PO','INVALID_AUTH_SEQUENCE') AS msg
1655: FROM chv_authorizations_gt CHVGT
1656: WHERE CHVGT.authorization_sequence_dsp IS NULL
1657: OR CHVGT.authorization_sequence_dsp NOT IN (1,2,3,4)
1658:
1659: UNION ALL

Line 1662: 'chv_authorizations_gt' AS entity ,

1658:
1659: UNION ALL
1660: --Reject records if timefence days is less than 1
1661: SELECT user_key ,
1662: 'chv_authorizations_gt' AS entity ,
1663: fnd_message.get_string('PO','INVALID_TIMEFENCE_DAYS') AS msg
1664: FROM chv_authorizations_gt CHVGT
1665: WHERE CHVGT.timefence_days_dsp IS NULL
1666: OR CHVGT.timefence_days_dsp <= 0

Line 1664: FROM chv_authorizations_gt CHVGT

1660: --Reject records if timefence days is less than 1
1661: SELECT user_key ,
1662: 'chv_authorizations_gt' AS entity ,
1663: fnd_message.get_string('PO','INVALID_TIMEFENCE_DAYS') AS msg
1664: FROM chv_authorizations_gt CHVGT
1665: WHERE CHVGT.timefence_days_dsp IS NULL
1666: OR CHVGT.timefence_days_dsp <= 0
1667:
1668: );