eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on WF_LOCAL_ROLES

Line 54: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';

50: x_orig_system OUT NOCOPY varchar2,
51: x_orig_system_id OUT NOCOPY number
52: ) IS
53:
54: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
55: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
56: l_res_hz_orig_system wf_local_roles.orig_system%TYPE := 'HZ_PARTY';
57:
58: l_role_name wf_local_roles.name%TYPE;

Line 55: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);

51: x_orig_system_id OUT NOCOPY number
52: ) IS
53:
54: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
55: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
56: l_res_hz_orig_system wf_local_roles.orig_system%TYPE := 'HZ_PARTY';
57:
58: l_role_name wf_local_roles.name%TYPE;
59: l_orig_system wf_local_roles.orig_system%TYPE;

Line 56: l_res_hz_orig_system wf_local_roles.orig_system%TYPE := 'HZ_PARTY';

52: ) IS
53:
54: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
55: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
56: l_res_hz_orig_system wf_local_roles.orig_system%TYPE := 'HZ_PARTY';
57:
58: l_role_name wf_local_roles.name%TYPE;
59: l_orig_system wf_local_roles.orig_system%TYPE;
60: l_orig_system_id wf_local_roles.orig_system_id%TYPE;

Line 58: l_role_name wf_local_roles.name%TYPE;

54: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
55: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
56: l_res_hz_orig_system wf_local_roles.orig_system%TYPE := 'HZ_PARTY';
57:
58: l_role_name wf_local_roles.name%TYPE;
59: l_orig_system wf_local_roles.orig_system%TYPE;
60: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
61:
62: l_category jtf_rs_resource_extns.category%TYPE;

Line 59: l_orig_system wf_local_roles.orig_system%TYPE;

55: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
56: l_res_hz_orig_system wf_local_roles.orig_system%TYPE := 'HZ_PARTY';
57:
58: l_role_name wf_local_roles.name%TYPE;
59: l_orig_system wf_local_roles.orig_system%TYPE;
60: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
61:
62: l_category jtf_rs_resource_extns.category%TYPE;
63: l_source_id jtf_rs_resource_extns.source_id%TYPE;

Line 60: l_orig_system_id wf_local_roles.orig_system_id%TYPE;

56: l_res_hz_orig_system wf_local_roles.orig_system%TYPE := 'HZ_PARTY';
57:
58: l_role_name wf_local_roles.name%TYPE;
59: l_orig_system wf_local_roles.orig_system%TYPE;
60: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
61:
62: l_category jtf_rs_resource_extns.category%TYPE;
63: l_source_id jtf_rs_resource_extns.source_id%TYPE;
64: l_person_party_id jtf_rs_resource_extns.person_party_id%TYPE;

Line 74: from wf_local_roles

70: where resource_id = p_resource_id;
71:
72: cursor res_wfrole_cur IS
73: select name, orig_system, orig_system_id
74: from wf_local_roles
75: where name = l_res_usr_role_name
76: and orig_system = l_res_usr_orig_system
77: and orig_system_id = p_resource_id;
78:

Line 81: from wf_local_roles

77: and orig_system_id = p_resource_id;
78:
79: cursor res_hz_wfrole_cur(c_party_id number) IS
80: select name, orig_system, orig_system_id
81: from wf_local_roles
82: where orig_system = l_res_hz_orig_system
83: and orig_system_id = c_party_id;
84:
85: cursor res_po_party_cur(c_vendor_contact_id number) IS

Line 147: l_role_name wf_local_roles.name%TYPE;

143: END get_wf_role;
144:
145: FUNCTION get_wf_role(p_resource_id IN number) RETURN varchar2
146: IS
147: l_role_name wf_local_roles.name%TYPE;
148: l_orig_system wf_local_roles.orig_system%TYPE;
149: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
150: BEGIN
151: jtf_rs_wf_integration_pub.get_wf_role

Line 148: l_orig_system wf_local_roles.orig_system%TYPE;

144:
145: FUNCTION get_wf_role(p_resource_id IN number) RETURN varchar2
146: IS
147: l_role_name wf_local_roles.name%TYPE;
148: l_orig_system wf_local_roles.orig_system%TYPE;
149: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
150: BEGIN
151: jtf_rs_wf_integration_pub.get_wf_role
152: (p_resource_id => p_resource_id,

Line 149: l_orig_system_id wf_local_roles.orig_system_id%TYPE;

145: FUNCTION get_wf_role(p_resource_id IN number) RETURN varchar2
146: IS
147: l_role_name wf_local_roles.name%TYPE;
148: l_orig_system wf_local_roles.orig_system%TYPE;
149: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
150: BEGIN
151: jtf_rs_wf_integration_pub.get_wf_role
152: (p_resource_id => p_resource_id,
153: x_role_name => l_role_name,

Line 239: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';

235: l_start_date_active date := trunc(p_start_date_active);
236: l_end_date_active date := trunc(p_end_date_active);
237: l_sysdate date := trunc(sysdate);
238:
239: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
240: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
241:
242: l_list WF_PARAMETER_LIST_T;
243:

Line 240: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);

236: l_end_date_active date := trunc(p_end_date_active);
237: l_sysdate date := trunc(sysdate);
238:
239: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
240: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
241:
242: l_list WF_PARAMETER_LIST_T;
243:
244: /* Cursor to get the party id of the employee */

Line 370: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';

366: where resource_id = p_resource_id;
367:
368: res_rec res_cur%rowtype;
369:
370: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
371: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
372:
373: cursor res_wfrole_cur IS
374: select name

Line 371: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);

367:
368: res_rec res_cur%rowtype;
369:
370: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
371: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
372:
373: cursor res_wfrole_cur IS
374: select name
375: from wf_local_roles

Line 375: from wf_local_roles

371: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
372:
373: cursor res_wfrole_cur IS
374: select name
375: from wf_local_roles
376: where name = l_res_usr_role_name
377: and orig_system = l_res_usr_orig_system
378: and orig_system_id = p_resource_id;
379:

Line 380: l_role_name wf_local_roles.name%TYPE;

376: where name = l_res_usr_role_name
377: and orig_system = l_res_usr_orig_system
378: and orig_system_id = p_resource_id;
379:
380: l_role_name wf_local_roles.name%TYPE;
381: res_wfrole_exists varchar2(1) := 'N';
382:
383: cursor fnd_wfrole_cur(l_user_id number) IS
384: select user_name

Line 388: l_fnd_old_user_name wf_local_roles.name%TYPE;

384: select user_name
385: from fnd_user
386: where user_id = l_user_id;
387:
388: l_fnd_old_user_name wf_local_roles.name%TYPE;
389: l_fnd_new_user_name wf_local_roles.name%TYPE;
390: l_fnd_usr_old_orig_system wf_local_roles.orig_system%TYPE;
391: l_fnd_usr_new_orig_system wf_local_roles.orig_system%TYPE;
392: l_fnd_usr_old_orig_system_id wf_local_roles.orig_system_id%TYPE;

Line 389: l_fnd_new_user_name wf_local_roles.name%TYPE;

385: from fnd_user
386: where user_id = l_user_id;
387:
388: l_fnd_old_user_name wf_local_roles.name%TYPE;
389: l_fnd_new_user_name wf_local_roles.name%TYPE;
390: l_fnd_usr_old_orig_system wf_local_roles.orig_system%TYPE;
391: l_fnd_usr_new_orig_system wf_local_roles.orig_system%TYPE;
392: l_fnd_usr_old_orig_system_id wf_local_roles.orig_system_id%TYPE;
393: l_fnd_usr_new_orig_system_id wf_local_roles.orig_system_id%TYPE;

Line 390: l_fnd_usr_old_orig_system wf_local_roles.orig_system%TYPE;

386: where user_id = l_user_id;
387:
388: l_fnd_old_user_name wf_local_roles.name%TYPE;
389: l_fnd_new_user_name wf_local_roles.name%TYPE;
390: l_fnd_usr_old_orig_system wf_local_roles.orig_system%TYPE;
391: l_fnd_usr_new_orig_system wf_local_roles.orig_system%TYPE;
392: l_fnd_usr_old_orig_system_id wf_local_roles.orig_system_id%TYPE;
393: l_fnd_usr_new_orig_system_id wf_local_roles.orig_system_id%TYPE;
394:

Line 391: l_fnd_usr_new_orig_system wf_local_roles.orig_system%TYPE;

387:
388: l_fnd_old_user_name wf_local_roles.name%TYPE;
389: l_fnd_new_user_name wf_local_roles.name%TYPE;
390: l_fnd_usr_old_orig_system wf_local_roles.orig_system%TYPE;
391: l_fnd_usr_new_orig_system wf_local_roles.orig_system%TYPE;
392: l_fnd_usr_old_orig_system_id wf_local_roles.orig_system_id%TYPE;
393: l_fnd_usr_new_orig_system_id wf_local_roles.orig_system_id%TYPE;
394:
395: PROCEDURE create_wf_role_usr_role (ll_role_name VARCHAR2,

Line 392: l_fnd_usr_old_orig_system_id wf_local_roles.orig_system_id%TYPE;

388: l_fnd_old_user_name wf_local_roles.name%TYPE;
389: l_fnd_new_user_name wf_local_roles.name%TYPE;
390: l_fnd_usr_old_orig_system wf_local_roles.orig_system%TYPE;
391: l_fnd_usr_new_orig_system wf_local_roles.orig_system%TYPE;
392: l_fnd_usr_old_orig_system_id wf_local_roles.orig_system_id%TYPE;
393: l_fnd_usr_new_orig_system_id wf_local_roles.orig_system_id%TYPE;
394:
395: PROCEDURE create_wf_role_usr_role (ll_role_name VARCHAR2,
396: ll_role_orig_system VARCHAR2,

Line 393: l_fnd_usr_new_orig_system_id wf_local_roles.orig_system_id%TYPE;

389: l_fnd_new_user_name wf_local_roles.name%TYPE;
390: l_fnd_usr_old_orig_system wf_local_roles.orig_system%TYPE;
391: l_fnd_usr_new_orig_system wf_local_roles.orig_system%TYPE;
392: l_fnd_usr_old_orig_system_id wf_local_roles.orig_system_id%TYPE;
393: l_fnd_usr_new_orig_system_id wf_local_roles.orig_system_id%TYPE;
394:
395: PROCEDURE create_wf_role_usr_role (ll_role_name VARCHAR2,
396: ll_role_orig_system VARCHAR2,
397: ll_role_orig_system_id NUMBER,

Line 559: from wf_local_roles

555: AND mem.resource_id = ll_resource_id;
556:
557: cursor grp_wfrole_cur(c_group_id number, c_grp_role_name varchar2) IS
558: select name
559: from wf_local_roles
560: where name = c_grp_role_name
561: and orig_system = g_grp_orig_system
562: and orig_system_id = c_group_id;
563:

Line 577: from wf_local_roles

573: AND mem.RESOURCE_TYPE = 'INDIVIDUAL';
574:
575: cursor tm_wfrole_cur(c_team_id number, c_team_role_name varchar2) IS
576: select name
577: from wf_local_roles
578: where name = c_team_role_name
579: and orig_system = g_team_orig_system
580: and orig_system_id = c_team_id;
581:

Line 582: l_grp_role_name wf_local_roles.name%TYPE;

578: where name = c_team_role_name
579: and orig_system = g_team_orig_system
580: and orig_system_id = c_team_id;
581:
582: l_grp_role_name wf_local_roles.name%TYPE;
583: l_team_role_name wf_local_roles.name%TYPE;
584: l_role_name wf_local_user_roles.role_name%TYPE;
585: l_role_orig_system_id wf_local_user_roles.role_orig_system_id%TYPE;
586:

Line 583: l_team_role_name wf_local_roles.name%TYPE;

579: and orig_system = g_team_orig_system
580: and orig_system_id = c_team_id;
581:
582: l_grp_role_name wf_local_roles.name%TYPE;
583: l_team_role_name wf_local_roles.name%TYPE;
584: l_role_name wf_local_user_roles.role_name%TYPE;
585: l_role_orig_system_id wf_local_user_roles.role_orig_system_id%TYPE;
586:
587: l_mem_role_start_date date;

Line 1058: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';

1054: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE';
1055:
1056: l_sysdate date := trunc(sysdate);
1057:
1058: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
1059: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
1060:
1061: CURSOR res_user_role_cur IS
1062: SELECT role_name, role_orig_system, role_orig_system_id

Line 1059: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);

1055:
1056: l_sysdate date := trunc(sysdate);
1057:
1058: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
1059: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
1060:
1061: CURSOR res_user_role_cur IS
1062: SELECT role_name, role_orig_system, role_orig_system_id
1063: FROM wf_local_user_roles

Line 1135: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);

1131: X_MSG_DATA OUT NOCOPY VARCHAR2
1132: ) IS
1133: l_api_version CONSTANT NUMBER := 1.0;
1134: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
1135: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);
1136: l_start_date_active date := trunc(P_START_DATE_ACTIVE);
1137: l_end_date_active date := trunc(P_END_DATE_ACTIVE);
1138: l_sysdate date := trunc(sysdate);
1139:

Line 1220: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);

1216: X_MSG_DATA OUT NOCOPY VARCHAR2
1217: ) IS
1218: l_api_version CONSTANT NUMBER := 1.0;
1219: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
1220: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);
1221: l_start_date_active date := trunc(P_START_DATE_ACTIVE);
1222: l_end_date_active date := trunc(P_END_DATE_ACTIVE);
1223: l_sysdate date := trunc(sysdate);
1224: l_g_miss_date date := trunc(to_date('31-12-4712','DD-MM-YYYY'));

Line 1228: FROM WF_LOCAL_ROLES

1224: l_g_miss_date date := trunc(to_date('31-12-4712','DD-MM-YYYY'));
1225:
1226: CURSOR C_ROLE_EXISTS (P_NAME IN VARCHAR2, P_ORG_SYS IN VARCHAR2, P_ORG_SYS_ID IN NUMBER) IS
1227: SELECT 'Y'
1228: FROM WF_LOCAL_ROLES
1229: WHERE NAME = P_NAME AND
1230: ORIG_SYSTEM_ID = P_ORG_SYS_ID AND
1231: ORIG_SYSTEM = P_ORG_SYS;
1232:

Line 1262: l_grp_mem_user_name wf_local_roles.name%TYPE;

1258: -- AND l_sysdate between trunc(tm.start_date_active) and nvl(trunc(tm.end_date_active),l_sysdate)
1259: AND mem.team_resource_id = p_group_id
1260: AND mem.RESOURCE_TYPE = 'GROUP';
1261:
1262: l_grp_mem_user_name wf_local_roles.name%TYPE;
1263: l_grp_mem_orig_system wf_local_roles.orig_system%TYPE;
1264: l_grp_mem_orig_system_id wf_local_roles.orig_system_id%TYPE;
1265:
1266: l_mem_role_start_date date;

Line 1263: l_grp_mem_orig_system wf_local_roles.orig_system%TYPE;

1259: AND mem.team_resource_id = p_group_id
1260: AND mem.RESOURCE_TYPE = 'GROUP';
1261:
1262: l_grp_mem_user_name wf_local_roles.name%TYPE;
1263: l_grp_mem_orig_system wf_local_roles.orig_system%TYPE;
1264: l_grp_mem_orig_system_id wf_local_roles.orig_system_id%TYPE;
1265:
1266: l_mem_role_start_date date;
1267: l_mem_role_end_date date;

Line 1264: l_grp_mem_orig_system_id wf_local_roles.orig_system_id%TYPE;

1260: AND mem.RESOURCE_TYPE = 'GROUP';
1261:
1262: l_grp_mem_user_name wf_local_roles.name%TYPE;
1263: l_grp_mem_orig_system wf_local_roles.orig_system%TYPE;
1264: l_grp_mem_orig_system_id wf_local_roles.orig_system_id%TYPE;
1265:
1266: l_mem_role_start_date date;
1267: l_mem_role_end_date date;
1268:

Line 1459: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);

1455: X_MSG_DATA OUT NOCOPY VARCHAR2
1456: ) IS
1457: l_api_version CONSTANT NUMBER := 1.0;
1458: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP_MEMBERS';
1459: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);
1460: l_sysdate date := trunc(sysdate);
1461:
1462: CURSOR C_ROLE_EXISTS (P_NAME IN VARCHAR2, P_ORG_SYS IN VARCHAR2, P_ORG_SYS_ID IN NUMBER) IS
1463: SELECT 'Y'

Line 1464: FROM WF_LOCAL_ROLES

1460: l_sysdate date := trunc(sysdate);
1461:
1462: CURSOR C_ROLE_EXISTS (P_NAME IN VARCHAR2, P_ORG_SYS IN VARCHAR2, P_ORG_SYS_ID IN NUMBER) IS
1463: SELECT 'Y'
1464: FROM WF_LOCAL_ROLES
1465: WHERE NAME = P_NAME AND
1466: ORIG_SYSTEM_ID = P_ORG_SYS_ID AND
1467: ORIG_SYSTEM = P_ORG_SYS;
1468:

Line 1489: l_user_name wf_local_roles.name%TYPE;

1485: l_group_role_exists c_role_exists%ROWTYPE;
1486: l_grp_active c_grp_active%ROWTYPE;
1487: l_res_active c_res_active%ROWTYPE;
1488:
1489: l_user_name wf_local_roles.name%TYPE;
1490: l_orig_system wf_local_roles.orig_system%TYPE;
1491: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
1492:
1493: l_mem_role_start_date date;

Line 1490: l_orig_system wf_local_roles.orig_system%TYPE;

1486: l_grp_active c_grp_active%ROWTYPE;
1487: l_res_active c_res_active%ROWTYPE;
1488:
1489: l_user_name wf_local_roles.name%TYPE;
1490: l_orig_system wf_local_roles.orig_system%TYPE;
1491: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
1492:
1493: l_mem_role_start_date date;
1494: l_mem_role_end_date date;

Line 1491: l_orig_system_id wf_local_roles.orig_system_id%TYPE;

1487: l_res_active c_res_active%ROWTYPE;
1488:
1489: l_user_name wf_local_roles.name%TYPE;
1490: l_orig_system wf_local_roles.orig_system%TYPE;
1491: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
1492:
1493: l_mem_role_start_date date;
1494: l_mem_role_end_date date;
1495: l_g_miss_date date := trunc(to_date('31-12-4712','DD-MM-YYYY'));

Line 1600: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);

1596: X_MSG_DATA OUT NOCOPY VARCHAR2
1597: ) IS
1598: l_api_version CONSTANT NUMBER := 1.0;
1599: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_GROUP_MEMBERS';
1600: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);
1601:
1602: l_user_name wf_local_roles.name%TYPE;
1603: l_orig_system wf_local_roles.orig_system%TYPE;
1604: l_orig_system_id wf_local_roles.orig_system_id%TYPE;

Line 1602: l_user_name wf_local_roles.name%TYPE;

1598: l_api_version CONSTANT NUMBER := 1.0;
1599: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_GROUP_MEMBERS';
1600: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);
1601:
1602: l_user_name wf_local_roles.name%TYPE;
1603: l_orig_system wf_local_roles.orig_system%TYPE;
1604: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
1605: BEGIN
1606: SAVEPOINT wf_int_del_res_grp_mbr;

Line 1603: l_orig_system wf_local_roles.orig_system%TYPE;

1599: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_GROUP_MEMBERS';
1600: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);
1601:
1602: l_user_name wf_local_roles.name%TYPE;
1603: l_orig_system wf_local_roles.orig_system%TYPE;
1604: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
1605: BEGIN
1606: SAVEPOINT wf_int_del_res_grp_mbr;
1607: x_return_status := fnd_api.g_ret_sts_success;

Line 1604: l_orig_system_id wf_local_roles.orig_system_id%TYPE;

1600: l_grp_role_name wf_local_roles.name%TYPE := g_grp_orig_system||':'||to_char(p_group_id);
1601:
1602: l_user_name wf_local_roles.name%TYPE;
1603: l_orig_system wf_local_roles.orig_system%TYPE;
1604: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
1605: BEGIN
1606: SAVEPOINT wf_int_del_res_grp_mbr;
1607: x_return_status := fnd_api.g_ret_sts_success;
1608:

Line 1668: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);

1664: X_MSG_DATA OUT NOCOPY VARCHAR2
1665: ) IS
1666: l_api_version CONSTANT NUMBER := 1.0;
1667: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';
1668: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);
1669: l_start_date_active date := trunc(P_START_DATE_ACTIVE);
1670: l_end_date_active date := trunc(P_END_DATE_ACTIVE);
1671: l_sysdate date := trunc(sysdate);
1672:

Line 1751: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);

1747: X_MSG_DATA OUT NOCOPY VARCHAR2
1748: ) IS
1749: l_api_version CONSTANT NUMBER := 1.0;
1750: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM';
1751: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);
1752: l_start_date_active date := trunc(P_START_DATE_ACTIVE);
1753: l_end_date_active date := trunc(P_END_DATE_ACTIVE);
1754: l_sysdate date := trunc(sysdate);
1755: l_g_miss_date date := trunc(to_date('31-12-4712','DD-MM-YYYY'));

Line 1759: FROM WF_LOCAL_ROLES

1755: l_g_miss_date date := trunc(to_date('31-12-4712','DD-MM-YYYY'));
1756:
1757: CURSOR C_ROLE_EXISTS (P_NAME IN VARCHAR2, P_ORG_SYS IN VARCHAR2, P_ORG_SYS_ID IN NUMBER) IS
1758: SELECT 'Y'
1759: FROM WF_LOCAL_ROLES
1760: WHERE NAME = P_NAME AND
1761: ORIG_SYSTEM_ID = P_ORG_SYS_ID AND
1762: ORIG_SYSTEM = P_ORG_SYS;
1763:

Line 1792: l_team_mem_user_name wf_local_roles.name%TYPE;

1788: trunc(end_date_active) end_date_active
1789: FROM jtf_rs_groups_b
1790: WHERE group_id = c_group_id;
1791:
1792: l_team_mem_user_name wf_local_roles.name%TYPE;
1793: l_team_mem_orig_system wf_local_roles.orig_system%TYPE;
1794: l_team_mem_orig_system_id wf_local_roles.orig_system_id%TYPE;
1795:
1796: l_team_mem_start_date date;

Line 1793: l_team_mem_orig_system wf_local_roles.orig_system%TYPE;

1789: FROM jtf_rs_groups_b
1790: WHERE group_id = c_group_id;
1791:
1792: l_team_mem_user_name wf_local_roles.name%TYPE;
1793: l_team_mem_orig_system wf_local_roles.orig_system%TYPE;
1794: l_team_mem_orig_system_id wf_local_roles.orig_system_id%TYPE;
1795:
1796: l_team_mem_start_date date;
1797: l_team_mem_end_date date;

Line 1794: l_team_mem_orig_system_id wf_local_roles.orig_system_id%TYPE;

1790: WHERE group_id = c_group_id;
1791:
1792: l_team_mem_user_name wf_local_roles.name%TYPE;
1793: l_team_mem_orig_system wf_local_roles.orig_system%TYPE;
1794: l_team_mem_orig_system_id wf_local_roles.orig_system_id%TYPE;
1795:
1796: l_team_mem_start_date date;
1797: l_team_mem_end_date date;
1798:

Line 1982: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);

1978: X_MSG_DATA OUT NOCOPY VARCHAR2
1979: ) IS
1980: l_api_version CONSTANT NUMBER := 1.0;
1981: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM_MEMBERS';
1982: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);
1983: l_sysdate date := trunc(sysdate);
1984:
1985: CURSOR C_ROLE_EXISTS (P_NAME IN VARCHAR2, P_ORG_SYS IN VARCHAR2, P_ORG_SYS_ID IN NUMBER) IS
1986: SELECT 'Y'

Line 1987: FROM WF_LOCAL_ROLES

1983: l_sysdate date := trunc(sysdate);
1984:
1985: CURSOR C_ROLE_EXISTS (P_NAME IN VARCHAR2, P_ORG_SYS IN VARCHAR2, P_ORG_SYS_ID IN NUMBER) IS
1986: SELECT 'Y'
1987: FROM WF_LOCAL_ROLES
1988: WHERE NAME = P_NAME AND
1989: ORIG_SYSTEM_ID = P_ORG_SYS_ID AND
1990: ORIG_SYSTEM = P_ORG_SYS;
1991:

Line 2021: l_user_name wf_local_roles.name%TYPE;

2017: l_team_active c_team_active%ROWTYPE;
2018: l_res_active c_res_active%ROWTYPE;
2019: l_grp_active c_grp_active%ROWTYPE;
2020:
2021: l_user_name wf_local_roles.name%TYPE;
2022: l_orig_system wf_local_roles.orig_system%TYPE;
2023: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
2024:
2025: l_mem_role_start_date date;

Line 2022: l_orig_system wf_local_roles.orig_system%TYPE;

2018: l_res_active c_res_active%ROWTYPE;
2019: l_grp_active c_grp_active%ROWTYPE;
2020:
2021: l_user_name wf_local_roles.name%TYPE;
2022: l_orig_system wf_local_roles.orig_system%TYPE;
2023: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
2024:
2025: l_mem_role_start_date date;
2026: l_mem_role_end_date date;

Line 2023: l_orig_system_id wf_local_roles.orig_system_id%TYPE;

2019: l_grp_active c_grp_active%ROWTYPE;
2020:
2021: l_user_name wf_local_roles.name%TYPE;
2022: l_orig_system wf_local_roles.orig_system%TYPE;
2023: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
2024:
2025: l_mem_role_start_date date;
2026: l_mem_role_end_date date;
2027: l_g_miss_date date := trunc(to_date('31-12-4712','DD-MM-YYYY'));

Line 2186: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);

2182: X_MSG_DATA OUT NOCOPY VARCHAR2
2183: ) IS
2184: l_api_version CONSTANT NUMBER := 1.0;
2185: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_TEAM_MEMBERS';
2186: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);
2187:
2188: l_user_name wf_local_roles.name%TYPE;
2189: l_orig_system wf_local_roles.orig_system%TYPE;
2190: l_orig_system_id wf_local_roles.orig_system_id%TYPE;

Line 2188: l_user_name wf_local_roles.name%TYPE;

2184: l_api_version CONSTANT NUMBER := 1.0;
2185: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_TEAM_MEMBERS';
2186: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);
2187:
2188: l_user_name wf_local_roles.name%TYPE;
2189: l_orig_system wf_local_roles.orig_system%TYPE;
2190: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
2191: BEGIN
2192: SAVEPOINT wf_int_del_res_team_mbr;

Line 2189: l_orig_system wf_local_roles.orig_system%TYPE;

2185: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_TEAM_MEMBERS';
2186: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);
2187:
2188: l_user_name wf_local_roles.name%TYPE;
2189: l_orig_system wf_local_roles.orig_system%TYPE;
2190: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
2191: BEGIN
2192: SAVEPOINT wf_int_del_res_team_mbr;
2193: x_return_status := fnd_api.g_ret_sts_success;

Line 2190: l_orig_system_id wf_local_roles.orig_system_id%TYPE;

2186: l_team_role_name wf_local_roles.name%TYPE := g_team_orig_system||':'||to_char(p_team_id);
2187:
2188: l_user_name wf_local_roles.name%TYPE;
2189: l_orig_system wf_local_roles.orig_system%TYPE;
2190: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
2191: BEGIN
2192: SAVEPOINT wf_int_del_res_team_mbr;
2193: x_return_status := fnd_api.g_ret_sts_success;
2194: