DBA Data[Home] [Help]

APPS.JTF_RS_ROLES_PVT dependencies on JTF_RS_ROLES_PVT

Line 1: PACKAGE BODY jtf_rs_roles_pvt AS

1: PACKAGE BODY jtf_rs_roles_pvt AS
2: /* $Header: jtfrsvob.pls 120.0 2005/05/11 08:23:11 appldev ship $ */
3:
4: /*****************************************************************************************
5: This package body defines the procedures for managing resource roles, like

Line 17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_ROLES_PVT';

13: ******************************************************************************************/
14:
15: --Package variables.
16:
17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_ROLES_PVT';
18:
19: --Procedure to create the resource roles based on input values passed by calling routines
20:
21: PROCEDURE create_rs_resource_roles (

Line 139: 'JTF_RS_ROLES_PVT',

135: --Make the pre processing call to the user hooks
136:
137: --Pre Call to the Customer Type User Hook
138: IF jtf_usr_hks.ok_to_execute(
139: 'JTF_RS_ROLES_PVT',
140: 'CREATE_RS_RESOURCE_ROLES',
141: 'B',
142: 'C')
143: THEN

Line 169: 'JTF_RS_ROLES_PVT',

165: END IF;
166:
167: --Pre Call to the Vertical Type User Hook
168: IF jtf_usr_hks.ok_to_execute(
169: 'JTF_RS_ROLES_PVT',
170: 'CREATE_RS_RESOURCE_ROLES',
171: 'B',
172: 'V')
173: THEN

Line 199: 'JTF_RS_ROLES_PVT',

195: END IF;
196:
197: --Pre Call to the Internal Type User Hook
198: IF jtf_usr_hks.ok_to_execute(
199: 'JTF_RS_ROLES_PVT',
200: 'CREATE_RS_RESOURCE_ROLES',
201: 'B',
202: 'I')
203: THEN

Line 428: 'JTF_RS_ROLES_PVT',

424: END IF;
425:
426: --Post Call to the Customer User Hook
427: IF jtf_usr_hks.ok_to_execute(
428: 'JTF_RS_ROLES_PVT',
429: 'CREATE_RS_RESOURCE_ROLES',
430: 'A',
431: 'C')
432: THEN

Line 459: 'JTF_RS_ROLES_PVT',

455: END IF;
456:
457: --Post Call to the Vertical Type User Hook
458: IF jtf_usr_hks.ok_to_execute(
459: 'JTF_RS_ROLES_PVT',
460: 'CREATE_RS_RESOURCE_ROLES',
461: 'A',
462: 'V')
463: THEN

Line 490: 'JTF_RS_ROLES_PVT',

486: END IF;
487:
488: --Post Call to the Internal Type User Hook
489: IF jtf_usr_hks.ok_to_execute(
490: 'JTF_RS_ROLES_PVT',
491: 'CREATE_RS_RESOURCE_ROLES',
492: 'A',
493: 'I')
494: THEN

Line 522: 'JTF_RS_ROLES_PVT',

518:
519: /* Standard call for Message Generation */
520:
521: IF jtf_usr_hks.ok_to_execute(
522: 'JTF_RS_ROLES_PVT',
523: 'CREATE_RS_RESOURCE_ROLES',
524: 'M',
525: 'M')
526: THEN

Line 739: l_resource_role_rec jtf_rs_roles_pvt.resource_role_rec_type;

735: l_return_status VARCHAR2(2000);
736: l_msg_count NUMBER;
737: l_msg_data VARCHAR2(2000);
738:
739: l_resource_role_rec jtf_rs_roles_pvt.resource_role_rec_type;
740:
741: BEGIN
742:
743: SAVEPOINT update_rs_resource_roles_pvt;

Line 755: 'JTF_RS_ROLES_PVT',

751: END IF;
752:
753: --Pre Call to the Customer User Hook
754: IF jtf_usr_hks.ok_to_execute(
755: 'JTF_RS_ROLES_PVT',
756: 'UPDATE_RS_RESOURCE_ROLES',
757: 'B',
758: 'C')
759: THEN

Line 786: 'JTF_RS_ROLES_PVT',

782: END IF;
783:
784: --Pre Call to Vertical User Hook
785: IF jtf_usr_hks.ok_to_execute(
786: 'JTF_RS_ROLES_PVT',
787: 'UPDATE_RS_RESOURCE_ROLES',
788: 'B',
789: 'V')
790: THEN

Line 817: 'JTF_RS_ROLES_PVT',

813: END IF;
814:
815: --Pre Call to Internal User Hook
816: IF jtf_usr_hks.ok_to_execute(
817: 'JTF_RS_ROLES_PVT',
818: 'UPDATE_RS_RESOURCE_ROLES',
819: 'B',
820: 'I')
821: THEN

Line 1141: 'JTF_RS_ROLES_PVT',

1137: --dbms_output.put_line('Role Successfully Updated');
1138:
1139: --Post Call to Customer User Hook
1140: IF jtf_usr_hks.ok_to_execute(
1141: 'JTF_RS_ROLES_PVT',
1142: 'UPDATE_RS_RESOURCE_ROLES',
1143: 'A',
1144: 'C')
1145: THEN

Line 1172: 'JTF_RS_ROLES_PVT',

1168: END IF;
1169:
1170: --Post Call to Vertical User Hook
1171: IF jtf_usr_hks.ok_to_execute(
1172: 'JTF_RS_ROLES_PVT',
1173: 'UPDATE_RS_RESOURCE_ROLES',
1174: 'A',
1175: 'V')
1176: THEN

Line 1203: 'JTF_RS_ROLES_PVT',

1199: END IF;
1200:
1201: --Post Call to Vertical User Hook
1202: IF jtf_usr_hks.ok_to_execute(
1203: 'JTF_RS_ROLES_PVT',
1204: 'UPDATE_RS_RESOURCE_ROLES',
1205: 'A',
1206: 'I')
1207: THEN

Line 1235: 'JTF_RS_ROLES_PVT',

1231:
1232: /* Standard call for Message Generation */
1233:
1234: IF jtf_usr_hks.ok_to_execute(
1235: 'JTF_RS_ROLES_PVT',
1236: 'UPDATE_RS_RESOURCE_ROLES',
1237: 'M',
1238: 'M')
1239: THEN

Line 1368: 'JTF_RS_ROLES_PVT',

1364: RAISE fnd_api.g_exc_unexpected_error;
1365: END IF;
1366: --Pre Call to Customer User Hook
1367: IF jtf_usr_hks.ok_to_execute(
1368: 'JTF_RS_ROLES_PVT',
1369: 'DELETE_RS_RESOURCE_ROLES',
1370: 'B',
1371: 'C')
1372: THEN

Line 1390: 'JTF_RS_ROLES_PVT',

1386: END IF;
1387:
1388: --Pre Call to Vertical User Hook
1389: IF jtf_usr_hks.ok_to_execute(
1390: 'JTF_RS_ROLES_PVT',
1391: 'DELETE_RS_RESOURCE_ROLES',
1392: 'B',
1393: 'V')
1394: THEN

Line 1413: 'JTF_RS_ROLES_PVT',

1409: END IF;
1410:
1411: --Pre Call to Internal User Hook
1412: IF jtf_usr_hks.ok_to_execute(
1413: 'JTF_RS_ROLES_PVT',
1414: 'DELETE_RS_RESOURCE_ROLES',
1415: 'B',
1416: 'I')
1417: THEN

Line 1475: 'JTF_RS_ROLES_PVT',

1471: END IF;
1472:
1473: --Post Call to Customer User Hook
1474: IF jtf_usr_hks.ok_to_execute(
1475: 'JTF_RS_ROLES_PVT',
1476: 'DELETE_RS_RESOURCE_ROLES',
1477: 'A',
1478: 'C')
1479: THEN

Line 1497: 'JTF_RS_ROLES_PVT',

1493: END IF;
1494:
1495: --Post Call to Vertical User Hook
1496: IF jtf_usr_hks.ok_to_execute(
1497: 'JTF_RS_ROLES_PVT',
1498: 'DELETE_RS_RESOURCE_ROLES',
1499: 'A',
1500: 'V')
1501: THEN

Line 1519: 'JTF_RS_ROLES_PVT',

1515: END IF;
1516:
1517: --Post Call to Internal User Hook
1518: IF jtf_usr_hks.ok_to_execute(
1519: 'JTF_RS_ROLES_PVT',
1520: 'DELETE_RS_RESOURCE_ROLES',
1521: 'A',
1522: 'I')
1523: THEN

Line 1542: 'JTF_RS_ROLES_PVT',

1538:
1539: /* Standard call for Message Generation */
1540:
1541: IF jtf_usr_hks.ok_to_execute(
1542: 'JTF_RS_ROLES_PVT',
1543: 'DELETE_RS_RESOURCE_ROLES',
1544: 'M',
1545: 'M')
1546: THEN

Line 1618: END jtf_rs_roles_pvt;

1614: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1615:
1616: END delete_rs_resource_roles;
1617:
1618: END jtf_rs_roles_pvt;