1 PACKAGE EAM_JOBCLOSE_PRIV AUTHID CURRENT_USER AS
2 /* $Header: EAMJCLPS.pls 120.0.12010000.2 2008/11/06 23:48:57 mashah ship $ */
3
4 /*************************************************************************
5 *
6 * procedure EAM_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 EAM_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 PROCEDURE EAM_CLOSE_WO
81 (
82 p_submission_date IN DATE,
83 p_organization_id IN NUMBER,
84 p_group_id IN NUMBER,
85 p_select_jobs IN NUMBER,
86 p_report_type IN VARCHAR2,
87 x_request_id OUT NOCOPY NUMBER
88 );
89
90
91 -- This procedure was added to the spec file for a WIP bug 6718091
92 PROCEDURE RAISE_WORKFLOW_STATUS_CHANGED
93 (p_wip_entity_id IN NUMBER,
94 p_wip_entity_name IN VARCHAR2,
95 p_organization_id IN NUMBER,
96 p_new_status IN NUMBER,
97 p_old_system_status IN NUMBER,
98 p_old_wo_status IN NUMBER,
99 p_workflow_type IN NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2
101 );
102
103
104 END EAM_JOBCLOSE_PRIV;