[Home] [Help]
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;
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);
1744: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1745: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1746: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1747: -- P_LOCATION IN MDSYS.SDO_GEOMETRY,
1748: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
1749: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
1750: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
1751: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
1752: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
2250: X_MSG_COUNT OUT NOCOPY NUMBER,
2251: X_MSG_DATA OUT NOCOPY VARCHAR2,
2252: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2253: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
2254: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
2255: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
2256: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
2257: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
2258: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,