PACKAGE: APPS.WSMPWROT

Source

1 PACKAGE WSMPWROT AUTHID CURRENT_USER as
2 /* $Header: WSMWROTS.pls 115.10 2004/06/16 05:27:25 mprathap ship $ */
3 --BA Phantom project
4 EXPLOSION_GROUP_ID NUMBER;
5 USE_PHANTOM_ROUTINGS NUMBER;
6 --Sortwidth is changed from 4 to 7 for bug 3673369
7 --X_SortWidth NUMBER:=4;/*to be replaced with the bom profile value*/
8 X_SortWidth NUMBER:=7;/*to be replaced with the bom profile value*/
9 --EA Phantom project
10 
11 PROCEDURE POPULATE_WRO (
12 	       p_first_flag IN NUMBER,
13                p_wip_entity_id IN NUMBER,
14                p_organization_id IN NUMBER,
15                p_assembly_item_id IN NUMBER,
16 	       p_bom_revision_date IN DATE,
17 	       p_alt_bom IN VARCHAR2,
18 	       p_quantity IN NUMBER,
19 	       p_operation_sequence_id IN NUMBER,	-- BA: NSO-WLT
20 	       p_charges_exist	IN NUMBER DEFAULT NULL, -- DEF ENH 0 ,-- EA: NSO-WLT
21 	       x_err_code OUT NOCOPY NUMBER,
22 	       x_err_msg OUT NOCOPY VARCHAR2,
23 /*BA2090293*/
24 		p_routing_revision_date IN DATE DEFAULT NULL, -- DEF ENH SYSDATE,
25 		p_wip_supply_type IN NUMBER DEFAULT NULL ); -- DEF ENH 7);
26 /*EA2090293*/
27 
28 PROCEDURE POPULATE_WRO (
29 	       p_first_flag IN NUMBER,
30                p_wip_entity_id IN NUMBER,
31                p_organization_id IN NUMBER,
32                p_assembly_item_id IN NUMBER,
33 	       p_bom_revision_date IN DATE,
34 	       p_alt_bom IN VARCHAR2,
35 	       p_quantity IN NUMBER,
36 	       p_operation_sequence_id IN NUMBER,	-- BA: NSO-WLT
37 	       p_charges_exist	IN NUMBER DEFAULT NULL, -- DEF ENH 0, -- EA: NSO-WLT
38 	       x_err_code OUT NOCOPY NUMBER,
39 	       x_err_msg OUT NOCOPY VARCHAR2,
40 /*BA2090293*/
41 		p_routing_revision_date IN DATE DEFAULT NULL, -- DEF ENH SYSDATE,
42 		p_wip_supply_type IN NUMBER DEFAULT NULL, -- DEF ENH 7,
43 /*EA2090293*/
44 		p_routing_sequence_id IN NUMBER );  --bug 2445489
45 
46 
47 FUNCTION GET_EXPLOSION_GROUP_ID
48 RETURN NUMBER;
49 
50 PROCEDURE SET_EXPLOSION_GROUP_ID_NULL;
51 
52 END  WSMPWROT;
53 
54