1 PACKAGE WSH_TRXLOTS_HANDLER AUTHID CURRENT_USER AS
2 /* $Header: WSHIIXLS.pls 120.0 2005/05/26 19:32:22 appldev noship $ */
3
4 -- ===========================================================================
5 --
6 -- Name:
7 --
8 -- insert_row
9 --
10 -- Description:
11 --
12 -- Called by the client to insert a row into the
13 -- MTL_TRANSACTION_LOTS_INTERFACE table.
14 --
15 -- ===========================================================================
16
17 PROCEDURE Insert_Row(
18 x_rowid IN OUT NOCOPY VARCHAR2,
19 x_trx_interface_id IN OUT NOCOPY NUMBER,
20 p_source_code IN VARCHAR2,
21 p_source_line_id IN NUMBER,
22 p_lot_number IN VARCHAR2,
23 p_trx_quantity IN NUMBER,
24 p_last_update_date IN DATE,
25 p_last_updated_by IN NUMBER,
26 p_creation_date IN DATE,
27 p_created_by IN NUMBER,
28 p_serial_trx_id IN NUMBER,
29 p_error_code IN VARCHAR2,
30 p_last_update_login IN NUMBER DEFAULT NULL,
31 p_request_id IN NUMBER DEFAULT NULL,
32 p_program_application_id IN NUMBER DEFAULT NULL,
33 p_program_id IN NUMBER DEFAULT NULL,
34 p_program_update_date IN DATE DEFAULT NULL,
35 p_lot_expiration_date IN DATE DEFAULT NULL,
36 p_primary_quantity IN NUMBER DEFAULT NULL,
37 p_process_flag IN VARCHAR2 DEFAULT 'Y',
38 -- HW OPMCONV. Added p_secondary_trx_quantity
39 -- and p_grade_code
40 p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
41 p_grade_code IN VARCHAR2 DEFAULT NULL
42 );
43
44
45 -- ===========================================================================
46 --
47 -- Name:
48 --
49 -- update_row
50 --
51 -- Description:
52 --
53 -- Called by the client to update a row in the
54 -- MTL_TRANSACTION_LOTS_INTERFACE table.
55 --
56 -- ===========================================================================
57
58 PROCEDURE Update_Row (
59 x_rowid IN OUT NOCOPY VARCHAR2,
60 p_trx_interface_id IN NUMBER,
61 p_source_code IN VARCHAR2,
62 p_source_line_id IN NUMBER,
63 p_lot_number IN VARCHAR2,
64 p_trx_quantity IN NUMBER,
65 p_last_update_date IN DATE,
66 p_last_updated_by IN NUMBER,
67 p_serial_trx_id IN NUMBER,
68 p_error_code IN VARCHAR2,
69 p_last_update_login IN NUMBER DEFAULT NULL,
70 p_request_id IN NUMBER DEFAULT NULL,
71 p_program_application_id IN NUMBER DEFAULT NULL,
72 p_program_id IN NUMBER DEFAULT NULL,
73 p_program_update_date IN DATE DEFAULT NULL,
74 p_lot_expiration_date IN DATE DEFAULT NULL,
75 p_primary_quantity IN NUMBER DEFAULT NULL,
76 p_process_flag IN VARCHAR2 DEFAULT 'Y',
77 -- HW OPMCONV. Added p_secondary_trx_quantity
78 -- and p_grade_code
79 p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
80 p_grade_code IN VARCHAR2 DEFAULT NULL);
81
82 -- ===========================================================================
83 --
84 -- Name:
85 --
86 -- delete_row
87 --
88 -- Description:
89 --
90 -- Called by the client to delete a row in the
91 -- MTL_TRANSACTION_LOTS_INTERFACE table.
92 --
93 -- ===========================================================================
94
95 PROCEDURE Delete_Row (
96 x_rowid IN OUT NOCOPY VARCHAR2 );
97
98 -- ===========================================================================
99 --
100 -- Name:
101 --
102 -- lock_row
103 --
104 -- Description:
105 --
106 -- Called by the client to lock a row in the
107 -- MTL_TRANSACTION_LOTS_INTERFACE table.
108 --
109 -- ===========================================================================
110
111 PROCEDURE Lock_Row (
112 x_rowid IN OUT NOCOPY VARCHAR2,
113 p_source_code IN VARCHAR2,
114 p_source_line_id IN NUMBER,
115 p_trx_interface_id IN NUMBER,
116 p_lot_number IN VARCHAR2,
117 p_trx_quantity IN NUMBER,
118 p_lot_expiration_date IN DATE,
119 p_primary_quantity IN NUMBER,
120 p_serial_trx_id IN NUMBER,
121 p_error_code IN VARCHAR2,
122 p_process_flag IN VARCHAR2,
123 -- HW OPMCONV. Added p_secondary_trx_quantity
124 -- and p_grade_code
125 p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
126 p_grade_code IN VARCHAR2 DEFAULT NULL );
127
128 --HVOP heali
129 PROCEDURE INSERT_ROW_BULK (
130 p_mtl_lot_txn_if_rec IN WSH_SHIP_CONFIRM_ACTIONS.mtl_lot_txn_if_rec_type,
131 x_return_status OUT NOCOPY VARCHAR2);
132 --HVOP heali
133
134 END WSH_TRXLOTS_HANDLER;