DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_RELATE_PVT dependencies on JTF_RS_GROUP_RELATE_PVT

Line 1: PACKAGE BODY jtf_rs_group_relate_pvt AS

1: PACKAGE BODY jtf_rs_group_relate_pvt AS
2: /* $Header: jtfrsvfb.pls 120.0 2005/05/11 08:22:58 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that caller will invoke.

Line 15: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_GROUP_RELATE_PVT';

11: Delete Resource Group Relate
12: All bUsiness logic validations are done through this API
13: ******************************************************************************************/
14:
15: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_GROUP_RELATE_PVT';
16: G_NAME VARCHAR2(200);
17:
18: /* Procedure to create the resource group relation
19: based on input values passed by calling routines. */

Line 251: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))

247: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
248:
249: -- user hook calls for customer
250: -- Customer pre- processing section - mandatory
251: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
252: then
253: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
254: then
255:

Line 253: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))

249: -- user hook calls for customer
250: -- Customer pre- processing section - mandatory
251: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
252: then
253: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
254: then
255:
256:
257: JTF_RS_GROUP_RELATE_CUHK.CREATE_RES_GROUP_RELATE_PRE(P_GROUP_ID => p_group_id,

Line 278: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))

274: end if;
275:
276: /* Vertical industry pre- processing section - mandatory */
277:
278: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
279: then
280: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
281: then
282:

Line 280: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))

276: /* Vertical industry pre- processing section - mandatory */
277:
278: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
279: then
280: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
281: then
282:
283: JTF_RS_GROUP_RELATE_VUHK.CREATE_RES_GROUP_RELATE_PRE(P_GROUP_ID => p_group_id,
284: P_RELATED_GROUP_ID => p_related_group_id,

Line 303: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))

299: end if;
300:
301: /* Internal pre- processing section - mandatory */
302:
303: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
304: then
305: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
306: then
307:

Line 305: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))

301: /* Internal pre- processing section - mandatory */
302:
303: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
304: then
305: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
306: then
307:
308: JTF_RS_GROUP_RELATE_IUHK.CREATE_RES_GROUP_RELATE_PRE(P_GROUP_ID => p_group_id,
309: P_RELATED_GROUP_ID => p_related_group_id,

Line 630: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))

626:
627:
628: -- user hook calls for customer
629: -- Customer post- processing section - mandatory
630: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
631: then
632: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
633: then
634: JTF_RS_GROUP_RELATE_CUHK.CREATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => l_group_relate_id,

Line 632: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))

628: -- user hook calls for customer
629: -- Customer post- processing section - mandatory
630: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
631: then
632: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
633: then
634: JTF_RS_GROUP_RELATE_CUHK.CREATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => l_group_relate_id,
635: P_GROUP_ID => p_group_id,
636: P_RELATED_GROUP_ID => p_related_group_id,

Line 655: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))

651: end if;
652:
653: /* Vertical industry post- processing section - mandatory */
654:
655: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
656: then
657: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
658: then
659:

Line 657: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))

653: /* Vertical industry post- processing section - mandatory */
654:
655: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
656: then
657: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
658: then
659:
660: JTF_RS_GROUP_RELATE_VUHK.CREATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => l_group_relate_id,
661: P_GROUP_ID => p_group_id,

Line 681: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))

677: end if;
678:
679: /* Internal post- processing section - mandatory */
680:
681: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
682: then
683: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
684: then
685:

Line 683: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))

679: /* Internal post- processing section - mandatory */
680:
681: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
682: then
683: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'CREATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
684: then
685:
686: JTF_RS_GROUP_RELATE_IUHK.CREATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => l_group_relate_id,
687: P_GROUP_ID => p_group_id,

Line 713: 'JTF_RS_GROUP_RELATE_PVT',

709:
710: x_group_relate_id := l_group_relate_id;
711:
712: IF jtf_resource_utl.ok_to_execute(
713: 'JTF_RS_GROUP_RELATE_PVT',
714: 'CREATE_RESOURCE_GROUP_RELATE',
715: 'M',
716: 'M')
717: THEN

Line 719: 'JTF_RS_GROUP_RELATE_PVT',

715: 'M',
716: 'M')
717: THEN
718: IF jtf_usr_hks.ok_to_execute(
719: 'JTF_RS_GROUP_RELATE_PVT',
720: 'CREATE_RESOURCE_GROUP_RELATE',
721: 'M',
722: 'M')
723: THEN

Line 1077: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))

1073: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1074:
1075: -- user hook calls for customer
1076: -- Customer pre- processing section - mandatory
1077: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
1078: then
1079: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
1080: then
1081: JTF_RS_GROUP_RELATE_CUHK.UPDATE_RES_GROUP_RELATE_PRE(P_GROUP_RELATE_ID => p_group_relate_id,

Line 1079: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))

1075: -- user hook calls for customer
1076: -- Customer pre- processing section - mandatory
1077: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
1078: then
1079: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
1080: then
1081: JTF_RS_GROUP_RELATE_CUHK.UPDATE_RES_GROUP_RELATE_PRE(P_GROUP_RELATE_ID => p_group_relate_id,
1082: P_START_DATE_ACTIVE => p_start_date_active,
1083: P_END_DATE_ACTIVE => p_end_date_active,

Line 1100: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))

1096: end if;
1097:
1098: /* Vertical industry pre- processing section - mandatory */
1099:
1100: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
1101: then
1102: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
1103: then
1104:

Line 1102: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))

1098: /* Vertical industry pre- processing section - mandatory */
1099:
1100: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
1101: then
1102: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
1103: then
1104:
1105: JTF_RS_GROUP_RELATE_VUHK.UPDATE_RES_GROUP_RELATE_PRE(P_GROUP_RELATE_ID => p_group_relate_id,
1106: P_START_DATE_ACTIVE => p_start_date_active,

Line 1124: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))

1120: end if;
1121:
1122: /* Internal pre- processing section - mandatory */
1123:
1124: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
1125: then
1126: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
1127: then
1128:

Line 1126: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))

1122: /* Internal pre- processing section - mandatory */
1123:
1124: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
1125: then
1126: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
1127: then
1128:
1129: JTF_RS_GROUP_RELATE_IUHK.UPDATE_RES_GROUP_RELATE_PRE(P_GROUP_RELATE_ID => p_group_relate_id,
1130: P_START_DATE_ACTIVE => p_start_date_active,

Line 1593: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))

1589:
1590: --end of update
1591: -- user hook calls for customer
1592: -- Customer post- processing section - mandatory
1593: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
1594: then
1595: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
1596: then
1597: JTF_RS_GROUP_RELATE_CUHK.UPDATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,

Line 1595: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))

1591: -- user hook calls for customer
1592: -- Customer post- processing section - mandatory
1593: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
1594: then
1595: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
1596: then
1597: JTF_RS_GROUP_RELATE_CUHK.UPDATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,
1598: P_START_DATE_ACTIVE => p_start_date_active,
1599: P_END_DATE_ACTIVE => p_end_date_active,

Line 1616: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))

1612: end if;
1613:
1614: /* Vertical industry post- processing section - mandatory */
1615:
1616: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
1617: then
1618: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
1619: then
1620: JTF_RS_GROUP_RELATE_VUHK.UPDATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,

Line 1618: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))

1614: /* Vertical industry post- processing section - mandatory */
1615:
1616: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
1617: then
1618: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
1619: then
1620: JTF_RS_GROUP_RELATE_VUHK.UPDATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,
1621: P_START_DATE_ACTIVE => p_start_date_active,
1622: P_END_DATE_ACTIVE => p_end_date_active,

Line 1639: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))

1635: end if;
1636:
1637: /* Internal post- processing section - mandatory */
1638:
1639: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
1640: then
1641: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
1642: then
1643: JTF_RS_GROUP_RELATE_IUHK.UPDATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,

Line 1641: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))

1637: /* Internal post- processing section - mandatory */
1638:
1639: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
1640: then
1641: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'UPDATE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
1642: then
1643: JTF_RS_GROUP_RELATE_IUHK.UPDATE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,
1644: P_START_DATE_ACTIVE => p_start_date_active,
1645: P_END_DATE_ACTIVE => p_end_date_active,

Line 1662: 'JTF_RS_GROUP_RELATE_PVT',

1658: end if;
1659:
1660: -- end of user hook call
1661: IF jtf_resource_utl.ok_to_execute(
1662: 'JTF_RS_GROUP_RELATE_PVT',
1663: 'UPDATE_RESOURCE_GROUP_RELATE',
1664: 'M',
1665: 'M')
1666: THEN

Line 1668: 'JTF_RS_GROUP_RELATE_PVT',

1664: 'M',
1665: 'M')
1666: THEN
1667: IF jtf_usr_hks.ok_to_execute(
1668: 'JTF_RS_GROUP_RELATE_PVT',
1669: 'UPDATE_RESOURCE_GROUP_RELATE',
1670: 'M',
1671: 'M')
1672: THEN

Line 1883: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'C' ))

1879: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1880:
1881: -- user hook calls for customer
1882: -- Customer pre- processing section - mandatory
1883: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
1884: then
1885: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
1886: then
1887: JTF_RS_GROUP_RELATE_CUHK.DELETE_RES_GROUP_RELATE_PRE(P_GROUP_RELATE_ID => p_group_relate_id,

Line 1885: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'C' ))

1881: -- user hook calls for customer
1882: -- Customer pre- processing section - mandatory
1883: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
1884: then
1885: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'C' ))
1886: then
1887: JTF_RS_GROUP_RELATE_CUHK.DELETE_RES_GROUP_RELATE_PRE(P_GROUP_RELATE_ID => p_group_relate_id,
1888: P_OBJECT_VERSION_NUM => p_object_version_num,
1889: p_data => L_data,

Line 1904: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'V' ))

1900: end if;
1901:
1902: /* Vertical industry pre- processing section - mandatory */
1903:
1904: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
1905: then
1906: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
1907: then
1908:

Line 1906: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'V' ))

1902: /* Vertical industry pre- processing section - mandatory */
1903:
1904: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
1905: then
1906: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'V' ))
1907: then
1908:
1909:
1910: JTF_RS_GROUP_RELATE_VUHK.DELETE_RES_GROUP_RELATE_PRE(P_GROUP_RELATE_ID => p_group_relate_id,

Line 1929: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'I' ))

1925:
1926:
1927: /* Internal pre- processing section - mandatory */
1928:
1929: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
1930: then
1931: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
1932: then
1933:

Line 1931: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'I' ))

1927: /* Internal pre- processing section - mandatory */
1928:
1929: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
1930: then
1931: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'B', 'I' ))
1932: then
1933:
1934:
1935: JTF_RS_GROUP_RELATE_IUHK.DELETE_RES_GROUP_RELATE_PRE(P_GROUP_RELATE_ID => p_group_relate_id,

Line 2153: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'C' ))

2149:
2150:
2151: -- user hook calls for customer
2152: -- Customer post- processing section - mandatory
2153: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
2154: then
2155: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
2156: then
2157: JTF_RS_GROUP_RELATE_CUHK.DELETE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,

Line 2155: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'C' ))

2151: -- user hook calls for customer
2152: -- Customer post- processing section - mandatory
2153: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
2154: then
2155: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'C' ))
2156: then
2157: JTF_RS_GROUP_RELATE_CUHK.DELETE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,
2158: P_OBJECT_VERSION_NUM => p_object_version_num,
2159: p_data => L_data,

Line 2174: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'V' ))

2170: end if;
2171:
2172: /* Vertical industry post- processing section - mandatory */
2173:
2174: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
2175: then
2176: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
2177: then
2178:

Line 2176: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'V' ))

2172: /* Vertical industry post- processing section - mandatory */
2173:
2174: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
2175: then
2176: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'V' ))
2177: then
2178:
2179: JTF_RS_GROUP_RELATE_VUHK.DELETE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,
2180: P_OBJECT_VERSION_NUM => p_object_version_num,

Line 2196: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'I' ))

2192: end if;
2193:
2194: /* Internal industry post- processing section - mandatory */
2195:
2196: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
2197: then
2198: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
2199: then
2200:

Line 2198: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'I' ))

2194: /* Internal industry post- processing section - mandatory */
2195:
2196: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
2197: then
2198: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_GROUP_RELATE_PVT', 'DELETE_RESOURCE_GROUP_RELATE', 'A', 'I' ))
2199: then
2200:
2201: JTF_RS_GROUP_RELATE_IUHK.DELETE_RES_GROUP_RELATE_POST(P_GROUP_RELATE_ID => p_group_relate_id,
2202: P_OBJECT_VERSION_NUM => p_object_version_num,

Line 2218: 'JTF_RS_GROUP_RELATE_PVT',

2214: end if;
2215:
2216: -- end of user hook call
2217: IF jtf_resource_utl.ok_to_execute(
2218: 'JTF_RS_GROUP_RELATE_PVT',
2219: 'DELETE_RESOURCE_GROUP_RELATE',
2220: 'M',
2221: 'M')
2222: THEN

Line 2224: 'JTF_RS_GROUP_RELATE_PVT',

2220: 'M',
2221: 'M')
2222: THEN
2223: IF jtf_usr_hks.ok_to_execute(
2224: 'JTF_RS_GROUP_RELATE_PVT',
2225: 'DELETE_RESOURCE_GROUP_RELATE',
2226: 'M',
2227: 'M')
2228: THEN

Line 2304: END jtf_rs_group_relate_pvt;

2300: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2301:
2302:
2303: END delete_resource_group_relate;
2304: END jtf_rs_group_relate_pvt;