APPS.ARP_AUTO_ACCOUNTING dependencies on RA_ACCOUNT_DEFAULT_SEGMENTS

Line 64: segment ra_account_default_segments.segment%type,

60: ------------------------------------------------------------------------
61: TYPE autoacc_rec_type IS RECORD
62: (
63: type ra_account_defaults.type%type,
64: segment ra_account_default_segments.segment%type,
65: table_name ra_account_default_segments.table_name%type,
66: constant ra_account_default_segments.constant%type
67: );
68:

Line 65: table_name ra_account_default_segments.table_name%type,

61: TYPE autoacc_rec_type IS RECORD
62: (
63: type ra_account_defaults.type%type,
64: segment ra_account_default_segments.segment%type,
65: table_name ra_account_default_segments.table_name%type,
66: constant ra_account_default_segments.constant%type
67: );
68:
69: --

Line 66: constant ra_account_default_segments.constant%type

62: (
63: type ra_account_defaults.type%type,
64: segment ra_account_default_segments.segment%type,
65: table_name ra_account_default_segments.table_name%type,
66: constant ra_account_default_segments.constant%type
67: );
68:
69: --
70: -- Autoaccounting definintion cache

Line 108: TABLE OF ra_account_default_segments.segment%type

104: unearn_count BINARY_INTEGER := 0;
105: suspense_count BINARY_INTEGER := 0;
106: --
107: TYPE segment_table_type IS
108: TABLE OF ra_account_default_segments.segment%type
109: INDEX BY BINARY_INTEGER;
110: --
111: TYPE table_table_type IS
112: TABLE OF ra_account_default_segments.table_name%type

Line 112: TABLE OF ra_account_default_segments.table_name%type

108: TABLE OF ra_account_default_segments.segment%type
109: INDEX BY BINARY_INTEGER;
110: --
111: TYPE table_table_type IS
112: TABLE OF ra_account_default_segments.table_name%type
113: INDEX BY BINARY_INTEGER;
114: --
115: TYPE const_table_type IS
116: TABLE OF ra_account_default_segments.constant%type

Line 116: TABLE OF ra_account_default_segments.constant%type

112: TABLE OF ra_account_default_segments.table_name%type
113: INDEX BY BINARY_INTEGER;
114: --
115: TYPE const_table_type IS
116: TABLE OF ra_account_default_segments.constant%type
117: INDEX BY BINARY_INTEGER;
118: --
119: autoacc_def_segment_t segment_table_type;
120: autoacc_def_table_t table_table_type;

Line 924: ra_account_default_segments ads,

920: ads.segment segment,
921: upper(ads.table_name) table_name,
922: ads.constant constant
923: FROM
924: ra_account_default_segments ads,
925: ra_account_defaults ad
926: WHERE ad.gl_default_id = ads.gl_default_id
927: AND ad.org_id = NVL(arp_global.sysparam.org_id, ad.org_id)
928: AND ad.type in

Line 4282: l_seg ra_account_default_segments.segment%type;

4278: l_table_offset BINARY_INTEGER;
4279: l_cnt BINARY_INTEGER;
4280: l_concat_segments VARCHAR2(800);
4281: l_int_concat_segments VARCHAR2(800);
4282: l_seg ra_account_default_segments.segment%type;
4283: l_const ra_account_default_segments.constant%type;
4284: l_tbl ra_account_default_segments.table_name%type;
4285: l_ccid BINARY_INTEGER;
4286: l_seg_num BINARY_INTEGER;

Line 4283: l_const ra_account_default_segments.constant%type;

4279: l_cnt BINARY_INTEGER;
4280: l_concat_segments VARCHAR2(800);
4281: l_int_concat_segments VARCHAR2(800);
4282: l_seg ra_account_default_segments.segment%type;
4283: l_const ra_account_default_segments.constant%type;
4284: l_tbl ra_account_default_segments.table_name%type;
4285: l_ccid BINARY_INTEGER;
4286: l_seg_num BINARY_INTEGER;
4287: l_seg_value gl_code_combinations.segment1%type;

Line 4284: l_tbl ra_account_default_segments.table_name%type;

4280: l_concat_segments VARCHAR2(800);
4281: l_int_concat_segments VARCHAR2(800);
4282: l_seg ra_account_default_segments.segment%type;
4283: l_const ra_account_default_segments.constant%type;
4284: l_tbl ra_account_default_segments.table_name%type;
4285: l_ccid BINARY_INTEGER;
4286: l_seg_num BINARY_INTEGER;
4287: l_seg_value gl_code_combinations.segment1%type;
4288: l_int_seg_value gl_code_combinations.segment1%type;