APPS.PA_RBS_MAPPING dependencies on PA_NUM_TBL_TYPE

Line 48: ) RETURN SYSTEM.pa_num_tbl_type

44: FUNCTION get_sorted_rules
45: (
46: p_struct_version_id NUMBER,
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:

Line 50: l_sorted_rules SYSTEM.pa_num_tbl_type;

46: p_struct_version_id NUMBER,
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

Line 1653: l_res_class_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1649: x_msg_count OUT NOCOPY NUMBER,
1650: x_msg_data OUT NOCOPY VARCHAR2
1651: )
1652: IS
1653: l_res_class_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1654: l_sorted_rule_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1655: --bug#3995697 l_rule_type VARCHAR2(1);
1656: --bug#3995697 l_max_level number;
1657: l_sql_stmt VARCHAR2(500);

Line 1654: l_sorted_rule_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1650: x_msg_data OUT NOCOPY VARCHAR2
1651: )
1652: IS
1653: l_res_class_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1654: l_sorted_rule_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1655: --bug#3995697 l_rule_type VARCHAR2(1);
1656: --bug#3995697 l_max_level number;
1657: l_sql_stmt VARCHAR2(500);
1658: l_leaf_type VARCHAR2(30);

Line 1815: l_rbs_struct_version_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1811: x_msg_data OUT NOCOPY VARCHAR2
1812: )
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: