1 PACKAGE wip_jobclose_priv AS
2 /* $Header: wipjclps.pls 120.0.12010000.1 2008/07/24 05:23:01 appldev ship $ */
3
4 /*************************************************************************
5 *
6 * procedure WIP_CLOSE_MGR
7 *
8 *************************************************************************
9 * This procedure will be used to create an executable file that
10 * will be called from Close Manager.
11 *
12 * PARAMETER:
13 *
14 * errbuf error messages
15 * retcode return status. 0 for success, 1 for warning and
16 * 2 for error.
17 * p_organization_id Organization Id.
18 *
19 * p_class_type Accounting Class type - Standard Discrete,
20 * Asset Non Standard , Expense non Std ,etc
21 * p_from_class To select a range of accounting classes ,a
22 * a select From range of class and
23 * p_to_class a select To range of class is used.
24 *
25 * p_from_job ,p_to_job To select a range of jobs for closure ,a
26 * From job and To Job is used.
27 * p_from_release_date ,
28 * p_to_release_date To select a range of jobs for closure between the
29 * specified job release dates .
30 * p_from_start_date ,
31 * p_to_start_date To select a range of jobs for closure between the
32 * specified job start dates .
33 * p_from_completion_date ,
34 * p_to_completion_date To select a range of jobs for closure between the
35 * specified job completion dates .
36 * p_status The various statuses of Jobs like RELEASED, COMPLETE
37 * COMPLETE NO CHARGES , ON HOLD , FAILED CLOSE , etc
38 * p_group_id group_id in WIP_DJ_CLOSE_TEMP
39 *
40 * p_exclude_reserved_jobs Decides if we can select reserved jobs
41 *
42 * p_exclude_pending_txn_jobs Decides if we can select jobs with pending
43 * transactions
44 * p_report_type The various report types like SUMMARY , NO REPORT ,
45 * DETAIL USING PLANNED START QUANTITY , etc
46 * p_act_close_date Actual close date of the Job.
47 *
48 *
49 ***************************************************************************/
50
51
52 procedure WIP_CLOSE_MGR
53 (
54 ERRBUF OUT NOCOPY VARCHAR2 ,
55 RETCODE OUT NOCOPY VARCHAR2 ,
56 p_organization_id IN NUMBER ,
57 p_class_type IN VARCHAR2 ,
58 p_from_class IN VARCHAR2 ,
59 p_to_class IN VARCHAR2 ,
60 p_from_job IN VARCHAR2 ,
61 p_to_job IN VARCHAR2 ,
62 p_from_release_date IN VARCHAR2 ,
63 p_to_release_date IN VARCHAR2 ,
64 p_from_start_date IN VARCHAR2 ,
65 p_to_start_date IN VARCHAR2 ,
66 p_from_completion_date IN VARCHAR2 ,
67 p_to_completion_date IN VARCHAR2 ,
68 p_status IN VARCHAR2 ,
69 p_group_id IN NUMBER ,
70 p_select_jobs IN NUMBER ,
71 p_exclude_reserved_jobs IN VARCHAR2 ,
72 p_uncompleted_jobs IN VARCHAR2,
73 p_exclude_pending_txn_jobs IN VARCHAR2 ,
74 p_report_type IN VARCHAR2 ,
75 p_act_close_date IN VARCHAR2
76
77 );
78
79
80 /***************************************************************************
81 *
82 * procedure WIP_CLOSE
83 *
84 ***************************************************************************
85 * This procedure is the new close job processor. This procedure is equivalent
86 * to wicdcl.ppc. This procedure will be used to create an executable file that
87 * will be called from Close Manager.
88 *
89 * PARAMETER:
90 *
91 * p_organization_id Organization Id.
92 *
93 * p_class_type Accounting Class type - Standard Discrete,
94 * Asset Non Standard , Expense non Std ,etc
95 * p_from_class To select a range of accounting classes ,a
96 * a select From range of class and
97 * p_to_class a select To range of class is used.
98 *
99 * p_from_job ,p_to_job To select a range of jobs for closure ,a
100 * From job and To Job is used.
101 * p_from_release_date ,
102 * p_to_release_date To select a range of jobs for closure between the
103 * specified job release dates .
104 * p_from_start_date ,
105 * p_to_start_date To select a range of jobs for closure between the
106 * specified job start dates .
107 * p_from_completion_date ,
108 * p_to_completion_date To select a range of jobs for closure between the
109 * specified job completion dates .
110 * p_status The various statuses of Jobs like RELEASED, COMPLETE
111 * COMPLETE NO CHARGES , ON HOLD , FAILED CLOSE , etc
112 * p_group_id group_id in WIP_DJ_CLOSE_TEMP
113 *
114 * p_exclude_reserved_jobs Decides if we can select reserved jobs
115 *
116 * p_exclude_pending_txn_jobs Decides if we can select jobs with pending
117 * transactions
118 * p_report_type The various report types like SUMMARY , NO REPORT ,
119 * DETAIL USING PLANNED START QUANTITY , etc
120 * p_act_close_date Actual close date of the Job.
121 *
122 *
123 ***************************************************************************/
124
125 procedure WIP_CLOSE
126 (
127 p_organization_id IN NUMBER ,
128 p_class_type IN VARCHAR2 ,
129 p_from_class IN VARCHAR2 ,
130 p_to_class IN VARCHAR2 ,
131 p_from_job IN VARCHAR2 ,
132 p_to_job IN VARCHAR2 ,
133 p_from_release_date IN VARCHAR2 ,
134 p_to_release_date IN VARCHAR2 ,
135 p_from_start_date IN VARCHAR2 ,
136 p_to_start_date IN VARCHAR2 ,
137 p_from_completion_date IN VARCHAR2 ,
138 p_to_completion_date IN VARCHAR2 ,
139 p_status IN VARCHAR2 ,
140 p_group_id IN NUMBER ,
141 p_select_jobs IN NUMBER ,
142 p_exclude_reserved_jobs IN VARCHAR2 ,
143 p_uncompleted_jobs IN VARCHAR2,
144 p_exclude_pending_txn_jobs IN VARCHAR2 ,
145 p_report_type IN VARCHAR2 ,
146 p_act_close_date IN VARCHAR2 ,
147 x_warning OUT NOCOPY NUMBER ,
148 x_returnStatus OUT NOCOPY VARCHAR2
149 );
150
151 END wip_jobclose_priv;