1 PACKAGE GMF_PeriodClose_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMFPIAPS.pls 120.2 2005/12/22 16:17:15 umoogala noship $ */
3
4
5 -- Start of comments
6 -- API name : Get_PendingTxnCount
7 -- Type : Public
8 -- Pre-reqs : None
9 -- Function : This procedure gets the number of pending transactions
10 -- outstanding for the given period. The existence of
11 -- pending transactions for which resolution is required
12 -- will prevent period close from continuing.
13 --
14 -- Type of transaction Required?
15 -- ------------------- -----------------
16 -- Unprocessed Material transactions Yes
17 -- Pending shipping delivery transactions Yes
18 -- Unprocessed receiving transactions No
19 -- Pending material transactions No
20 --
21 -- Parameters :
22 -- p_api_version IN NUMBER Required
23 -- p_org_id IN INTEGER Required
24 -- p_closing_period IN INTEGER Required
25 -- p_sched_close_date IN DATE Required
26 -- x_pend_receiving OUT NOCOPY INTEGER
27 -- x_unproc_matl OUT NOCOPY INTEGER
28 -- x_pend_matl OUT NOCOPY INTEGER
29 -- x_pending_ship OUT NOCOPY INTEGER
30 -- x_return_status OUT NOCOPY VARCHAR2
31 -- Version : Current version 1.0
32 -- Initial version 1.0
33 -- End of comments
34
35 PROCEDURE Get_PendingTxnCount(
36 p_api_version IN NUMBER,
37 p_org_id IN INTEGER,
38 p_closing_period IN INTEGER,
39 p_sched_close_date IN DATE,
40 x_pend_receiving OUT NOCOPY INTEGER,
41 x_unproc_matl OUT NOCOPY INTEGER,
42 x_pend_matl OUT NOCOPY INTEGER,
43 x_pending_ship OUT NOCOPY INTEGER,
44 x_return_status OUT NOCOPY VARCHAR2
45 );
46
47 -- Start of comments
48 -- API name : Verify_PeriodClose
49 -- Type : Public
50 -- Pre-reqs : None
51 -- Function : Checks that necessary conditions are met prior to
52 -- closing a period.
53 -- Parameters : p_api_version IN NUMBER Required
54 -- p_org_id IN NUMBER
55 -- p_closing_acct_period_id IN NUMBER
56 -- p_closing_end_date IN DATE
57 -- x_open_period_exists OUT NOCOPY BOOLEAN
58 -- x_proper_order OUT NOCOPY BOOLEAN
59 -- x_end_date_is_past OUT NOCOPY BOOLEAN
60 -- x_download_in_process OUT NOCOPY BOOLEAN
61 -- x_prompt_to_reclose OUT NOCOPY BOOLEAN
62 -- x_return_status OUT NOCOPY VARCHAR2
63 -- Version : Current version 1.0
64 -- Initial version 1.0
65 -- End of comments
66 PROCEDURE Verify_PeriodClose(
67 p_api_version IN NUMBER,
68 p_org_id IN NUMBER,
69 p_closing_acct_period_id IN NUMBER,
70 p_closing_end_date IN DATE,
71 x_open_period_exists OUT NOCOPY BOOLEAN,
72 x_proper_order OUT NOCOPY BOOLEAN,
73 x_end_date_is_past OUT NOCOPY BOOLEAN,
74 x_prompt_to_reclose OUT NOCOPY BOOLEAN,
75 x_return_status OUT NOCOPY VARCHAR2
76 );
77
78 -- Start of comments
79 -- API name : Close_Period
80 -- Type : Public
81 -- Pre-reqs : None
82 -- Function : Closes a period and transfers to GL.
83 -- Parameters : p_api_version IN NUMBER Required
84 -- p_org_id IN NUMBER
85 -- p_user_id IN NUMBER
86 -- p_login_id IN NUMBER
87 -- p_closing_acct_period_id IN NUMBER
88 -- p_period_close_date IN DATE
89 -- p_schedule_close_date IN DATE
90 -- p_closing_rowid IN VARCHAR2
91 -- x_wip_failed IN OUT NOCOPY BOOLEAN
92 -- x_close_failed OUT NOCOPY BOOLEAN
93 -- x_download_failed OUT NOCOPY BOOLEAN
94 -- x_req_id IN OUT NOCOPY NUMBER
95 -- x_return_status OUT NOCOPY VARCHAR2
96 -- Version : Current version 1.0
97 -- Initial version 1.0
98 -- End of comments
99 PROCEDURE Close_Period(
100 p_api_version IN NUMBER,
101 p_org_id IN NUMBER,
102 p_user_id IN NUMBER,
103 p_login_id IN NUMBER,
104 p_closing_acct_period_id IN NUMBER,
105 p_period_close_date IN DATE,
106 p_schedule_close_date IN DATE,
107 x_close_failed OUT NOCOPY BOOLEAN,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_req_id OUT NOCOPY NUMBER
110 );
111
112 PROCEDURE get_prev_inv_period_status(
113 p_legal_entity_id IN VARCHAR2,
114 p_cost_type_id IN VARCHAR2,
115 p_period_end_date IN DATE,
116 x_close_status OUT NOCOPY BOOLEAN,
117 x_inv_period_year OUT NOCOPY NUMBER,
118 x_inv_period_num OUT NOCOPY NUMBER,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_errbuf OUT NOCOPY VARCHAR2
121 );
122
123 END GMF_PeriodClose_PUB;
124