[Home] [Help]
PACKAGE: APPS.WSH_TRXSN_HANDLER
Source
1 PACKAGE WSH_TRXSN_HANDLER AUTHID CURRENT_USER AS
2 /* $Header: WSHIISNS.pls 115.2 2003/07/08 01:54:41 heali ship $ */
3
4 --
5 -- PACKAGE EXCEPTIONS
6 --
7
8 WSH_FM_SERIALNO_NULL EXCEPTION;
9
10 --
11 -- PUBLIC FUNCTIONS/PROCEDURES
12 --
13
14 -- ===========================================================================
15 --
16 -- Name:
17 --
18 -- insert_row
19 --
20 -- Description:
21 --
22 -- Called by the client to insert a row into the
23 -- MTL_SERIAL_NUMBERS_INTERFACE table.
24 --
25 -- ===========================================================================
26 PROCEDURE Insert_Row (
27 x_rowid IN OUT NOCOPY VARCHAR2,
28 x_trx_interface_id IN OUT NOCOPY NUMBER,
29 p_source_code IN VARCHAR2,
30 p_source_line_id IN NUMBER,
31 p_fm_serial_number IN VARCHAR2,
32 p_to_serial_number IN VARCHAR2,
33 p_creation_date IN DATE,
34 p_created_by IN NUMBER,
35 p_last_updated_by IN NUMBER,
36 p_last_update_date IN DATE,
37 p_last_update_login IN NUMBER DEFAULT NULL,
38 p_request_id IN NUMBER DEFAULT NULL,
39 p_program_application_id IN NUMBER DEFAULT NULL,
40 p_program_id IN NUMBER DEFAULT NULL,
41 p_program_update_date IN DATE DEFAULT NULL,
42 p_parent_serial_number IN VARCHAR2 DEFAULT NULL,
43 p_vendor_serial_number IN VARCHAR2 DEFAULT NULL,
44 p_vendor_lot_number IN VARCHAR2 DEFAULT NULL,
45 p_error_code IN VARCHAR2 DEFAULT NULL,
46 p_process_flag IN NUMBER DEFAULT 1);
47
48 -- ===========================================================================
49 --
50 -- Name:
51 --
52 -- update_row
53 --
54 -- Description:
55 --
56 -- Called by the client to update a row in the
57 -- MTL_SERIAL_NUMBERS_INTERFACE table.
58 --
59 -- ===========================================================================
60
61 PROCEDURE Update_Row (
62 x_rowid IN OUT NOCOPY VARCHAR2,
63 p_trx_interface_id IN NUMBER,
64 p_source_code IN VARCHAR2,
65 p_source_line_id IN NUMBER,
66 p_fm_serial_number IN VARCHAR2,
67 p_to_serial_number IN VARCHAR2,
68 p_last_updated_by IN NUMBER,
69 p_last_update_date IN DATE,
70 p_last_update_login IN NUMBER DEFAULT NULL,
71 p_request_id IN NUMBER DEFAULT NULL,
72 p_program_application_id IN NUMBER DEFAULT NULL,
73 p_program_id IN NUMBER DEFAULT NULL,
74 p_program_update_date IN DATE DEFAULT NULL,
75 p_parent_serial_number IN VARCHAR2 DEFAULT NULL,
76 p_vendor_serial_number IN VARCHAR2 DEFAULT NULL,
77 p_vendor_lot_number IN VARCHAR2 DEFAULT NULL,
78 p_error_code IN VARCHAR2 DEFAULT NULL,
79 p_process_flag IN NUMBER DEFAULT 1);
80
81 -- ===========================================================================
82 --
83 -- Name:
84 --
85 -- delete_row
86 --
87 -- Description:
88 --
89 -- Called by the client to delete a row in the
90 -- MTL_SERIAL_NUMBERS_INTERFACE table.
91 --
92 -- ===========================================================================
93
94 PROCEDURE Delete_Row (
95 x_rowid IN OUT NOCOPY VARCHAR2 );
96
97 -- ===========================================================================
98 --
99 -- Name:
100 --
101 -- lock_row
102 --
103 -- Description:
104 --
105 -- Called by the client to lock a row in the
106 -- MTL_SERIAL_NUMBERS_INTERFACE table.
107 --
108 -- ===========================================================================
109
110 PROCEDURE Lock_Row (
111 x_rowid IN OUT NOCOPY VARCHAR2,
112 p_source_code IN VARCHAR2,
113 p_source_line_id IN NUMBER,
114 p_trx_interface_id IN NUMBER,
115 p_vendor_serial_number IN VARCHAR2,
116 p_vendor_lot_number IN VARCHAR2,
117 p_fm_serial_number IN VARCHAR2,
118 p_to_serial_number IN VARCHAR2,
119 p_error_code IN VARCHAR2,
120 p_process_flag IN NUMBER,
121 p_parent_serial_number IN VARCHAR2 );
122
123 --HVOP heali
124 PROCEDURE INSERT_ROW_BULK (
125 p_mtl_ser_txn_if_rec IN WSH_SHIP_CONFIRM_ACTIONS.mtl_ser_txn_if_rec_type,
126 x_return_status OUT NOCOPY VARCHAR2);
127 --HVOP heali
128
129 END WSH_TRXSN_HANDLER;