1 PACKAGE CSTPPPSC AUTHID CURRENT_USER AS
2 /* $Header: CSTPPSCS.pls 120.1 2005/06/30 17:02:55 bkuntz noship $ */
3
4 PROCEDURE open_period (
5 l_entity_id IN NUMBER,
6 l_cost_type_id IN NUMBER,
7 l_user_id IN NUMBER,
8 l_login_id IN NUMBER,
9 open_period_name IN VARCHAR2,
10 open_period_num IN NUMBER,
11 open_period_year IN NUMBER,
12 open_period_set_name IN VARCHAR2,
13 open_period_type IN VARCHAR2,
14 last_scheduled_close_date IN OUT NOCOPY DATE,
15 l_period_end_date IN DATE,
16
17 prior_open_period OUT NOCOPY BOOLEAN,
18 improper_order OUT NOCOPY BOOLEAN,
19 new_pac_period_id OUT NOCOPY NUMBER,
20 duplicate_open_period OUT NOCOPY BOOLEAN,
21 undefined_cost_groups OUT NOCOPY BOOLEAN,
22 user_defined_error OUT NOCOPY BOOLEAN,
23 commit_complete OUT NOCOPY BOOLEAN
24 );
25
26 PROCEDURE validate_open_period (
27 l_entity_id IN NUMBER,
28 l_cost_type_id IN NUMBER,
29 l_user_id IN NUMBER,
30 l_login_id IN NUMBER,
31 open_period_name IN VARCHAR2,
32 open_period_num IN NUMBER,
33 open_period_year IN NUMBER,
34 open_period_set_name IN VARCHAR2,
35 open_period_type IN VARCHAR2,
36 last_scheduled_close_date IN OUT NOCOPY DATE,
37 l_period_end_date IN DATE,
38
39 prior_open_period OUT NOCOPY BOOLEAN,
40 improper_order OUT NOCOPY BOOLEAN,
41 new_pac_period_id OUT NOCOPY NUMBER,
42 duplicate_open_period OUT NOCOPY BOOLEAN,
43 undefined_cost_groups OUT NOCOPY BOOLEAN,
44 user_defined_error OUT NOCOPY BOOLEAN,
45 commit_complete OUT NOCOPY BOOLEAN
46 );
47
48
49 PROCEDURE api_close_period(
50 errbuf OUT NOCOPY VARCHAR2,
51 retcode OUT NOCOPY NUMBER,
52 l_entity_id IN NUMBER,
53 l_cost_type_id IN NUMBER,
54 closing_pac_period_id IN NUMBER,
55 closing_period_type IN VARCHAR2,
56 l_closing_end_date IN VARCHAR2,
57 l_user_id IN NUMBER,
58 l_login_id IN NUMBER,
59 l_last_scheduled_close_date IN VARCHAR2
60 );
61
62
63
64 PROCEDURE close_period (
65 l_entity_id IN NUMBER,
66 l_cost_type_id IN NUMBER,
67 closing_pac_period_id IN NUMBER,
68 closing_period_type IN VARCHAR2,
69 closing_end_date IN DATE,
70 l_user_id IN NUMBER,
71 l_login_id IN NUMBER,
72
73 last_scheduled_close_date IN OUT NOCOPY DATE,
74 end_date_is_passed OUT NOCOPY BOOLEAN,
75 incomplete_processing OUT NOCOPY BOOLEAN,
76 pending_transactions OUT NOCOPY BOOLEAN,
77 rerun_processor OUT NOCOPY BOOLEAN,
78 prompt_to_reclose OUT NOCOPY BOOLEAN,
79 undefined_cost_groups OUT NOCOPY BOOLEAN,
80 backdated_transactions OUT NOCOPY BOOLEAN,
81 perpetual_periods_open OUT NOCOPY BOOLEAN,
82 ap_period_open OUT NOCOPY BOOLEAN,
83 ar_period_open OUT NOCOPY BOOLEAN,
84 cogsgen_phase2_notrun OUT NOCOPY BOOLEAN,
85 cogsgen_phase3_notrun OUT NOCOPY BOOLEAN,
86 user_defined_error OUT NOCOPY BOOLEAN,
87 commit_complete OUT NOCOPY BOOLEAN,
88 req_id OUT NOCOPY NUMBER
89 );
90
91 PROCEDURE validate_close_period (
92 l_entity_id IN NUMBER,
93 l_cost_type_id IN NUMBER,
94 closing_pac_period_id IN NUMBER,
95 closing_period_type IN VARCHAR2,
96 closing_end_date IN DATE,
97 l_user_id IN NUMBER,
98 l_login_id IN NUMBER,
99
100 last_scheduled_close_date IN OUT NOCOPY DATE,
101 end_date_is_passed OUT NOCOPY BOOLEAN,
102 incomplete_processing OUT NOCOPY BOOLEAN,
103 pending_transactions OUT NOCOPY BOOLEAN,
104 rerun_processor OUT NOCOPY BOOLEAN,
105 prompt_to_reclose OUT NOCOPY BOOLEAN,
106 undefined_cost_groups OUT NOCOPY BOOLEAN,
107 backdated_transactions OUT NOCOPY BOOLEAN,
108 perpetual_periods_open OUT NOCOPY BOOLEAN,
109 ap_period_open OUT NOCOPY BOOLEAN,
110 ar_period_open OUT NOCOPY BOOLEAN,
111 cogsgen_phase2_notrun OUT NOCOPY BOOLEAN,
112 cogsgen_phase3_notrun OUT NOCOPY BOOLEAN,
113 user_defined_error OUT NOCOPY BOOLEAN,
114 commit_complete OUT NOCOPY BOOLEAN
115 );
116
117
118 END CSTPPPSC;