[Home] [Help]
PACKAGE: APPS.JG_ALLOCATE_JOURNALS_PKG
Source
1 PACKAGE JG_ALLOCATE_JOURNALS_PKG AUTHID CURRENT_USER AS
2 /* $Header: jgzztaks.pls 115.2 2002/11/20 09:20:49 arimai ship $ */
3
4 PROCEDURE allocate;
5
6 FUNCTION get_dynamic_select_string RETURN VARCHAR2;
7 --
8 --
9 -- Handle for Journal Query
10 --
11 G_journal_qry_c INTEGER;
12
13 --
14 -- Record for Journal Query
15 --
16 TYPE FISCAL_JOURNAL_LINE IS RECORD
17 (l_je_lines_v_rec jg_zz_ta_je_lines_v%ROWTYPE,
18 account_number jg_zz_ta_je_lines_v.segment1%TYPE,
19 cost_center jg_zz_ta_je_lines_v.segment1%TYPE,
20 cc_range_id jg_zz_ta_cc_ranges.cc_range_id%TYPE,
21 account_range_id jg_zz_ta_account_ranges.account_range_id%TYPE,
22 offset_account jg_zz_ta_account_ranges.offset_account%TYPE,
23 cc_range_low jg_zz_ta_cc_ranges.cc_range_low%TYPE,
24 cc_range_high jg_zz_ta_cc_ranges.cc_range_high%TYPE,
25 rule_set_name jg_zz_ta_rule_sets.name%TYPE,
26 partial_allocation jg_zz_ta_rule_sets.partial_allocation%TYPE,
27 cc_range_description jg_zz_ta_cc_ranges.description%TYPE);
28 G_journal_qry_rec FISCAL_JOURNAL_LINE;
29 G_last_journal_qry_rec FISCAL_JOURNAL_LINE;
30 G_currency_format_mask VARCHAR2(100);
31 G_currency_precision FND_CURRENCIES.precision%TYPE;
32 G_jrnl_total_allocn_percent NUMBER := NULL;
33
34 END JG_ALLOCATE_JOURNALS_PKG;