APPS.PA_RESOURCE_MAPPING dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 299: ) RETURN SYSTEM.pa_varchar2_30_tbl_type IS

295: -------------------------------------
296: FUNCTION get_format_res_tokens (
297: p_resource_class_id IN NUMBER,
298: p_eff_res_format_id IN NUMBER
299: ) RETURN SYSTEM.pa_varchar2_30_tbl_type IS
300:
301: l_plan_res_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
302: l_format pa_plan_res_format;
303: l_token_string VARCHAR2(30);

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

300:
301: l_plan_res_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
302: l_format pa_plan_res_format;
303: l_token_string VARCHAR2(30);
304: l_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
305:
306: BEGIN
307:
308: --Get all resource tokens for a given effective format

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

354: p_operation_type VARCHAR2
355: ) RETURN VARCHAR2 IS
356:
357: l_insert_clause VARCHAR2(4000);
358: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();
359:
360: BEGIN
361:
362: --Generate the INSERT clause for the

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

431: p_operation_type VARCHAR2
432: ) RETURN VARCHAR2 IS
433:
434: l_select_clause VARCHAR2(5000);
435: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();
436:
437: BEGIN
438:
439: --Generate the SELECT clause for the

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

526: p_src_table VARCHAR2
527: ) RETURN VARCHAR2 IS
528:
529: l_from_clause VARCHAR2(1000);
530: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();
531:
532: BEGIN
533:
534: --Generate the FROM clause for the

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

597: p_operation_type VARCHAR2
598: ) RETURN VARCHAR2 IS
599:
600: l_where_clause VARCHAR2(2000);
601: l_res_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type ();
602:
603: l_pos NUMBER; --bug#3799207
604:
605: BEGIN