APPS.PA_RESOURCE_MAPPING dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 279: ) RETURN SYSTEM.pa_varchar2_30_tbl_type IS

275: -------------------------------------
276: FUNCTION get_format_res_tokens (
277: p_resource_class_id IN NUMBER,
278: p_eff_res_format_id IN NUMBER
279: ) RETURN SYSTEM.pa_varchar2_30_tbl_type IS
280:
281: l_plan_res_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
282: l_format pa_plan_res_format;
283: l_token_string VARCHAR2(30);

Line 284: l_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

280:
281: l_plan_res_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
282: l_format pa_plan_res_format;
283: l_token_string VARCHAR2(30);
284: l_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
285:
286: BEGIN
287:
288: --Get all resource tokens for a given effective format

Line 326: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();

322: p_operation_type VARCHAR2
323: ) RETURN VARCHAR2 IS
324:
325: l_insert_clause VARCHAR2(4000);
326: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();
327:
328: BEGIN
329:
330: --Generate the INSERT clause for the

Line 403: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();

399: p_operation_type VARCHAR2
400: ) RETURN VARCHAR2 IS
401:
402: l_select_clause VARCHAR2(5000);
403: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();
404:
405: BEGIN
406:
407: --Generate the SELECT clause for the

Line 486: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();

482: p_src_table VARCHAR2
483: ) RETURN VARCHAR2 IS
484:
485: l_from_clause VARCHAR2(1000);
486: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();
487:
488: BEGIN
489:
490: --Generate the FROM clause for the

Line 537: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();

533: p_operation_type VARCHAR2
534: ) RETURN VARCHAR2 IS
535:
536: l_where_clause VARCHAR2(2000);
537: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();
538:
539: l_pos NUMBER; --bug#3799207
540:
541: BEGIN