109: END IF;
110:
111: --GET USER ID AND SYSDATE
112: l_date := sysdate;
113: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
114: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
115:
116: -- user hook calls for customer
117: -- Customer pre- processing section - mandatory
110:
111: --GET USER ID AND SYSDATE
112: l_date := sysdate;
113: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
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' ))
723: END IF;
724:
725: --GET USER ID AND SYSDATE
726: l_date := sysdate;
727: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
728: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
729:
730: -- user hook calls for customer
731: -- Customer pre- processing section - mandatory
724:
725: --GET USER ID AND SYSDATE
726: l_date := sysdate;
727: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
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' ))
1428: END IF;
1429:
1430: --GET USER ID AND SYSDATE
1431: l_date := sysdate;
1432: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1433: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1434:
1435: -- user hook calls for customer
1436: -- Customer pre- processing section - mandatory
1429:
1430: --GET USER ID AND SYSDATE
1431: l_date := sysdate;
1432: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
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' ))