1 PACKAGE WSMPLBTH AUTHID CURRENT_USER AS
2 /* $Header: WSMLBTHS.pls 115.11 2002/11/13 03:25:50 abedajna ship $ */
3
4
5 FUNCTION Insert_Starting_Lot (
6 p_transaction_type IN NUMBER,
7 p_organization_id IN NUMBER,
8 p_wip_flag IN NUMBER,
9 p_split_flag IN NUMBER,
10 p_lot_number IN VARCHAR2,
11 p_inventory_item_id IN NUMBER,
12 p_quantity IN NUMBER,
13 p_subinventory_code IN VARCHAR2,
14 p_locator_id IN NUMBER,
15 p_revision IN VARCHAR2,
16 X_err_code OUT NOCOPY NUMBER,
17 X_err_msg OUT NOCOPY VARCHAR2
18 )
19 RETURN NUMBER;
20
21 PROCEDURE Insert_Resulting_Lot (
22 p_transaction_id IN NUMBER ,
23 p_lot_number IN VARCHAR2 ,
24 p_inventory_item_id IN NUMBER ,
25 p_organization_id IN NUMBER ,
26 p_quantity IN NUMBER ,
27 p_subinventory_code IN VARCHAR2,
28 p_locator_id IN NUMBER,
29 X_err_code OUT NOCOPY NUMBER,
30 X_err_msg OUT NOCOPY VARCHAR2
31 );
32
33 /* This procedure returns org level information that is needed
34 at startup of the Create Lots form */
35
36 PROCEDURE get_org_values (
37 p_organization_id IN NUMBER,
38 p_acct_period_id OUT NOCOPY NUMBER,
39 p_org_locator_control OUT NOCOPY NUMBER,
40 X_err_code OUT NOCOPY NUMBER,
41 X_err_msg OUT NOCOPY VARCHAR2
42 );
43
44
45 FUNCTION Create_New_Lot (
46 p_source_line_id IN NUMBER,
47 p_organization_id IN NUMBER,
48 p_primary_item_id IN NUMBER,
49 p_job_name IN VARCHAR2,
50 p_start_quantity IN NUMBER,
51 p_net_quantity IN NUMBER, /* APS-1-AM */
52 p_wip_entity_id IN NUMBER,
53 p_completion_subinventory IN VARCHAR2,
54 p_completion_locator_id IN NUMBER,
55 p_alternate_rtg IN VARCHAR2,
56 p_alternate_bom IN VARCHAR2,
57 p_description IN VARCHAR2,
58 p_job_type IN NUMBER,
59 p_bill_sequence_id IN NUMBER,
60 p_routing_sequence_id IN NUMBER,
61 p_bom_revision_date IN DATE,
62 p_routing_revision_date IN DATE,
63 p_bom_revision IN VARCHAR2,
64 p_routing_revision IN VARCHAR2,
65 p_start_date IN DATE,
66 p_complete_date IN DATE,
67 p_class_code IN VARCHAR2,
68 p_wjsi_group_id OUT NOCOPY NUMBER,
69 p_coproducts_supply IN NUMBER, /* APS-1-AM */
70 x_err_code OUT NOCOPY NUMBER,
71 x_err_msg OUT NOCOPY VARCHAR2
72
73 ) RETURN NUMBER ;
74
75
76
77
78 PROCEDURE UPDATE_WRO( p_wip_entity_id NUMBER,
79 p_operation_seq_num NUMBER,
80 p_inventory_item_id NUMBER,
81 x_err_code OUT NOCOPY NUMBER,
82 x_err_msg OUT NOCOPY VARCHAR2 );
83
84
85 /*BA#2326548*/
86 PROCEDURE lot_creation_enter_genealogy(p_transaction_id IN NUMBER,
87 p_organization_id IN NUMBER,
88 p_starting_lot_number IN VARCHAR2,
89 p_source_item_id IN NUMBER,
90 p_resulting_lot_number IN VARCHAR2,
91 p_err_code OUT NOCOPY NUMBER,
92 p_err_msg OUT NOCOPY VARCHAR2);
93 /*EA#2326548*/
94
95
96 END WSMPLBTH;