1 PACKAGE glf02220_bje_pkg AUTHID CURRENT_USER AS
2 /* $Header: glfbdejs.pls 120.5 2005/07/29 16:57:23 djogg ship $ */
3 --
4 -- Package
5 -- glf02220_bje_pkg
6 -- Purpose
7 -- Form package for Enter Budget Journals form
8 -- History
9 -- 08/19/94 R Ng Created
10 --
11
12 --
13 -- Function
14 -- bje_trans_exists
15 -- Purpose
16 -- Determines whether there are any non-zero budget
17 -- journals going to be created based on records present
18 -- in GL_BUDGET_RANGE_INTERIM.
19 -- History
20 -- 08/19/94 R Ng Created
21 -- Arguments
22 -- X_status_number Status number (for this bje session)
23 -- X_ledger_id Ledger ID
24 -- X_period_year Budget period year
25 -- X_start_period_num Start period number
26 -- X_end_period_num End period number
27 -- Example
28 -- Notes
29 --
30 FUNCTION bje_trans_exists( X_status_number IN NUMBER,
31 X_ledger_id IN NUMBER,
32 X_period_year IN NUMBER,
33 X_start_period_num IN NUMBER,
34 X_end_period_num IN NUMBER ) RETURN BOOLEAN;
35
36 --
37 -- Procedure
38 -- insert_bc_packet
39 -- Purpose
40 -- Inserts transactions into GL_BC_PACKETS for funds check/reservation
41 -- based on records present in GL_BUDGET_RANGE_INTERIM.
42 -- Retrieves packet_id and returns packet_id to calling form upon exit.
43 -- History
44 -- 08/19/94 R Ng Created
45 -- Arguments
46 -- X_packet_id Packet ID
47 -- X_status_number Status number (for this bje session)
48 -- X_ledger_id Ledger ID
49 -- X_je_category_name JE category name
50 -- X_fc_mode Funds check mode (C/R)
51 -- X_je_batch_name BJE batch name
52 -- X_period_year Budget period year
53 -- X_start_period_num Start period number
54 -- X_end_period_num End period number
55 -- X_session_Id Session Id
56 -- X_serial_Id Serial Id
57 -- Example
58 -- Notes
59 --
60 PROCEDURE insert_bc_packet( X_packet_id IN OUT NOCOPY NUMBER,
61 X_status_number IN NUMBER,
62 X_ledger_id IN NUMBER,
63 X_je_category_name IN VARCHAR2,
64 X_fc_mode IN VARCHAR2,
65 X_je_batch_name IN VARCHAR2,
66 X_period_year IN NUMBER,
67 X_start_period_num IN NUMBER,
68 X_end_period_num IN NUMBER,
69 X_session_id IN NUMBER,
70 X_serial_id IN NUMBER);
71
72 --
73 -- Procedure
74 -- insert_interface_rows
75 -- Purpose
76 -- Inserts transactions into GL_INTERFACE for current BJE forms session
77 -- based on records present in GL_BUDGET_RANGE_INTERIM.
78 -- Retrieves group_id and returns group_id to calling form upon exit.
79 -- History
80 -- 08/24/94 R Ng Created
81 -- Arguments
82 -- X_group_id Journal Import Group ID
83 -- X_status_number Status number (for this bje session)
84 -- X_ledger_id Ledger ID
85 -- X_user_je_category_name User JE category name
86 -- X_je_batch_name BJE batch name
87 -- X_period_year Budget period year
88 -- X_start_period_num Start period number
89 -- X_end_period_num End period number
90 -- Example
91 -- Notes
92 --
93 PROCEDURE insert_interface_rows( X_group_id IN OUT NOCOPY NUMBER,
94 X_status_number IN NUMBER,
95 X_ledger_id IN NUMBER,
96 X_user_je_category_name IN VARCHAR2,
97 X_je_batch_name IN VARCHAR2,
98 X_period_year IN NUMBER,
99 X_start_period_num IN NUMBER,
100 X_end_period_num IN NUMBER );
101
102 --
103 -- Procedure
104 -- delete_range_interim_records
105 -- Purpose
106 -- Delete records from GL_BUDGET_RANGE_INTERIM after submitting
107 -- Create Journals program (BC on) or Journal Import (BC off)
108 -- History
109 -- 08/19/94 R Ng Created
110 -- Arguments
111 -- X_status_number Status number (for this bje session)
112 -- Example
113 -- Notes
114 --
115 PROCEDURE delete_range_interim_records( X_status_number IN NUMBER );
116
117 END glf02220_bje_pkg;