DBA Data[Home] [Help]

APPS.JTF_RS_ROLES_PVT dependencies on JTF_RESOURCE_UTL

Line 297: jtf_resource_utl.validate_rs_role_flags (

293: --Validate the flags
294:
295: --Validate the seeded flag
296: IF l_seeded_flag IS NOT NULL THEN
297: jtf_resource_utl.validate_rs_role_flags (
298: p_rs_role_flag => l_seeded_flag,
299: x_return_status => x_return_status
300: );
301: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 309: jtf_resource_utl.validate_rs_role_flags (

305: END IF;
306:
307: --Validate the member flag
308: IF l_member_flag IS NOT NULL THEN
309: jtf_resource_utl.validate_rs_role_flags (
310: p_rs_role_flag => l_member_flag,
311: x_return_status => x_return_status
312: );
313: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 321: jtf_resource_utl.validate_rs_role_flags (

317: END IF;
318:
319: --Validate the admin flag
320: IF l_admin_flag IS NOT NULL THEN
321: jtf_resource_utl.validate_rs_role_flags (
322: p_rs_role_flag => l_admin_flag,
323: x_return_status => x_return_status
324: );
325: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 333: jtf_resource_utl.validate_rs_role_flags (

329: END IF;
330:
331: --Validate the lead flag
332: IF l_lead_flag IS NOT NULL THEN
333: jtf_resource_utl.validate_rs_role_flags (
334: p_rs_role_flag => l_lead_flag,
335: x_return_status => x_return_status
336: );
337: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 345: jtf_resource_utl.validate_rs_role_flags (

341: END IF;
342:
343: --Validate the manager flag
344: IF l_manager_flag IS NOT NULL THEN
345: jtf_resource_utl.validate_rs_role_flags (
346: p_rs_role_flag => l_manager_flag,
347: x_return_status => x_return_status
348: );
349: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 357: jtf_resource_utl.validate_rs_role_flags (

353: END IF;
354:
355: --Validate the active flag
356: IF l_active_flag IS NOT NULL THEN
357: jtf_resource_utl.validate_rs_role_flags (
358: p_rs_role_flag => l_active_flag,
359: x_return_status => x_return_status
360: );
361: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 404: X_CREATED_BY => jtf_resource_utl.created_by,

400: X_ATTRIBUTE2 => l_attribute2,
401: X_ROLE_NAME => l_role_name,
402: X_ROLE_DESC => l_role_desc,
403: X_CREATION_DATE => sysdate,
404: X_CREATED_BY => jtf_resource_utl.created_by,
405: X_LAST_UPDATE_DATE => sysdate,
406: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
407: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
408: );

Line 406: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,

402: X_ROLE_DESC => l_role_desc,
403: X_CREATION_DATE => sysdate,
404: X_CREATED_BY => jtf_resource_utl.created_by,
405: X_LAST_UPDATE_DATE => sysdate,
406: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
407: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
408: );
409:
410: --dbms_output.put_line('Inserted Row');

Line 407: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id

403: X_CREATION_DATE => sysdate,
404: X_CREATED_BY => jtf_resource_utl.created_by,
405: X_LAST_UPDATE_DATE => sysdate,
406: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
407: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
408: );
409:
410: --dbms_output.put_line('Inserted Row');
411: OPEN c_jtf_rs_roles (l_role_id);

Line 864: --jtf_resource_utl.validate_resource_role(

860: --Validate the Resource Role
861:
862: --BEGIN
863:
864: --jtf_resource_utl.validate_resource_role(
865: -- p_role_id => l_role_id,
866: -- p_role_code => l_role_code,
867: -- x_return_status => x_return_status,
868: -- x_role_id => l_role_id

Line 969: jtf_resource_utl.validate_rs_role_flags (

965:
966: --Validate the seeded flag
967: IF l_seeded_flag <> FND_API.G_MISS_CHAR THEN
968: IF rs_role_rec.l_seeded_flag IS NOT NULL THEN
969: jtf_resource_utl.validate_rs_role_flags (
970: p_rs_role_flag => rs_role_rec.l_seeded_flag,
971: x_return_status => x_return_status
972: );
973: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 983: jtf_resource_utl.validate_rs_role_flags (

979:
980: --Validate the member flag
981: IF l_member_flag <> FND_API.G_MISS_CHAR THEN
982: IF rs_role_rec.l_member_flag IS NOT NULL THEN
983: jtf_resource_utl.validate_rs_role_flags (
984: p_rs_role_flag => rs_role_rec.l_member_flag,
985: x_return_status => x_return_status
986: );
987: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 997: jtf_resource_utl.validate_rs_role_flags (

993:
994: --Validate the admin flag
995: IF l_admin_flag <> FND_API.G_MISS_CHAR THEN
996: IF rs_role_rec.l_admin_flag IS NOT NULL THEN
997: jtf_resource_utl.validate_rs_role_flags (
998: p_rs_role_flag => rs_role_rec.l_admin_flag,
999: x_return_status => x_return_status
1000: );
1001: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1011: jtf_resource_utl.validate_rs_role_flags (

1007:
1008: --Validate the lead flag
1009: IF l_lead_flag <> FND_API.G_MISS_CHAR THEN
1010: IF rs_role_rec.l_lead_flag IS NOT NULL THEN
1011: jtf_resource_utl.validate_rs_role_flags (
1012: p_rs_role_flag => rs_role_rec.l_lead_flag,
1013: x_return_status => x_return_status
1014: );
1015: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1025: jtf_resource_utl.validate_rs_role_flags (

1021:
1022: --Validate the manager flag
1023: IF l_manager_flag <> FND_API.G_MISS_CHAR THEN
1024: IF rs_role_rec.l_manager_flag IS NOT NULL THEN
1025: jtf_resource_utl.validate_rs_role_flags (
1026: p_rs_role_flag => rs_role_rec.l_manager_flag,
1027: x_return_status => x_return_status
1028: );
1029: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1039: jtf_resource_utl.validate_rs_role_flags (

1035:
1036: --Validate the active flag
1037: IF l_active_flag <> FND_API.G_MISS_CHAR THEN
1038: IF rs_role_rec.l_active_flag IS NOT NULL THEN
1039: jtf_resource_utl.validate_rs_role_flags (
1040: p_rs_role_flag => rs_role_rec.l_active_flag,
1041: x_return_status => x_return_status
1042: );
1043: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1123: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,

1119: X_ROLE_NAME => rs_role_rec.l_role_name,
1120: X_ROLE_DESC => rs_role_rec.l_role_desc,
1121: X_OBJECT_VERSION_NUMBER=> l_object_version_number,
1122: X_LAST_UPDATE_DATE => sysdate,
1123: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
1124: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
1125: );
1126:
1127: p_object_version_number := l_object_version_number;

Line 1124: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id

1120: X_ROLE_DESC => rs_role_rec.l_role_desc,
1121: X_OBJECT_VERSION_NUMBER=> l_object_version_number,
1122: X_LAST_UPDATE_DATE => sysdate,
1123: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
1124: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
1125: );
1126:
1127: p_object_version_number := l_object_version_number;
1128:

Line 1313: -- added for NOCOPY handle in JTF_RESOURCE_UTL

1309: l_role_id jtf_rs_roles_vl.role_id%type := p_role_id;
1310: l_role_code jtf_rs_roles_vl.role_code%type := p_role_code;
1311: L_BIND_DATA_ID NUMBER;
1312: l_object_version_number jtf_rs_roles_vl.object_version_number%type := p_object_version_number;
1313: -- added for NOCOPY handle in JTF_RESOURCE_UTL
1314: l_role_id_out jtf_rs_roles_vl.role_id%type;
1315:
1316: l_return_status VARCHAR2(2000);
1317: l_msg_count NUMBER;

Line 1439: jtf_resource_utl.validate_resource_role(

1435: --Validate the Resource Role
1436:
1437: BEGIN
1438:
1439: jtf_resource_utl.validate_resource_role(
1440: p_role_id => l_role_id,
1441: p_role_code => l_role_code,
1442: x_return_status => x_return_status,
1443: x_role_id => l_role_id_out