[Home] [Help]
PACKAGE: APPS.CN_SRP_PMT_PLANS_PKG
Source
1 PACKAGE CN_SRP_PMT_PLANS_PKG AS
2 /* $Header: cntspps.pls 120.1 2005/06/16 15:07:11 appldev $ */
3 --
4 -- Package Name
5 -- CN_SRP_PMT_PLANS_PKG
6 -- Purpose
7 -- Table Handler for CN_SRP_PMT_PLANS
8 -- FORM CNSRMT
9 -- BLOCK SRP_PMT_PLAN
10 --
11 -- History
12 -- 26-May-99 Angela Chung Created
13 -- 01-AUG-01 Kumar Sivankaran Added Object Version Number
14 --/*-------------------------------------------------------------------------*
15 -- Procedure Name
16 -- Insert_row
17 -- Purpose
18 -- Main insert procedure
19 -- *-------------------------------------------------------------------------*/
20 PROCEDURE insert_row
21 (x_srp_pmt_plan_id IN OUT NOCOPY NUMBER
22 ,x_pmt_plan_id IN NUMBER
23 ,x_salesrep_id IN NUMBER
24 ,x_org_id IN NUMBER
25 ,x_role_id IN NUMBER
26 ,x_credit_type_id IN NUMBER
27 ,x_start_date DATE
28 ,x_end_date DATE
29 ,x_minimum_amount IN NUMBER
30 ,x_maximum_amount IN NUMBER
31 ,x_max_recovery_amount IN NUMBER
32 ,x_attribute_category VARCHAR2 := NULL
33 ,x_attribute1 VARCHAR2 := NULL
34 ,x_attribute2 VARCHAR2 := NULL
35 ,x_attribute3 VARCHAR2 := NULL
36 ,x_attribute4 VARCHAR2 := NULL
37 ,x_attribute5 VARCHAR2 := NULL
38 ,x_attribute6 VARCHAR2 := NULL
39 ,x_attribute7 VARCHAR2 := NULL
40 ,x_attribute8 VARCHAR2 := NULL
41 ,x_attribute9 VARCHAR2 := NULL
42 ,x_attribute10 VARCHAR2 := NULL
43 ,x_attribute11 VARCHAR2 := NULL
44 ,x_attribute12 VARCHAR2 := NULL
45 ,x_attribute13 VARCHAR2 := NULL
46 ,x_attribute14 VARCHAR2 := NULL
47 ,x_attribute15 VARCHAR2 := NULL
48 ,x_Created_By NUMBER
49 ,x_Creation_Date DATE
50 ,x_Last_Updated_By NUMBER
51 ,x_Last_Update_Date DATE
52 ,x_Last_Update_Login NUMBER
53 ,x_srp_role_id NUMBER := NULL
54 ,x_role_pmt_plan_id NUMBER := NULL
55 ,x_lock_flag VARCHAR2 := NULL
56 );
57
58 -- /*-------------------------------------------------------------------------*
59 -- Procedure Name
60 -- Lock_row
61 -- Purpose
62 -- Lock db row after form record is changed
63 -- Notes
64 -- Only called from the form
65 -- *-------------------------------------------------------------------------*/
66 PROCEDURE lock_row
67 ( x_srp_pmt_plan_id NUMBER
68 ,x_pmt_plan_id NUMBER
69 ,x_salesrep_id NUMBER
70 ,x_org_id NUMBER
71 ,x_role_id NUMBER
72 ,x_credit_type_id NUMBER
73 ,x_start_date DATE
74 ,x_end_date DATE
75 ,x_minimum_amount NUMBER
76 ,x_maximum_amount NUMBER
77 ,x_max_recovery_amount NUMBER
78 ,x_attribute_category VARCHAR2 := NULL
79 ,x_attribute1 VARCHAR2 := NULL
80 ,x_attribute2 VARCHAR2 := NULL
81 ,x_attribute3 VARCHAR2 := NULL
82 ,x_attribute4 VARCHAR2 := NULL
83 ,x_attribute5 VARCHAR2 := NULL
84 ,x_attribute6 VARCHAR2 := NULL
85 ,x_attribute7 VARCHAR2 := NULL
86 ,x_attribute8 VARCHAR2 := NULL
87 ,x_attribute9 VARCHAR2 := NULL
88 ,x_attribute10 VARCHAR2 := NULL
89 ,x_attribute11 VARCHAR2 := NULL
90 ,x_attribute12 VARCHAR2 := NULL
91 ,x_attribute13 VARCHAR2 := NULL
92 ,x_attribute14 VARCHAR2 := NULL
93 ,x_attribute15 VARCHAR2 := NULL
94 );
95
96 -- /*-------------------------------------------------------------------------*
97 -- Procedure Name
98 -- Update Record
99 -- Purpose
100 -- To Update the Srp Payment Plan Assign
101 --
102 -- *-------------------------------------------------------------------------*/
103 PROCEDURE update_row (
104 x_srp_pmt_plan_id NUMBER
105 ,x_pmt_plan_id NUMBER := fnd_api.g_miss_num
106 ,x_salesrep_id NUMBER := fnd_api.g_miss_num
107 ,x_org_id NUMBER := fnd_api.g_miss_num
108 ,x_role_id NUMBER := fnd_api.g_miss_num
109 ,x_credit_type_id NUMBER := fnd_api.g_miss_num
110 ,x_start_date DATE := fnd_api.g_miss_date
111 ,x_end_date DATE := fnd_api.g_miss_date
112 ,x_minimum_amount NUMBER := fnd_api.g_miss_num
113 ,x_maximum_amount NUMBER := fnd_api.g_miss_num
114 ,x_max_recovery_amount NUMBER := fnd_api.g_miss_num
115 ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char
116 ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char
117 ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char
118 ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char
119 ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char
120 ,x_attribute5 VARCHAR2 := fnd_api.g_miss_char
121 ,x_attribute6 VARCHAR2 := fnd_api.g_miss_char
122 ,x_attribute7 VARCHAR2 := fnd_api.g_miss_char
123 ,x_attribute8 VARCHAR2 := fnd_api.g_miss_char
124 ,x_attribute9 VARCHAR2 := fnd_api.g_miss_char
125 ,x_attribute10 VARCHAR2 := fnd_api.g_miss_char
126 ,x_attribute11 VARCHAR2 := fnd_api.g_miss_char
127 ,x_attribute12 VARCHAR2 := fnd_api.g_miss_char
128 ,x_attribute13 VARCHAR2 := fnd_api.g_miss_char
129 ,x_attribute14 VARCHAR2 := fnd_api.g_miss_char
130 ,x_attribute15 VARCHAR2 := fnd_api.g_miss_char
131 ,x_Last_Updated_By NUMBER
132 ,x_Last_Update_Date DATE
133 ,x_Last_Update_Login NUMBER
134 ,x_object_version_number NUMBER
135 ,x_lock_flag VARCHAR2 := fnd_api.g_miss_char);
136
137 --/*-------------------------------------------------------------------------*
138 -- Procedure Name
139 -- Delete_row
140 -- Purpose
141 -- Delete the Srp Payment Plan Assign
142 --*-------------------------------------------------------------------------*/
143 PROCEDURE Delete_row( x_srp_pmt_plan_id NUMBER );
144
145 END CN_SRP_PMT_PLANS_PKG;