PACKAGE: APPS.FA_FLEX_TYPE

Source

1 PACKAGE FA_FLEX_TYPE as
2 /* $Header: FAFBXITS.pls 120.0 2002/08/24 07:16:04 appldev noship $ */
3 
4   --
5   -- Private Inter-Package Types
6   --
7   -- Following types are used to construct nested record type of table type
8   --
9   TYPE fafbglb IS RECORD (
10         book_type_code		FA_BOOK_CONTROLS.book_type_code%TYPE,
11   	book_type_name		FA_BOOK_CONTROLS.book_type_name%TYPE,
12 	function_name		varchar2(31),
13   	id_flex_num		FA_BOOK_CONTROLS.accounting_flex_structure%TYPE,
14    	appid		        number,
15     	userid			number,
16         login			number,
17         acct_segnum		number,
18         bal_segnum		number,
19         cost_segnum		number,
20         numsegs		        number,
21         delim			varchar2(1));
22 
23   TYPE fafbact is RECORD (
24        	type_name	varchar2(50),
25   	type_code	varchar2(30),
26 	flag		varchar2(1));
27 
28     fafbglb_rec   fafbglb;
29   --fafbact_rec   fafbact;
30     fafbact_rec   fafbact;
31   TYPE fafb_acct_tab_type IS TABLE OF fafbact
32 	INDEX BY BINARY_INTEGER;
33   -- COMMON CONSTANT
34   --
35   -- Positional argument tokens
36  -- Mode      - First argument is the mode
37  -- Book_type - Book Type Code
38   RUN_MODE		CONSTANT NUMBER := 1;
39   BOOK_TYPE		CONSTANT NUMBER := 2;
40 
41 -- Possible calling modes
42 -- seed_mode		:initial seeding mode
43 -- delete_mode		:delete a book
44 -- bad_mode		:non-existent mode
45 -- num_flex_params	:number of flexbuilder parameters
46 -- bad_arg		:bad argument
47 
48   SEED_MODE		CONSTANT NUMBER := 0;
49   DELETE_MODE		CONSTANT NUMBER := 1;
50   BAD_MODE		CONSTANT NUMBER := 2;
51   NUM_FLEX_PARAMS	CONSTANT NUMBER := 3;
52 
53 -- bonus: from 23 to 25
54   NUM_ACCTS		CONSTANT NUMBER := 25;
55   GL_APPL_ID		CONSTANT NUMBER :=101;
56   FA_APPL_ID		CONSTANT NUMBER :=140;
57   TOTAL_SEG_COLS	CONSTANT NUMBER :=30;  /* Total segments in gl_code_combinations  */
58 
59 END FA_FLEX_TYPE;