APPS.ARP_AUTO_ACCOUNTING_BR dependencies on RA_ACCOUNT_DEFAULT_SEGMENTS

Line 57: segment ra_account_default_segments.segment%type,

53: ------------------------------------------------------------------------
54: TYPE autoacc_rec_type IS RECORD
55: (
56: type ra_account_defaults.type%type,
57: segment ra_account_default_segments.segment%type,
58: table_name ra_account_default_segments.table_name%type,
59: constant ra_account_default_segments.constant%type
60: );
61:

Line 58: table_name ra_account_default_segments.table_name%type,

54: TYPE autoacc_rec_type IS RECORD
55: (
56: type ra_account_defaults.type%type,
57: segment ra_account_default_segments.segment%type,
58: table_name ra_account_default_segments.table_name%type,
59: constant ra_account_default_segments.constant%type
60: );
61:
62: --

Line 59: constant ra_account_default_segments.constant%type

55: (
56: type ra_account_defaults.type%type,
57: segment ra_account_default_segments.segment%type,
58: table_name ra_account_default_segments.table_name%type,
59: constant ra_account_default_segments.constant%type
60: );
61:
62: --
63: -- Autoaccounting definintion cache

Line 92: TABLE OF ra_account_default_segments.segment%type

88: unearn_count BINARY_INTEGER := 0;
89: suspense_count BINARY_INTEGER := 0;
90:
91: TYPE segment_table_type IS
92: TABLE OF ra_account_default_segments.segment%type
93: INDEX BY BINARY_INTEGER;
94: --
95: TYPE table_table_type IS
96: TABLE OF ra_account_default_segments.table_name%type

Line 96: TABLE OF ra_account_default_segments.table_name%type

92: TABLE OF ra_account_default_segments.segment%type
93: INDEX BY BINARY_INTEGER;
94: --
95: TYPE table_table_type IS
96: TABLE OF ra_account_default_segments.table_name%type
97: INDEX BY BINARY_INTEGER;
98: --
99: TYPE const_table_type IS
100: TABLE OF ra_account_default_segments.constant%type

Line 100: TABLE OF ra_account_default_segments.constant%type

96: TABLE OF ra_account_default_segments.table_name%type
97: INDEX BY BINARY_INTEGER;
98: --
99: TYPE const_table_type IS
100: TABLE OF ra_account_default_segments.constant%type
101: INDEX BY BINARY_INTEGER;
102: --
103: autoacc_def_segment_t segment_table_type;
104: autoacc_def_table_t table_table_type;

Line 585: ra_account_default_segments ads,

581: ads.segment segment,
582: upper(ads.table_name) table_name,
583: ads.constant constant
584: FROM
585: ra_account_default_segments ads,
586: ra_account_defaults ad
587: WHERE ad.gl_default_id = ads.gl_default_id
588: AND ad.type in
589: (

Line 2740: l_seg ra_account_default_segments.segment%type;

2736:
2737: l_table_offset BINARY_INTEGER;
2738: l_cnt BINARY_INTEGER;
2739: l_concat_segments VARCHAR2(800);
2740: l_seg ra_account_default_segments.segment%type;
2741: l_const ra_account_default_segments.constant%type;
2742: l_tbl ra_account_default_segments.table_name%type;
2743: l_ccid BINARY_INTEGER;
2744: l_seg_num BINARY_INTEGER;

Line 2741: l_const ra_account_default_segments.constant%type;

2737: l_table_offset BINARY_INTEGER;
2738: l_cnt BINARY_INTEGER;
2739: l_concat_segments VARCHAR2(800);
2740: l_seg ra_account_default_segments.segment%type;
2741: l_const ra_account_default_segments.constant%type;
2742: l_tbl ra_account_default_segments.table_name%type;
2743: l_ccid BINARY_INTEGER;
2744: l_seg_num BINARY_INTEGER;
2745: l_seg_value gl_code_combinations.segment1%type;

Line 2742: l_tbl ra_account_default_segments.table_name%type;

2738: l_cnt BINARY_INTEGER;
2739: l_concat_segments VARCHAR2(800);
2740: l_seg ra_account_default_segments.segment%type;
2741: l_const ra_account_default_segments.constant%type;
2742: l_tbl ra_account_default_segments.table_name%type;
2743: l_ccid BINARY_INTEGER;
2744: l_seg_num BINARY_INTEGER;
2745: l_seg_value gl_code_combinations.segment1%type;
2746: l_delim VARCHAR2(1);