1 Package FV_FACTS_TRX_REGISTER AUTHID CURRENT_USER AS
2 /* $Header: FVFCTRGS.pls 120.9.12010000.1 2008/07/28 06:30:58 appldev ship $ */
3 ---- -------------------------------------------------------------------
4 -- PROCEDURE MAIN
5 -- ---------------------------------------------------------------------
6 -- Called from following procedures:
7 -- This is called from the concurrent program to execute FACTS
8 -- transaction register process
9 -- Purpose:
10 -- This calls all subsequent procedures
11 -- ---------------------------------------------------------------------
12 PROCEDURE main (p_errbuf OUT NOCOPY VARCHAR2,
13 p_retcode OUT NOCOPY NUMBER,
14 p_set_of_books_id NUMBER,
15 p_coa_id NUMBER,
16 p_currency_code VARCHAR2,
17 p_treasury_symbol_low VARCHAR2,
18 p_treasury_symbol_high VARCHAR2,
19 p_from_period_name VARCHAR2,
20 p_to_period_name VARCHAR2,
21 p_from_gl_posted_date VARCHAR2,
22 p_to_gl_posted_date VARCHAR2,
23 p_source VARCHAR2 DEFAULT NULL,
24 p_category VARCHAR2 DEFAULT NULL,
25 p_report_id VARCHAR2,
26 p_attribute_set VARCHAR2,
27 p_output_format VARCHAR2
28 );
29
30 -- -------------------------------------------------------------
31 -- PROCEDURE PRCOESS PERIOD INFO
32 -- -------------------------------------------------------------
33 -- Process_Period_Info procedure is called from the Main procedure.
34 -- This procedure loads global variables 'g_period_num_low'
35 -- and 'g_period_num_high' with the derived period num range.
36 -- -------------------------------------------------------------
37
38 PROCEDURE process_period_info;
39
40 -- -------------------------------------------------------------
41 -- PROCEDURE GET QUALIFIER SEGMENTS
42 -- -------------------------------------------------------------
43 -- Get_QualIFier_Segments procedure is called from the Main
44 -- procedure.
45 -- This procedure gets the accounting and the balancing segments.
46 -- -------------------------------------------------------------
47 PROCEDURE get_qualifier_segments;
48
49 -- -------------------------------------------------------------------
50 -- PROCEDURE JOURNAL_PROCESS
51 -- -------------------------------------------------------------------
52 -- Journal_Process procedure is called from the Main procedure.
53 -- Its primary purpose is to derive values to populate
54 -- 'FV_FACTS_TRX_TEMP' table from the rows derived from INVOICES,
55 -- PAYMENTS etc. It uses Dynamic SQL to dynamically set
56 -- the select statement for the cursor.
57 -- It uses the argument 'p_jrnl_type' to find whether the journal
58 -- type is Invoice or payment, etc. The valid journal type values
59 -- INV-Invoice, PMT-Payment, REC-Receivable, ORD-Purchase Order
60 -- -------------------------------------------------------------------
61
62 PROCEDURE journal_process;
63
64
65 -- -------------------------------------------------------------------
66 -- PROCEDURE GET_DOC_USER
67 -- -------------------------------------------------------------------
68 -- Called from following procedures:
69 -- Journal_Process
70 -- Purpose:
71 -- Determine the user who created the journal line being processed
72 -- Also format the creation_date
73 -- -------------------------------------------------------------------
74
75 PROCEDURE get_doc_user (p_created_by NUMBER,
76 p_entry_user OUT NOCOPY VARCHAR2);
77
78 -- --------------------------------------------------------------------
79 -- PROCEDURE GET_FUND_GROUP_INFO
80 -- --------------------------------------------------------------------
81 -- Its primary purpose get the fund Group, Dept Id, bureau Id and
82 -- balancing segment from the fv_fund_parameters table for the
83 -- passed Code Combination Id.
84 -- --------------------------------------------------------------------
85
86 PROCEDURE get_fund_group_info (p_ccid Gl_Balances.code_combination_id%TYPE,
87 p_fund_group IN OUT NOCOPY VARCHAR2,
88 p_dept_id IN OUT NOCOPY VARCHAR2,
89 p_bureau_id IN OUT NOCOPY VARCHAR2,
90 p_bal_segment IN OUT NOCOPY VARCHAR2);
91
92
93 -- -------------------------------------------------------------------
94 -- PROCEDURE GET_SGL_PARENT
95 -- -------------------------------------------------------------------
96 -- Gets the SGL Parent Account for the passed account number
97 -- ------------------------------------------------------------------
98
99 PROCEDURE get_sgl_parent(
100 Acct_num VARCHAR2,
101 sgl_acct_num OUT NOCOPY VARCHAR2 ) ;
102
103 -- -------------------------------------------------------------------
104 -- PROCEDURE GET_USSGL_INFO
105 -- -------------------------------------------------------------------
106 -- Gets the information like enabled flag and reporting type
107 -- for the passed account number.
108 -- -------------------------------------------------------------------
109
110 PROCEDURE get_ussgl_info (p_ussgl_acct_num IN VARCHAR2,
111 p_enabled_flag IN OUT NOCOPY VARCHAR2,
112 p_reporting_type IN OUT NOCOPY VARCHAR2);
113
114
115 -- ------------------------------------------------------------------
116 -- PROCEDURE GET_PERIOD_YEAR
117 -- ------------------------------------------------------------------
118 -- Get_Period_Year procedure is called from the Main procedure.
119 -- This procedure gets the accounting calender name(period set name)
120 -- based on the set of books parameter that is passed and then gets
121 -- the period year based on period from and period to parameters.
122 -- It then gets the start date of the from period and end date of the
123 -- to period, which are used in the Journal_Process Procedure.
124 -- ------------------------------------------------------------------
125
126 PROCEDURE get_period_year (p_period_from VARCHAR2,
127 p_period_to VARCHAR2);
128
129 -- -------------------------------------------------------------------
130 -- PROCEDURE GET_COHORT_INFO
131 -- -------------------------------------------------------------------
132 -- Gets the cohort segment name based on the Financing Acct value
133 -- ------------------------------------------------------------------
134
135 PROCEDURE get_cohort_info ;
136
137 -- -------------------------------------------------------------------
138 -- PROCEDURE PURGE_FACTS_TRANSACTIONS
139 -- -------------------------------------------------------------------
140 -- Purges all FACTS transactions from the FV_FACTS_TRX_TEMP table for
141 -- the passed Treasaury Symbol.
142 -- ------------------------------------------------------------------
143
144 PROCEDURE purge_facts_transactions ;
145
146 -- -------------------------------------------------------------------
147 -- PROCEDURE LOAD_FACTS_ATTRIBUTES
148 -- -------------------------------------------------------------------
149 -- This procedure selects the attributes for the Account number
150 -- segment from FV_FACTS_ATTRIBUTES table and load them into global
151 -- variables for usage in the FACTS Main process. It also calculates
152 -- one time pull up values for the account number that does not
153 -- require drill down into GL transactions.
154 -- ------------------------------------------------------------------
155
156 PROCEDURE load_facts_attributes (acct_num VARCHAR2,
157 fund_val VARCHAR2);
158
159 -- -------------------------------------------------------------------
160 -- PROCEDURE RESET_ATTRIBUTES
161 -- The Process sets all the values of the FACTS Attributes to NULL
162 -- -------------------------------------------------------------------
163 -- ------------------------------------------------------------------
164
165 PROCEDURE reset_facts_attributes ;
166
167 END fv_facts_trx_register;