APPS.ARP_AUTO_ACCOUNTING dependencies on GL_CODE_COMBINATIONS

Line 260: TABLE OF gl_code_combinations.segment1%type

256: TABLE OF DATE
257: INDEX BY BINARY_INTEGER;
258:
259: TYPE segment_type IS
260: TABLE OF gl_code_combinations.segment1%type
261: INDEX BY BINARY_INTEGER;
262:
263: TYPE cursor_attr_tbl_type IS
264: TABLE OF VARCHAR2(100)

Line 278: TABLE OF gl_code_combinations.segment1%type

274:
275: -- To store segment values for binding
276: --
277: TYPE seg_table_type IS
278: TABLE OF gl_code_combinations.segment1%type
279: INDEX BY binary_integer;
280: --
281: TYPE ccid_rec_type IS RECORD
282: (

Line 381: ( detail_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE,

377: /* Bug-2178723 : Cached the values of detail_posting_allowed_flag and summary_flag
378: in pl/sql table to avoid the high execution count */
379:
380: TYPE code_comb_rec_type IS RECORD
381: ( detail_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE,
382: summary_flag gl_code_combinations.summary_flag%TYPE);
383:
384: TYPE t_ar_code_comb_table IS TABLE OF code_comb_rec_type
385: INDEX BY BINARY_INTEGER;

Line 382: summary_flag gl_code_combinations.summary_flag%TYPE);

378: in pl/sql table to avoid the high execution count */
379:
380: TYPE code_comb_rec_type IS RECORD
381: ( detail_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE,
382: summary_flag gl_code_combinations.summary_flag%TYPE);
383:
384: TYPE t_ar_code_comb_table IS TABLE OF code_comb_rec_type
385: INDEX BY BINARY_INTEGER;
386:

Line 2886: FROM gl_code_combinations

2882: l_segment28,
2883: l_segment29,
2884: l_segment30,
2885: p_desired_segment
2886: FROM gl_code_combinations
2887: WHERE code_combination_id = p_ccid;
2888:
2889:
2890: /*--------------------------------------------------+

Line 3052: | Select the segments from gl_code_combinations and add them |

3048: THEN
3049:
3050: /*--------------------------------------------------------------+
3051: | The ccid was not in the cache. |
3052: | Select the segments from gl_code_combinations and add them |
3053: | to the cache if it is not already full. |
3054: +--------------------------------------------------------------*/
3055:
3056: add_segments_to_cache(p_ccid, p_segment_number,l_desired_segment);

Line 3060: ' from gl_code_combinations', MSG_LEVEL_DEBUG);

3056: add_segments_to_cache(p_ccid, p_segment_number,l_desired_segment);
3057:
3058: debug('getting segment ' || p_segment_number ||
3059: 'for ccid ' || p_ccid ||
3060: ' from gl_code_combinations', MSG_LEVEL_DEBUG);
3061:
3062: print_fcn_label2( 'arp_auto_accounting.get_segment_from_glcc()-' );
3063: RETURN(l_desired_segment);
3064:

Line 3426: FROM gl_code_combinations

3422: SELECT detail_posting_allowed_flag,
3423: summary_flag
3424: INTO l_detail_posting_flag,
3425: l_summary_flag
3426: FROM gl_code_combinations
3427: WHERE code_combination_id = l_ccid;
3428:
3429: pg_ar_code_comb_rec(l_ccid).detail_posting_flag := l_detail_posting_flag ;
3430: pg_ar_code_comb_rec(l_ccid).summary_flag := l_summary_flag ;

Line 4260: l_seg_value gl_code_combinations.segment1%type;

4256: l_const ra_account_default_segments.constant%type;
4257: l_tbl ra_account_default_segments.table_name%type;
4258: l_ccid BINARY_INTEGER;
4259: l_seg_num BINARY_INTEGER;
4260: l_seg_value gl_code_combinations.segment1%type;
4261: l_int_seg_value gl_code_combinations.segment1%type;
4262: l_delim VARCHAR2(1);
4263:
4264: -- to store segment values for binding

Line 4261: l_int_seg_value gl_code_combinations.segment1%type;

4257: l_tbl ra_account_default_segments.table_name%type;
4258: l_ccid BINARY_INTEGER;
4259: l_seg_num BINARY_INTEGER;
4260: l_seg_value gl_code_combinations.segment1%type;
4261: l_int_seg_value gl_code_combinations.segment1%type;
4262: l_delim VARCHAR2(1);
4263:
4264: -- to store segment values for binding
4265: --