APPS.PA_PROJECT_SEARCH_UTILS dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 273: ,p_param_value_tbl IN SYSTEM.pa_varchar2_240_tbl_type

269: -- Search.
270: ------------------------------------------------------------
271: PROCEDURE Convert_NameToId
272: ( p_param_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
273: ,p_param_value_tbl IN SYSTEM.pa_varchar2_240_tbl_type
274: ,p_param_value2_tbl IN SYSTEM.pa_varchar2_240_tbl_type
275: ,p_init_msg_list IN VARCHAR2
276: ,x_param_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
277: ,x_return_status OUT NOCOPY VARCHAR2

Line 274: ,p_param_value2_tbl IN SYSTEM.pa_varchar2_240_tbl_type

270: ------------------------------------------------------------
271: PROCEDURE Convert_NameToId
272: ( p_param_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
273: ,p_param_value_tbl IN SYSTEM.pa_varchar2_240_tbl_type
274: ,p_param_value2_tbl IN SYSTEM.pa_varchar2_240_tbl_type
275: ,p_init_msg_list IN VARCHAR2
276: ,x_param_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
277: ,x_return_status OUT NOCOPY VARCHAR2
278: ,x_msg_count OUT NOCOPY NUMBER

Line 287: l_param_value_tbl SYSTEM.pa_varchar2_240_tbl_type := p_param_value_tbl;

283: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
284: l_msg_count NUMBER;
285: l_msg_data VARCHAR2(200);
286: l_param_type_tbl SYSTEM.pa_varchar2_30_tbl_type := p_param_type_tbl;
287: l_param_value_tbl SYSTEM.pa_varchar2_240_tbl_type := p_param_value_tbl;
288: l_param_value2_tbl SYSTEM.pa_varchar2_240_tbl_type := p_param_value2_tbl;
289: l_id NUMBER := null;
290: l_type_id NUMBER := null;
291:

Line 288: l_param_value2_tbl SYSTEM.pa_varchar2_240_tbl_type := p_param_value2_tbl;

284: l_msg_count NUMBER;
285: l_msg_data VARCHAR2(200);
286: l_param_type_tbl SYSTEM.pa_varchar2_30_tbl_type := p_param_type_tbl;
287: l_param_value_tbl SYSTEM.pa_varchar2_240_tbl_type := p_param_value_tbl;
288: l_param_value2_tbl SYSTEM.pa_varchar2_240_tbl_type := p_param_value2_tbl;
289: l_id NUMBER := null;
290: l_type_id NUMBER := null;
291:
292: BEGIN

Line 406: -- x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE,

402: p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL, -- added for bug4361663
403: p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL, -- added for bug4361663
404: x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
405: x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
406: -- x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE,
407: x_sec_ret_code OUT NOCOPY VARCHAR2,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2