[Home] [Help]
PACKAGE: APPS.CN_IMP_HEADERS_PKG
Source
1 PACKAGE CN_IMP_HEADERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntimhrs.pls 115.2 2002/02/05 00:25:54 pkm ship $*/
3
4 -- * ------------------------------------------------------------------+
5 -- Record Type Definition
6 -- * ------------------------------------------------------------------+
7
8 -- * -------------------------------------------------------------------------*
9 -- Procedure Name
10 -- Insert_row
11 -- Purpose
12 -- Main insert procedure
13 -- Note
14 -- 1. Primary key should be populated from sequence before call
15 -- this procedure. No refernece to sequence in this procedure.
16 -- 2. All paramaters are IN parameter.
17 -- * -------------------------------------------------------------------------*
18 PROCEDURE insert_row
19 ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE);
20
21 -- * -------------------------------------------------------------------------*
22 -- Procedure Name
23 -- update_row
24 -- Purpose
25 -- Main update procedure
26 -- Note
27 -- 1. No object version checking, overwrite may happen
28 -- 2. Calling lock_update for object version checking
29 -- 3. All paramaters are IN parameter.
30 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
31 -- * -------------------------------------------------------------------------*
32 PROCEDURE update_row
33 ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE);
34
35 -- * -------------------------------------------------------------------------*
36 -- Procedure Name
37 -- lock_update_row
38 -- Purpose
39 -- Main lcok and update procedure
40 -- Note
41 -- 1. Object version checking is performed before checking
42 -- 2. Calling update_row if you don not want object version checking
43 -- 3. All paramaters are IN parameter.
44 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
45 -- * -------------------------------------------------------------------------*
46 PROCEDURE lock_update_row
47 ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE);
48
49 -- * -------------------------------------------------------------------------*
50 -- Procedure Name
51 -- delete_row
52 -- Purpose
53 -- Main lcok and update procedure
54 -- Note
55 -- 1. All paramaters are IN parameter.
56 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
57 -- * -------------------------------------------------------------------------*
58 PROCEDURE delete_row
59 (
60 p_imp_header_id NUMBER
61 );
62
63 END CN_IMP_HEADERS_PKG;