PACKAGE: APPS.WIP_COMPONENT

Source

1 PACKAGE WIP_COMPONENT as
2 /* $Header: wipfnmts.pls 120.2 2005/06/17 12:52:59 appldev  $ */
3 
4 /* Returns WIP_CONSTANTS.YES if a component should be picked up in
5    populate temp based on the action, supply type, and quantities required
6    and issued.
7    Otherwise returns WIP_CONSTANTS.NO
8 */
9 FUNCTION IS_VALID
10 (p_transaction_action_id NUMBER,
11  p_wip_supply_type NUMBER,
12  p_required_quantity NUMBER,
13  p_quantity_issued NUMBER,
14  p_assembly_quantity NUMBER,
15  p_entity_type NUMBER) RETURN NUMBER;
16 
17 PRAGMA RESTRICT_REFERENCES(is_valid, WNDS, WNPS);
18 
19 /* Returns WIP_CONSTANTS.YES if the component satisfies all criteria
20    a user might have entered in the material transactions window.  Otherwise,
21    returns WIP_CONSTANTS.NO
22 */
23 FUNCTION MEETS_CRITERIA
24 (req_op_seq NUMBER,
25  crit_op_seq NUMBER,
26  req_dept_id NUMBER,
27  crit_dept_id NUMBER,
28  req_sub VARCHAR2,
29  crit_sub VARCHAR2) RETURN NUMBER;
30 
31 PRAGMA RESTRICT_REFERENCES(meets_criteria, WNDS, WNPS);
32 
33 /* Returns the proper deafult transaction quantity based on the
34    Transaction action, Requirement quantities, and optional assembly quantity
35  */
36  /* ER 4369064: Component Yield Enhancement */
37  /* Added two new parameters include_yield and component_yield_factor */
38 FUNCTION Determine_Txn_Quantity
39                 (transaction_action_id IN NUMBER,
40                  qty_per_assembly IN NUMBER,
41                  required_qty IN NUMBER,
42                  qty_issued IN NUMBER,
43                  assembly_qty IN NUMBER,
44                  include_yield IN NUMBER,
45                  component_yield_factor IN NUMBER,
46                  basis_type IN NUMBER DEFAULT NULL ) RETURN NUMBER; /* LBM Project */
47 
48 PRAGMA RESTRICT_REFERENCES(Determine_Txn_Quantity, WNDS, WNPS, TRUST);  /* LBM Project */
49 
50 /* Returns  'Y' or 'N' depending on whether the subinventory, item, org
51    combination is valid */
52 
53 FUNCTION Valid_Subinventory
54 		(p_subinventory IN VARCHAR2,
55 		 p_item_id IN NUMBER,
56 		 p_org_id IN NUMBER) RETURN VARCHAR2;
57 
58 PRAGMA RESTRICT_REFERENCES(Valid_Subinventory, WNDS, WNPS);
59 
60 /* Returns  'Y' or 'N' depending on whether the subinventory, item, org
61    and locator combination is valid */
62 
63 FUNCTION Valid_Locator
64 		(p_locator_id IN OUT NOCOPY NUMBER,
65 		 p_item_id IN NUMBER,
66 		 p_org_id IN NUMBER,
67                  p_org_control IN NUMBER,
68                  p_sub_control IN NUMBER,
69                  p_item_control IN NUMBER,
70                  p_restrict_locators_code IN NUMBER,
71                  p_loc_disable_date IN DATE,
72                  p_locator_control OUT NOCOPY NUMBER
73 		 ) RETURN VARCHAR2;
74 
75 END WIP_COMPONENT;