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 375: RETURN PA_PLSQL_DATATYPES.Char30TabTyp

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

Line 380: l_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 423: ) RETURN PA_PLSQL_DATATYPES.Char60TabTyp

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

Line 426: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;

422: p_level NUMBER
423: ) RETURN PA_PLSQL_DATATYPES.Char60TabTyp
424: IS
425: l_token VARCHAR2(30);
426: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;
427: j NUMBER;
428:
429: l_prev_token VARCHAR2(30);
430:

Line 483: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;

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

Line 485: l_res_type_cols2 PA_PLSQL_DATATYPES.Char240TabTyp;

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

Line 563: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;

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

Line 627: l_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 755: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;

751: )
752: RETURN VARCHAR2
753: IS
754:
755: l_res_type_cols PA_PLSQL_DATATYPES.Char60TabTyp;
756: l_sql_clause VARCHAR2 (500);
757: l_value NUMBER;
758: l_sql_stmt VARCHAR2 (500);
759: l_rbs_element_id NUMBER;

Line 1475: l_res_type_cols PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 1535: l_txn_header_id PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 1827: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;

1823: IS
1824: l_status NUMBER := 0;
1825: l_rbs_struct_version_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1826:
1827: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;
1828: l_res_id NUMBER;
1829:
1830: l_return_status VARCHAR2(15);
1831: l_msg_count NUMBER ;

Line 2286: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;

2282: IS
2283: l_status NUMBER := 0;
2284: l_rbs_struct_version_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2285:
2286: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;
2287: l_res_id NUMBER;
2288:
2289: l_return_status VARCHAR2(15);
2290: l_msg_count NUMBER ;

Line 2583: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;

2579: x_msg_count OUT NOCOPY NUMBER,
2580: x_msg_data OUT NOCOPY VARCHAR2
2581: )
2582: IS
2583: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;
2584: l_person_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
2585:
2586: l_rbs_struct_version_id PA_PLSQL_DATATYPES.NumTabTyp;
2587:

Line 2584: l_person_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

2580: x_msg_data OUT NOCOPY VARCHAR2
2581: )
2582: IS
2583: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;
2584: l_person_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
2585:
2586: l_rbs_struct_version_id PA_PLSQL_DATATYPES.NumTabTyp;
2587:
2588: l_res_id NUMBER;

Line 2586: l_rbs_struct_version_id PA_PLSQL_DATATYPES.NumTabTyp;

2582: IS
2583: l_revenue_category PA_PLSQL_DATATYPES.Char30TabTyp;
2584: l_person_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
2585:
2586: l_rbs_struct_version_id PA_PLSQL_DATATYPES.NumTabTyp;
2587:
2588: l_res_id NUMBER;
2589: l_return_status VARCHAR2(30);
2590: l_msg_data VARCHAR2(500);

Line 3337: level PA_PLSQL_DATATYPES.Char30TabTyp,

3333: PROCEDURE insert_rule
3334: (
3335: rbs_version_id number,
3336: depth number,
3337: level PA_PLSQL_DATATYPES.Char30TabTyp,
3338: element_id number,
3339: rule_flag varchar2,
3340: per_rc_pre number,
3341: equip_rc_pre number,

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

3612: PROCEDURE traverse_tree
3613: (rbs_version_id number,
3614: element_id number,
3615: depth number,
3616: level IN OUT NOCOPY /* file.sql.39 change */ PA_PLSQL_DATATYPES.Char30TabTyp,
3617: per_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number,
3618: equip_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number,
3619: mat_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number,
3620: fin_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number

Line 3624: l_res_type_id PA_PLSQL_DATATYPES.IdTabTyp;

3620: fin_rc_pre IN OUT NOCOPY /* file.sql.39 change */ number
3621: )
3622: IS
3623: l_count number;
3624: l_res_type_id PA_PLSQL_DATATYPES.IdTabTyp;
3625: elem_version_id PA_PLSQL_DATATYPES.IdTabTyp;
3626: l_tmp varchar2(30);
3627: rule_flag PA_PLSQL_DATATYPES.Char1TabTyp;
3628:

Line 3625: elem_version_id PA_PLSQL_DATATYPES.IdTabTyp;

3621: )
3622: IS
3623: l_count number;
3624: l_res_type_id PA_PLSQL_DATATYPES.IdTabTyp;
3625: elem_version_id PA_PLSQL_DATATYPES.IdTabTyp;
3626: l_tmp varchar2(30);
3627: rule_flag PA_PLSQL_DATATYPES.Char1TabTyp;
3628:
3629: per_rc_pre_last number; --bug#3793418

Line 3627: rule_flag PA_PLSQL_DATATYPES.Char1TabTyp;

3623: l_count number;
3624: l_res_type_id PA_PLSQL_DATATYPES.IdTabTyp;
3625: elem_version_id PA_PLSQL_DATATYPES.IdTabTyp;
3626: l_tmp varchar2(30);
3627: rule_flag PA_PLSQL_DATATYPES.Char1TabTyp;
3628:
3629: per_rc_pre_last number; --bug#3793418
3630: equip_rc_pre_last number; --bug#3793418
3631: mat_rc_pre_last number; --bug#3793418

Line 3706: l_level PA_PLSQL_DATATYPES.Char30TabTyp;

3702: x_msg_count OUT NOCOPY NUMBER,
3703: x_msg_data OUT NOCOPY VARCHAR2
3704: )
3705: IS
3706: l_level PA_PLSQL_DATATYPES.Char30TabTyp;
3707: per_rc_pre number;
3708: equip_rc_pre number;
3709: mat_rc_pre number;
3710: fin_rc_pre number;