PACKAGE: APPS.WIP_WS_EXCEPTIONS

Source

1 package WIP_WS_EXCEPTIONS as
2 /* $Header: wipvexcs.pls 120.1 2005/10/19 05:01:46 amgarg noship $ */
3 
4  /*
5   * Close all exceptions for a Job
6   */
7   function close_exception_job
8   (
9     p_wip_entity_id number,
10     p_organization_id number
11   ) return boolean;
12 
13  /*
14   * Close exception for a Job Op combination
15   */
16   function close_exception_jobop
17   (
18     p_wip_entity_id number,
19     p_operation_seq_num number,
20     p_organization_id number
21   ) return boolean;
22 
23  /*
24   * Close exception for a Job Op combination
25   * check if department changed, close exception.
26   */
27   function close_exception_jobop
28   (
29     p_wip_entity_id number,
30     p_operation_seq_num number,
31     p_department_id number,
32     p_organization_id number
33   ) return boolean;
34 
35  /*
36   * Close exception for a Job,Op,Res combination
37   */
38   function close_exception_jobop_res
39   (
40     p_wip_entity_id number,
41     p_operation_seq_num number,
42     p_resource_seq_num number,
43     p_organization_id number
44   ) return boolean;
45 
46  /*
47   * Close exception for a Job,Op,Res combination.
48   * Check if resource Id changed, only then close exceptions.
49   */
50   function close_exception_jobop_res
51   (
52     p_wip_entity_id number,
53     p_operation_seq_num number,
54     p_resource_seq_num number,
55     p_resource_id number,
56     p_organization_id number
57   ) return boolean;
58 
59  /*
60   * Close exception for a Job,Op,Res combination
61   * Check if either resource_id changed or department_id changed, close exceptions
62   */
63   function close_exception_jobop_res
64   (
65     p_wip_entity_id number,
66     p_operation_seq_num number,
67     p_resource_seq_num number,
68     p_resource_id number,
69     p_department_code varchar2,
70     p_organization_id number
71   ) return boolean;
72 
73  /*
74   * Close exception for a Job,Op,Replacement Group Num combination
75   * Resolves exception when altenates are assigned.
76   */
77   function close_exception_alt_res
78   (
79     p_wip_entity_id number,
80     p_operation_seq_num number,
81     p_substitute_group_num number,
82     p_organization_id number
83   ) return boolean;
84 
85  /*
86   * Close exception for a Job,Op,Res Instance combination
87   * when doing a res Instance deleted
88   * Serial Number field won't be used.
89   */
90   function close_exception_res_instance
91   (
92     p_wip_entity_id number,
93     p_operation_seq_num number,
94     p_resource_seq_num number,
95     p_instance_id number,
96     p_serial_number varchar2,
97     p_organization_id number
98   ) return boolean;
99 
100  /*
101   * Close exception for a Job,Op,Res Instance combination
102   * Closes exception when a Res Instance is Updated.
103   * Check if Serial_Number is changed, close exception.
104   */
105   function close_exp_res_instance_update
106   (
107     p_wip_entity_id number,
108     p_operation_seq_num number,
109     p_resource_seq_num number,
110     p_instance_id number,
111     p_serial_number varchar2,
112     p_organization_id number
113   ) return boolean;
114 
115  /*
116   * Close exception for a Job:Op component.
117   * component_item_id is inventory_item_id from WRO.
118   */
119   function close_exception_component
120   (
121     p_wip_entity_id number,
122     p_operation_seq_num number,
123     p_component_item_id number,
124     p_organization_id number
125   ) return boolean;
126 
127  /*
128   * Close exception for this exception_id.
129   */
130   function close_exception
131   (
132     p_exception_id number
133   ) return boolean;
134 
135  /*
136   * Delete exception for a Job:Op combination.
137   */
138   function delete_exception_jobop
139   (
140     p_wip_entity_id number,
141     p_operation_seq_num number,
142     p_organization_id number
143   ) return boolean;
144 
145  /*
146   * Delete all exceptions for a Job.
147   */
148   function delete_exception_job
149   (
150     p_wip_entity_id number,
151     p_organization_id number
152   ) return boolean;
153 
154 
155 end WIP_WS_EXCEPTIONS;
156