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.AHL_MEL_CDL_APPROVALS_PVT dependencies on AHL_MEL_CDL_APPROVALS_PVT

Line 1: PACKAGE BODY AHL_MEL_CDL_APPROVALS_PVT AS

1: PACKAGE BODY AHL_MEL_CDL_APPROVALS_PVT AS
2: /* $Header: AHLVMAPB.pls 120.6.12020000.2 2012/12/10 13:53:15 shnatu ship $ */
3:
4: --------------------
5: -- Common cursors --

Line 473: 'AHL_MEL_CDL_APPROVALS_PVT',

469: END IF;
470:
471: wf_core.context
472: (
473: 'AHL_MEL_CDL_APPROVALS_PVT',
474: 'SET_ACTIVITY_DETAILS',
475: itemtype,
476: itemkey,
477: actid,

Line 487: 'AHL_MEL_CDL_APPROVALS_PVT',

483:
484: WHEN OTHERS THEN
485: wf_core.context
486: (
487: 'AHL_MEL_CDL_APPROVALS_PVT',
488: 'SET_ACTIVITY_DETAILS',
489: itemtype,
490: itemkey,
491: actid,

Line 652: 'AHL_MEL_CDL_APPROVALS_PVT',

648: END IF;
649:
650: wf_core.context
651: (
652: 'AHL_MEL_CDL_APPROVALS_PVT',
653: 'NTF_FORWARD_FYI',
654: l_item_type,
655: l_item_key,
656: l_error_msg

Line 663: 'AHL_MEL_CDL_APPROVALS_PVT',

659:
660: WHEN OTHERS THEN
661: wf_core.context
662: (
663: 'AHL_MEL_CDL_APPROVALS_PVT',
664: 'NTF_FORWARD_FYI',
665: l_item_type,
666: l_item_key
667: );

Line 825: 'AHL_MEL_CDL_APPROVALS_PVT',

821: END IF;
822:
823: wf_core.context
824: (
825: 'AHL_MEL_CDL_APPROVALS_PVT',
826: 'NTF_APPROVED_FYI',
827: l_item_type,
828: l_item_key,
829: l_error_msg

Line 836: 'AHL_MEL_CDL_APPROVALS_PVT',

832:
833: WHEN OTHERS THEN
834: wf_core.context
835: (
836: 'AHL_MEL_CDL_APPROVALS_PVT',
837: 'NTF_APPROVED_FYI',
838: l_item_type,
839: l_item_key
840: );

Line 989: 'AHL_MEL_CDL_APPROVALS_PVT',

985: END IF;
986:
987: wf_core.context
988: (
989: 'AHL_MEL_CDL_APPROVALS_PVT',
990: 'NTF_FINAL_APPROVAL_FYI',
991: l_item_type,
992: l_item_key,
993: l_error_msg

Line 1000: 'AHL_MEL_CDL_APPROVALS_PVT',

996:
997: WHEN OTHERS THEN
998: wf_core.context
999: (
1000: 'AHL_MEL_CDL_APPROVALS_PVT',
1001: 'NTF_FINAL_APPROVAL_FYI',
1002: l_item_type,
1003: l_item_key
1004: );

Line 1162: 'AHL_MEL_CDL_APPROVALS_PVT',

1158: END IF;
1159:
1160: wf_core.context
1161: (
1162: 'AHL_MEL_CDL_APPROVALS_PVT',
1163: 'NTF_REJECTED_FYI',
1164: l_item_type,
1165: l_item_key,
1166: l_error_msg

Line 1173: 'AHL_MEL_CDL_APPROVALS_PVT',

1169:
1170: WHEN OTHERS THEN
1171: wf_core.context
1172: (
1173: 'AHL_MEL_CDL_APPROVALS_PVT',
1174: 'NTF_REJECTED_FYI',
1175: l_item_type,
1176: l_item_key
1177: );

Line 1344: 'AHL_MEL_CDL_APPROVALS_PVT',

1340: END IF;
1341:
1342: wf_core.context
1343: (
1344: 'AHL_MEL_CDL_APPROVALS_PVT',
1345: 'NTF_APPROVAL',
1346: l_item_type,
1347: l_item_key,
1348: l_error_msg

Line 1355: 'AHL_MEL_CDL_APPROVALS_PVT',

1351:
1352: WHEN OTHERS THEN
1353: wf_core.context
1354: (
1355: 'AHL_MEL_CDL_APPROVALS_PVT',
1356: 'NTF_APPROVAL',
1357: l_item_type,
1358: l_item_key
1359: );

Line 1526: 'AHL_MEL_CDL_APPROVALS_PVT',

1522: END IF;
1523:
1524: wf_core.context
1525: (
1526: 'AHL_MEL_CDL_APPROVALS_PVT',
1527: 'NTF_APPROVAL_REMINDER',
1528: l_item_type,
1529: l_item_key,
1530: l_error_msg

Line 1537: 'AHL_MEL_CDL_APPROVALS_PVT',

1533:
1534: WHEN OTHERS THEN
1535: wf_core.context
1536: (
1537: 'AHL_MEL_CDL_APPROVALS_PVT',
1538: 'NTF_APPROVAL_REMINDER',
1539: l_item_type,
1540: l_item_key
1541: );

Line 1698: 'AHL_MEL_CDL_APPROVALS_PVT',

1694: END IF;
1695:
1696: wf_core.context
1697: (
1698: 'AHL_MEL_CDL_APPROVALS_PVT',
1699: 'NTF_ERROR_ACT',
1700: l_item_type,
1701: l_item_key,
1702: l_error_msg

Line 1709: 'AHL_MEL_CDL_APPROVALS_PVT',

1705:
1706: WHEN OTHERS THEN
1707: wf_core.context
1708: (
1709: 'AHL_MEL_CDL_APPROVALS_PVT',
1710: 'NTF_ERROR_ACT',
1711: l_item_type,
1712: l_item_key
1713: );

Line 1921: 'AHL_MEL_CDL_APPROVALS_PVT',

1917: END IF;
1918:
1919: wf_core.context
1920: (
1921: 'AHL_MEL_CDL_APPROVALS_PVT',
1922: 'UPDATE_STATUS',
1923: itemtype,
1924: itemkey,
1925: actid,

Line 1935: 'AHL_MEL_CDL_APPROVALS_PVT',

1931:
1932: WHEN OTHERS THEN
1933: wf_core.context
1934: (
1935: 'AHL_MEL_CDL_APPROVALS_PVT',
1936: 'UPDATE_STATUS',
1937: itemtype,
1938: itemkey,
1939: actid,

Line 2102: 'AHL_MEL_CDL_APPROVALS_PVT',

2098: END IF;
2099:
2100: wf_core.context
2101: (
2102: 'AHL_MEL_CDL_APPROVALS_PVT',
2103: 'REVERT_STATUS',
2104: itemtype,
2105: itemkey,
2106: actid,

Line 2116: 'AHL_MEL_CDL_APPROVALS_PVT',

2112:
2113: WHEN OTHERS THEN
2114: wf_core.context
2115: (
2116: 'AHL_MEL_CDL_APPROVALS_PVT',
2117: 'REVERT_STATUS',
2118: itemtype,
2119: itemkey,
2120: actid,

Line 2599: 'AHL_MEL_CDL_APPROVALS_PVT',

2595: END IF;
2596:
2597: wf_core.context
2598: (
2599: 'AHL_MEL_CDL_APPROVALS_PVT',
2600: 'NR_SET_ACTIVITY_DETAILS',
2601: itemtype,
2602: itemkey,
2603: actid,

Line 2613: 'AHL_MEL_CDL_APPROVALS_PVT',

2609:
2610: WHEN OTHERS THEN
2611: wf_core.context
2612: (
2613: 'AHL_MEL_CDL_APPROVALS_PVT',
2614: 'NR_SET_ACTIVITY_DETAILS',
2615: itemtype,
2616: itemkey,
2617: actid,

Line 2771: 'AHL_MEL_CDL_APPROVALS_PVT',

2767: END IF;
2768:
2769: wf_core.context
2770: (
2771: 'AHL_MEL_CDL_APPROVALS_PVT',
2772: 'NR_NTF_FORWARD_FYI',
2773: l_item_type,
2774: l_item_key,
2775: l_error_msg

Line 2782: 'AHL_MEL_CDL_APPROVALS_PVT',

2778:
2779: WHEN OTHERS THEN
2780: wf_core.context
2781: (
2782: 'AHL_MEL_CDL_APPROVALS_PVT',
2783: 'NR_NTF_FORWARD_FYI',
2784: l_item_type,
2785: l_item_key
2786: );

Line 2937: 'AHL_MEL_CDL_APPROVALS_PVT',

2933: END IF;
2934:
2935: wf_core.context
2936: (
2937: 'AHL_MEL_CDL_APPROVALS_PVT',
2938: 'NR_NTF_APPROVED_FYI',
2939: l_item_type,
2940: l_item_key,
2941: l_error_msg

Line 2948: 'AHL_MEL_CDL_APPROVALS_PVT',

2944:
2945: WHEN OTHERS THEN
2946: wf_core.context
2947: (
2948: 'AHL_MEL_CDL_APPROVALS_PVT',
2949: 'NR_NTF_APPROVED_FYI',
2950: l_item_type,
2951: l_item_key
2952: );

Line 3090: 'AHL_MEL_CDL_APPROVALS_PVT',

3086: END IF;
3087:
3088: wf_core.context
3089: (
3090: 'AHL_MEL_CDL_APPROVALS_PVT',
3091: 'NR_NTF_FINAL_APPROVAL_FYI',
3092: l_item_type,
3093: l_item_key,
3094: l_error_msg

Line 3101: 'AHL_MEL_CDL_APPROVALS_PVT',

3097:
3098: WHEN OTHERS THEN
3099: wf_core.context
3100: (
3101: 'AHL_MEL_CDL_APPROVALS_PVT',
3102: 'NR_NTF_FINAL_APPROVAL_FYI',
3103: l_item_type,
3104: l_item_key
3105: );

Line 3259: 'AHL_MEL_CDL_APPROVALS_PVT',

3255: END IF;
3256:
3257: wf_core.context
3258: (
3259: 'AHL_MEL_CDL_APPROVALS_PVT',
3260: 'NR_NTF_REJECTED_FYI',
3261: l_item_type,
3262: l_item_key,
3263: l_error_msg

Line 3270: 'AHL_MEL_CDL_APPROVALS_PVT',

3266:
3267: WHEN OTHERS THEN
3268: wf_core.context
3269: (
3270: 'AHL_MEL_CDL_APPROVALS_PVT',
3271: 'NR_NTF_REJECTED_FYI',
3272: l_item_type,
3273: l_item_key
3274: );

Line 3426: 'AHL_MEL_CDL_APPROVALS_PVT',

3422: END IF;
3423:
3424: wf_core.context
3425: (
3426: 'AHL_MEL_CDL_APPROVALS_PVT',
3427: 'NR_NTF_APPROVAL',
3428: l_item_type,
3429: l_item_key,
3430: l_error_msg

Line 3437: 'AHL_MEL_CDL_APPROVALS_PVT',

3433:
3434: WHEN OTHERS THEN
3435: wf_core.context
3436: (
3437: 'AHL_MEL_CDL_APPROVALS_PVT',
3438: 'NR_NTF_APPROVAL',
3439: l_item_type,
3440: l_item_key
3441: );

Line 3609: 'AHL_MEL_CDL_APPROVALS_PVT',

3605: END IF;
3606:
3607: wf_core.context
3608: (
3609: 'AHL_MEL_CDL_APPROVALS_PVT',
3610: 'NR_NTF_APPROVAL_REMINDER',
3611: l_item_type,
3612: l_item_key,
3613: l_error_msg

Line 3620: 'AHL_MEL_CDL_APPROVALS_PVT',

3616:
3617: WHEN OTHERS THEN
3618: wf_core.context
3619: (
3620: 'AHL_MEL_CDL_APPROVALS_PVT',
3621: 'NR_NTF_APPROVAL_REMINDER',
3622: l_item_type,
3623: l_item_key
3624: );

Line 3771: 'AHL_MEL_CDL_APPROVALS_PVT',

3767: END IF;
3768:
3769: wf_core.context
3770: (
3771: 'AHL_MEL_CDL_APPROVALS_PVT',
3772: 'NR_NTF_ERROR_ACT',
3773: l_item_type,
3774: l_item_key,
3775: l_error_msg

Line 3782: 'AHL_MEL_CDL_APPROVALS_PVT',

3778:
3779: WHEN OTHERS THEN
3780: wf_core.context
3781: (
3782: 'AHL_MEL_CDL_APPROVALS_PVT',
3783: 'NR_NTF_ERROR_ACT',
3784: l_item_type,
3785: l_item_key
3786: );

Line 4044: wf_core.context('AHL_MEL_CDL_APPROVALS_PVT',

4040: p_attr_name => 'ERROR_MSG',
4041: x_error_msg => l_error_msg
4042: ) ;
4043:
4044: wf_core.context('AHL_MEL_CDL_APPROVALS_PVT',
4045: 'NR_UPDATE_STATUS',
4046: itemtype,itemkey,l_error_msg);
4047:
4048:

Line 4090: wf_core.context( 'AHL_MEL_CDL_APPROVALS_PVT', 'NR_UPDATE_STATUS', itemtype, itemkey );

4086: x_resultout => resultout);
4087: */
4088: WHEN OTHERS THEN
4089: ROLLBACK TO AHL_NR_UPDATE_STATUS;
4090: wf_core.context( 'AHL_MEL_CDL_APPROVALS_PVT', 'NR_UPDATE_STATUS', itemtype, itemkey );
4091:
4092: l_error_msg := SQLCODE || ': ' || SQLERRM;
4093:
4094: -- update validation errors.

Line 4309: 'AHL_MEL_CDL_APPROVALS_PVT',

4305: END IF;
4306:
4307: wf_core.context
4308: (
4309: 'AHL_MEL_CDL_APPROVALS_PVT',
4310: 'NR_REVERT_STATUS',
4311: itemtype,
4312: itemkey,
4313: actid,

Line 4345: 'AHL_MEL_CDL_APPROVALS_PVT',

4341: WHEN OTHERS THEN
4342: ROLLBACK TO AHL_NR_REVERT_STATUS;
4343: wf_core.context
4344: (
4345: 'AHL_MEL_CDL_APPROVALS_PVT',
4346: 'NR_REVERT_STATUS',
4347: itemtype,
4348: itemkey,
4349: actid,

Line 4460: 'AHL_MEL_CDL_APPROVALS_PVT',

4456: END IF;
4457:
4458: wf_core.context
4459: (
4460: 'AHL_MEL_CDL_APPROVALS_PVT',
4461: 'NR_REVERT_STATUS',
4462: p_itemtype,
4463: p_itemkey,
4464: p_actid,

Line 4475: 'AHL_MEL_CDL_APPROVALS_PVT',

4471:
4472: WHEN OTHERS THEN
4473: wf_core.context
4474: (
4475: 'AHL_MEL_CDL_APPROVALS_PVT',
4476: 'NR_REVERT_STATUS',
4477: p_itemtype,
4478: p_itemkey,
4479: p_actid,

Line 4488: End AHL_MEL_CDL_APPROVALS_PVT;

4484: RAISE;
4485:
4486: END NR_Rollback_Status;
4487:
4488: End AHL_MEL_CDL_APPROVALS_PVT;