DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PKG dependencies on FND_API

Line 105: ,x_pmt_plan_id NUMBER := fnd_api.g_miss_num

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

Line 106: ,x_salesrep_id NUMBER := fnd_api.g_miss_num

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

Line 107: ,x_org_id NUMBER := fnd_api.g_miss_num

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

Line 108: ,x_role_id NUMBER := fnd_api.g_miss_num

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

Line 109: ,x_credit_type_id NUMBER := fnd_api.g_miss_num

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

Line 110: ,x_start_date DATE := fnd_api.g_miss_date

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

Line 111: ,x_end_date DATE := fnd_api.g_miss_date

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

Line 112: ,x_minimum_amount 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

Line 113: ,x_maximum_amount 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

Line 114: ,x_max_recovery_amount 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

Line 115: ,x_attribute_category VARCHAR2 := fnd_api.g_miss_char

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

Line 116: ,x_attribute1 VARCHAR2 := fnd_api.g_miss_char

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

Line 117: ,x_attribute2 VARCHAR2 := fnd_api.g_miss_char

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

Line 118: ,x_attribute3 VARCHAR2 := fnd_api.g_miss_char

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

Line 119: ,x_attribute4 VARCHAR2 := fnd_api.g_miss_char

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

Line 120: ,x_attribute5 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

Line 121: ,x_attribute6 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

Line 122: ,x_attribute7 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

Line 123: ,x_attribute8 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

Line 124: ,x_attribute9 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

Line 125: ,x_attribute10 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

Line 126: ,x_attribute11 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

Line 127: ,x_attribute12 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

Line 128: ,x_attribute13 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

Line 129: ,x_attribute14 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

Line 130: ,x_attribute15 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

Line 135: ,x_lock_flag 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