PACKAGE: APPS.WSM_MES_UTILITIES_PVT

Source

1 PACKAGE WSM_MES_UTILITIES_PVT AUTHID CURRENT_USER AS
2 /* $Header: WSMMESUS.pls 120.5 2006/08/10 09:13:23 mprathap noship $ */
3 
4 mrp_debug      varchar2(1):= fnd_profile.value('mrp_debug');
5 
6 
7 /*
8  * Will return a codemask, indicate whether move in, move out, move to next is allowed
9  *
10  * 2^16 = 65536     move in
11  * 2^17 = 131072    move out
12  * 2^18 = 262144    move to next op
13  */
14 function move_txn_allowed(
15             p_responsibility_id         in number,
16             p_wip_entity_id             in number,
17             p_org_id                    in number,
18             p_job_op_seq_num            in number,
19             p_standard_op_id            in number,
20             p_intraop_step              in number,
21             p_status_type               in number
22 ) return number;
23 
24 
25 /*
26  * Will return 1 if allowed, 0 otherwise
27  *
28  * p_transaction_type:
29  *
30  * 2^4  = 16            Split Job
31  * 2^5  = 32            Merge Jobs
32  * 2^6  = 64            Update Assembly
33  * 2^7  = 128           Update Routing
34  * 2^8  = 256           Update Lot Name
35  * 2^9  = 512           Update Quantity
36  * 2^10 = 1024          Transact Materials
37  * 2^11 = 2048          Jump To Operation
38  * 2^12 = 4096          Undo Move
39  */
40 procedure wsm_transaction_allowed(
41             p_transaction_type          in number,
42             p_responsibility_id         in number,
43             p_wip_entity_id             in number,
44             p_org_id                    in number,
45             p_job_op_seq_num            in number,
46             p_standard_op_id            in number,
47             p_intraop_step              in number,
48             p_status_type               in number,
49             x_allowed                   out nocopy number,
50             x_error_msg_name            out nocopy varchar2
51 );
52 
53 /*
54  * Will return 1 if job status changed, 0 otherwise
55  */
56 function wsm_job_changed(
57             p_wip_entity_id             in number,
58             p_job_op_seq_num            in number,
59             p_intraop_step              in number,
60             p_status_type               in number,
61             p_quantity                  in number,
62             p_job_name                  in varchar2
63 ) return number;
64 
65 
66 /*
67  * find corrent job operations for that is with a give resource / instance
68  */
69 function get_current_job_op (
70         p_organization_id               in number,
71         p_department_id                 in number,
72         p_resource_id                   in number,
73         p_instance_id                   in number,
74         p_serial_number                 in varchar2) return varchar2;
75 
76 /*
77  * Bugfix 5356648 OSP warnings.  Check for po reqs and orders.
78  */
79 function check_po_req_exists(
80 	p_txn_type			in number,
81 	p_wip_entity_id			in number) return number;
82 --Bug 5409116: Function to get the share_from_dept_id of a given
83 --resource and department is added.
84 function get_share_from_dept(
85         p_department_id                 in number,
86         p_resource_id                   in number) return number;
87 
88 END;