89: PROCEDURE create_resource
90: (P_API_VERSION IN NUMBER,
91: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
94: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
95: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
96: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
97: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
90: (P_API_VERSION IN NUMBER,
91: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
94: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
95: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
96: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
97: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
98: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
91: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
94: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
95: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
96: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
97: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
98: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
99: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
92: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
94: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
95: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
96: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
97: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
98: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
99: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
100: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
93: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
94: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
95: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
96: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
97: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
98: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
99: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
100: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
101: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
95: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
96: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
97: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
98: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
99: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
100: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
101: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
102: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
103: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
96: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
97: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
98: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
99: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
100: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
101: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
102: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
103: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
104: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
97: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
98: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
99: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
100: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
101: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
102: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
103: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
104: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
105: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
98: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
99: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
100: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
101: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
102: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
103: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
104: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
105: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
106: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
99: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
100: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
101: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
102: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
103: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
104: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
105: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
106: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
107: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
100: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
101: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
102: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
103: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
104: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
105: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
106: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
107: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
108: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
101: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
102: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
103: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
104: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
105: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
106: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
107: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
108: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
109: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
102: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
103: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
104: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
105: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
106: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
107: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
108: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
109: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
110: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
103: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
104: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
105: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
106: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
107: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
108: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
109: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
110: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
111: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
105: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
106: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
107: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
108: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
109: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
110: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
111: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
112: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
113: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
106: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
107: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
108: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
109: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
110: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
111: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
112: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
113: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
114: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
107: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
108: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
109: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
110: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
111: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
112: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
113: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
114: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
115: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
108: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
109: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
110: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
111: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
112: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
113: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
114: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
115: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
116: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
109: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
110: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
111: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
112: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
113: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
114: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
115: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
116: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
117: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
110: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
111: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
112: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
113: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
114: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
115: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
116: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
117: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
118: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
111: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
112: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
113: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
114: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
115: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
116: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
117: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
118: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
119: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
112: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
113: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
114: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
115: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
116: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
117: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
118: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
119: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
120: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
113: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
114: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
115: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
116: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
117: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
118: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
119: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
120: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121: X_MSG_COUNT OUT NOCOPY NUMBER,
114: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
115: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
116: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
117: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
118: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
119: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
120: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121: X_MSG_COUNT OUT NOCOPY NUMBER,
122: X_MSG_DATA OUT NOCOPY VARCHAR2,
119: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
120: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121: X_MSG_COUNT OUT NOCOPY NUMBER,
122: X_MSG_DATA OUT NOCOPY VARCHAR2,
123: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
124: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
125: );
126:
127: --Create Resource Migration API, used for one-time migration of resource data
120: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121: X_MSG_COUNT OUT NOCOPY NUMBER,
122: X_MSG_DATA OUT NOCOPY VARCHAR2,
123: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
124: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
125: );
126:
127: --Create Resource Migration API, used for one-time migration of resource data
128: --The API includes RESOURCE_ID as one of its Input Parameters
189: PROCEDURE create_resource_migrate
190: (P_API_VERSION IN NUMBER,
191: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
192: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
194: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
195: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
196: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
197: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
190: (P_API_VERSION IN NUMBER,
191: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
192: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
194: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
195: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
196: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
197: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
198: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
191: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
192: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
194: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
195: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
196: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
197: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
198: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
199: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
192: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
194: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
195: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
196: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
197: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
198: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
199: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
200: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
193: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
194: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
195: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
196: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
197: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
198: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
199: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
200: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
201: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
195: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
196: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
197: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
198: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
199: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
200: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
201: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
202: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
203: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
196: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
197: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
198: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
199: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
200: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
201: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
202: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
203: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
204: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
197: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
198: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
199: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
200: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
201: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
202: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
203: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
204: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
205: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
198: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
199: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
200: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
201: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
202: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
203: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
204: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
205: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
206: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
199: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
200: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
201: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
202: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
203: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
204: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
205: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
206: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
207: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
200: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
201: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
202: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
203: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
204: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
205: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
206: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
207: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
208: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
201: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
202: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
203: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
204: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
205: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
206: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
207: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
208: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
209: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
202: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
203: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
204: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
205: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
206: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
207: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
208: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
209: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
210: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
203: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
204: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
205: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
206: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
207: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
208: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
209: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
210: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
211: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
205: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
206: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
207: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
208: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
209: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
210: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
211: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
212: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
213: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
206: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
207: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
208: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
209: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
210: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
211: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
212: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
213: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
214: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
207: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
208: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
209: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
210: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
211: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
212: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
213: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
214: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
215: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
208: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
209: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
210: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
211: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
212: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
213: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
214: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
215: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
216: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
209: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
210: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
211: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
212: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
213: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
214: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
215: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
216: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
217: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
210: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
211: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
212: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
213: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
214: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
215: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
216: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
217: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
218: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
211: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
212: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
213: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
214: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
215: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
216: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
217: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
218: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
219: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
212: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
213: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
214: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
215: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
216: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
217: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
218: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
219: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
220: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE DEFAULT NULL,
213: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
214: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
215: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
216: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
217: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
218: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
219: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
220: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE DEFAULT NULL,
221: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
214: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
215: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
216: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
217: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
218: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
219: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
220: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE DEFAULT NULL,
221: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
222: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
216: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
217: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
218: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
219: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
220: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE DEFAULT NULL,
221: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
222: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
223: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
224: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
217: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
218: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
219: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
220: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE DEFAULT NULL,
221: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
222: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
223: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
224: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
225: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
218: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
219: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
220: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE DEFAULT NULL,
221: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
222: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
223: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
224: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
225: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
226: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
219: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
220: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE DEFAULT NULL,
221: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
222: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
223: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
224: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
225: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
226: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
227: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
220: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE DEFAULT NULL,
221: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
222: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
223: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
224: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
225: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
226: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
227: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
228: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
221: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
222: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
223: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
224: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
225: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
226: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
227: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
228: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
229: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
222: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
223: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
224: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
225: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
226: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
227: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
228: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
229: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
230: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
223: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
224: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
225: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
226: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
227: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
228: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
229: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
230: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
231: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
224: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
225: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
226: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
227: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
228: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
229: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
230: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
231: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
232: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
225: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
226: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
227: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
228: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
229: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
230: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
231: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
232: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
233: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
226: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
227: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
228: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
229: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
230: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
231: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
232: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
233: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
234: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
227: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
228: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
229: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
230: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
231: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
232: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
233: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
234: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
235: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
228: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
229: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
230: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
231: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
232: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
233: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
234: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
235: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
236: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
229: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
230: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
231: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
232: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
233: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
234: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
235: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
236: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
237: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
230: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
231: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
232: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
233: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
234: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
235: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
236: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
237: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
238: X_MSG_COUNT OUT NOCOPY NUMBER,
231: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
232: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
233: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
234: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
235: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
236: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
237: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
238: X_MSG_COUNT OUT NOCOPY NUMBER,
239: X_MSG_DATA OUT NOCOPY VARCHAR2,
232: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
233: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
234: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
235: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
236: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
237: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
238: X_MSG_COUNT OUT NOCOPY NUMBER,
239: X_MSG_DATA OUT NOCOPY VARCHAR2,
240: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
236: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
237: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
238: X_MSG_COUNT OUT NOCOPY NUMBER,
239: X_MSG_DATA OUT NOCOPY VARCHAR2,
240: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
241: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
242: );
243:
244: --Creating a Global Variable to be used for setting the flag,
237: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
238: X_MSG_COUNT OUT NOCOPY NUMBER,
239: X_MSG_DATA OUT NOCOPY VARCHAR2,
240: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
241: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE
242: );
243:
244: --Creating a Global Variable to be used for setting the flag,
245: --when the create_resource_migrate gets called
244: --Creating a Global Variable to be used for setting the flag,
245: --when the create_resource_migrate gets called
246:
247: G_RS_ID_PUB_FLAG VARCHAR2(1) := 'Y';
248: G_RESOURCE_ID JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE := NULL;
249: G_ATTRIBUTE1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE := NULL;
250: G_ATTRIBUTE2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE := NULL;
251: G_ATTRIBUTE3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE := NULL;
252: G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
245: --when the create_resource_migrate gets called
246:
247: G_RS_ID_PUB_FLAG VARCHAR2(1) := 'Y';
248: G_RESOURCE_ID JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE := NULL;
249: G_ATTRIBUTE1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE := NULL;
250: G_ATTRIBUTE2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE := NULL;
251: G_ATTRIBUTE3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE := NULL;
252: G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
253: G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
246:
247: G_RS_ID_PUB_FLAG VARCHAR2(1) := 'Y';
248: G_RESOURCE_ID JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE := NULL;
249: G_ATTRIBUTE1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE := NULL;
250: G_ATTRIBUTE2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE := NULL;
251: G_ATTRIBUTE3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE := NULL;
252: G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
253: G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
254: G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
247: G_RS_ID_PUB_FLAG VARCHAR2(1) := 'Y';
248: G_RESOURCE_ID JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE := NULL;
249: G_ATTRIBUTE1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE := NULL;
250: G_ATTRIBUTE2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE := NULL;
251: G_ATTRIBUTE3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE := NULL;
252: G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
253: G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
254: G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
255: G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
248: G_RESOURCE_ID JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE := NULL;
249: G_ATTRIBUTE1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE := NULL;
250: G_ATTRIBUTE2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE := NULL;
251: G_ATTRIBUTE3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE := NULL;
252: G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
253: G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
254: G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
255: G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
256: G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
249: G_ATTRIBUTE1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE := NULL;
250: G_ATTRIBUTE2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE := NULL;
251: G_ATTRIBUTE3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE := NULL;
252: G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
253: G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
254: G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
255: G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
256: G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
257: G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
250: G_ATTRIBUTE2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE := NULL;
251: G_ATTRIBUTE3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE := NULL;
252: G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
253: G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
254: G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
255: G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
256: G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
257: G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
258: G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
251: G_ATTRIBUTE3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE := NULL;
252: G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
253: G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
254: G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
255: G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
256: G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
257: G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
258: G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
259: G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
252: G_ATTRIBUTE4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE := NULL;
253: G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
254: G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
255: G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
256: G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
257: G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
258: G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
259: G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
260: G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
253: G_ATTRIBUTE5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE := NULL;
254: G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
255: G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
256: G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
257: G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
258: G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
259: G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
260: G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
261: G_ATTRIBUTE13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE := NULL;
254: G_ATTRIBUTE6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE := NULL;
255: G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
256: G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
257: G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
258: G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
259: G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
260: G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
261: G_ATTRIBUTE13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE := NULL;
262: G_ATTRIBUTE14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE := NULL;
255: G_ATTRIBUTE7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE := NULL;
256: G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
257: G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
258: G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
259: G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
260: G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
261: G_ATTRIBUTE13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE := NULL;
262: G_ATTRIBUTE14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE := NULL;
263: G_ATTRIBUTE15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE := NULL;
256: G_ATTRIBUTE8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE := NULL;
257: G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
258: G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
259: G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
260: G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
261: G_ATTRIBUTE13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE := NULL;
262: G_ATTRIBUTE14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE := NULL;
263: G_ATTRIBUTE15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE := NULL;
264: G_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE := NULL;
257: G_ATTRIBUTE9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE := NULL;
258: G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
259: G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
260: G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
261: G_ATTRIBUTE13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE := NULL;
262: G_ATTRIBUTE14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE := NULL;
263: G_ATTRIBUTE15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE := NULL;
264: G_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE := NULL;
265:
258: G_ATTRIBUTE10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE := NULL;
259: G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
260: G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
261: G_ATTRIBUTE13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE := NULL;
262: G_ATTRIBUTE14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE := NULL;
263: G_ATTRIBUTE15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE := NULL;
264: G_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE := NULL;
265:
266: /* Procedure to update the resource based on input values passed by calling routines. */
259: G_ATTRIBUTE11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE := NULL;
260: G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
261: G_ATTRIBUTE13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE := NULL;
262: G_ATTRIBUTE14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE := NULL;
263: G_ATTRIBUTE15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE := NULL;
264: G_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE := NULL;
265:
266: /* Procedure to update the resource based on input values passed by calling routines. */
267:
260: G_ATTRIBUTE12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE := NULL;
261: G_ATTRIBUTE13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE := NULL;
262: G_ATTRIBUTE14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE := NULL;
263: G_ATTRIBUTE15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE := NULL;
264: G_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE := NULL;
265:
266: /* Procedure to update the resource based on input values passed by calling routines. */
267:
268: /*#
291: * @param p_hold_reason_code The reason that compensation is being withheld
292: * @param p_hold_payment Whether Withhold compensation or not
293: * @param p_comp_service_team_id The identifier for the team to which this resource belongs
294: * @param p_user_id User Id of the Resource
295: * @param p_object_version_num The object version number of the resource derives from the jtf_rs_resource_extns table.
296: * @param x_return_status Output parameter for return status
297: * @param x_msg_count Output parameter for number of user messages from this procedure
298: * @param x_msg_data Output parameter containing last user message from this procedure
299: * @rep:scope internal
303: PROCEDURE update_resource
304: (P_API_VERSION IN NUMBER,
305: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
306: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
307: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
308: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
309: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
310: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
311: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
304: (P_API_VERSION IN NUMBER,
305: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
306: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
307: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
308: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
309: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
310: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
311: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
312: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
305: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
306: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
307: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
308: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
309: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
310: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
311: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
312: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
313: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
306: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
307: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
308: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
309: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
310: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
311: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
312: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
313: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
314: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
307: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
308: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
309: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
310: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
311: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
312: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
313: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
314: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
308: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
309: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
310: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
311: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
312: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
313: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
314: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
316: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
309: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
310: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
311: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
312: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
313: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
314: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
316: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
317: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
310: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
311: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
312: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
313: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
314: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
316: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
317: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
318: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
311: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
312: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
313: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
314: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
316: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
317: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
318: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
312: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
313: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
314: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
316: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
317: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
318: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
320: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
313: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
314: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
316: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
317: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
318: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
320: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
321: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
314: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
316: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
317: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
318: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
320: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
321: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
322: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
315: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
316: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
317: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
318: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
320: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
321: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
322: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
323: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
316: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
317: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
318: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
320: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
321: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
322: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
323: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
324: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
317: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
318: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
320: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
321: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
322: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
323: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
324: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
325: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
318: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
320: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
321: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
322: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
323: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
324: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
325: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
326: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
319: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
320: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
321: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
322: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
323: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
324: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
325: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
326: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
327: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
320: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
321: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
322: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
323: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
324: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
325: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
326: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
327: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
328: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
321: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
322: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
323: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
324: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
325: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
326: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
327: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
328: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
329: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
322: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
323: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
324: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
325: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
326: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
327: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
328: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
329: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
330: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
323: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
324: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
325: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
326: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
327: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
328: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
329: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
330: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
331: X_MSG_COUNT OUT NOCOPY NUMBER,
325: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
326: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
327: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
328: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
329: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
330: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
331: X_MSG_COUNT OUT NOCOPY NUMBER,
332: X_MSG_DATA OUT NOCOPY VARCHAR2
333: );
354: PROCEDURE delete_resource
355: (P_API_VERSION IN NUMBER,
356: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
358: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
359: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
360: X_MSG_COUNT OUT NOCOPY NUMBER,
361: X_MSG_DATA OUT NOCOPY VARCHAR2
362: );
459: PROCEDURE create_resource
460: (P_API_VERSION IN NUMBER,
461: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
464: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
465: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
466: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
467: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
460: (P_API_VERSION IN NUMBER,
461: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
464: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
465: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
466: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
467: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
468: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
461: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
464: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
465: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
466: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
467: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
468: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
469: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
462: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
464: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
465: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
466: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
467: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
468: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
469: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
470: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
463: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
464: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,
465: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
466: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
467: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
468: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
469: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
470: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
471: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
465: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT NULL,
466: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
467: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
468: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
469: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
470: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
471: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
472: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
473: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
466: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE DEFAULT NULL,
467: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
468: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
469: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
470: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
471: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
472: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
473: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
474: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
467: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT NULL,
468: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
469: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
470: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
471: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
472: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
473: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
474: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
475: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
468: P_MANAGING_EMP_NUM IN PER_EMPLOYEES_CURRENT_X.EMPLOYEE_NUM%TYPE DEFAULT NULL,
469: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
470: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
471: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
472: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
473: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
474: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
475: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
476: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
469: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
470: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
471: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
472: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
473: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
474: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
475: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
476: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
477: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
470: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
471: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
472: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
473: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
474: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
475: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
476: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
477: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
478: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
471: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT NULL,
472: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
473: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
474: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
475: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
476: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
477: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
478: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
479: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
472: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT NULL,
473: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
474: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
475: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
476: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
477: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
478: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
479: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
480: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
473: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT NULL,
474: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT NULL,
475: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
476: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
477: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
478: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
479: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
480: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
481: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
475: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT NULL,
476: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
477: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
478: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
479: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
480: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
481: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
482: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
483: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
476: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT NULL,
477: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
478: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
479: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
480: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
481: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
482: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
483: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
484: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
477: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT NULL,
478: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
479: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
480: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
481: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
482: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
483: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
484: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
485: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
478: P_INTERACTION_CENTER_NAME IN VARCHAR2 DEFAULT NULL,
479: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
480: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
481: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
482: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
483: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
484: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
485: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
486: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
479: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT NULL,
480: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
481: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
482: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
483: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
484: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
485: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
486: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
487: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
480: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT NULL,
481: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
482: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
483: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
484: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
485: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
486: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
487: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
488: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
481: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT NULL,
482: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
483: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
484: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
485: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
486: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
487: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
488: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
489: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
482: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT NULL,
483: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
484: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
485: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
486: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
487: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
488: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
489: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
490: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
483: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT 'Y',
484: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
485: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
486: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
487: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
488: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
489: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
490: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
491: X_MSG_COUNT OUT NOCOPY NUMBER,
484: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT NULL,
485: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
486: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
487: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT NULL,
488: P_TRANSACTION_NUMBER IN JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE DEFAULT NULL,
489: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
490: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
491: X_MSG_COUNT OUT NOCOPY NUMBER,
492: X_MSG_DATA OUT NOCOPY VARCHAR2,
489: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
490: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
491: X_MSG_COUNT OUT NOCOPY NUMBER,
492: X_MSG_DATA OUT NOCOPY VARCHAR2,
493: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
494: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
495: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
496: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
497: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
490: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
491: X_MSG_COUNT OUT NOCOPY NUMBER,
492: X_MSG_DATA OUT NOCOPY VARCHAR2,
493: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
494: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
495: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
496: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
497: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
498: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
491: X_MSG_COUNT OUT NOCOPY NUMBER,
492: X_MSG_DATA OUT NOCOPY VARCHAR2,
493: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
494: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
495: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
496: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
497: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
498: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
499: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
492: X_MSG_DATA OUT NOCOPY VARCHAR2,
493: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
494: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
495: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
496: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
497: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
498: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
499: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
500: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
493: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
494: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
495: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
496: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
497: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
498: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
499: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
500: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
501: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
494: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
495: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
496: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
497: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
498: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
499: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
500: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
501: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
502: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
495: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
496: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
497: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
498: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
499: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
500: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
501: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
502: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
503: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
496: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
497: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
498: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
499: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
500: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
501: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
502: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
503: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
504: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
497: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,
498: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
499: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
500: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
501: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
502: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
503: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
504: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
505: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
498: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT NULL,
499: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
500: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
501: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
502: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
503: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
504: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
505: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
506: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
499: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT NULL,
500: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
501: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
502: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
503: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
504: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
505: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
506: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
507: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
500: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT NULL,
501: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
502: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
503: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
504: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
505: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
506: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
507: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
508: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
501: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE DEFAULT NULL,
502: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
503: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
504: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
505: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
506: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
507: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
508: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
509: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
502: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT NULL,
503: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
504: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
505: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
506: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
507: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
508: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
509: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
510: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
503: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT NULL,
504: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
505: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
506: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
507: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
508: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
509: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
510: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
511: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
504: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT NULL,
505: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
506: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
507: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
508: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
509: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
510: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
511: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
512: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
505: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT NULL,
506: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
507: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
508: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
509: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
510: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
511: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
512: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
513: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
506: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT NULL,
507: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
508: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
509: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
510: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
511: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
512: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
513: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
514: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
507: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT NULL,
508: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
509: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
510: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
511: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
512: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
513: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
514: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
515: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
508: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT NULL,
509: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
510: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
511: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
512: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
513: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
514: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
515: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
516: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
509: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT NULL,
510: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
511: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
512: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
513: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
514: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
515: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
516: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
517: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
510: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT NULL,
511: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
512: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
513: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
514: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
515: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
516: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
517: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
518: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
511: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT NULL,
512: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
513: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
514: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
515: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
516: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
517: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
518: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
519: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
512: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT NULL,
513: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
514: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
515: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
516: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
517: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
518: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
519: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
520: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
513: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT NULL,
514: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
515: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
516: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
517: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
518: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
519: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
520: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
521: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
514: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT NULL,
515: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
516: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
517: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
518: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
519: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
520: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
521: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
522: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
515: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT NULL,
516: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
517: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
518: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
519: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
520: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
521: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
522: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
523: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
516: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT NULL,
517: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
518: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
519: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
520: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
521: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
522: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
523: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
524: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
517: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT NULL,
518: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
519: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
520: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
521: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
522: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
523: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
524: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
525: P_USER_NAME IN VARCHAR2 DEFAULT NULL,
518: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT NULL,
519: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
520: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
521: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
522: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
523: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
524: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
525: P_USER_NAME IN VARCHAR2 DEFAULT NULL,
526: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
519: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT NULL,
520: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
521: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
522: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
523: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
524: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
525: P_USER_NAME IN VARCHAR2 DEFAULT NULL,
526: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
527: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
520: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT NULL,
521: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT NULL,
522: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
523: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
524: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
525: P_USER_NAME IN VARCHAR2 DEFAULT NULL,
526: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
527: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
528: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
522: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT NULL,
523: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
524: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
525: P_USER_NAME IN VARCHAR2 DEFAULT NULL,
526: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
527: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
528: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
529: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
530: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
523: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT NULL,
524: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
525: P_USER_NAME IN VARCHAR2 DEFAULT NULL,
526: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
527: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
528: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
529: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
530: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
531: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
524: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT NULL,
525: P_USER_NAME IN VARCHAR2 DEFAULT NULL,
526: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
527: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
528: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
529: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
530: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
531: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
532: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
525: P_USER_NAME IN VARCHAR2 DEFAULT NULL,
526: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
527: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
528: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
529: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
530: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
531: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
532: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
533: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
526: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT NULL,
527: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
528: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
529: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
530: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
531: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
532: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
533: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
534: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
527: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT NULL,
528: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
529: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
530: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
531: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
532: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
533: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
534: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
535: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
528: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT NULL,
529: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
530: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
531: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
532: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
533: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
534: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
535: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
536: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
529: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT NULL,
530: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
531: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
532: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
533: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
534: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
535: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
536: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
537: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
530: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT NULL,
531: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
532: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
533: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
534: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
535: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
536: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
537: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
538: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
531: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT NULL,
532: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
533: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
534: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
535: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
536: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
537: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
538: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
539: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
532: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT NULL,
533: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
534: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
535: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
536: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
537: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
538: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
539: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
540: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
533: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT NULL,
534: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
535: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
536: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
537: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
538: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
539: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
540: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
541: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
534: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT NULL,
535: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
536: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
537: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
538: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
539: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
540: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
541: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
542: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
535: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT NULL,
536: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
537: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
538: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
539: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
540: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
541: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
542: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
543: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
536: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT NULL,
537: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
538: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
539: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
540: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
541: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
542: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
543: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
544: );
537: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT NULL,
538: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
539: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
540: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
541: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
542: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
543: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
544: );
545:
538: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT NULL,
539: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
540: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
541: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
542: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
543: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
544: );
545:
546:
539: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT NULL,
540: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT NULL,
541: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT NULL,
542: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT NULL,
543: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL
544: );
545:
546:
547: /* Procedure to update the resource with the resource synchronizing parameters. */
605: * @param p_source_office Source Office
606: * @param p_source_location Source Location
607: * @param p_source_mailstop Source Mailstop
608: * @param p_address_id Resource address
609: * @param p_object_version_num The object version number of the resource derives from the jtf_rs_resource_extns table.
610: * @param p_user_name User Name
611: * @param p_source_mobile_phone Source Mobile Phone
612: * @param p_source_pager Source Pager
613: * @param p_attribute1 Descriptive flexfield Segment 1
640: PROCEDURE update_resource
641: (P_API_VERSION IN NUMBER,
642: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
643: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
644: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
645: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
646: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
647: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
648: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
641: (P_API_VERSION IN NUMBER,
642: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
643: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
644: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
645: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
646: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
647: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
648: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
649: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
642: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
643: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
644: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
645: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
646: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
647: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
648: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
649: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
650: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
643: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
644: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
645: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
646: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
647: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
648: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
649: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
650: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
651: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
644: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
645: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
646: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
647: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
648: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
649: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
650: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
651: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
645: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
646: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
647: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
648: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
649: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
650: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
651: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
653: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
646: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
647: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
648: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
649: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
650: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
651: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
653: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
647: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
648: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
649: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
650: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
651: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
653: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
655: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
648: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
649: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
650: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
651: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
653: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
655: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
649: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM,
650: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
651: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
653: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
655: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
650: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE DEFAULT FND_API.G_MISS_NUM,
651: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
653: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
655: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
658: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
651: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
653: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
655: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
658: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
659: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
652: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
653: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
655: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
658: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
659: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
653: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
654: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
655: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
658: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
659: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
661: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
654: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE DEFAULT FND_API.G_MISS_CHAR,
655: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
658: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
659: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
661: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
662: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
655: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
658: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
659: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
661: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
662: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
663: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
656: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
658: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
659: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
661: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
662: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
663: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
664: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
657: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
658: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
659: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
661: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
662: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
663: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
664: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
665: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
658: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE DEFAULT FND_API.G_MISS_CHAR,
659: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
661: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
662: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
663: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
664: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
665: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
666: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
659: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
660: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
661: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
662: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
663: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
664: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
665: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
666: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
667: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
660: P_COMMISSIONABLE_FLAG IN JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
661: P_HOLD_REASON_CODE IN JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
662: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
663: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
664: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
665: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
666: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
667: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
668: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
662: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT FND_API.G_MISS_CHAR,
663: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
664: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
665: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
666: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
667: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
668: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
669: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
670: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
663: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
664: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
665: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
666: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
667: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
668: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
669: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
670: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
671: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
664: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
665: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
666: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
667: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
668: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
669: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
670: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
671: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
672: P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
665: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT G_MISS_LOCATION,
666: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
667: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
668: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
669: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
670: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
671: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
672: P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
673: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
666: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
667: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
668: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
669: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
670: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
671: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
672: P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
673: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
674: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
667: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
668: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
669: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
670: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
671: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
672: P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
673: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
674: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
675: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
669: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE DEFAULT FND_API.G_MISS_CHAR,
670: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
671: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
672: P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
673: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
674: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
675: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
676: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
677: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
670: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE DEFAULT FND_API.G_MISS_CHAR,
671: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
672: P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
673: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
674: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
675: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
676: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
677: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
678: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
671: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
672: P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
673: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
674: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
675: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
676: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
677: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
678: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
679: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
672: P_SOURCE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
673: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
674: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
675: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
676: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
677: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
678: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
679: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
673: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
674: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
675: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
676: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
677: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
678: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
679: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
681: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
674: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE DEFAULT FND_API.G_MISS_CHAR,
675: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
676: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
677: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
678: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
679: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
681: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
682: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
675: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE DEFAULT FND_API.G_MISS_CHAR,
676: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
677: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
678: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
679: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
681: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
682: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
683: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
676: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE DEFAULT FND_API.G_MISS_CHAR,
677: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
678: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
679: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
681: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
682: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
683: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
677: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE DEFAULT FND_API.G_MISS_CHAR,
678: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
679: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
681: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
682: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
683: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
678: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
679: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
681: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
682: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
683: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
679: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
680: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
681: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
682: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
683: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
687: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
680: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE DEFAULT FND_API.G_MISS_CHAR,
681: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
682: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
683: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
687: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
681: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE DEFAULT FND_API.G_MISS_CHAR,
682: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
683: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
687: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
682: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE DEFAULT FND_API.G_MISS_CHAR,
683: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
687: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
690: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
683: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
687: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
690: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
691: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
684: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
685: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
687: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
690: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
691: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
692: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
685: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
686: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
687: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
690: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
691: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
692: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
693: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
686: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
687: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
690: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
691: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
692: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
693: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
694: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
687: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
688: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
690: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
691: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
692: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
693: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
694: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
695: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
688: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
689: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
690: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
691: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
692: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
693: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
694: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
695: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
696: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
689: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
690: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
691: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
692: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
693: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
694: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
695: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
696: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
697: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
690: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
691: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
692: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
693: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
694: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
695: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
696: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
697: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
698: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
691: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
692: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
693: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
694: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
695: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
696: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
697: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
698: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
699: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
692: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
693: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
694: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
695: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
696: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
697: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
698: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
699: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
700: X_MSG_COUNT OUT NOCOPY NUMBER,
693: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE DEFAULT FND_API.G_MISS_CHAR,
694: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE DEFAULT FND_API.G_MISS_CHAR,
695: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE DEFAULT FND_API.G_MISS_CHAR,
696: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
697: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
698: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
699: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
700: X_MSG_COUNT OUT NOCOPY NUMBER,
701: X_MSG_DATA OUT NOCOPY VARCHAR2,
698: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
699: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
700: X_MSG_COUNT OUT NOCOPY NUMBER,
701: X_MSG_DATA OUT NOCOPY VARCHAR2,
702: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
703: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT FND_API.G_MISS_CHAR,
704: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
705: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
706: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
699: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
700: X_MSG_COUNT OUT NOCOPY NUMBER,
701: X_MSG_DATA OUT NOCOPY VARCHAR2,
702: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
703: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT FND_API.G_MISS_CHAR,
704: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
705: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
706: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
707: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
700: X_MSG_COUNT OUT NOCOPY NUMBER,
701: X_MSG_DATA OUT NOCOPY VARCHAR2,
702: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
703: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT FND_API.G_MISS_CHAR,
704: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
705: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
706: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
707: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
708: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
701: X_MSG_DATA OUT NOCOPY VARCHAR2,
702: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
703: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT FND_API.G_MISS_CHAR,
704: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
705: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
706: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
707: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
708: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
709: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
702: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE DEFAULT FND_API.G_MISS_CHAR,
703: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT FND_API.G_MISS_CHAR,
704: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
705: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
706: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
707: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
708: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
709: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
710: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
703: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE DEFAULT FND_API.G_MISS_CHAR,
704: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
705: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
706: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
707: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
708: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
709: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
710: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
711: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
704: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
705: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
706: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
707: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
708: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
709: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
710: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
711: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
712: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
705: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
706: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
707: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
708: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
709: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
710: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
711: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
712: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
713: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
706: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
707: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
708: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
709: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
710: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
711: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
712: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
713: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
714: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
707: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
708: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
709: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
710: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
711: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
712: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
713: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
714: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
715: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
708: P_ATTRIBUTE5 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
709: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
710: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
711: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
712: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
713: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
714: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
715: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
716: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
709: P_ATTRIBUTE6 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
710: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
711: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
712: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
713: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
714: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
715: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
716: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
717: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
710: P_ATTRIBUTE7 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
711: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
712: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
713: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
714: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
715: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
716: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
717: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
718: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
711: P_ATTRIBUTE8 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
712: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
713: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
714: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
715: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
716: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
717: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
718: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
719: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR
712: P_ATTRIBUTE9 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
713: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
714: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
715: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
716: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
717: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
718: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
719: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR
720: );
713: P_ATTRIBUTE10 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
714: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
715: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
716: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
717: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
718: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
719: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR
720: );
721:
714: P_ATTRIBUTE11 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
715: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
716: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
717: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
718: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
719: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR
720: );
721:
722:
715: P_ATTRIBUTE12 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
716: P_ATTRIBUTE13 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
717: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
718: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
719: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR
720: );
721:
722:
723: END jtf_rs_resource_pub;