1 PACKAGE RCV_PROCESSOR_PVT AUTHID CURRENT_USER AS
2 /* $Header: RCVPROCS.pls 115.5 2003/10/02 15:17:16 pparthas noship $ */
3 --
4 -- Purpose: APIs called from the receiving processor.
5 --
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- pparthas 08/31/01 Created Package
10 --
11 --
12 cursor lpn_grps_cur (x_request_id number, x_group_id NUMBER) is
13 select distinct lpn_group_id
14 from rcv_transactions_interface
15 where (processing_request_id is null or processing_request_id=x_request_id)
16 and group_id = decode(x_group_id, 0, group_id, x_group_id)
17 and processing_status_code = 'RUNNING'
18 and lpn_group_id is not null;
19
20 PROCEDURE INSERT_RCV_LOTS_SUPPLY
21 (
22 p_api_version IN NUMBER ,
23 p_Init_Msg_List IN VARCHAR2 ,
24 x_return_status OUT NOCOPY VARCHAR2,
25 p_interface_transaction_id IN NUMBER ,
26 p_shipment_line_id IN NUMBER ,
27 p_supply_source_id IN NUMBER,
28 p_source_type_code IN VARCHAR2,
29 p_transaction_type IN VARCHAR2);
30
31 PROCEDURE INSERT_RCV_SERIALS_SUPPLY
32 (
33 p_api_version IN NUMBER ,
34 p_Init_Msg_List IN VARCHAR2 ,
35 x_return_status OUT NOCOPY VARCHAR2,
36 p_interface_transaction_id IN NUMBER ,
37 p_shipment_line_id IN NUMBER ,
38 p_supply_source_id IN NUMBER,
39 p_source_type_code IN VARCHAR2,
40 p_transaction_type IN VARCHAR2);
41
42
43 PROCEDURE SPLIT_SERIAL_NUMBER (
44 p_sequence IN VARCHAR2,
45 x_prefix OUT NOCOPY VARCHAR2,
46 x_number OUT NOCOPY NUMBER);
47
48
49 PROCEDURE UPDATE_RCV_LOTS_SUPPLY
50 (
51 p_api_version IN NUMBER ,
52 p_Init_Msg_List IN VARCHAR2 ,
53 x_return_status OUT NOCOPY VARCHAR2,
54 p_interface_transaction_id IN NUMBER,
55 p_transaction_type IN Varchar2,
56 p_shipment_line_id IN number,
57 p_source_type_code IN Varchar2,
58 p_parent_supply_id IN number,
59 p_correction_type IN Varchar2);
60
61
62 PROCEDURE UPDATE_RCV_SERIALS_SUPPLY
63 (
64 p_api_version IN NUMBER ,
65 p_Init_Msg_List IN VARCHAR2 ,
66 x_return_status OUT NOCOPY VARCHAR2,
67 p_interface_transaction_id IN NUMBER,
68 p_transaction_type IN Varchar2,
69 p_shipment_line_id IN number,
70 p_source_type_code IN Varchar2,
71 p_parent_supply_id IN number,
72 p_correction_type IN Varchar2);
73
74
75 PROCEDURE INSERT_LOT_SUPPLY(p_interface_transaction_id IN number,
76 p_supply_type_code IN VARCHAR2,
77 p_supply_source_id IN number,
78 x_return_status OUT NOCOPY VARCHAR2);
79
80 PROCEDURE INSERT_SERIAL_SUPPLY(p_interface_transaction_id IN number,
81 p_lot_number IN Varchar2,
82 p_serial_number IN Varchar2,
83 p_supply_type_code IN VARCHAR2,
84 p_supply_source_id IN number,
85 x_return_status OUT NOCOPY VARCHAR2);
86
87 PROCEDURE INSERT_LOT_TRANSACTIONS(p_interface_transaction_id IN number,
88 p_lot_context IN Varchar2,
89 p_lot_context_id IN number,
90 p_source_transaction_id IN number,
91 p_correction_transaction_id IN number,
92 p_negate_qty IN VARCHAR2,
93 x_return_status OUT NOCOPY VARCHAR2);
94
95 PROCEDURE VALIDATE_LPN_GROUPS ( p_request_id in number,
96 p_group_id in number);
97
98 END RCV_PROCESSOR_PVT;