1 PACKAGE PSB_COMMITMENTS_PVT AS
2 /* $Header: PSBVWCLS.pls 120.2 2005/07/13 11:30:41 shtripat ship $ */
3
4 /* ----------------------------------------------------------------------- */
5
6 -- API name : Create_Commitment_Line_Items
7 -- Pre-reqs : FND_API, FND_MESSAGE
8 -- .
9 -- Version : Current version 1.0
10 -- Initial version 1.0
11 -- Created 01/26/2000 by Shweta Jain
12 --
13 -- Create Line Items from the Commitment Budgetary Control system for a
14 -- specific worksheet during the budget preparation process. This process
15 -- should extract account balances from Commitment Budgetary Control and
16 -- create them for a specific worksheet in PSB. Input parameters include
17 -- p_worksheet_id which identifies the budget preparation worksheet
18 -- header in PSB
19
20 PROCEDURE Create_Commitment_Line_Items
21 ( p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23 p_commit IN VARCHAR2 := FND_API.G_FALSE,
24 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
25 p_return_status OUT NOCOPY VARCHAR2,
26 p_msg_count OUT NOCOPY NUMBER,
27 p_msg_data OUT NOCOPY VARCHAR2,
28 p_worksheet_id IN NUMBER
29 );
30
31 /* ----------------------------------------------------------------------- */
32
33 -- API name : Post_Commitment_Worksheet
34 -- Pre-reqs : FND_API, FND_MESSAGE
35 -- .
36 -- Version : Current version 1.0
37 -- Initial version 1.0
38 -- Created 01/26/2000 by Shweta Jain
39 --
40 -- Post the worksheet created during the budget preparation process to
41 -- the Commitment Budgetary Control system. This process should post the
42 -- estimate account balances that were projected in PSB to Commitment
43 -- Budgetary Control system. Input parameters include p_worksheet_id which
44 -- identifies the budget preparation worksheet header in PSB
45
46 PROCEDURE Post_Commitment_Worksheet
47 ( p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
51 p_return_status OUT NOCOPY VARCHAR2,
52 p_msg_count OUT NOCOPY NUMBER,
53 p_msg_data OUT NOCOPY VARCHAR2,
54 p_worksheet_id IN NUMBER
55 );
56
57 /* ----------------------------------------------------------------------- */
58
59 -- API name : Create_Commitment_Revisions
60 -- Pre-reqs : FND_API, FND_MESSAGE
61 -- .
62 -- Version : Current version 1.0
63 -- Initial version 1.0
64 -- Created 03/06/2000 by Shweta Jain
65 --
66 -- Create revisions from the Commitment Budgetary Control system for
67 -- mass-entry budget revisions. This process should populate a specific
68 -- budget revision in PSB with the commitment account balances, process
69 -- parameters and perform a funds check if required. Input parameters
70 -- include p_budget_revision_id which identifies the budget revision
71 -- header in PSB
72
73 PROCEDURE Create_Commitment_Revisions
74 ( p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 p_return_status OUT NOCOPY VARCHAR2,
79 p_msg_count OUT NOCOPY NUMBER,
80 p_msg_data OUT NOCOPY VARCHAR2,
81 p_budget_revision_id IN NUMBER
82 );
83
84 /* ----------------------------------------------------------------------- */
85
86 -- API name : Post_Commitment_Revisions
87 -- Pre-reqs : FND_API, FND_MESSAGE
88 -- .
89 -- Version : Current version 1.0
90 -- Initial version 1.0
91 -- Created 03/06/2000 by Shweta Jain
92 --
93 -- Post approved budget revisions to the Commitment Budgetary Control
94 -- system. This process should update the commitment account balances
95 -- with the budget revision changes and perform a funds reservation.
96 -- Input parameters include p_budget_revision_id which identifies
97 -- the budget revision header in PSB
98
99 PROCEDURE Post_Commitment_Revisions
100 ( p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102 p_commit IN VARCHAR2 := FND_API.G_FALSE,
103 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104 p_return_status OUT NOCOPY VARCHAR2,
105 p_msg_count OUT NOCOPY NUMBER,
106 p_msg_data OUT NOCOPY VARCHAR2,
107 p_budget_revision_id IN NUMBER
108 );
109
110 /* ----------------------------------------------------------------------- */
111
112 -- API name : Commitment_Funds_Check
113 -- Pre-reqs : FND_API, FND_MESSAGE
114 -- .
115 -- Version : Current version 1.0
116 -- Initial version 1.0
117 --
118 -- Check Funds Availability for a budget revision from the Commitment
119 -- Budgetary Control system. Input parameters include p_budget_revision_id
120 -- which identifies the budget revision header in PSB
121
122 PROCEDURE Commitment_Funds_Check
123 ( p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125 p_commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127 p_return_status OUT NOCOPY VARCHAR2,
128 p_msg_count OUT NOCOPY NUMBER,
129 p_msg_data OUT NOCOPY VARCHAR2,
130 p_budget_revision_id IN NUMBER
131 );
132
133 /* ----------------------------------------------------------------------- */
134
135 /* ----------------------------------------------------------------------- */
136
137 -- API name : Commitment_Funds_Check
138 -- Pre-reqs : FND_API, FND_MESSAGE
139 -- .
140 -- Version : Current version 1.0
141 -- Initial version 1.0
142 -- Created 06/29/2000 by Shweta Jain
143 -- Function returns value based on CC setup for CBC
144
145 FUNCTION Is_Cbc_Enabled
146 ( p_set_of_books_id IN NUMBER
147 ) RETURN BOOLEAN;
148
149 END PSB_COMMITMENTS_PVT;