APPS.IEU_DIAGNOSTICS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 51: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

47: l_msg_count NUMBER(2);
48:
49: l_msg_data VARCHAR2(2000);
50:
51: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
52: l_sql VARCHAR2(4000);
53:
54:
55:

Line 95: from jtf_rs_resource_extns where user_id = :l_user_id';

91:
92: if NOT(l_user_id is null) then
93: begin
94: l_sql := 'select resource_id
95: from jtf_rs_resource_extns where user_id = :l_user_id';
96:
97: EXECUTE IMMEDIATE l_sql
98: into l_resource_id
99: USING l_user_id;

Line 971: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;

967: l_msg_count NUMBER(2);
968:
969: l_msg_data VARCHAR2(2000);
970:
971: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
972:
973: l_media_types IEU_DIAG_STRING_NST;
974:
975: l_svr_group_name IEO_SVR_GROUPS.GROUP_NAME%TYPE;

Line 1012: l_sql := 'select server_group_id from jtf_rs_resource_extns where user_id = :l_user_id';

1008:
1009: if x_return_status = 'S' then
1010:
1011: begin
1012: l_sql := 'select server_group_id from jtf_rs_resource_extns where user_id = :l_user_id';
1013:
1014: EXECUTE IMMEDIATE l_sql
1015: INTO l_server_group_id
1016: USING l_user_id;

Line 1636: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

1632: l_msg_count NUMBER(2);
1633:
1634: l_msg_data VARCHAR2(2000);
1635:
1636: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1637:
1638: l_wb_style VARCHAR2(2);
1639:
1640: l_media_eligible VARCHAR2(5) ;

Line 1767: l_sql := 'select resource_id from jtf_rs_resource_extns where user_id = :l_user_id';

1763: l_temp_msg_data, p_user_name,
1764: p_responsibility, l_svr_group_name,
1765: l_medias);*/
1766:
1767: l_sql := 'select resource_id from jtf_rs_resource_extns where user_id = :l_user_id';
1768:
1769: EXECUTE IMMEDIATE l_sql
1770: INTO l_resource_id
1771: USING l_user_id;

Line 2244: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

2240: l_language VARCHAR2(4);
2241:
2242: l_valid_nodes IEU_DIAG_NODE_NST;
2243:
2244: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
2245:
2246: CURSOR c_node IS
2247: SELECT
2248: node_id, node_label, node_pid, node_weight

Line 2272: from jtf_rs_resource_extns

2268: p_user_name, p_responsibility, l_user_id, l_responsibility_id, l_application_id);
2269: if (x_return_status = 'S') then
2270: BEGIN
2271: l_sql := ' select resource_id
2272: from jtf_rs_resource_extns
2273: where user_id = :l_user_id';
2274:
2275: EXECUTE IMMEDIATE l_sql
2276: INTO l_resource_id

Line 2460: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

2456: l_language VARCHAR2(4);
2457:
2458: l_valid_nodes IEU_DIAG_NODE_NST;
2459:
2460: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
2461:
2462: l_temp_rproc IEU_UWQ_SEL_ENUMERATORS.REFRESH_PROC%TYPE;
2463:
2464: l_temp_pkg_name IEU_UWQ_SEL_ENUMERATORS.REFRESH_PROC%TYPE;

Line 2663: from jtf_rs_resource_extns

2659:
2660:
2661:
2662: l_sql := 'select resource_id
2663: from jtf_rs_resource_extns
2664: where user_id = :l_user_id';
2665:
2666: --DBMS_OUTPUT.put_line('query---'||l_sql);
2667: EXECUTE IMMEDIATE l_sql

Line 3485: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

3481: l_language VARCHAR2(4);
3482:
3483: l_valid_nodes IEU_DIAG_NODE_NST;
3484:
3485: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
3486:
3487: l_count NUMBER(3) ;
3488:
3489: l_sql VARCHAR2(4000);

Line 3518: l_sql := ' select resource_id from jtf_rs_resource_extns where user_id = :l_user_id';

3514: p_user_name, p_responsibility, l_user_id, l_responsibility_id, l_application_id);
3515:
3516: if (x_return_status = 'S') then
3517: BEGIN
3518: l_sql := ' select resource_id from jtf_rs_resource_extns where user_id = :l_user_id';
3519:
3520: EXECUTE IMMEDIATE l_sql
3521: INTO l_resource_id
3522: USING l_user_id;

Line 3891: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

3887: v_create_string2 varchar2(1000);
3888: v_numrows2 NUMBER;
3889: v_numrows1 NUMBER;
3890: l_count NUMBER;
3891: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
3892: l_string1 varchar2(60);
3893: l_string2 varchar2(60) ;
3894: l_string3 varchar2(60) ;
3895: l_source_object_type_code varchar2(60);