APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on WF_PARAMETER_LIST_T

Line 162: AddParameterToList - adds name and value to wf_parameter_list_t

158: RETURN NULL;
159: END get_wf_role;
160:
161: /*
162: AddParameterToList - adds name and value to wf_parameter_list_t
163: If the list is null, will initialize, otherwise just adds to the end of list
164: */
165: PROCEDURE AddParameterToList(p_name in varchar2,
166: p_value in varchar2,

Line 167: p_parameterlist in out nocopy wf_parameter_list_t)

163: If the list is null, will initialize, otherwise just adds to the end of list
164: */
165: PROCEDURE AddParameterToList(p_name in varchar2,
166: p_value in varchar2,
167: p_parameterlist in out nocopy wf_parameter_list_t)
168: IS
169: j number;
170: BEGIN
171: if (p_ParameterList is null) then

Line 175: p_ParameterList := wf_parameter_list_t(null);

171: if (p_ParameterList is null) then
172: --
173: -- Initialize Parameter List and set value
174: --
175: p_ParameterList := wf_parameter_list_t(null);
176: p_ParameterList(1) := wf_parameter_t(p_Name, p_Value);
177: else
178: --
179: -- parameter list exists, add parameter to list

Line 242: l_list WF_PARAMETER_LIST_T;

238:
239: l_res_usr_orig_system wf_local_roles.orig_system%TYPE := 'JRES_IND';
240: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
241:
242: l_list WF_PARAMETER_LIST_T;
243:
244: /* Cursor to get the party id of the employee */
245: cursor emp_party_id_cur IS
246: select ppf.party_id

Line 405: l_list WF_PARAMETER_LIST_T;

401: ll_expiration_date DATE,
402: ll_source_id NUMBER,
403: ll_category VARCHAR2) IS
404:
405: l_list WF_PARAMETER_LIST_T;
406:
407: /* Cursor to get the party id of the employee */
408: cursor emp_party_id_cur IS
409: select party_id

Line 469: l_list WF_PARAMETER_LIST_T;

465: ll_start_date_active DATE,
466: ll_expiration_date DATE,
467: ll_source_id NUMBER,
468: ll_category VARCHAR2) IS
469: l_list WF_PARAMETER_LIST_T;
470:
471: /* Cursor to get the party id of the employee */
472: cursor emp_party_id_cur IS
473: select party_id

Line 1069: l_list WF_PARAMETER_LIST_T;

1065: AND user_orig_system = l_res_usr_orig_system
1066: AND user_orig_system_id = p_resource_id
1067: AND role_name <> l_res_usr_role_name;
1068:
1069: l_list WF_PARAMETER_LIST_T;
1070:
1071: BEGIN
1072:
1073: x_return_status := fnd_api.g_ret_sts_success;

Line 1140: l_list WF_PARAMETER_LIST_T;

1136: l_start_date_active date := trunc(P_START_DATE_ACTIVE);
1137: l_end_date_active date := trunc(P_END_DATE_ACTIVE);
1138: l_sysdate date := trunc(sysdate);
1139:
1140: l_list WF_PARAMETER_LIST_T;
1141:
1142: BEGIN
1143: SAVEPOINT wf_int_create_resource_group;
1144: x_return_status := fnd_api.g_ret_sts_success;

Line 1269: l_list WF_PARAMETER_LIST_T;

1265:
1266: l_mem_role_start_date date;
1267: l_mem_role_end_date date;
1268:
1269: l_list WF_PARAMETER_LIST_T;
1270:
1271: BEGIN
1272: SAVEPOINT wf_int_update_resource_group;
1273: x_return_status := fnd_api.g_ret_sts_success;

Line 1673: l_list WF_PARAMETER_LIST_T;

1669: l_start_date_active date := trunc(P_START_DATE_ACTIVE);
1670: l_end_date_active date := trunc(P_END_DATE_ACTIVE);
1671: l_sysdate date := trunc(sysdate);
1672:
1673: l_list WF_PARAMETER_LIST_T;
1674:
1675: BEGIN
1676: SAVEPOINT wf_int_create_resource_team;
1677: x_return_status := fnd_api.g_ret_sts_success;

Line 1799: l_list WF_PARAMETER_LIST_T;

1795:
1796: l_team_mem_start_date date;
1797: l_team_mem_end_date date;
1798:
1799: l_list WF_PARAMETER_LIST_T;
1800:
1801: BEGIN
1802: SAVEPOINT wf_int_update_resource_team;
1803: x_return_status := fnd_api.g_ret_sts_success;