1 Package FV_FACTS_TBAL_TRANSACTIONS AUTHID CURRENT_USER as
2 /* $Header: FVFCTRGS.pls 115.18 2002/11/10 15:06:24 ksriniva ship $*/
3
4 -- Main Procedure that is called for the FACTS Process Execution
5 Procedure MAIN(
6 Errbuf OUT NOCOPY Varchar2,
7 retcode OUT NOCOPY Varchar2,
8 Set_Of_Books_Id Number,
9 p_coa Number,
10 Treasury_Symbol Varchar2,
11 Start_Date Date,
12 End_Date Date,
13 Source_Name varchar2 DEFAULT NULL ,
14 Category_Name varchar2 DEFAULT NULL,
15 currency_code Varchar2,
16 p_pagebreak1 VARCHAR2,
17 p_pagebreak1_low VARCHAR2,
18 p_pagebreak1_high VARCHAR2,
19 p_pagebreak2 VARCHAR2,
20 p_pagebreak2_low VARCHAR2,
21 p_pagebreak2_high VARCHAR2,
22 p_pagebreak3 VARCHAR2,
23 p_pagebreak3_low VARCHAR2,
24 p_pagebreak3_high VARCHAR2);
25
26
27
28
29 -- Purge old transactions from Temp table for the passed Treasury Symbol
30 Procedure PURGE_FACTS_TRANSACTIONS ;
31
32 -- Gets all information related to the current and beginning period.
33 -- (Period Number, Start Date, End Date and Year Start Date Etc.
34 Procedure GET_PERIOD_INFO ;
35
36 -- Gets Balancing and Accounting Segment names from FND Tables.
37 Procedure GET_QUALIFIER_SEGMENTS ;
38
39 -- Gets the cohort segment value for the treasury symbol
40 Procedure GET_COHORT_INFO ;
41
42 -- Processes FACTS Transactions
43 Procedure PROCESS_TBAL_TRANSACTIONS ;
44
45 Procedure GET_SGL_PARENT(
46 Acct_num Varchar2,
47 sgl_acct_num OUT NOCOPY Varchar2) ;
48
49 -- Gets all the FACTS attributes and direct pull up values for the passed
50 -- account number
51 Procedure LOAD_FACTS_ATTRIBUTES (Acct_num Varchar2,
52 Fund_val Varchar2) ;
53
54 -- Create Trial Balance Record
55 Procedure CREATE_TBAL_RECORD ;
56
57 -- Reset the Attribute Variables
58 Procedure reset_attributes ;
59
60 -- Procedure to get Document Number, Date
61 Procedure GET_DOC_INFO (
62 P_je_header_id IN number,
63 P_je_source_name IN Varchar2
64 ,P_je_category_name IN Varchar2
65 ,P_Name IN Varchar2
66 ,P_Date IN Date
67 ,P_created_by IN Number
68 ,P_creation_date IN Date
69 ,P_Reference1 IN Varchar2
70 ,P_Reference2 IN Varchar2
71 ,P_Reference3 IN Varchar2
72 ,P_Reference4 IN Varchar2
73 ,P_Reference5 IN Varchar2
74 ,P_Reference9 IN Varchar2
75 ,P_Ref2 IN Varchar2
76 ,P_Doc_Num OUT NOCOPY Varchar2
77 ,P_Doc_Date OUT NOCOPY Date
78 ,P_doc_created_by OUT NOCOPY Number
79 ,P_doc_creation_date OUT NOCOPY Date);
80
81 END FV_FACTS_TBAL_TRANSACTIONS ;