APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on GL_CODE_COMBINATIONS

Line 513: l_gl_ccid_rec GL_CODE_COMBINATIONS%ROWTYPE;

509: /*===============================End Of FUNCTION/PROCEDURE===============================*/
510: function prepare_category(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
511: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
512: return boolean is
513: l_gl_ccid_rec GL_CODE_COMBINATIONS%ROWTYPE;
514: l_mass_add_rec FA_MASSADD_PREPARE_PKG.mass_add_rec;
515: l_err_mesg varchar2(500);
516: l_calling_fn varchar2(40) := 'prepare_category';
517: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;

Line 634: from gl_code_combinations

630: l_segment(28),
631: l_segment(29),
632: l_segment(30),
633: l_gl_ccid_enabled_flag
634: from gl_code_combinations
635: where code_combination_id =
636: px_mass_add_rec.payables_code_combination_id
637: and chart_of_accounts_id = h_chart_of_accounts_id;
638:

Line 654: from gl_code_combinations gl_ccid

650: p_log_level_rec => p_log_level_rec);
651: end if;
652: select max(code_combination_id)
653: into l_clearing_acct_ccid
654: from gl_code_combinations gl_ccid
655: where decode(l_segment(1), null, '-1', gl_ccid.Segment1) =
656: nvl(l_segment(1), '-1')
657: and decode(l_segment(2), null, '-1', gl_ccid.Segment2) =
658: nvl(l_segment(2), '-1')

Line 745: from gl_code_combinations gl_ccid

741: p_log_level_rec => p_log_level_rec);
742: end if;
743: select max(code_combination_id)
744: into l_clearing_acct_ccid
745: from gl_code_combinations gl_ccid
746: where decode(l_segment(1), null, '-1', gl_ccid.Segment1) =
747: nvl(l_segment(1), '-1')
748: and decode(l_segment(2), null, '-1', gl_ccid.Segment2) =
749: nvl(l_segment(2), '-1')

Line 1422: from gl_code_combinations

1418: l_segment(28),
1419: l_segment(29),
1420: l_segment(30),
1421: l_gl_ccid_enabled_flag
1422: from gl_code_combinations
1423: where code_combination_id =
1424: px_mass_add_rec.payables_code_combination_id;
1425:
1426: for i in 1 .. 30 loop

Line 1473: from fa_locations fa_loc2, gl_code_combinations gl_code

1469: l_loc_query := 'select max(location_id) from fa_locations fa_loc where fa_loc.' ||
1470: l_loc_seg_name || '= ' ||
1471: l_segment(to_number(substr(l_loc_seg_name, 8))) || '
1472: and location_id in (select location_id
1473: from fa_locations fa_loc2, gl_code_combinations gl_code
1474: where fa_loc.segment1 = gl_code.' ||
1475: loc_seg_clr_acct_map(1) ||
1476: ' and fa_loc.segment2 = gl_code.' ||
1477: loc_seg_clr_acct_map(2) ||