DBA Data[Home] [Help]

APPS.PA_PROJECT_SEARCH_UTILS dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 272: ( p_param_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type

268: -- the corresponding Ids. Used by Project Lists
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

Line 286: l_param_type_tbl SYSTEM.pa_varchar2_30_tbl_type := p_param_type_tbl;

282:
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;

Line 401: p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL, -- added for bug4361663

397: (
398: p_source_api IN VARCHAR2,
399: p_project_id IN NUMBER,
400: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
401: p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL, -- added for bug4361663
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,

Line 402: p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL, -- added for bug4361663

398: p_source_api IN VARCHAR2,
399: p_project_id IN NUMBER,
400: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
401: p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL, -- added for bug4361663
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,