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 2903: FROM gl_code_combinations

2899: l_segment28,
2900: l_segment29,
2901: l_segment30,
2902: p_desired_segment
2903: FROM gl_code_combinations
2904: WHERE code_combination_id = p_ccid;
2905:
2906:
2907: /*--------------------------------------------------+

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

3065: THEN
3066:
3067: /*--------------------------------------------------------------+
3068: | The ccid was not in the cache. |
3069: | Select the segments from gl_code_combinations and add them |
3070: | to the cache if it is not already full. |
3071: +--------------------------------------------------------------*/
3072:
3073: add_segments_to_cache(p_ccid, p_segment_number,l_desired_segment);

Line 3077: ' from gl_code_combinations', MSG_LEVEL_DEBUG);

3073: add_segments_to_cache(p_ccid, p_segment_number,l_desired_segment);
3074:
3075: debug('getting segment ' || p_segment_number ||
3076: 'for ccid ' || p_ccid ||
3077: ' from gl_code_combinations', MSG_LEVEL_DEBUG);
3078:
3079: print_fcn_label2( 'arp_auto_accounting.get_segment_from_glcc()-' );
3080: RETURN(l_desired_segment);
3081:

Line 3443: FROM gl_code_combinations

3439: SELECT detail_posting_allowed_flag,
3440: summary_flag
3441: INTO l_detail_posting_flag,
3442: l_summary_flag
3443: FROM gl_code_combinations
3444: WHERE code_combination_id = l_ccid;
3445:
3446: pg_ar_code_comb_rec(l_ccid).detail_posting_flag := l_detail_posting_flag ;
3447: pg_ar_code_comb_rec(l_ccid).summary_flag := l_summary_flag ;

Line 4287: l_seg_value gl_code_combinations.segment1%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;
4289: l_delim VARCHAR2(1);
4290:
4291: -- to store segment values for binding

Line 4288: l_int_seg_value gl_code_combinations.segment1%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;
4289: l_delim VARCHAR2(1);
4290:
4291: -- to store segment values for binding
4292: --