1 PACKAGE WSH_TRXLOTS_HANDLER_TEST AUTHID CURRENT_USER AS
2 /* $Header: WSHTESTS.pls 115.2 2003/12/01 18:47:31 heali 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
39 -- ===========================================================================
40 --
41 -- Name:
42 --
43 -- update_row
44 --
45 -- Description:
46 --
47 -- Called by the client to update a row in the
48 -- MTL_TRANSACTION_LOTS_INTERFACE table.
49 --
50 -- ===========================================================================
51
52 PROCEDURE Update_Row (
53 x_rowid IN OUT NOCOPY VARCHAR2,
54 p_trx_interface_id IN NUMBER,
55 p_source_code IN VARCHAR2,
56 p_source_line_id IN NUMBER,
57 p_lot_number IN VARCHAR2,
58 p_trx_quantity IN NUMBER,
59 p_last_update_date IN DATE,
60 p_last_updated_by IN NUMBER,
61 p_serial_trx_id IN NUMBER,
62 p_error_code IN VARCHAR2,
63 p_last_update_login IN NUMBER DEFAULT NULL,
64 p_request_id IN NUMBER DEFAULT NULL,
65 p_program_application_id IN NUMBER DEFAULT NULL,
66 p_program_id IN NUMBER DEFAULT NULL,
67 p_program_update_date IN DATE DEFAULT NULL,
68 p_lot_expiration_date IN DATE DEFAULT NULL,
69 p_primary_quantity IN NUMBER DEFAULT NULL,
70 p_process_flag IN VARCHAR2 DEFAULT 'Y');
71
72 -- ===========================================================================
73 --
74 -- Name:
75 --
76 -- delete_row
77 --
78 -- Description:
79 --
80 -- Called by the client to delete a row in the
81 -- MTL_TRANSACTION_LOTS_INTERFACE table.
82 --
83 -- ===========================================================================
84
85 PROCEDURE Delete_Row (
86 x_rowid IN OUT NOCOPY VARCHAR2 );
87
88 -- ===========================================================================
89 --
90 -- Name:
91 --
92 -- lock_row
93 --
94 -- Description:
95 --
96 -- Called by the client to lock a row in the
97 -- MTL_TRANSACTION_LOTS_INTERFACE table.
98 --
99 -- ===========================================================================
100
101 PROCEDURE Lock_Row (
102 x_rowid IN OUT NOCOPY VARCHAR2,
103 p_source_code IN VARCHAR2,
104 p_source_line_id IN NUMBER,
105 p_trx_interface_id IN NUMBER,
106 p_lot_number IN VARCHAR2,
107 p_trx_quantity IN NUMBER,
108 p_lot_expiration_date IN DATE,
109 p_primary_quantity IN NUMBER,
110 p_serial_trx_id IN NUMBER,
111 p_error_code IN VARCHAR2,
112 p_process_flag IN VARCHAR2 );
113
114 END WSH_TRXLOTS_HANDLER_TEST;