APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on JTF_RS_WF_INTEGRATION_PUB

Line 1: PACKAGE BODY jtf_rs_wf_integration_pub AS

1: PACKAGE BODY jtf_rs_wf_integration_pub AS
2: /* $Header: jtfrswfb.pls 120.1 2005/06/24 20:30:40 baianand ship $ */
3:
4: /*****************************************************************************************
5: ******************************************************************************************/

Line 9: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_WF_INTEGRATION_PUB';

5: ******************************************************************************************/
6:
7: /* Package variables. */
8:
9: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_WF_INTEGRATION_PUB';
10:
11: G_GRP_ORIG_SYSTEM CONSTANT VARCHAR2(10) := 'JRES_GRP';
12: G_TEAM_ORIG_SYSTEM CONSTANT VARCHAR2(10) := 'JRES_TEAM';
13:

Line 36: jtf_rs_wf_integration_pub.get_wf_role

32: --xx CLOSE res_cur;
33:
34: l_user_id := NULL;
35:
36: jtf_rs_wf_integration_pub.get_wf_role
37: (p_resource_id => p_resource_id,
38: p_user_id => l_user_id,
39: x_role_name => x_role_name,
40: x_orig_system => x_orig_system,

Line 151: jtf_rs_wf_integration_pub.get_wf_role

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,
154: x_orig_system => l_orig_system,
155: x_orig_system_id => l_orig_system_id);

Line 1336: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => i.resource_id,

1332: (l_end_date_active is not null and l_old_grp_vals.end_date_active is null)) THEN
1333: /* above if is to find out if there a change in group dates */
1334:
1335: for i in grp_mem_cur LOOP
1336: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => i.resource_id,
1337: X_ROLE_NAME => l_grp_mem_user_name,
1338: X_ORIG_SYSTEM => l_grp_mem_orig_system,
1339: X_ORIG_SYSTEM_ID => l_grp_mem_orig_system_id);
1340: if (i.grp_mem_end_date = l_g_miss_date) then

Line 1535: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,

1531: /* Group as well as resource are active */
1532: OPEN c_role_exists(l_grp_role_name, g_grp_orig_system, p_group_id);
1533: FETCH c_role_exists into l_group_role_exists;
1534: IF (c_role_exists%FOUND) THEN
1535: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,
1536: X_ROLE_NAME => l_user_name,
1537: X_ORIG_SYSTEM => l_orig_system,
1538: X_ORIG_SYSTEM_ID => l_orig_system_id);
1539:

Line 1616: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,

1612: IF p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list) THEN
1613: fnd_msg_pub.initialize;
1614: END IF;
1615:
1616: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,
1617: X_ROLE_NAME => l_user_name,
1618: X_ORIG_SYSTEM => l_orig_system,
1619: X_ORIG_SYSTEM_ID => l_orig_system_id);
1620:

Line 1869: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => i.team_resource_id,

1865:
1866: for i in team_mem_cur LOOP
1867:
1868: if i.resource_type = 'INDIVIDUAL' then
1869: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => i.team_resource_id,
1870: X_ROLE_NAME => l_team_mem_user_name,
1871: X_ORIG_SYSTEM => l_team_mem_orig_system,
1872: X_ORIG_SYSTEM_ID => l_team_mem_orig_system_id);
1873:

Line 2068: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,

2064: /* Team as well as resource are active */
2065: OPEN c_role_exists(l_team_role_name, g_team_orig_system, p_team_id);
2066: FETCH c_role_exists into l_role_exists;
2067: IF (c_role_exists%FOUND) THEN
2068: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,
2069: X_ROLE_NAME => l_user_name,
2070: X_ORIG_SYSTEM => l_orig_system,
2071: X_ORIG_SYSTEM_ID => l_orig_system_id);
2072:

Line 2204: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,

2200: fnd_msg_pub.initialize;
2201: END IF;
2202:
2203: IF (P_RESOURCE_ID is not null) THEN
2204: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,
2205: X_ROLE_NAME => l_user_name,
2206: X_ORIG_SYSTEM => l_orig_system,
2207: X_ORIG_SYSTEM_ID => l_orig_system_id);
2208:

Line 2252: END jtf_rs_wf_integration_pub;

2248: x_return_status := fnd_api.g_ret_sts_unexp_error;
2249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2250: END;
2251:
2252: END jtf_rs_wf_integration_pub;