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

Line 1: PACKAGE BODY jtf_rs_role_relate_pvt AS

1: PACKAGE BODY jtf_rs_role_relate_pvt AS
2: /* $Header: jtfrsvlb.pls 120.0 2005/05/11 08:23:06 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a public API that caller will invoke.

Line 12: Calls to these procedures will invoke procedures from jtf_rs_role_relate_pvt

8: Its main procedures are as following:
9: Create Resource Role Relate
10: Update Resource Role Relate
11: Delete Resource Role Relate
12: Calls to these procedures will invoke procedures from jtf_rs_role_relate_pvt
13: to do business validations and to do actual inserts, updates and deletes into tables.
14: ******************************************************************************************/
15: /* Package variables. */
16:

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_ROLE_RELATE_PVT';

13: to do business validations and to do actual inserts, updates and deletes into tables.
14: ******************************************************************************************/
15: /* Package variables. */
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_ROLE_RELATE_PVT';
18: G_NAME VARCHAR2(240);
19:
20:
21: /* private procedure to check that is updating role date for resource then

Line 519: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))

515:
516:
517: -- user hook calls for customer
518: -- Customer pre- processing section - mandatory
519: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
520: then
521: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
522: then
523:

Line 521: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))

517: -- user hook calls for customer
518: -- Customer pre- processing section - mandatory
519: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
520: then
521: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
522: then
523:
524:
525: JTF_RS_ROLE_RELATE_CUHK.CREATE_RES_ROLE_RELATE_PRE(P_ROLE_RESOURCE_TYPE => p_role_resource_type,

Line 547: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))

543: end if;
544:
545: /* Vertial industry pre- processing section - mandatory */
546:
547: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
548: then
549: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
550: then
551:

Line 549: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))

545: /* Vertial industry pre- processing section - mandatory */
546:
547: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
548: then
549: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
550: then
551:
552: JTF_RS_ROLE_RELATE_VUHK.CREATE_RES_ROLE_RELATE_PRE(P_ROLE_RESOURCE_TYPE => p_role_resource_type,
553: P_ROLE_RESOURCE_ID => p_role_resource_id,

Line 574: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))

570: end if;
571:
572: /* Internal pre- processing section - mandatory */
573:
574: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
575: then
576: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
577: then
578:

Line 576: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))

572: /* Internal pre- processing section - mandatory */
573:
574: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
575: then
576: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
577: then
578:
579: JTF_RS_ROLE_RELATE_IUHK.CREATE_RES_ROLE_RELATE_PRE(P_ROLE_RESOURCE_TYPE => p_role_resource_type,
580: P_ROLE_RESOURCE_ID => p_role_resource_id,

Line 1065: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'C' ))

1061:
1062: --dbms_output.put_line ('Debug Message 22');
1063: -- user hook calls for customer
1064: -- Customer post- processing section - mandatory
1065: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'C' ))
1066: then
1067: JTF_RS_ROLE_RELATE_CUHK.CREATE_RES_ROLE_RELATE_POST(P_ROLE_RELATE_ID => l_role_relate_id,
1068: P_ROLE_RESOURCE_TYPE => p_role_resource_type,
1069: P_ROLE_RESOURCE_ID => p_role_resource_id,

Line 1092: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))

1088: --dbms_output.put_line ('Debug Message 23');
1089:
1090: /* Verticle industry post- processing section - mandatory */
1091:
1092: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
1093: then
1094: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
1095: then
1096: JTF_RS_ROLE_RELATE_VUHK.CREATE_RES_ROLE_RELATE_POST(p_role_relate_id => l_role_relate_id,

Line 1094: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))

1090: /* Verticle industry post- processing section - mandatory */
1091:
1092: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
1093: then
1094: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
1095: then
1096: JTF_RS_ROLE_RELATE_VUHK.CREATE_RES_ROLE_RELATE_POST(p_role_relate_id => l_role_relate_id,
1097: P_ROLE_RESOURCE_TYPE => p_role_resource_type,
1098: P_ROLE_RESOURCE_ID => p_role_resource_id,

Line 1119: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))

1115: end if;
1116:
1117: /* Internal post- processing section - mandatory */
1118:
1119: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
1120: then
1121: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
1122: then
1123: JTF_RS_ROLE_RELATE_IUHK.CREATE_RES_ROLE_RELATE_POST(p_role_relate_id => l_role_relate_id,

Line 1121: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))

1117: /* Internal post- processing section - mandatory */
1118:
1119: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
1120: then
1121: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'CREATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
1122: then
1123: JTF_RS_ROLE_RELATE_IUHK.CREATE_RES_ROLE_RELATE_POST(p_role_relate_id => l_role_relate_id,
1124: P_ROLE_RESOURCE_TYPE => p_role_resource_type,
1125: P_ROLE_RESOURCE_ID => p_role_resource_id,

Line 1149: 'JTF_RS_ROLE_RELATE_PVT',

1145:
1146: x_role_relate_id := l_role_relate_id;
1147:
1148: IF jtf_resource_utl.ok_to_execute(
1149: 'JTF_RS_ROLE_RELATE_PVT',
1150: 'CREATE_RESOURCE_ROLE_RELATE',
1151: 'M',
1152: 'M')
1153: THEN

Line 1155: 'JTF_RS_ROLE_RELATE_PVT',

1151: 'M',
1152: 'M')
1153: THEN
1154: IF jtf_usr_hks.ok_to_execute(
1155: 'JTF_RS_ROLE_RELATE_PVT',
1156: 'CREATE_RESOURCE_ROLE_RELATE',
1157: 'M',
1158: 'M')
1159: THEN

Line 1660: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))

1656: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1657:
1658: -- user hook calls for customer
1659: -- Customer pre- processing section - mandatory
1660: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
1661: then
1662: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
1663: then
1664: JTF_RS_ROLE_RELATE_CUHK.UPDATE_RES_ROLE_RELATE_PRE(P_ROLE_RELATE_ID => p_role_relate_id,

Line 1662: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))

1658: -- user hook calls for customer
1659: -- Customer pre- processing section - mandatory
1660: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
1661: then
1662: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
1663: then
1664: JTF_RS_ROLE_RELATE_CUHK.UPDATE_RES_ROLE_RELATE_PRE(P_ROLE_RELATE_ID => p_role_relate_id,
1665: P_START_DATE_ACTIVE => P_start_date_active,
1666: P_END_DATE_ACTIVE => P_end_date_active,

Line 1686: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))

1682: end if;
1683:
1684: /* Vertical industry pre- processing section - mandatory */
1685:
1686: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
1687: then
1688: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
1689: then
1690:

Line 1688: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))

1684: /* Vertical industry pre- processing section - mandatory */
1685:
1686: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
1687: then
1688: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
1689: then
1690:
1691: JTF_RS_ROLE_RELATE_VUHK.UPDATE_RES_ROLE_RELATE_PRE(P_ROLE_RELATE_ID => p_role_relate_id,
1692: P_START_DATE_ACTIVE => P_start_date_active,

Line 1713: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))

1709: end if;
1710:
1711: /* Internal pre- processing section - mandatory */
1712:
1713: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
1714: then
1715: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
1716: then
1717:

Line 1715: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))

1711: /* Internal pre- processing section - mandatory */
1712:
1713: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
1714: then
1715: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
1716: then
1717:
1718: JTF_RS_ROLE_RELATE_IUHK.UPDATE_RES_ROLE_RELATE_PRE(P_ROLE_RELATE_ID => p_role_relate_id,
1719: P_START_DATE_ACTIVE => P_start_date_active,

Line 2420: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'C' ))

2416: END IF;
2417:
2418: -- user hook calls for customer
2419: -- Customer pre- processing section - mandatory
2420: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'C' ))
2421: then
2422: JTF_RS_ROLE_RELATE_CUHK.UPDATE_RES_ROLE_RELATE_POST(P_ROLE_RELATE_ID => p_role_relate_id,
2423: P_START_DATE_ACTIVE => P_start_date_active,
2424: P_END_DATE_ACTIVE => P_end_date_active,

Line 2443: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))

2439: end if;
2440:
2441: /* Vertical industry post- processing section - mandatory */
2442:
2443: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
2444: then
2445: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
2446: then
2447:

Line 2445: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))

2441: /* Vertical industry post- processing section - mandatory */
2442:
2443: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
2444: then
2445: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
2446: then
2447:
2448: JTF_RS_ROLE_RELATE_VUHK.UPDATE_RES_ROLE_RELATE_POST(P_ROLE_RELATE_ID => p_role_relate_id,
2449: P_START_DATE_ACTIVE => P_start_date_active,

Line 2471: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))

2467:
2468:
2469: /* Internal post- processing section - mandatory */
2470:
2471: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
2472: then
2473: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
2474: then
2475:

Line 2473: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))

2469: /* Internal post- processing section - mandatory */
2470:
2471: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
2472: then
2473: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'UPDATE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
2474: then
2475:
2476: JTF_RS_ROLE_RELATE_IUHK.UPDATE_RES_ROLE_RELATE_POST(P_ROLE_RELATE_ID => p_role_relate_id,
2477: P_START_DATE_ACTIVE => P_start_date_active,

Line 2498: 'JTF_RS_ROLE_RELATE_PVT',

2494: end if;
2495: -- end of user hook call
2496:
2497: IF jtf_resource_utl.ok_to_execute(
2498: 'JTF_RS_ROLE_RELATE_PVT',
2499: 'UPDATE_RESOURCE_ROLE_RELATE',
2500: 'M',
2501: 'M')
2502: THEN

Line 2504: 'JTF_RS_ROLE_RELATE_PVT',

2500: 'M',
2501: 'M')
2502: THEN
2503: IF jtf_usr_hks.ok_to_execute(
2504: 'JTF_RS_ROLE_RELATE_PVT',
2505: 'UPDATE_RESOURCE_ROLE_RELATE',
2506: 'M',
2507: 'M')
2508: THEN

Line 2774: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'C' ))

2770: END IF;
2771:
2772: -- user hook calls for customer
2773: -- Customer pre- processing section - mandatory
2774: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
2775: then
2776: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
2777: then
2778: JTF_RS_ROLE_RELATE_CUHK.DELETE_RES_ROLE_RELATE_PRE(P_ROLE_RELATE_ID => p_role_relate_id,

Line 2776: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'C' ))

2772: -- user hook calls for customer
2773: -- Customer pre- processing section - mandatory
2774: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
2775: then
2776: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'C' ))
2777: then
2778: JTF_RS_ROLE_RELATE_CUHK.DELETE_RES_ROLE_RELATE_PRE(P_ROLE_RELATE_ID => p_role_relate_id,
2779: P_OBJECT_VERSION_NUM => p_object_version_num,
2780: p_data => L_data,

Line 2798: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'V' ))

2794: end if;
2795:
2796: /* Vertical industry pre- processing section - mandatory */
2797:
2798: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
2799: then
2800: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
2801: then
2802:

Line 2800: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'V' ))

2796: /* Vertical industry pre- processing section - mandatory */
2797:
2798: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
2799: then
2800: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'V' ))
2801: then
2802:
2803: JTF_RS_ROLE_RELATE_VUHK.DELETE_RES_ROLE_RELATE_PRE(P_ROLE_RELATE_ID => p_role_relate_id,
2804: P_OBJECT_VERSION_NUM => p_object_version_num,

Line 2823: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'I' ))

2819: end if;
2820:
2821: /* Internal pre- processing section - mandatory */
2822:
2823: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
2824: then
2825: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
2826: then
2827:

Line 2825: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'I' ))

2821: /* Internal pre- processing section - mandatory */
2822:
2823: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
2824: then
2825: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'B', 'I' ))
2826: then
2827:
2828: JTF_RS_ROLE_RELATE_IUHK.DELETE_RES_ROLE_RELATE_PRE(P_ROLE_RELATE_ID => p_role_relate_id,
2829: P_OBJECT_VERSION_NUM => p_object_version_num,

Line 3082: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'C' ))

3078: END IF;
3079:
3080: -- user hook calls for customer
3081: -- Customer post- processing section - mandatory
3082: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'C' ))
3083: then
3084: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'C' ))
3085: then
3086: JTF_RS_ROLE_RELATE_CUHK.DELETE_RES_ROLE_RELATE_POST(P_ROLE_RELATE_ID => p_role_relate_id,

Line 3084: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'C' ))

3080: -- user hook calls for customer
3081: -- Customer post- processing section - mandatory
3082: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'C' ))
3083: then
3084: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'C' ))
3085: then
3086: JTF_RS_ROLE_RELATE_CUHK.DELETE_RES_ROLE_RELATE_POST(P_ROLE_RELATE_ID => p_role_relate_id,
3087: P_OBJECT_VERSION_NUM => p_object_version_num,
3088: p_data => L_data,

Line 3105: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'V' ))

3101: end if;
3102:
3103: /* Verticle industry post- processing section - mandatory */
3104:
3105: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
3106: then
3107: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
3108: then
3109:

Line 3107: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'V' ))

3103: /* Verticle industry post- processing section - mandatory */
3104:
3105: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
3106: then
3107: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'V' ))
3108: then
3109:
3110:
3111: JTF_RS_ROLE_RELATE_VUHK.DELETE_RES_ROLE_RELATE_POST(P_ROLE_RELATE_ID => p_role_relate_id,

Line 3131: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'I' ))

3127:
3128:
3129: /* Internal post- processing section - mandatory */
3130:
3131: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
3132: then
3133: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
3134: then
3135:

Line 3133: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'I' ))

3129: /* Internal post- processing section - mandatory */
3130:
3131: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
3132: then
3133: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_ROLE_RELATE_PVT', 'DELETE_RESOURCE_ROLE_RELATE', 'A', 'I' ))
3134: then
3135:
3136:
3137: JTF_RS_ROLE_RELATE_IUHK.DELETE_RES_ROLE_RELATE_POST(P_ROLE_RELATE_ID => p_role_relate_id,

Line 3155: 'JTF_RS_ROLE_RELATE_PVT',

3151: end if;
3152: end if;
3153:
3154: IF jtf_resource_utl.ok_to_execute(
3155: 'JTF_RS_ROLE_RELATE_PVT',
3156: 'DELETE_RESOURCE_ROLE_RELATE',
3157: 'M',
3158: 'M')
3159: THEN

Line 3161: 'JTF_RS_ROLE_RELATE_PVT',

3157: 'M',
3158: 'M')
3159: THEN
3160: IF jtf_usr_hks.ok_to_execute(
3161: 'JTF_RS_ROLE_RELATE_PVT',
3162: 'DELETE_RESOURCE_ROLE_RELATE',
3163: 'M',
3164: 'M')
3165: THEN

Line 3266: END jtf_rs_role_relate_pvt;

3262: p_data => x_msg_data);
3263:
3264: END delete_resource_role_relate;
3265:
3266: END jtf_rs_role_relate_pvt;