1: PACKAGE BODY jtf_rs_dynamic_groups_pvt AS
2: /* $Header: jtfrsvyb.pls 120.0 2005/05/11 08:23:22 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that caller will invoke.
10: Update Dynamic Groups
11: Delete Dynamic Groups
12: ******************************************************************************************/
13:
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_DYNAMIC_GROUPS_PVT';
15:
16: /* Procedure to create the Dynamic Groups
17: based on input values passed by calling routines. */
18:
114: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
115:
116: -- user hook calls for customer
117: -- Customer pre- processing section - mandatory
118: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'C' ))
119: then
120: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'C' ))
121: then
122: JTF_RS_DYNAMIC_GROUPS_CUHK.CREATE_DYNAMIC_GROUPS_PRE(P_GROUP_NAME => p_group_name,
116: -- user hook calls for customer
117: -- Customer pre- processing section - mandatory
118: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'C' ))
119: then
120: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'C' ))
121: then
122: JTF_RS_DYNAMIC_GROUPS_CUHK.CREATE_DYNAMIC_GROUPS_PRE(P_GROUP_NAME => p_group_name,
123: P_GROUP_DESC => p_group_desc,
124: P_USAGE => p_usage,
151: end if;
152:
153: /* Verticle industry pre- processing section - mandatory */
154:
155: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'V' ))
156: then
157: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'V' ))
158: then
159:
153: /* Verticle industry pre- processing section - mandatory */
154:
155: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'V' ))
156: then
157: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'V' ))
158: then
159:
160:
161: JTF_RS_DYNAMIC_GROUPS_VUHK.CREATE_DYNAMIC_GROUPS_PRE(P_GROUP_NAME => p_group_name,
190: end if;
191:
192: /* Internal industry pre- processing section - mandatory */
193:
194: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'I' ))
195: then
196: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'I' ))
197: then
198:
192: /* Internal industry pre- processing section - mandatory */
193:
194: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'I' ))
195: then
196: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'B', 'I' ))
197: then
198:
199:
200: JTF_RS_DYNAMIC_GROUPS_IUHK.CREATE_DYNAMIC_GROUPS_PRE(P_GROUP_NAME => p_group_name,
382: end if;
383:
384: /* Vertical industry post- processing section - mandatory */
385:
386: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'A', 'V' ))
387: then
388: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'A', 'V' ))
389: then
390:
384: /* Vertical industry post- processing section - mandatory */
385:
386: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'A', 'V' ))
387: then
388: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'A', 'V' ))
389: then
390:
391:
392: JTF_RS_DYNAMIC_GROUPS_VUHK.CREATE_DYNAMIC_GROUPS_POST(P_GROUP_ID => l_group_id,
422: end if;
423:
424: /* iNTERNAL post- processing section - mandatory */
425:
426: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'A', 'I' ))
427: then
428: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'A', 'I' ))
429: then
430:
424: /* iNTERNAL post- processing section - mandatory */
425:
426: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'A', 'I' ))
427: then
428: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'CREATE_DYNAMIC_GROUPS', 'A', 'I' ))
429: then
430:
431:
432: JTF_RS_DYNAMIC_GROUPS_IUHK.CREATE_DYNAMIC_GROUPS_POST(P_GROUP_ID => l_group_id,
462: end if;
463:
464: -- end of user hook call
465: IF jtf_resource_utl.ok_to_execute(
466: 'JTF_RS_DYNAMIC_GROUPS_PVT',
467: 'CREATE_DYNAMIC_GROUPS',
468: 'M',
469: 'M')
470: THEN
468: 'M',
469: 'M')
470: THEN
471: IF jtf_usr_hks.ok_to_execute(
472: 'JTF_RS_DYNAMIC_GROUPS_PVT',
473: 'CREATE_DYNAMIC_GROUPS',
474: 'M',
475: 'M')
476: THEN
728: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
729:
730: -- user hook calls for customer
731: -- Customer pre- processing section - mandatory
732: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'C' ))
733: then
734: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'C' ))
735: then
736: JTF_RS_DYNAMIC_GROUPS_CUHK.UPDATE_DYNAMIC_GROUPS_PRE(P_GROUP_ID => p_group_id,
730: -- user hook calls for customer
731: -- Customer pre- processing section - mandatory
732: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'C' ))
733: then
734: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'C' ))
735: then
736: JTF_RS_DYNAMIC_GROUPS_CUHK.UPDATE_DYNAMIC_GROUPS_PRE(P_GROUP_ID => p_group_id,
737: P_GROUP_NUMBER => p_group_number,
738: P_GROUP_NAME => p_group_name,
768: end if;
769:
770: /* Vertical industry pre- processing section - mandatory */
771:
772: if ( JTF_resource_utl.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'V' ))
773: then
774: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'V' ))
775: then
776:
770: /* Vertical industry pre- processing section - mandatory */
771:
772: if ( JTF_resource_utl.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'V' ))
773: then
774: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'V' ))
775: then
776:
777:
778: JTF_RS_DYNAMIC_GROUPS_VUHK.UPDATE_DYNAMIC_GROUPS_PRE(P_GROUP_ID => p_group_id,
810: end if;
811:
812: /* Internal pre- processing section - mandatory */
813:
814: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'I' ))
815: then
816: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'I' ))
817: then
818:
812: /* Internal pre- processing section - mandatory */
813:
814: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'I' ))
815: then
816: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'B', 'I' ))
817: then
818:
819:
820: JTF_RS_DYNAMIC_GROUPS_IUHK.UPDATE_DYNAMIC_GROUPS_PRE(P_GROUP_ID => p_group_id,
1176: end if;
1177:
1178: /* Verticle industry pre- processing section - mandatory */
1179:
1180: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'A', 'V' ))
1181: then
1182: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'A', 'V' ))
1183: then
1184:
1178: /* Verticle industry pre- processing section - mandatory */
1179:
1180: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'A', 'V' ))
1181: then
1182: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'A', 'V' ))
1183: then
1184:
1185:
1186: JTF_RS_DYNAMIC_GROUPS_VUHK.UPDATE_DYNAMIC_GROUPS_POST(P_GROUP_ID => p_group_id,
1218: end if;
1219:
1220: /* Internal pre- processing section - mandatory */
1221:
1222: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'A', 'I' ))
1223: then
1224: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'A', 'I' ))
1225: then
1226:
1220: /* Internal pre- processing section - mandatory */
1221:
1222: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'A', 'I' ))
1223: then
1224: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'UPDATE_DYNAMIC_GROUPS', 'A', 'I' ))
1225: then
1226:
1227:
1228: JTF_RS_DYNAMIC_GROUPS_IUHK.UPDATE_DYNAMIC_GROUPS_POST(P_GROUP_ID => p_group_id,
1261:
1262: -- end of user hook call
1263:
1264: IF jtf_resource_utl.ok_to_execute(
1265: 'JTF_RS_DYNAMIC_GROUPS_PVT',
1266: 'UPDATE_DYNAMIC_GROUPS',
1267: 'M',
1268: 'M')
1269: THEN
1267: 'M',
1268: 'M')
1269: THEN
1270: IF jtf_usr_hks.ok_to_execute(
1271: 'JTF_RS_DYNAMIC_GROUPS_PVT',
1272: 'UPDATE_DYNAMIC_GROUPS',
1273: 'M',
1274: 'M')
1275: THEN
1433: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1434:
1435: -- user hook calls for customer
1436: -- Customer pre- processing section - mandatory
1437: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'C' ))
1438: then
1439: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'C' ))
1440: then
1441: JTF_RS_DYNAMIC_GROUPS_CUHK.DELETE_DYNAMIC_GROUPS_PRE(P_GROUP_ID => p_group_id,
1435: -- user hook calls for customer
1436: -- Customer pre- processing section - mandatory
1437: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'C' ))
1438: then
1439: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'C' ))
1440: then
1441: JTF_RS_DYNAMIC_GROUPS_CUHK.DELETE_DYNAMIC_GROUPS_PRE(P_GROUP_ID => p_group_id,
1442: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1443: p_data => L_data,
1466: end if;
1467:
1468: /* Vertical industry pre- processing section - mandatory */
1469:
1470: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'V' ))
1471: then
1472: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'V' ))
1473: then
1474:
1468: /* Vertical industry pre- processing section - mandatory */
1469:
1470: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'V' ))
1471: then
1472: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'V' ))
1473: then
1474:
1475:
1476: JTF_RS_DYNAMIC_GROUPS_VUHK.DELETE_DYNAMIC_GROUPS_PRE(P_GROUP_ID => p_group_id,
1501: end if;
1502:
1503: /* Internal pre- processing section - mandatory */
1504:
1505: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'I' ))
1506: then
1507: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'I' ))
1508: then
1509:
1503: /* Internal pre- processing section - mandatory */
1504:
1505: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'I' ))
1506: then
1507: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'B', 'I' ))
1508: then
1509:
1510:
1511: JTF_RS_DYNAMIC_GROUPS_IUHK.DELETE_DYNAMIC_GROUPS_PRE(P_GROUP_ID => p_group_id,
1597: end if;
1598:
1599: /* Verticle industry post- processing section - mandatory */
1600:
1601: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'A', 'V' ))
1602: then
1603: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'A', 'V' ))
1604: then
1605:
1599: /* Verticle industry post- processing section - mandatory */
1600:
1601: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'A', 'V' ))
1602: then
1603: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'A', 'V' ))
1604: then
1605:
1606:
1607: JTF_RS_DYNAMIC_GROUPS_VUHK.DELETE_DYNAMIC_GROUPS_POST(P_GROUP_ID => p_group_id,
1632: end if;
1633:
1634: /* Internal post- processing section - mandatory */
1635:
1636: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'A', 'I' ))
1637: then
1638: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'A', 'I' ))
1639: then
1640:
1634: /* Internal post- processing section - mandatory */
1635:
1636: if ( JTF_RESOURCE_UTL.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'A', 'I' ))
1637: then
1638: if ( JTF_USR_HKS.Ok_to_execute( 'JTF_RS_DYNAMIC_GROUPS_PVT', 'DELETE_DYNAMIC_GROUPS', 'A', 'I' ))
1639: then
1640:
1641:
1642: JTF_RS_DYNAMIC_GROUPS_IUHK.DELETE_DYNAMIC_GROUPS_POST(P_GROUP_ID => p_group_id,
1669:
1670: -- end of user hook call
1671:
1672: IF jtf_resource_utl.ok_to_execute(
1673: 'JTF_RS_DYNAMIC_GROUPS_PVT',
1674: 'DELETE_DYNAMIC_GROUPS',
1675: 'M',
1676: 'M')
1677: THEN
1675: 'M',
1676: 'M')
1677: THEN
1678: IF jtf_usr_hks.ok_to_execute(
1679: 'JTF_RS_DYNAMIC_GROUPS_PVT',
1680: 'DELETE_DYNAMIC_GROUPS',
1681: 'M',
1682: 'M')
1683: THEN
1783: x_return_status := fnd_api.g_ret_sts_unexp_error;
1784: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1785: */
1786: END;
1787: END jtf_rs_dynamic_groups_pvt;