[Home] [Help]
PACKAGE: APPS.GCS_RP_UTILITY_PKG
Source
1 PACKAGE GCS_RP_UTILITY_PKG AUTHID CURRENT_USER AS
2
3 --API Name
4 g_api VARCHAR2(50) := 'gcs.plsql.GCS_RP_UTILITY_PKG';
5
6 -- Action types for writing module information to the log file. Used for
7 -- the procedure log_file_module_write.
8 g_module_enter VARCHAR2(2) := '>>';
9 g_module_success VARCHAR2(2) := '<<';
10 g_module_failure VARCHAR2(2) := '<x';
11
12 g_rp_selColumnList VARCHAR2(10000) := '
13 ';
14
15 g_rp_srcColumnList VARCHAR2(10000) := '
16 ';
17
18 g_rp_tgtColumnList VARCHAR2(10000) := '
19 ';
20
21 g_rp_offColumnList VARCHAR2(10000) := '
22 ) ';
23
24 g_core_insert_stmt VARCHAR2(2000) :=
25 'INSERT INTO gcs_entries_gt(
26 rule_id ,
27 step_seq ,
28 step_name ,
29 formula_text ,
30 rule_step_id ,
31 offset_flag ,
32 sql_statement_num ,
33 currency_code ,
34 ad_input_amount ,
35 pe_input_amount ,
36 ce_input_amount ,
37 ee_input_amount ,
38 output_amount ,
39 entity_id ,
40 ytd_credit_balance_e ,
41 ytd_debit_balance_e ,
42 src_company_cost_center_org_id ,
43 src_intercompany_id ,
44 tgt_company_cost_center_org_id ,
45 tgt_intercompany_id ';
46
47 g_core_sel_stmt VARCHAR2(2000) :=
48 'SELECT :rid ,
49 :seq ,
50 :sna ,
51 :ftx ,
52 :rsi ,
53 :osf ,
54 :stn ,
55 :ccy ,
56 0 ,
57 SUM(
58 DECODE(b.entity_id, :pid,
59 b.ytd_balance_e, 0)) ,
60 SUM(
61 DECODE(b.entity_id, :cid,
62 b.ytd_balance_e, 0)) ,
63 SUM(
64 DECODE(b.entity_id, :eid,
65 b.ytd_balance_e, 0)) ,
66 0 ,
67 0 ,
68 0 ,
69 0 ,
70 b.company_cost_center_org_id ,
71 b.intercompany_id ,
72 :tgt_cctr_org_id ,
73 :tgt_intercompany_id ';
74
75 g_core_frm_stmt VARCHAR2(2000) := '
76 FROM fem_balances b ';
77 g_core_whr_stmt VARCHAR2(2000) := '
78 WHERE b.dataset_code = :dci
79 AND b.cal_period_id = :cpi
80 AND b.source_system_code = 70
81 AND b.ledger_id = :ledger
82 AND b.currency_code = :ccy ';
83
84 g_core_grp_stmt VARCHAR2(2000) := '
85 group by b.company_cost_center_org_id
86 ,b.intercompany_id';
87
88 --Public Procedure and Function Definitions
89
90 --
91 -- Procedure
92 -- create_entry_lines
93 -- Purpose
94 -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt
95 --
96 -- Arguments
97 -- p_entry_id: entry identifier
98 -- p_row_count: #of rows inserted
99 --
100 PROCEDURE create_entry_lines (p_entry_id IN NUMBER,
101 p_offset_flag IN VARCHAR2,
102 p_row_count IN OUT NOCOPY NUMBER);
103 --
104 -- Procedure
105 -- create_off_gt_lines
106 -- Purpose
107 -- creates offset lines in gcs_entries_gt for performance
108 --
109 -- Arguments
110 -- p_rule_id: rule identifier
111 -- p_step_seq: step seq identifier
112 -- p_offset_members: offset member object
113 --
114 --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER,
115 -- p_row_count IN OUT NOCOPY NUMBER);
116 --
117 END GCS_RP_UTILITY_PKG;