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);
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);
44: TYPE bind_tbl_type IS TABLE OF bind_rec_type INDEX BY binary_integer;
116: PROCEDURE create_resource
117: (P_API_VERSION IN NUMBER,
118: P_INIT_MSG_LIST IN VARCHAR2,
119: P_COMMIT IN VARCHAR2,
120: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
121: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
122: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
123: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
124: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
117: (P_API_VERSION IN NUMBER,
118: P_INIT_MSG_LIST IN VARCHAR2,
119: P_COMMIT IN VARCHAR2,
120: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
121: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
122: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
123: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
124: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
125: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
118: P_INIT_MSG_LIST IN VARCHAR2,
119: P_COMMIT IN VARCHAR2,
120: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
121: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
122: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
123: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
124: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
125: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
126: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
119: P_COMMIT IN VARCHAR2,
120: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
121: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
122: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
123: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
124: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
125: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
126: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
127: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
120: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
121: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
122: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
123: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
124: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
125: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
126: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
127: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
128: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
122: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
123: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
124: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
125: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
126: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
127: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
128: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
129: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
130: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
123: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
124: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
125: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
126: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
127: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
128: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
129: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
130: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
131: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
124: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
125: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
126: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
127: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
128: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
129: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
130: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
131: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
132: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
125: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
126: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
127: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
128: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
129: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
130: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
131: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
132: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
133: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
126: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
127: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
128: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
129: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
130: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
131: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
132: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
133: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
134: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
127: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
128: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
129: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
130: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
131: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
132: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
133: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
134: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
135: P_INTERACTION_CENTER_NAME IN VARCHAR2,
128: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
129: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
130: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
131: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
132: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
133: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
134: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
135: P_INTERACTION_CENTER_NAME IN VARCHAR2,
136: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
129: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
130: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
131: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
132: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
133: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
134: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
135: P_INTERACTION_CENTER_NAME IN VARCHAR2,
136: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
137: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
130: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
131: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
132: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
133: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
134: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
135: P_INTERACTION_CENTER_NAME IN VARCHAR2,
136: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
137: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
138: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
132: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
133: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
134: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
135: P_INTERACTION_CENTER_NAME IN VARCHAR2,
136: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
137: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
138: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
139: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
140: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
133: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
134: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
135: P_INTERACTION_CENTER_NAME IN VARCHAR2,
136: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
137: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
138: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
139: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
140: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
141: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
134: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
135: P_INTERACTION_CENTER_NAME IN VARCHAR2,
136: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
137: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
138: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
139: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
140: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
141: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
142: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
135: P_INTERACTION_CENTER_NAME IN VARCHAR2,
136: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
137: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
138: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
139: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
140: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
141: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
142: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
143: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
136: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
137: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
138: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
139: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
140: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
141: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
142: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
143: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
144: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
137: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
138: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
139: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
140: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
141: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
142: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
143: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
144: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
145: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
138: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
139: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
140: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
141: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
142: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
143: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
144: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
145: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
146: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
139: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
140: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
141: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
142: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
143: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
144: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
145: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
146: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
141: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
142: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
143: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
144: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
145: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
146: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
148: X_MSG_COUNT OUT NOCOPY NUMBER,
141: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
142: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
143: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
144: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
145: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
146: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
148: X_MSG_COUNT OUT NOCOPY NUMBER,
149: X_MSG_DATA OUT NOCOPY VARCHAR2,
146: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
148: X_MSG_COUNT OUT NOCOPY NUMBER,
149: X_MSG_DATA OUT NOCOPY VARCHAR2,
150: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
151: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
152: ) IS
153:
154: l_api_version CONSTANT NUMBER := 1.0;
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
148: X_MSG_COUNT OUT NOCOPY NUMBER,
149: X_MSG_DATA OUT NOCOPY VARCHAR2,
150: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
151: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
152: ) IS
153:
154: l_api_version CONSTANT NUMBER := 1.0;
155: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
152: ) IS
153:
154: l_api_version CONSTANT NUMBER := 1.0;
155: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
156: l_category jtf_rs_resource_extns.category%TYPE;
157: l_source_id jtf_rs_resource_extns.source_id%TYPE;
158: l_address_id jtf_rs_resource_extns.address_id%TYPE;
159: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
160: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
153:
154: l_api_version CONSTANT NUMBER := 1.0;
155: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
156: l_category jtf_rs_resource_extns.category%TYPE;
157: l_source_id jtf_rs_resource_extns.source_id%TYPE;
158: l_address_id jtf_rs_resource_extns.address_id%TYPE;
159: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
160: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
161: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
154: l_api_version CONSTANT NUMBER := 1.0;
155: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
156: l_category jtf_rs_resource_extns.category%TYPE;
157: l_source_id jtf_rs_resource_extns.source_id%TYPE;
158: l_address_id jtf_rs_resource_extns.address_id%TYPE;
159: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
160: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
161: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
162: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
155: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
156: l_category jtf_rs_resource_extns.category%TYPE;
157: l_source_id jtf_rs_resource_extns.source_id%TYPE;
158: l_address_id jtf_rs_resource_extns.address_id%TYPE;
159: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
160: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
161: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
162: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
163: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
156: l_category jtf_rs_resource_extns.category%TYPE;
157: l_source_id jtf_rs_resource_extns.source_id%TYPE;
158: l_address_id jtf_rs_resource_extns.address_id%TYPE;
159: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
160: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
161: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
162: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
163: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
164: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
158: l_address_id jtf_rs_resource_extns.address_id%TYPE;
159: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
160: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
161: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
162: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
163: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
164: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
165: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
166: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
159: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
160: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
161: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
162: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
163: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
164: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
165: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
166: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
167: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
160: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
161: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
162: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
163: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
164: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
165: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
166: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
167: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
168: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
161: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
162: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
163: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
164: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
165: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
166: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
167: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
168: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
169: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
162: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
163: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
164: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
165: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
166: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
167: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
168: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
169: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
170: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
163: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
164: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
165: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
166: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
167: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
168: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
169: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
170: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
171: l_interaction_center_name VARCHAR2(256);
164: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
165: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
166: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
167: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
168: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
169: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
170: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
171: l_interaction_center_name VARCHAR2(256);
172: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
165: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
166: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
167: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
168: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
169: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
170: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
171: l_interaction_center_name VARCHAR2(256);
172: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
173: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
166: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
167: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
168: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
169: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
170: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
171: l_interaction_center_name VARCHAR2(256);
172: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
173: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
174: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
168: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
169: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
170: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
171: l_interaction_center_name VARCHAR2(256);
172: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
173: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
174: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
175: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
176: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
169: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
170: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
171: l_interaction_center_name VARCHAR2(256);
172: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
173: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
174: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
175: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
176: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
177: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
170: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
171: l_interaction_center_name VARCHAR2(256);
172: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
173: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
174: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
175: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
176: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
177: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
178: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
171: l_interaction_center_name VARCHAR2(256);
172: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
173: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
174: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
175: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
176: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
177: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
178: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
179: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
172: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
173: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
174: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
175: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
176: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
177: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
178: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
179: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
180: l_user_id jtf_rs_resource_extns.user_id%TYPE;
173: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
174: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
175: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
176: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
177: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
178: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
179: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
180: l_user_id jtf_rs_resource_extns.user_id%TYPE;
181: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
174: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
175: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
176: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
177: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
178: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
179: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
180: l_user_id jtf_rs_resource_extns.user_id%TYPE;
181: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
182: --l_location MDSYS.SDO_GEOMETRY := p_location;
175: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
176: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
177: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
178: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
179: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
180: l_user_id jtf_rs_resource_extns.user_id%TYPE;
181: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
182: --l_location MDSYS.SDO_GEOMETRY := p_location;
183:
176: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
177: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
178: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
179: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
180: l_user_id jtf_rs_resource_extns.user_id%TYPE;
181: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
182: --l_location MDSYS.SDO_GEOMETRY := p_location;
183:
184: --added for NOCOPY
177: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
178: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
179: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
180: l_user_id jtf_rs_resource_extns.user_id%TYPE;
181: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
182: --l_location MDSYS.SDO_GEOMETRY := p_location;
183:
184: --added for NOCOPY
185: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
181: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
182: --l_location MDSYS.SDO_GEOMETRY := p_location;
183:
184: --added for NOCOPY
185: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
186: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
187: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
188:
189: l_check_flag VARCHAR2(1);
182: --l_location MDSYS.SDO_GEOMETRY := p_location;
183:
184: --added for NOCOPY
185: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
186: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
187: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
188:
189: l_check_flag VARCHAR2(1);
190: l_source_name VARCHAR2(2000);
183:
184: --added for NOCOPY
185: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
186: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
187: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
188:
189: l_check_flag VARCHAR2(1);
190: l_source_name VARCHAR2(2000);
191: l_found BOOLEAN;
400: l_assigned_to_group_id IN NUMBER)
401: IS
402: SELECT u.user_id
403: FROM fnd_user u,
404: jtf_rs_resource_extns r
405: WHERE u.user_id = r.user_id
406: AND u.user_id = l_assigned_to_group_id;
407:
408:
409: CURSOR c_validate_user_id(
410: l_user_id IN NUMBER)
411: IS
412: SELECT 'Y'
413: FROM jtf_rs_resource_extns
414: WHERE user_id = l_user_id;
415:
416: -- Enh 3947611 2-dec-2004 added cursor to check emp existence
417: CURSOR c_emp_exist(p_person_id IN NUMBER)
1324: PROCEDURE create_resource_migrate (
1325: P_API_VERSION IN NUMBER,
1326: P_INIT_MSG_LIST IN VARCHAR2,
1327: P_COMMIT IN VARCHAR2,
1328: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1329: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
1330: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1331: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
1332: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1325: P_API_VERSION IN NUMBER,
1326: P_INIT_MSG_LIST IN VARCHAR2,
1327: P_COMMIT IN VARCHAR2,
1328: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1329: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
1330: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1331: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
1332: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1333: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
1326: P_INIT_MSG_LIST IN VARCHAR2,
1327: P_COMMIT IN VARCHAR2,
1328: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1329: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
1330: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1331: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
1332: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1333: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
1334: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1327: P_COMMIT IN VARCHAR2,
1328: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1329: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
1330: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1331: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
1332: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1333: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
1334: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1335: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1328: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1329: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
1330: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1331: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
1332: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1333: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
1334: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1335: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1336: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1330: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1331: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
1332: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1333: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
1334: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1335: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1336: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1337: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1338: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1331: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
1332: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1333: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
1334: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1335: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1336: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1337: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1338: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1339: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1332: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1333: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
1334: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1335: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1336: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1337: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1338: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1339: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1340: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1333: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE,
1334: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1335: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1336: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1337: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1338: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1339: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1340: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1341: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1334: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1335: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1336: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1337: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1338: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1339: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1340: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1341: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1342: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1335: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1336: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1337: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1338: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1339: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1340: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1341: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1342: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1343: P_INTERACTION_CENTER_NAME IN VARCHAR2,
1336: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1337: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1338: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1339: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1340: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1341: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1342: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1343: P_INTERACTION_CENTER_NAME IN VARCHAR2,
1344: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1337: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1338: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1339: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1340: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1341: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1342: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1343: P_INTERACTION_CENTER_NAME IN VARCHAR2,
1344: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1345: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1338: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1339: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1340: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1341: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1342: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1343: P_INTERACTION_CENTER_NAME IN VARCHAR2,
1344: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1345: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1346: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1340: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1341: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1342: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1343: P_INTERACTION_CENTER_NAME IN VARCHAR2,
1344: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1345: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1346: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1347: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1348: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1341: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1342: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1343: P_INTERACTION_CENTER_NAME IN VARCHAR2,
1344: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1345: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1346: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1347: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1348: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1349: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1342: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1343: P_INTERACTION_CENTER_NAME IN VARCHAR2,
1344: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1345: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1346: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1347: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1348: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1349: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1350: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1343: P_INTERACTION_CENTER_NAME IN VARCHAR2,
1344: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1345: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1346: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1347: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1348: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1349: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1350: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1351: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1344: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1345: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1346: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1347: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1348: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1349: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1350: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1351: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1352: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1345: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1346: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1347: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1348: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1349: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1350: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1351: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1352: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1353: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
1346: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1347: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1348: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1349: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1350: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1351: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1352: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1353: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
1354: --P_LOCATION IN MDSYS.SDO_GEOMETRY,
1347: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1348: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1349: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1350: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1351: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1352: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1353: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
1354: --P_LOCATION IN MDSYS.SDO_GEOMETRY,
1355: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1348: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1349: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1350: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1351: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1352: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1353: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
1354: --P_LOCATION IN MDSYS.SDO_GEOMETRY,
1355: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1356: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1349: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1350: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1351: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1352: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1353: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
1354: --P_LOCATION IN MDSYS.SDO_GEOMETRY,
1355: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1356: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1357: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1351: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1352: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1353: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
1354: --P_LOCATION IN MDSYS.SDO_GEOMETRY,
1355: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1356: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1357: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1358: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1359: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1352: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1353: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
1354: --P_LOCATION IN MDSYS.SDO_GEOMETRY,
1355: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1356: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1357: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1358: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1359: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1360: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1353: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE,
1354: --P_LOCATION IN MDSYS.SDO_GEOMETRY,
1355: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1356: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1357: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1358: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1359: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1360: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1361: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1354: --P_LOCATION IN MDSYS.SDO_GEOMETRY,
1355: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1356: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1357: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1358: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1359: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1360: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1361: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1362: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1355: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1356: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1357: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1358: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1359: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1360: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1361: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1362: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1363: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1356: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1357: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1358: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1359: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1360: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1361: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1362: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1363: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1364: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1357: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1358: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1359: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1360: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1361: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1362: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1363: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1364: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1365: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1358: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1359: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1360: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1361: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1362: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1363: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1364: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1365: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1366: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1359: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1360: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1361: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1362: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1363: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1364: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1365: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1366: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1367: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1360: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1361: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1362: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1363: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1364: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1365: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1366: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1367: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1368: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1361: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1362: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1363: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1364: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1365: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1366: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1367: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1368: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1369: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1362: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1363: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1364: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1365: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1366: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1367: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1368: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1369: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1370: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1363: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1364: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1365: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1366: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1367: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1368: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1369: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1370: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1371: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
1364: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1365: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1366: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1367: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1368: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1369: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1370: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1371: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
1372: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1365: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1366: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1367: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1368: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1369: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1370: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1371: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
1372: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1373: X_MSG_COUNT OUT NOCOPY NUMBER,
1366: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1367: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1368: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1369: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1370: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1371: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
1372: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1373: X_MSG_COUNT OUT NOCOPY NUMBER,
1374: X_MSG_DATA OUT NOCOPY VARCHAR2,
1367: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1368: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1369: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1370: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1371: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
1372: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1373: X_MSG_COUNT OUT NOCOPY NUMBER,
1374: X_MSG_DATA OUT NOCOPY VARCHAR2,
1375: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1371: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
1372: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1373: X_MSG_COUNT OUT NOCOPY NUMBER,
1374: X_MSG_DATA OUT NOCOPY VARCHAR2,
1375: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1376: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
1377: ) IS
1378:
1379:
1372: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1373: X_MSG_COUNT OUT NOCOPY NUMBER,
1374: X_MSG_DATA OUT NOCOPY VARCHAR2,
1375: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1376: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
1377: ) IS
1378:
1379:
1380: BEGIN
1451: PROCEDURE update_resource
1452: (P_API_VERSION IN NUMBER,
1453: P_INIT_MSG_LIST IN VARCHAR2,
1454: P_COMMIT IN VARCHAR2,
1455: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1456: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1457: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1458: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1459: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1452: (P_API_VERSION IN NUMBER,
1453: P_INIT_MSG_LIST IN VARCHAR2,
1454: P_COMMIT IN VARCHAR2,
1455: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1456: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1457: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1458: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1459: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1460: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1453: P_INIT_MSG_LIST IN VARCHAR2,
1454: P_COMMIT IN VARCHAR2,
1455: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1456: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1457: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1458: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1459: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1460: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1461: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1454: P_COMMIT IN VARCHAR2,
1455: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1456: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1457: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1458: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1459: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1460: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1461: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1462: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1455: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1456: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1457: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1458: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1459: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1460: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1461: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1462: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1463: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1456: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1457: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1458: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1459: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1460: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1461: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1462: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1463: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1464: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1457: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1458: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1459: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1460: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1461: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1462: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1463: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1464: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1465: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1458: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1459: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1460: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1461: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1462: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1463: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1464: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1465: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1466: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1459: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1460: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1461: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1462: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1463: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1464: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1465: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1466: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1467: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1460: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1461: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1462: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1463: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1464: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1465: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1466: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1467: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1468: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1461: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1462: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1463: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1464: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1465: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1466: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1467: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1468: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1469: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1462: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1463: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1464: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1465: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1466: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1467: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1468: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1469: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1470: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1463: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1464: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1465: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1466: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1467: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1468: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1469: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1470: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1471: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1464: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1465: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1466: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1467: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1468: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1469: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1470: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1471: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1472: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1465: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1466: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1467: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1468: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1469: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1470: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1471: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1472: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1473: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1466: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1467: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1468: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1469: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1470: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1471: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1472: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1473: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1474: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1467: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1468: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1469: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1470: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1471: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1472: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1473: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1474: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1475: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1468: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1469: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1470: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1471: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1472: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1473: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1474: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1475: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1476: -- P_LOCATION IN MDSYS.SDO_GEOMETRY,
1469: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1470: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1471: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1472: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1473: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1474: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1475: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1476: -- P_LOCATION IN MDSYS.SDO_GEOMETRY,
1477: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
1470: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1471: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1472: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1473: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1474: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1475: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1476: -- P_LOCATION IN MDSYS.SDO_GEOMETRY,
1477: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
1478: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1471: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1472: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1473: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1474: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1475: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1476: -- P_LOCATION IN MDSYS.SDO_GEOMETRY,
1477: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
1478: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1479: X_MSG_COUNT OUT NOCOPY NUMBER,
1473: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1474: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE,
1475: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE,
1476: -- P_LOCATION IN MDSYS.SDO_GEOMETRY,
1477: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
1478: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1479: X_MSG_COUNT OUT NOCOPY NUMBER,
1480: X_MSG_DATA OUT NOCOPY VARCHAR2
1481: ) IS
1481: ) IS
1482:
1483: l_api_version CONSTANT NUMBER := 1.0;
1484: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
1485: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1486: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1487: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1488: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1489: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1482:
1483: l_api_version CONSTANT NUMBER := 1.0;
1484: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
1485: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1486: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1487: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1488: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1489: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1490: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1483: l_api_version CONSTANT NUMBER := 1.0;
1484: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
1485: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1486: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1487: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1488: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1489: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1490: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1491: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1484: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
1485: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1486: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1487: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1488: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1489: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1490: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1491: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1492: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1485: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1486: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1487: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1488: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1489: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1490: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1491: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1492: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1493: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1486: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1487: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1488: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1489: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1490: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1491: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1492: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1493: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1494: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1487: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1488: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1489: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1490: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1491: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1492: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1493: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1494: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1495: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1488: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1489: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1490: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1491: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1492: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1493: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1494: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1495: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1496: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1489: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1490: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1491: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1492: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1493: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1494: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1495: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1496: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1497: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1490: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1491: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1492: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1493: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1494: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1495: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1496: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1497: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1498: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1491: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1492: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1493: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1494: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1495: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1496: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1497: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1498: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1499: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1492: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1493: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1494: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1495: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1496: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1497: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1498: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1499: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1500: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1493: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1494: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1495: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1496: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1497: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1498: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1499: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1500: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1501: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1494: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1495: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1496: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1497: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1498: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1499: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1500: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1501: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1502: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1495: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1496: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1497: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1498: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1499: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1500: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1501: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1502: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1503: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1496: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1497: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1498: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1499: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1500: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1501: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1502: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1503: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1504: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1497: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1498: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1499: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1500: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1501: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1502: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1503: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1504: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1505: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1498: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1499: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1500: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1501: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1502: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1503: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1504: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1505: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1506: -- l_location mdsys.sdo_geometry;
1499: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1500: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1501: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1502: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1503: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1504: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1505: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1506: -- l_location mdsys.sdo_geometry;
1507: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1500: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1501: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1502: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1503: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1504: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1505: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1506: -- l_location mdsys.sdo_geometry;
1507: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1508:
1501: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1502: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1503: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1504: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1505: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1506: -- l_location mdsys.sdo_geometry;
1507: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1508:
1509: l_check_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1503: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1504: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1505: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1506: -- l_location mdsys.sdo_geometry;
1507: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1508:
1509: l_check_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1510: l_check_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1511:
1505: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1506: -- l_location mdsys.sdo_geometry;
1507: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1508:
1509: l_check_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1510: l_check_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1511:
1512:
1513: CURSOR c_resource_id(
1506: -- l_location mdsys.sdo_geometry;
1507: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1508:
1509: l_check_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1510: l_check_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1511:
1512:
1513: CURSOR c_resource_id(
1514: l_resource_id IN NUMBER)
1513: CURSOR c_resource_id(
1514: l_resource_id IN NUMBER)
1515: IS
1516: SELECT resource_id
1517: FROM jtf_rs_resource_extns
1518: WHERE resource_id = l_resource_id;
1519:
1520:
1521: CURSOR c_resource_number(
1521: CURSOR c_resource_number(
1522: l_resource_number IN VARCHAR2)
1523: IS
1524: SELECT resource_id
1525: FROM jtf_rs_resource_extns
1526: WHERE resource_number = l_resource_number;
1527:
1528:
1529: BEGIN
1722: PROCEDURE update_resource
1723: (P_API_VERSION IN NUMBER,
1724: P_INIT_MSG_LIST IN VARCHAR2,
1725: P_COMMIT IN VARCHAR2,
1726: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1727: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1728: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1729: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1730: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1723: (P_API_VERSION IN NUMBER,
1724: P_INIT_MSG_LIST IN VARCHAR2,
1725: P_COMMIT IN VARCHAR2,
1726: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1727: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1728: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1729: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1730: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1731: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1724: P_INIT_MSG_LIST IN VARCHAR2,
1725: P_COMMIT IN VARCHAR2,
1726: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1727: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1728: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1729: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1730: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1731: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1732: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1725: P_COMMIT IN VARCHAR2,
1726: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1727: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1728: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1729: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1730: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1731: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1732: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1733: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1726: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1727: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1728: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1729: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1730: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1731: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1732: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1733: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1734: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1727: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
1728: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1729: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1730: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1731: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1732: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1733: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1734: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1735: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1728: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1729: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1730: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1731: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1732: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1733: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1734: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1735: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1736: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1729: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1730: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1731: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1732: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1733: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1734: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1735: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1736: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1737: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1730: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1731: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1732: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1733: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1734: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1735: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1736: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1737: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1738: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1731: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1732: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1733: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1734: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1735: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1736: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1737: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1738: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1739: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1732: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1733: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1734: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1735: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1736: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1737: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1738: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1739: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1740: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1733: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1734: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1735: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1736: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1737: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1738: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1739: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1740: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1741: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1734: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1735: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1736: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1737: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1738: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1739: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1740: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1741: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1742: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1735: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1736: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1737: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1738: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1739: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1740: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1741: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1742: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1743: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1736: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
1737: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1738: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1739: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1740: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1741: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1742: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1743: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
1744: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
1737: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
1738: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1739: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1740: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1741: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1742: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1743: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
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,
1738: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
1739: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1740: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1741: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1742: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1743: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
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,
1739: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
1740: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1741: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1742: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1743: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
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,
1740: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
1741: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1742: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1743: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
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,
1741: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,
1742: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1743: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
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,
1742: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
1743: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE,
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,
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,
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,
1753: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%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,
1753: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
1754: P_SOURCE_ORG_ID IN NUMBER,
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,
1753: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
1754: P_SOURCE_ORG_ID IN NUMBER,
1755: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
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,
1753: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
1754: P_SOURCE_ORG_ID IN NUMBER,
1755: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
1756: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%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,
1753: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
1754: P_SOURCE_ORG_ID IN NUMBER,
1755: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
1756: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
1757: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%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,
1753: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
1754: P_SOURCE_ORG_ID IN NUMBER,
1755: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
1756: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
1757: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
1758: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
1759: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
1752: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
1753: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
1754: P_SOURCE_ORG_ID IN NUMBER,
1755: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
1756: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
1757: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
1758: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
1759: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
1760: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
1753: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
1754: P_SOURCE_ORG_ID IN NUMBER,
1755: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
1756: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
1757: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
1758: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
1759: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
1760: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
1761: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
1754: P_SOURCE_ORG_ID IN NUMBER,
1755: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
1756: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
1757: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
1758: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
1759: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
1760: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
1761: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
1762: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
1755: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
1756: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
1757: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
1758: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
1759: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
1760: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
1761: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
1762: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
1763: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
1756: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
1757: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
1758: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
1759: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
1760: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
1761: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
1762: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
1763: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
1764: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
1757: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
1758: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
1759: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
1760: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
1761: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
1762: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
1763: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
1764: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
1765: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
1758: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
1759: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
1760: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
1761: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
1762: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
1763: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
1764: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
1765: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
1766: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE,
1759: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
1760: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
1761: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
1762: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
1763: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
1764: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
1765: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
1766: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE,
1767: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE,
1760: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
1761: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
1762: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
1763: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
1764: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
1765: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
1766: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE,
1767: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE,
1768: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE,
1761: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
1762: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
1763: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
1764: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
1765: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
1766: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE,
1767: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE,
1768: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE,
1769: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE,
1762: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
1763: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
1764: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
1765: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
1766: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE,
1767: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE,
1768: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE,
1769: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE,
1770: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
1763: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
1764: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
1765: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
1766: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE,
1767: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE,
1768: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE,
1769: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE,
1770: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
1771: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
1764: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
1765: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
1766: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE,
1767: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE,
1768: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE,
1769: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE,
1770: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
1771: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
1772: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
1765: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
1766: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE,
1767: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE,
1768: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE,
1769: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE,
1770: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
1771: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
1772: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
1773: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
1766: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE,
1767: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE,
1768: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE,
1769: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE,
1770: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
1771: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
1772: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
1773: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
1774: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
1767: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE,
1768: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE,
1769: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE,
1770: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
1771: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
1772: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
1773: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
1774: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
1775: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
1768: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE,
1769: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE,
1770: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
1771: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
1772: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
1773: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
1774: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
1775: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
1776: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
1769: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE,
1770: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
1771: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
1772: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
1773: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
1774: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
1775: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
1776: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
1777: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
1770: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
1771: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
1772: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
1773: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
1774: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
1775: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
1776: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
1777: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
1778: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1771: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
1772: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
1773: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
1774: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
1775: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
1776: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
1777: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
1778: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1779: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
1772: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
1773: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
1774: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
1775: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
1776: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
1777: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
1778: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1779: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
1780: P_USER_NAME IN VARCHAR2,
1773: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
1774: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
1775: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
1776: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
1777: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
1778: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1779: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
1780: P_USER_NAME IN VARCHAR2,
1781: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1774: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
1775: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
1776: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
1777: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
1778: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1779: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
1780: P_USER_NAME IN VARCHAR2,
1781: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1782: X_MSG_COUNT OUT NOCOPY NUMBER,
1775: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
1776: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
1777: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
1778: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1779: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
1780: P_USER_NAME IN VARCHAR2,
1781: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1782: X_MSG_COUNT OUT NOCOPY NUMBER,
1783: X_MSG_DATA OUT NOCOPY VARCHAR2,
1780: P_USER_NAME IN VARCHAR2,
1781: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1782: X_MSG_COUNT OUT NOCOPY NUMBER,
1783: X_MSG_DATA OUT NOCOPY VARCHAR2,
1784: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
1785: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE,
1786: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1787: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1788: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1781: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1782: X_MSG_COUNT OUT NOCOPY NUMBER,
1783: X_MSG_DATA OUT NOCOPY VARCHAR2,
1784: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
1785: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE,
1786: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1787: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1788: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1789: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1782: X_MSG_COUNT OUT NOCOPY NUMBER,
1783: X_MSG_DATA OUT NOCOPY VARCHAR2,
1784: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
1785: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE,
1786: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1787: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1788: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1789: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1790: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1783: X_MSG_DATA OUT NOCOPY VARCHAR2,
1784: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
1785: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE,
1786: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1787: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1788: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1789: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1790: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1791: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1784: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
1785: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE,
1786: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1787: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1788: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1789: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1790: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1791: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1792: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1785: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE,
1786: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1787: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1788: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1789: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1790: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1791: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1792: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1793: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1786: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE,
1787: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1788: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1789: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1790: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1791: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1792: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1793: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1794: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1787: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE,
1788: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1789: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1790: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1791: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1792: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1793: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1794: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1795: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1788: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE,
1789: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1790: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1791: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1792: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1793: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1794: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1795: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1796: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1789: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE,
1790: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1791: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1792: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1793: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1794: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1795: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1796: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1797: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1790: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE,
1791: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1792: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1793: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1794: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1795: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1796: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1797: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1798: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1791: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE,
1792: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1793: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1794: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1795: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1796: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1797: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1798: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1799: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1792: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE,
1793: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1794: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1795: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1796: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1797: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1798: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1799: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1800: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1793: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE,
1794: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1795: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1796: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1797: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1798: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1799: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1800: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1801: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE
1794: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE,
1795: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1796: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1797: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1798: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1799: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1800: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1801: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE
1802: ) IS
1795: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE,
1796: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1797: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1798: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1799: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1800: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1801: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE
1802: ) IS
1803:
1796: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE,
1797: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1798: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1799: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1800: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1801: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE
1802: ) IS
1803:
1804: l_api_version CONSTANT NUMBER := 1.0;
1797: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE,
1798: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE,
1799: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
1800: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
1801: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE
1802: ) IS
1803:
1804: l_api_version CONSTANT NUMBER := 1.0;
1805: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
1802: ) IS
1803:
1804: l_api_version CONSTANT NUMBER := 1.0;
1805: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
1806: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1807: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1808: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1809: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1810: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1803:
1804: l_api_version CONSTANT NUMBER := 1.0;
1805: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
1806: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1807: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1808: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1809: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1810: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1811: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1804: l_api_version CONSTANT NUMBER := 1.0;
1805: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
1806: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1807: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1808: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1809: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1810: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1811: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1812: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1805: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
1806: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1807: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1808: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1809: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1810: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1811: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1812: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1813: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1806: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1807: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1808: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1809: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1810: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1811: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1812: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1813: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1814: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1807: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1808: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1809: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1810: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1811: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1812: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1813: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1814: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1815: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1808: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1809: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1810: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1811: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1812: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1813: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1814: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1815: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1816: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1809: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1810: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1811: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1812: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1813: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1814: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1815: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1816: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1817: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1810: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1811: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1812: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1813: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1814: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1815: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1816: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1817: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1818: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1811: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1812: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1813: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1814: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1815: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1816: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1817: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1818: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1819: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1812: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1813: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1814: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1815: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1816: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1817: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1818: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1819: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1820: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1813: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1814: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1815: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1816: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1817: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1818: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1819: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1820: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1821: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1814: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1815: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1816: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1817: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1818: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1819: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1820: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1821: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1822: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1815: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1816: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1817: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1818: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1819: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1820: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1821: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1822: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1823: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1816: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1817: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1818: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1819: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1820: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1821: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1822: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1823: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1824: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1817: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1818: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1819: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1820: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1821: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1822: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1823: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1824: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1825: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1818: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1819: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1820: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1821: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1822: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1823: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1824: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1825: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1826: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1819: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1820: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1821: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1822: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1823: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1824: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1825: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1826: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1827: -- l_location mdsys.sdo_geometry;
1820: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1821: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1822: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1823: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1824: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1825: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1826: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1827: -- l_location mdsys.sdo_geometry;
1828: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1821: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
1822: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1823: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1824: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1825: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1826: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1827: -- l_location mdsys.sdo_geometry;
1828: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1829: l_user_name jtf_rs_resource_extns.user_name%type;
1822: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
1823: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
1824: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1825: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1826: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1827: -- l_location mdsys.sdo_geometry;
1828: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1829: l_user_name jtf_rs_resource_extns.user_name%type;
1830: l_check_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1824: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
1825: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1826: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1827: -- l_location mdsys.sdo_geometry;
1828: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1829: l_user_name jtf_rs_resource_extns.user_name%type;
1830: l_check_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1831: l_check_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1832:
1825: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
1826: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1827: -- l_location mdsys.sdo_geometry;
1828: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1829: l_user_name jtf_rs_resource_extns.user_name%type;
1830: l_check_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1831: l_check_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1832:
1833:
1826: l_user_id jtf_rs_resource_extns.user_id%TYPE;
1827: -- l_location mdsys.sdo_geometry;
1828: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1829: l_user_name jtf_rs_resource_extns.user_name%type;
1830: l_check_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1831: l_check_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1832:
1833:
1834: CURSOR c_resource_id(
1827: -- l_location mdsys.sdo_geometry;
1828: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
1829: l_user_name jtf_rs_resource_extns.user_name%type;
1830: l_check_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1831: l_check_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1832:
1833:
1834: CURSOR c_resource_id(
1835: l_resource_id IN NUMBER)
1834: CURSOR c_resource_id(
1835: l_resource_id IN NUMBER)
1836: IS
1837: SELECT resource_id
1838: FROM jtf_rs_resource_extns
1839: WHERE resource_id = l_resource_id;
1840:
1841:
1842: CURSOR c_resource_number(
1842: CURSOR c_resource_number(
1843: l_resource_number IN VARCHAR2)
1844: IS
1845: SELECT resource_id
1846: FROM jtf_rs_resource_extns
1847: WHERE resource_number = l_resource_number;
1848:
1849:
1850: BEGIN
2093: PROCEDURE delete_resource
2094: (P_API_VERSION IN NUMBER,
2095: P_INIT_MSG_LIST IN VARCHAR2,
2096: P_COMMIT IN VARCHAR2,
2097: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2098: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2099: X_MSG_COUNT OUT NOCOPY NUMBER,
2100: X_MSG_DATA OUT NOCOPY VARCHAR2
2101: ) IS
2101: ) IS
2102:
2103: l_api_version CONSTANT NUMBER := 1.0;
2104: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE';
2105: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
2106:
2107: CURSOR res_cur(
2108: l_resource_id IN NUMBER)
2109: IS
2108: l_resource_id IN NUMBER)
2109: IS
2110: SELECT resource_id,
2111: category
2112: FROM jtf_rs_resource_extns
2113: WHERE resource_id = l_resource_id;
2114:
2115: res_rec res_cur%rowtype;
2116:
2218: PROCEDURE create_resource
2219: (P_API_VERSION IN NUMBER,
2220: P_INIT_MSG_LIST IN VARCHAR2,
2221: P_COMMIT IN VARCHAR2,
2222: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
2223: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
2224: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
2225: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
2226: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
2219: (P_API_VERSION IN NUMBER,
2220: P_INIT_MSG_LIST IN VARCHAR2,
2221: P_COMMIT IN VARCHAR2,
2222: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
2223: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
2224: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
2225: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
2226: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
2227: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
2220: P_INIT_MSG_LIST IN VARCHAR2,
2221: P_COMMIT IN VARCHAR2,
2222: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
2223: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
2224: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
2225: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
2226: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
2227: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
2228: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
2221: P_COMMIT IN VARCHAR2,
2222: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
2223: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
2224: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
2225: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
2226: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
2227: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
2228: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
2229: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
2222: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
2223: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
2224: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
2225: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
2226: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
2227: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
2228: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
2229: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
2230: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
2224: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
2225: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
2226: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
2227: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
2228: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
2229: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
2230: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
2231: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
2232: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
2225: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
2226: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
2227: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
2228: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
2229: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
2230: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
2231: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
2232: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
2233: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
2226: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
2227: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
2228: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
2229: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
2230: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
2231: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
2232: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
2233: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
2234: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
2227: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
2228: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
2229: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
2230: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
2231: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
2232: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
2233: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
2234: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
2235: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
2228: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
2229: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
2230: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
2231: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
2232: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
2233: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
2234: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
2235: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
2236: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
2229: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
2230: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
2231: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
2232: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
2233: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
2234: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
2235: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
2236: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
2237: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
2230: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
2231: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
2232: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
2233: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
2234: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
2235: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
2236: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
2237: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
2238: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
2231: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
2232: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
2233: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
2234: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
2235: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
2236: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
2237: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
2238: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
2239: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
2232: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
2233: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
2234: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
2235: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
2236: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
2237: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
2238: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
2239: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
2240: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
2234: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
2235: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
2236: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
2237: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
2238: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
2239: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
2240: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
2241: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
2242: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
2235: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
2236: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
2237: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
2238: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
2239: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
2240: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
2241: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
2242: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
2243: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
2236: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
2237: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
2238: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
2239: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
2240: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
2241: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
2242: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
2243: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
2244: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
2237: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
2238: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
2239: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
2240: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
2241: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
2242: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
2243: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
2244: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
2245: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
2238: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
2239: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
2240: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
2241: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
2242: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
2243: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
2244: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
2245: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
2246: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
2239: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
2240: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
2241: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
2242: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
2243: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
2244: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
2245: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
2246: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
2247: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
2240: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
2241: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
2242: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
2243: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
2244: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
2245: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
2246: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
2247: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
2248: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
2241: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
2242: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
2243: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
2244: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
2245: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
2246: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
2247: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
2248: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
2249: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2242: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE,
2243: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
2244: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
2245: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
2246: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
2247: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
2248: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
2249: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2250: X_MSG_COUNT OUT NOCOPY NUMBER,
2243: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
2244: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE,
2245: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
2246: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
2247: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
2248: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
2249: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2250: X_MSG_COUNT OUT NOCOPY NUMBER,
2251: X_MSG_DATA OUT NOCOPY VARCHAR2,
2248: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
2249: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
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,
2249: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
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,
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,
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,
2259: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
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,
2259: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
2260: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
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,
2259: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
2260: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
2261: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
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,
2259: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
2260: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
2261: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
2262: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%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,
2259: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
2260: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
2261: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
2262: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
2263: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
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,
2259: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
2260: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
2261: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
2262: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
2263: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
2264: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%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,
2259: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
2260: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
2261: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
2262: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
2263: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
2264: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
2265: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
2258: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
2259: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
2260: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
2261: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
2262: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
2263: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
2264: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
2265: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
2266: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
2259: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
2260: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
2261: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
2262: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
2263: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
2264: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
2265: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
2266: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
2267: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
2260: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
2261: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
2262: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
2263: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
2264: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
2265: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
2266: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
2267: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
2268: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
2261: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
2262: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
2263: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
2264: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
2265: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
2266: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
2267: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
2268: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
2269: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
2262: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
2263: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
2264: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
2265: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
2266: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
2267: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
2268: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
2269: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
2270: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
2263: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
2264: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
2265: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
2266: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
2267: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
2268: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
2269: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
2270: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
2271: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
2264: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
2265: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
2266: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
2267: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
2268: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
2269: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
2270: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
2271: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
2272: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type DEFAULT NULL,
2265: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
2266: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
2267: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
2268: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
2269: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
2270: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
2271: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
2272: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type DEFAULT NULL,
2273: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type DEFAULT NULL,
2266: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
2267: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
2268: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
2269: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
2270: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
2271: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
2272: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type DEFAULT NULL,
2273: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type DEFAULT NULL,
2274: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type DEFAULT NULL,
2267: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
2268: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
2269: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
2270: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
2271: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
2272: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type DEFAULT NULL,
2273: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type DEFAULT NULL,
2274: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type DEFAULT NULL,
2275: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type DEFAULT NULL,
2268: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
2269: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
2270: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
2271: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
2272: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type DEFAULT NULL,
2273: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type DEFAULT NULL,
2274: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type DEFAULT NULL,
2275: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type DEFAULT NULL,
2276: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
2269: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
2270: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
2271: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
2272: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type DEFAULT NULL,
2273: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type DEFAULT NULL,
2274: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type DEFAULT NULL,
2275: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type DEFAULT NULL,
2276: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
2277: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
2270: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
2271: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
2272: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type DEFAULT NULL,
2273: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type DEFAULT NULL,
2274: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type DEFAULT NULL,
2275: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type DEFAULT NULL,
2276: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
2277: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
2278: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
2271: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
2272: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type DEFAULT NULL,
2273: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type DEFAULT NULL,
2274: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type DEFAULT NULL,
2275: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type DEFAULT NULL,
2276: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
2277: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
2278: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
2279: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
2272: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type DEFAULT NULL,
2273: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type DEFAULT NULL,
2274: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type DEFAULT NULL,
2275: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type DEFAULT NULL,
2276: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
2277: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
2278: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
2279: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
2280: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
2273: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type DEFAULT NULL,
2274: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type DEFAULT NULL,
2275: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type DEFAULT NULL,
2276: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
2277: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
2278: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
2279: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
2280: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
2281: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
2274: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type DEFAULT NULL,
2275: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type DEFAULT NULL,
2276: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
2277: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
2278: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
2279: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
2280: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
2281: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
2282: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
2275: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type DEFAULT NULL,
2276: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
2277: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
2278: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
2279: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
2280: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
2281: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
2282: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
2283: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
2276: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
2277: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
2278: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
2279: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
2280: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
2281: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
2282: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
2283: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
2284: P_USER_NAME IN VARCHAR2,
2277: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
2278: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
2279: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
2280: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
2281: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
2282: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
2283: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
2284: P_USER_NAME IN VARCHAR2,
2285: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
2278: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
2279: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
2280: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
2281: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
2282: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
2283: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
2284: P_USER_NAME IN VARCHAR2,
2285: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
2286: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
2279: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
2280: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
2281: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
2282: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
2283: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
2284: P_USER_NAME IN VARCHAR2,
2285: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
2286: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
2287: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
2281: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
2282: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
2283: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
2284: P_USER_NAME IN VARCHAR2,
2285: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
2286: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
2287: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
2288: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
2289: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
2282: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
2283: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
2284: P_USER_NAME IN VARCHAR2,
2285: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
2286: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
2287: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
2288: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
2289: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
2290: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
2283: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
2284: P_USER_NAME IN VARCHAR2,
2285: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
2286: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
2287: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
2288: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
2289: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
2290: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
2291: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
2284: P_USER_NAME IN VARCHAR2,
2285: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
2286: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
2287: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
2288: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
2289: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
2290: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
2291: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
2292: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
2285: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
2286: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
2287: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
2288: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
2289: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
2290: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
2291: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
2292: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
2293: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
2286: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
2287: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
2288: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
2289: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
2290: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
2291: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
2292: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
2293: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
2294: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
2287: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
2288: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
2289: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
2290: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
2291: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
2292: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
2293: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
2294: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
2295: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
2288: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
2289: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
2290: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
2291: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
2292: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
2293: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
2294: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
2295: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
2296: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
2289: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
2290: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
2291: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
2292: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
2293: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
2294: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
2295: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
2296: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
2297: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
2290: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
2291: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
2292: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
2293: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
2294: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
2295: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
2296: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
2297: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
2298: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
2291: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
2292: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
2293: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
2294: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
2295: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
2296: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
2297: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
2298: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
2299: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
2292: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
2293: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
2294: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
2295: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
2296: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
2297: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
2298: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
2299: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
2300: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
2293: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
2294: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
2295: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
2296: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
2297: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
2298: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
2299: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
2300: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
2301: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
2294: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
2295: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
2296: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
2297: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
2298: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
2299: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
2300: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
2301: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
2302: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
2295: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
2296: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
2297: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
2298: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
2299: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
2300: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
2301: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
2302: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
2303: )
2296: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
2297: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
2298: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
2299: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
2300: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
2301: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
2302: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
2303: )
2304: IS
2297: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
2298: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
2299: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
2300: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
2301: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
2302: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
2303: )
2304: IS
2305:
2298: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
2299: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
2300: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
2301: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
2302: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
2303: )
2304: IS
2305:
2306: l_api_version CONSTANT NUMBER := 1.0;
2306: l_api_version CONSTANT NUMBER := 1.0;
2307: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
2308:
2309: --duplicated from the create_resource api above
2310: l_category jtf_rs_resource_extns.category%TYPE;
2311: l_source_id jtf_rs_resource_extns.source_id%TYPE;
2312: l_address_id jtf_rs_resource_extns.address_id%TYPE;
2313: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
2314: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
2307: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
2308:
2309: --duplicated from the create_resource api above
2310: l_category jtf_rs_resource_extns.category%TYPE;
2311: l_source_id jtf_rs_resource_extns.source_id%TYPE;
2312: l_address_id jtf_rs_resource_extns.address_id%TYPE;
2313: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
2314: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
2315: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
2308:
2309: --duplicated from the create_resource api above
2310: l_category jtf_rs_resource_extns.category%TYPE;
2311: l_source_id jtf_rs_resource_extns.source_id%TYPE;
2312: l_address_id jtf_rs_resource_extns.address_id%TYPE;
2313: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
2314: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
2315: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
2316: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
2309: --duplicated from the create_resource api above
2310: l_category jtf_rs_resource_extns.category%TYPE;
2311: l_source_id jtf_rs_resource_extns.source_id%TYPE;
2312: l_address_id jtf_rs_resource_extns.address_id%TYPE;
2313: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
2314: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
2315: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
2316: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
2317: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2310: l_category jtf_rs_resource_extns.category%TYPE;
2311: l_source_id jtf_rs_resource_extns.source_id%TYPE;
2312: l_address_id jtf_rs_resource_extns.address_id%TYPE;
2313: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
2314: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
2315: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
2316: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
2317: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2318: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2312: l_address_id jtf_rs_resource_extns.address_id%TYPE;
2313: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
2314: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
2315: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
2316: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
2317: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2318: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2319: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2320: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2313: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
2314: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
2315: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
2316: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
2317: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2318: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2319: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2320: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2321: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2314: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
2315: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
2316: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
2317: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2318: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2319: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2320: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2321: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2322: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2315: l_managing_emp_num per_employees_current_x.employee_num%TYPE;
2316: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
2317: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2318: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2319: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2320: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2321: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2322: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2323: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2316: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
2317: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2318: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2319: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2320: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2321: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2322: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2323: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2324: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2317: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2318: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2319: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2320: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2321: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2322: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2323: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2324: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2325: l_interaction_center_name VARCHAR2(256);
2318: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2319: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2320: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2321: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2322: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2323: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2324: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2325: l_interaction_center_name VARCHAR2(256);
2326: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2319: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2320: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2321: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2322: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2323: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2324: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2325: l_interaction_center_name VARCHAR2(256);
2326: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2327: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
2320: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2321: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2322: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2323: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2324: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2325: l_interaction_center_name VARCHAR2(256);
2326: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2327: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
2328: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
2322: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2323: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2324: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2325: l_interaction_center_name VARCHAR2(256);
2326: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2327: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
2328: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
2329: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
2330: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
2323: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2324: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2325: l_interaction_center_name VARCHAR2(256);
2326: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2327: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
2328: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
2329: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
2330: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
2331: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
2324: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2325: l_interaction_center_name VARCHAR2(256);
2326: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2327: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
2328: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
2329: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
2330: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
2331: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
2332: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
2325: l_interaction_center_name VARCHAR2(256);
2326: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2327: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
2328: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
2329: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
2330: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
2331: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
2332: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
2333: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
2326: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2327: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
2328: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
2329: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
2330: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
2331: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
2332: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
2333: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
2334: l_user_id jtf_rs_resource_extns.user_id%TYPE;
2327: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
2328: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
2329: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
2330: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
2331: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
2332: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
2333: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
2334: l_user_id jtf_rs_resource_extns.user_id%TYPE;
2335: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
2328: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
2329: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
2330: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
2331: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
2332: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
2333: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
2334: l_user_id jtf_rs_resource_extns.user_id%TYPE;
2335: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
2336: --l_location MDSYS.SDO_GEOMETRY := p_location;
2329: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;
2330: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
2331: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
2332: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
2333: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
2334: l_user_id jtf_rs_resource_extns.user_id%TYPE;
2335: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
2336: --l_location MDSYS.SDO_GEOMETRY := p_location;
2337:
2330: l_commissionable_flag jtf_rs_resource_extns.commissionable_flag%TYPE;
2331: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
2332: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
2333: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
2334: l_user_id jtf_rs_resource_extns.user_id%TYPE;
2335: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
2336: --l_location MDSYS.SDO_GEOMETRY := p_location;
2337:
2338: --added for NOCOPY
2331: l_hold_reason_code jtf_rs_resource_extns.hold_reason_code%TYPE;
2332: l_hold_payment jtf_rs_resource_extns.hold_payment%TYPE;
2333: l_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%TYPE;
2334: l_user_id jtf_rs_resource_extns.user_id%TYPE;
2335: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
2336: --l_location MDSYS.SDO_GEOMETRY := p_location;
2337:
2338: --added for NOCOPY
2339: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
2335: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
2336: --l_location MDSYS.SDO_GEOMETRY := p_location;
2337:
2338: --added for NOCOPY
2339: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
2340: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
2341: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
2342:
2343:
2336: --l_location MDSYS.SDO_GEOMETRY := p_location;
2337:
2338: --added for NOCOPY
2339: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
2340: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
2341: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
2342:
2343:
2344: l_user_name jtf_rs_resource_extns.user_name%type;
2337:
2338: --added for NOCOPY
2339: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
2340: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
2341: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
2342:
2343:
2344: l_user_name jtf_rs_resource_extns.user_name%type;
2345: l_check_flag VARCHAR2(1);
2340: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
2341: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
2342:
2343:
2344: l_user_name jtf_rs_resource_extns.user_name%type;
2345: l_check_flag VARCHAR2(1);
2346: l_found BOOLEAN;
2347:
2348:
2544: l_assigned_to_group_id IN NUMBER)
2545: IS
2546: SELECT u.user_id
2547: FROM fnd_user u,
2548: jtf_rs_resource_extns r
2549: WHERE u.user_id = r.user_id
2550: AND u.user_id = l_assigned_to_group_id;
2551:
2552: CURSOR c_validate_user_id(
2552: CURSOR c_validate_user_id(
2553: l_user_id IN NUMBER)
2554: IS
2555: SELECT 'Y'
2556: FROM jtf_rs_resource_extns
2557: WHERE user_id = l_user_id;
2558:
2559: -- Enh 3947611 2-dec-2004 added cursor to check emp existence
2560: CURSOR c_emp_exist(p_person_id IN NUMBER)