[Home] [Help]
PACKAGE: APPS.CN_QUOTA_RULE_UPLIFTS_PKG
Source
1 PACKAGE cn_quota_rule_uplifts_pkg AUTHID CURRENT_USER AS
2 /* $Header: cnpliqrus.pls 120.1 2005/07/11 19:59:42 appldev ship $ */
3
4 /*
5 Date Name Description
6 ----------------------------------------------------------------------------+
7 15-FEB-95 S Kumar Unit tested
8
9 Name
10
11 Purpose
12
13 Notes
14 Created during 3i changes
15 */
16 -- Name
17 --+
18 -- Purpose
19 --+
20 -- Notes
21 --+
22 --+
23 PROCEDURE begin_record (
24 x_operation VARCHAR2,
25 x_org_id NUMBER,
26 x_quota_rule_uplift_id IN OUT NOCOPY NUMBER,
27 x_quota_rule_id NUMBER,
28 x_quota_rule_id_old NUMBER,
29 x_start_date DATE,
30 x_start_date_old DATE,
31 x_end_date DATE,
32 x_end_date_old DATE,
33 x_payment_factor NUMBER,
34 x_payment_factor_old NUMBER,
35 x_quota_factor NUMBER,
36 x_quota_factor_old NUMBER,
37 x_last_updated_by NUMBER,
38 x_creation_date DATE,
39 x_created_by NUMBER,
40 x_last_update_login NUMBER,
41 x_last_update_date DATE,
42 x_program_type VARCHAR2,
43 x_status_code VARCHAR2,
44 x_object_version_number OUT NOCOPY NUMBER
45 );
46
47 -- Name
48 --+
49 -- Purpose
50 --+
51 -- Notes
52 --+
53 --+
54 PROCEDURE DELETE_RECORD (
55 x_quota_rule_uplift_id NUMBER,
56 x_quota_rule_id NUMBER,
57 x_quota_id NUMBER
58 );
59
60 -- Name
61 --+
62 -- Purpose
63 --+
64 -- Notes
65 --+
66 --+
67 PROCEDURE end_record (
68 x_rowid VARCHAR2,
69 x_quota_rule_uplift_id NUMBER,
70 x_quota_rule_id NUMBER,
71 x_start_date DATE,
72 x_end_date DATE,
73 x_payment_factor NUMBER,
74 x_quota_factor NUMBER,
75 x_program_type VARCHAR2
76 );
77 -- Name
78 --+
79 -- Purpose
80 --+
81 -- Notes
82 --+
83 --+
84 END cn_quota_rule_uplifts_pkg;