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_RESOURCE_PUB dependencies on JTF_RS_RESOURCE_EXTNS_TL

Line 31: SELECT resource_name from jtf_rs_resource_extns_tl

27: where object_user_code = 'RESOURCE_WORKFLOW' ) ;
28:
29: --Adding this cursor to display the resource name in the message (repuri 03/12/01)
30: cursor c_rs_name (l_resource_id IN NUMBER) IS
31: SELECT resource_name from jtf_rs_resource_extns_tl
32: WHERE resource_id = l_resource_id
33: AND language = userenv ('LANG');
34:
35: x number := 0;

Line 39: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;

35: x number := 0;
36: select_statement varchar2(2000) := null ;
37: wf_rolename varchar2(60);
38:
39: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;
40: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
41:
42: -- variables for dynamic bind to query
43: TYPE bind_rec_type IS RECORD (bind_value NUMBER);

Line 1772: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,

1768: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1769: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1770: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1771: -- P_LOCATION IN MDSYS.SDO_GEOMETRY,
1772: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
1773: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
1774: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
1775: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
1776: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,

Line 2170: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,

2166: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
2167: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
2168: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
2169: -- P_LOCATION IN MDSYS.SDO_GEOMETRY,
2170: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
2171: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
2172: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
2173: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
2174: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,

Line 2473: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,

2469: X_MSG_COUNT OUT NOCOPY NUMBER,
2470: X_MSG_DATA OUT NOCOPY VARCHAR2,
2471: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2472: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
2473: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
2474: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
2475: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
2476: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
2477: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,