[Home] [Help]
PACKAGE: APPS.CN_INVOICE_CHANGES_PKG
Source
1 PACKAGE CN_INVOICE_CHANGES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cninvlns.pls 115.3 2002/01/28 20:01:42 pkm ship $*/
3
4 -- * ------------------------------------------------------------------+
5 -- Record Type Definition
6 -- * ------------------------------------------------------------------+
7
8 TYPE INVOICE_CHANGES_ALL_REC_TYPE IS RECORD
9 (
10 INVOICE_CHANGE_ID NUMBER := FND_API.G_MISS_NUM,
11 SALESREP_ID NUMBER := FND_API.G_MISS_NUM,
12 INVOICE_NUMBER VARCHAR2(20) := FND_API.G_MISS_CHAR,
13 LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14 REVENUE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
15 SPLIT_PCT NUMBER := FND_API.G_MISS_NUM,
16 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 CREATION_DATE DATE := FND_API.G_MISS_DATE,
33 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
37 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
38 ORG_ID NUMBER := FND_API.G_MISS_NUM,
39 COMM_LINES_API_ID NUMBER := FND_API.G_MISS_NUM
40 );
41
42 G_MISS_INVOICE_CHANGES_ALL_REC INVOICE_CHANGES_ALL_REC_TYPE;
43
44 -- * -------------------------------------------------------------------------*
45 -- Procedure Name
46 -- Insert_row
47 -- Purpose
48 -- Main insert procedure
49 -- Note
50 -- 1. Primary key should be populated from sequence before call
51 -- this procedure. No refernece to sequence in this procedure.
52 -- 2. All paramaters are IN parameter.
53 -- * -------------------------------------------------------------------------*
54 PROCEDURE insert_row
55 ( p_invoice_changes_all_rec IN INVOICE_CHANGES_ALL_REC_TYPE);
56
57 -- * -------------------------------------------------------------------------*
58 -- Procedure Name
59 -- update_row
60 -- Purpose
61 -- Main update procedure
62 -- Note
63 -- 1. No object version checking, overwrite may happen
64 -- 2. Calling lock_update for object version checking
65 -- 3. All paramaters are IN parameter.
66 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
67 -- * -------------------------------------------------------------------------*
68 PROCEDURE update_row
69 ( p_invoice_changes_all_rec IN INVOICE_CHANGES_ALL_REC_TYPE);
70
71 -- * -------------------------------------------------------------------------*
72 -- Procedure Name
73 -- lock_update_row
74 -- Purpose
75 -- Main lcok and update procedure
76 -- Note
77 -- 1. Object version checking is performed before checking
78 -- 2. Calling update_row if you don not want object version checking
79 -- 3. All paramaters are IN parameter.
80 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
81 -- * -------------------------------------------------------------------------*
82 PROCEDURE lock_update_row
83 ( p_invoice_changes_all_rec IN INVOICE_CHANGES_ALL_REC_TYPE);
84
85 -- * -------------------------------------------------------------------------*
86 -- Procedure Name
87 -- delete_row
88 -- Purpose
89 -- Main lcok and update procedure
90 -- Note
91 -- 1. All paramaters are IN parameter.
92 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
93 -- * -------------------------------------------------------------------------*
94 PROCEDURE delete_row
95 (
96 p_invoice_change_id NUMBER
97 );
98
99 END CN_INVOICE_CHANGES_PKG;