1 PACKAGE PSA_FUNDS_CHECKER_PKG AUTHID CURRENT_USER AS
2 /* $Header: psafbcfs.pls 120.25.12020000.1 2012/06/26 13:06:57 appldev ship $ */
3 /*#
4 * PSA_FUNDS_CHECKER_PKG is an online funds checker that enforces budgetary control.
5 * General Ledger provides this uniform interface through which subledgers
6 * and General Ledger can check and reserve funds.
7 * @rep:scope public
8 * @rep:product PSA
9 * @rep:lifecycle active
10 * @rep:displayname PSA Funds Checker
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GL_BC_PACKETS
13 * @rep:ihelp psa/@aproverchpx#aproverchpx Product Overview, Oracle Public Sector Advanced Features Help.
14 */
15
16 -- Funds Checker Main Routine
17
18 /*#
19 * Glxfck is the main Funds Check API for any process that needs to perform Funds Check
20 * and/or Funds Reservation. This routine returns TRUE if successfull; otherwise
21 * it returns FALSE.
22 * @param p_ledgerid The Ledger Id
23 * @param p_packetid The packet id of the packet in process
24 * @param p_mode The Funds check operation mode, default to C
25 * @param p_override Override indicator in case of Funds Reservation failure; default is N
26 * @param p_conc_flag Indicates whether the API is invoked from a Concurrent program; default is N
27 * @param p_user_id The User ID for Override (From AP AutoApproval)
28 * @param p_user_resp_id The User Responsibility ID for Override (From AP AutoApproval)
29 * @param p_calling_prog_flag Identifies whether Funds Checker called from SLA validation routine
30 * @param p_return_code Contains the funds check return code of the packet in process
31 * @return Returns TRUE if successful else FALSE
32 * @rep:scope public
33 * @rep:lifecycle active
34 * @rep:displayname PSA Funds Check API
35 * @rep:compatibility S
36 * @rep:ihelp psa/@aproverchpx#aproverchpx Product Overview, Oracle Public Sector Advanced Features Help.
37 */
38 FUNCTION glxfck(p_ledgerid IN NUMBER,
39 p_packetid IN NUMBER,
40 p_mode IN VARCHAR2 DEFAULT 'C',
41 p_override IN VARCHAR2 DEFAULT 'N',
42 p_conc_flag IN VARCHAR2 DEFAULT 'N',
43 p_user_id IN NUMBER DEFAULT NULL,
44 p_user_resp_id IN NUMBER DEFAULT NULL,
45 p_calling_prog_flag IN VARCHAR2 DEFAULT 'S',
46 p_return_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
47
48 --
49 -- Overloaded Version of glxfck()
50 -- This contains an additional OUT parameter p_unrsv_packet_id.
51 -- This is to be used by General Ledger only.
52 --
53 FUNCTION glxfck(p_ledgerid IN NUMBER,
54 p_packetid IN NUMBER,
55 p_mode IN VARCHAR2 DEFAULT 'C',
56 p_override IN VARCHAR2 DEFAULT 'N',
57 p_conc_flag IN VARCHAR2 DEFAULT 'N',
58 p_user_id IN NUMBER DEFAULT NULL,
59 p_user_resp_id IN NUMBER DEFAULT NULL,
60 p_calling_prog_flag IN VARCHAR2 DEFAULT 'G',
61 p_return_code OUT NOCOPY VARCHAR2,
62 p_unrsv_packet_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
63
64 --
65 -- This contains an additional OUT parameter p_unrsv_packet_id and
66 -- an additional IN parameter p_confirm_override
67 -- This is to be used by General Ledger only for override behaviour
68 --
69
70 FUNCTION gl_confirm_override(p_ledgerid IN NUMBER,
71 p_packetid IN NUMBER,
72 p_mode IN VARCHAR2 DEFAULT 'C',
73 p_override IN VARCHAR2 DEFAULT 'N',
74 p_conc_flag IN VARCHAR2 DEFAULT 'N',
75 p_user_id IN NUMBER DEFAULT NULL,
76 p_user_resp_id IN NUMBER DEFAULT NULL,
77 p_calling_prog_flag IN VARCHAR2 DEFAULT 'G',
78 p_confirm_override IN VARCHAR2 DEFAULT 'Y',
79 p_return_code OUT NOCOPY VARCHAR2,
80 p_unrsv_packet_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
81
82 PROCEDURE glxfpp(p_eventid IN NUMBER);
83
84 FUNCTION get_debug return VARCHAR2;
85
86 PROCEDURE bc_optimizer (err_buf OUT NOCOPY VARCHAR2,
87 ret_code OUT NOCOPY VARCHAR2,
88 p_ledger_id IN NUMBER,
89 p_purge_days IN NUMBER,
90 p_delete_mode IN VARCHAR2);
91
92
93 PROCEDURE bc_purge_hist (err_buf OUT NOCOPY VARCHAR2,
94 ret_code OUT NOCOPY VARCHAR2,
95 p_ledger_id IN NUMBER,
96 p_purge_mode IN VARCHAR2,
97 p_purge_statuses IN VARCHAR2,
98 p_purge_date IN VARCHAR2);
99
100 PROCEDURE glxfma (err_buf OUT NOCOPY VARCHAR2,
101 ret_code OUT NOCOPY VARCHAR2,
102 p_ledger_id IN NUMBER,
103 p_check_flag IN VARCHAR2,
104 p_autopost_set_id IN NUMBER);
105
106 PROCEDURE glsibc (p_last_updated_by IN NUMBER,
107 p_new_template_id IN NUMBER,
108 p_ledger_id IN NUMBER);
109
110 PROCEDURE glsfbc (p_curr_temp_id IN NUMBER,
111 p_ledger_id IN NUMBER,
112 p_last_updated_by IN NUMBER);
113
114 FUNCTION budgetary_control (p_ledgerid IN NUMBER,
115 p_return_code OUT NOCOPY VARCHAR2) return BOOLEAN;
116
117 PROCEDURE populate_group_id (p_grp_id IN NUMBER,
118 p_application_id IN NUMBER,
119 p_je_batch_name IN VARCHAR2 DEFAULT NULL);
120
121 TYPE xla_events_table IS TABLE OF psa_xla_events_logs%ROWTYPE;
122
123 TYPE xla_validation_lines_table IS TABLE OF psa_xla_validation_lines_logs%ROWTYPE;
124
125 TYPE xla_ae_lines_table IS TABLE OF psa_xla_ae_lines_logs%ROWTYPE;
126
127 TYPE xla_ae_headers_table IS TABLE OF psa_xla_ae_headers_logs%ROWTYPE;
128
129 TYPE xla_distribution_links_table IS TABLE OF psa_xla_dist_links_logs%ROWTYPE;
130
131 TYPE bc_pkts_rec IS TABLE OF gl_bc_packets%rowtype;
132 g_bc_pkts_hist bc_pkts_rec;
133
134 TYPE ae_lines_gt_rec is TABLE of xla_ae_lines_gt%rowtype;
135 TYPE validation_lines_gt_rec is TABLE of xla_validation_lines_gt%rowtype;
136 g_ae_lines_gt_rec ae_lines_gt_rec;
137 g_validation_lines_gt_rec validation_lines_gt_rec;
138
139 TYPE num_rec IS TABLE OF NUMBER(15);
140 g_debug VARCHAR2(32000);
141
142 -- To be called by SLA only
143 PROCEDURE sync_xla_errors (p_failed_ldgr_array IN num_rec,
144 p_failed_evnt_array IN num_rec);
145
146
147 END PSA_FUNDS_CHECKER_PKG;