eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RBS_MAPPING dependencies on PA_PLSQL_DATATYPES

Line 15: g_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp ;

11:
12: -- added for bug#3995697
13: g_rule_id NUMBER := NULL;
14: g_max_level NUMBER := NULL;
15: g_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp ;
16: g_res_type_cols_flag VARCHAR2 (1) := NULL;
17: g_rbs_element_id NUMBER := NULL;
18: g_rule_type VARCHAR2 (1) := NULL;
19:

Line 51: l_precedence PA_PLSQL_DATATYPES.Char30TabTyp;

47: p_res_class_id NUMBER --1,2,3,4
48: ) RETURN SYSTEM.pa_num_tbl_type
49: IS
50: l_sorted_rules SYSTEM.pa_num_tbl_type;
51: l_precedence PA_PLSQL_DATATYPES.Char30TabTyp;
52:
53: BEGIN
54: IF g_debug_mode = 'Y' THEN
55: PA_DEBUG.set_curr_function( p_function => 'get_sorted_rules'

Line 372: RETURN PA_PLSQL_DATATYPES.Char30TabTyp

368: FUNCTION get_res_type_cols
369: (
370: p_rule_id NUMBER
371: )
372: RETURN PA_PLSQL_DATATYPES.Char30TabTyp
373: IS
374:
375: --bug#3995697 l_max_level NUMBER;
376: l_token VARCHAR2(30);

Line 377: l_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp;

373: IS
374:
375: --bug#3995697 l_max_level NUMBER;
376: l_token VARCHAR2(30);
377: l_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp;
378: j NUMBER;
379:
380: BEGIN
381: IF g_debug_mode = 'Y' THEN

Line 420: ) RETURN PA_PLSQL_DATATYPES.Char60TabTyp

416: FUNCTION get_res_type_cols_inst
417: (
418: p_rule_id NUMBER,
419: p_level NUMBER
420: ) RETURN PA_PLSQL_DATATYPES.Char60TabTyp
421: IS
422: l_token VARCHAR2(30);
423: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;
424: j NUMBER;

Line 423: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;

419: p_level NUMBER
420: ) RETURN PA_PLSQL_DATATYPES.Char60TabTyp
421: IS
422: l_token VARCHAR2(30);
423: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;
424: j NUMBER;
425:
426: l_prev_token VARCHAR2(30);
427:

Line 480: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;

476: p_operation_type VARCHAR2
477: ) RETURN VARCHAR2
478: IS
479: l_token VARCHAR2(30);
480: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;
481:
482: l_res_type_cols2 PA_PLSQL_DATATYPES.Char240TabTyp;
483: j NUMBER;
484:

Line 482: l_res_type_cols2 PA_PLSQL_DATATYPES.Char240TabTyp;

478: IS
479: l_token VARCHAR2(30);
480: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;
481:
482: l_res_type_cols2 PA_PLSQL_DATATYPES.Char240TabTyp;
483: j NUMBER;
484:
485: l_prev_token VARCHAR2(30);
486: l_sql_clause VARCHAR2 (1000);

Line 560: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;

556: p_operation_type VARCHAR2
557: ) RETURN VARCHAR2
558: IS
559: l_token VARCHAR2(30);
560: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;
561: j NUMBER;
562:
563: l_sql_clause VARCHAR2 (1000);
564:

Line 624: l_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp;

620: p_level NUMBER,
621: p_operation_type VARCHAR2
622: ) RETURN VARCHAR2
623: IS
624: l_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp;
625: l_sql_clause VARCHAR2 (500);
626:
627: l_curr_res_col VARCHAR2 (240);
628: l_prev_res_col VARCHAR2 (240);

Line 752: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;

748: )
749: RETURN VARCHAR2
750: IS
751:
752: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;
753: l_sql_clause VARCHAR2 (500);
754: l_value NUMBER;
755: l_sql_stmt VARCHAR2 (500);
756: l_rbs_element_id NUMBER;

Line 1472: l_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp;

1468: IS
1469:
1470: --bug#3995697 l_max_level NUMBER;
1471: l_token VARCHAR2(30);
1472: l_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp;
1473: j NUMBER;
1474:
1475: --bug#3995697 l_rbs_element_id NUMBER;
1476: l_sql_cols VARCHAR2(200);

Line 1532: l_txn_header_id PA_PLSQL_DATATYPES.Char30TabTyp;

1528: l_SQL_statement VARCHAR2 (2000);
1529: l_count NUMBER;
1530: l_sequence NUMBER;
1531:
1532: l_txn_header_id PA_PLSQL_DATATYPES.Char30TabTyp;
1533:
1534: x_rbs_element_name_id NUMBER;
1535: x_return_status VARCHAR2(30);
1536: BEGIN

Line 1817: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;

1813: IS
1814: l_status NUMBER := 0;
1815: l_rbs_struct_version_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1816:
1817: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;
1818: l_res_id NUMBER;
1819:
1820: l_return_status VARCHAR2(15);
1821: l_msg_count NUMBER ;

Line 2248: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;

2244: x_msg_count OUT NOCOPY NUMBER,
2245: x_msg_data OUT NOCOPY VARCHAR2
2246: )
2247: IS
2248: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;
2249: l_person_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
2250:
2251: l_rbs_struct_version_id PA_PLSQL_DATATYPES.NumTabTyp;
2252:

Line 2249: l_person_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

2245: x_msg_data OUT NOCOPY VARCHAR2
2246: )
2247: IS
2248: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;
2249: l_person_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
2250:
2251: l_rbs_struct_version_id PA_PLSQL_DATATYPES.NumTabTyp;
2252:
2253: l_res_id NUMBER;

Line 2251: l_rbs_struct_version_id PA_PLSQL_DATATYPES.NumTabTyp;

2247: IS
2248: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;
2249: l_person_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
2250:
2251: l_rbs_struct_version_id PA_PLSQL_DATATYPES.NumTabTyp;
2252:
2253: l_res_id NUMBER;
2254: l_return_status VARCHAR2(30);
2255: l_msg_data VARCHAR2(500);

Line 3002: level PA_PLSQL_DATATYPES.Char30TabTyp,

2998: PROCEDURE insert_rule
2999: (
3000: rbs_version_id number,
3001: depth number,
3002: level PA_PLSQL_DATATYPES.Char30TabTyp,
3003: element_id number,
3004: rule_flag varchar2,
3005: per_rc_pre number,
3006: equip_rc_pre number,

Line 3281: level IN OUT NOCOPY /* file.sql.39 change */ PA_PLSQL_DATATYPES.Char30TabTyp,

3277: PROCEDURE traverse_tree
3278: (rbs_version_id number,
3279: element_id number,
3280: depth number,
3281: level IN OUT NOCOPY /* file.sql.39 change */ PA_PLSQL_DATATYPES.Char30TabTyp,
3282: per_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number,
3283: equip_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number,
3284: mat_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number,
3285: fin_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number

Line 3289: l_res_type_id PA_PLSQL_DATATYPES.IdTabTyp;

3285: fin_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number
3286: )
3287: IS
3288: l_count number;
3289: l_res_type_id PA_PLSQL_DATATYPES.IdTabTyp;
3290: elem_version_id PA_PLSQL_DATATYPES.IdTabTyp;
3291: l_tmp varchar2(30);
3292: rule_flag PA_PLSQL_DATATYPES.Char1TabTyp;
3293:

Line 3290: elem_version_id PA_PLSQL_DATATYPES.IdTabTyp;

3286: )
3287: IS
3288: l_count number;
3289: l_res_type_id PA_PLSQL_DATATYPES.IdTabTyp;
3290: elem_version_id PA_PLSQL_DATATYPES.IdTabTyp;
3291: l_tmp varchar2(30);
3292: rule_flag PA_PLSQL_DATATYPES.Char1TabTyp;
3293:
3294: per_rc_pre_last number; --bug#3793418

Line 3292: rule_flag PA_PLSQL_DATATYPES.Char1TabTyp;

3288: l_count number;
3289: l_res_type_id PA_PLSQL_DATATYPES.IdTabTyp;
3290: elem_version_id PA_PLSQL_DATATYPES.IdTabTyp;
3291: l_tmp varchar2(30);
3292: rule_flag PA_PLSQL_DATATYPES.Char1TabTyp;
3293:
3294: per_rc_pre_last number; --bug#3793418
3295: equip_rc_pre_last number; --bug#3793418
3296: mat_rc_pre_last number; --bug#3793418

Line 3369: l_level PA_PLSQL_DATATYPES.Char30TabTyp;

3365: x_msg_count OUT NOCOPY NUMBER,
3366: x_msg_data OUT NOCOPY VARCHAR2
3367: )
3368: IS
3369: l_level PA_PLSQL_DATATYPES.Char30TabTyp;
3370: per_rc_pre number;
3371: equip_rc_pre number;
3372: mat_rc_pre number;
3373: fin_rc_pre number;