[Home] [Help]
PACKAGE: APPS.CN_CALC_SUB_ENTRIES_PKG
Source
1 PACKAGE CN_CALC_SUB_ENTRIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cnsbbtes.pls 120.2 2005/08/08 10:04:53 ymao ship $ */
3
4 --
5 --
6 --
7 -- This Procedure is called to
8 -- 1. Insert
9 -- 2. Update
10 -- 3. Delete
11 -- Records into Table cn_calc_submission_entries
12 --
13 --
14 --
15 Procedure Begin_Record ( P_OPERATION VARCHAR2,
16 p_calc_sub_entry_id NUMBER := NULL,
17 p_calc_sub_batch_id NUMBER := NULL,
18 p_salesrep_id NUMBER := NULL,
19 p_hierarchy_flag VARCHAR2 := NULL,
20 p_org_id NUMBER,
21 P_ATTRIBUTE_CATEGORY VARCHAR2 := NULL,
22 P_ATTRIBUTE1 VARCHAR2 := NULL,
23 P_ATTRIBUTE2 VARCHAR2 := NULL,
24 P_ATTRIBUTE3 VARCHAR2 := NULL,
25 P_ATTRIBUTE4 VARCHAR2 := NULL,
26 P_ATTRIBUTE5 VARCHAR2 := NULL,
27 P_ATTRIBUTE6 VARCHAR2 := NULL,
28 P_ATTRIBUTE7 VARCHAR2 := NULL,
29 P_ATTRIBUTE8 VARCHAR2 := NULL,
30 P_ATTRIBUTE9 VARCHAR2 := NULL,
31 P_ATTRIBUTE10 VARCHAR2 := NULL,
32 P_ATTRIBUTE11 VARCHAR2 := NULL,
33 P_ATTRIBUTE12 VARCHAR2 := NULL,
34 P_ATTRIBUTE13 VARCHAR2 := NULL,
35 P_ATTRIBUTE14 VARCHAR2 := NULL,
36 P_ATTRIBUTE15 VARCHAR2 := NULL,
37 P_CREATED_BY NUMBER := NULL,
38 P_CREATION_DATE DATE := NULL,
39 P_LAST_UPDATE_LOGIN NUMBER := NULL,
40 P_LAST_UPDATE_DATE DATE := NULL,
41 P_LAST_UPDATED_BY NUMBER := NULL
42 );
43
44
45
46 --+
47 -- Procedure Name
48 -- get_calc_sub_entry_id
49 -- Scope
50 -- public
51 -- Purpose
52 -- get the calculation type for this physical batch
53 -- state.
54 -- History
55 -- 10-JUL-98 Richard Jin Created
56 --+
57 FUNCTION get_calc_sub_entry_id RETURN NUMBER;
58
59 --
60 --
61 --
62 END cn_calc_sub_entries_pkg;