DBA Data[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;