APPS.ARP_AUTO_ACCOUNTING_BR dependencies on GL_CODE_COMBINATIONS

Line 183: TABLE OF gl_code_combinations.segment1%type

179: TABLE OF DATE
180: INDEX BY BINARY_INTEGER;
181:
182: TYPE segment_type IS
183: TABLE OF gl_code_combinations.segment1%type
184: INDEX BY BINARY_INTEGER;
185:
186: TYPE cursor_attr_tbl_type IS
187: TABLE OF VARCHAR2(100)

Line 201: TABLE OF gl_code_combinations.segment1%type

197:
198: -- To store segment values for binding
199: --
200: TYPE seg_table_type IS
201: TABLE OF gl_code_combinations.segment1%type
202: INDEX BY binary_integer;
203: --
204: TYPE ccid_rec_type IS RECORD
205: (

Line 1571: FROM gl_code_combinations

1567: l_segment28,
1568: l_segment29,
1569: l_segment30,
1570: p_desired_segment
1571: FROM gl_code_combinations
1572: WHERE code_combination_id = p_ccid;
1573:
1574:
1575: /*--------------------------------------------------+

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

1733: THEN
1734:
1735: /*--------------------------------------------------------------+
1736: | The ccid was not in the cache. |
1737: | Select the segments from gl_code_combinations and add them |
1738: | to the cache if it is not already full. |
1739: +--------------------------------------------------------------*/
1740:
1741: add_segments_to_cache(p_ccid, p_segment_number,l_desired_segment);

Line 1745: ' from gl_code_combinations', MSG_LEVEL_DEBUG);

1741: add_segments_to_cache(p_ccid, p_segment_number,l_desired_segment);
1742:
1743: debug('getting segment ' || p_segment_number ||
1744: 'for ccid ' || p_ccid ||
1745: ' from gl_code_combinations', MSG_LEVEL_DEBUG);
1746:
1747: print_fcn_label2( 'arp_auto_accounting_br.get_segment_from_glcc()-' );
1748: RETURN(l_desired_segment);
1749:

Line 2745: l_seg_value gl_code_combinations.segment1%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);
2747:
2748: -- to store segment values for binding
2749: --

Line 3953: FROM gl_code_combinations

3949: temp :=
3950: 'SELECT
3951: detail_posting_allowed_flag,
3952: summary_flag
3953: FROM gl_code_combinations
3954: WHERE code_combination_id = :ccid
3955: ';
3956:
3957: -- debug