APPS.OZF_OFFR_QUAL_PKG dependencies on FND_API

Line 115: DECODE( px_qualifier_id, FND_API.G_MISS_NUM, NULL, px_qualifier_id),

111: attribute15,
112: active_flag,
113: object_version_number
114: ) VALUES (
115: DECODE( px_qualifier_id, FND_API.G_MISS_NUM, NULL, px_qualifier_id),
116: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 116: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

112: active_flag,
113: object_version_number
114: ) VALUES (
115: DECODE( px_qualifier_id, FND_API.G_MISS_NUM, NULL, px_qualifier_id),
116: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

113: object_version_number
114: ) VALUES (
115: DECODE( px_qualifier_id, FND_API.G_MISS_NUM, NULL, px_qualifier_id),
116: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),

Line 118: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

114: ) VALUES (
115: DECODE( px_qualifier_id, FND_API.G_MISS_NUM, NULL, px_qualifier_id),
116: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),
122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),

Line 119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

115: DECODE( px_qualifier_id, FND_API.G_MISS_NUM, NULL, px_qualifier_id),
116: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),
122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),
123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),

Line 120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

116: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),
122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),
123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),
124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),

Line 121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),

117: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
118: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),
122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),
123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),
124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),
125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

Line 122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),

118: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),
122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),
123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),
124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),
125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),

119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),
122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),
123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),
124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),
125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),

Line 124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),

120: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),
122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),
123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),
124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),
125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),

Line 125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

121: DECODE( p_qualifier_grouping_no, FND_API.G_MISS_NUM, NULL, p_qualifier_grouping_no),
122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),
123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),
124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),
125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),

Line 126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

122: DECODE( p_qualifier_context, FND_API.g_miss_char, NULL, p_qualifier_context),
123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),
124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),
125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),

123: DECODE( p_qualifier_attribute, FND_API.g_miss_char, NULL, p_qualifier_attribute),
124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),
125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),

124: DECODE( p_qualifier_attr_value, FND_API.g_miss_char, NULL, p_qualifier_attr_value),
125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),

125: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

Line 130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

126: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

Line 131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

127: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

Line 132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

128: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

Line 133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

129: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

Line 134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

130: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

Line 135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

131: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

Line 136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

132: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

Line 137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

133: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

Line 138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

134: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

Line 139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

135: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
143: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

Line 140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

136: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
143: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
144: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

Line 141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

137: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
143: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
144: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
145: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),

Line 142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

138: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
143: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
144: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
145: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
146: DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

Line 143: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

139: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
143: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
144: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
145: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
146: DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
147: );

Line 144: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

140: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
143: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
144: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
145: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
146: DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
147: );
148:

Line 145: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),

141: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
143: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
144: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
145: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
146: DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
147: );
148:
149: END Insert_Row;

Line 146: DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

142: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
143: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
144: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
145: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
146: DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
147: );
148:
149: END Insert_Row;
150:

Line 202: qualifier_id = DECODE( p_qualifier_id, null, qualifier_id, FND_API.G_MISS_NUM, null, p_qualifier_id),

198: IS
199: BEGIN
200: Update ozf_offer_qualifiers
201: SET
202: qualifier_id = DECODE( p_qualifier_id, null, qualifier_id, FND_API.G_MISS_NUM, null, p_qualifier_id),
203: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
204: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
205: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),

Line 203: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

199: BEGIN
200: Update ozf_offer_qualifiers
201: SET
202: qualifier_id = DECODE( p_qualifier_id, null, qualifier_id, FND_API.G_MISS_NUM, null, p_qualifier_id),
203: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
204: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
205: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),
207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),

Line 204: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

200: Update ozf_offer_qualifiers
201: SET
202: qualifier_id = DECODE( p_qualifier_id, null, qualifier_id, FND_API.G_MISS_NUM, null, p_qualifier_id),
203: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
204: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
205: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),
207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),
208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),

Line 205: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

201: SET
202: qualifier_id = DECODE( p_qualifier_id, null, qualifier_id, FND_API.G_MISS_NUM, null, p_qualifier_id),
203: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
204: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
205: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),
207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),
208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),
209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),

Line 206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),

202: qualifier_id = DECODE( p_qualifier_id, null, qualifier_id, FND_API.G_MISS_NUM, null, p_qualifier_id),
203: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
204: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
205: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),
207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),
208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),
209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),
210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

Line 207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),

203: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
204: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
205: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),
207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),
208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),
209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),
210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),

204: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
205: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),
207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),
208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),
209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),
210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),

Line 209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),

205: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),
207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),
208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),
209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),
210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),

Line 210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

206: qualifier_grouping_no = DECODE( p_qualifier_grouping_no, null, qualifier_grouping_no, FND_API.G_MISS_NUM, null, p_qualifier_grouping_no),
207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),
208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),
209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),
210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),

Line 211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

207: qualifier_context = DECODE( p_qualifier_context, null, qualifier_context, FND_API.g_miss_char, null, p_qualifier_context),
208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),
209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),
210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

Line 212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),

208: qualifier_attribute = DECODE( p_qualifier_attribute, null, qualifier_attribute, FND_API.g_miss_char, null, p_qualifier_attribute),
209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),
210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

Line 213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),

209: qualifier_attr_value = DECODE( p_qualifier_attr_value, null, qualifier_attr_value, FND_API.g_miss_char, null, p_qualifier_attr_value),
210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

Line 214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),

210: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

Line 215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

211: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

Line 216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

212: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

Line 217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

213: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

Line 218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

214: context = DECODE( p_context, null, context, FND_API.g_miss_char, null, p_context),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

Line 219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

Line 220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

Line 221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

Line 222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

Line 223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

Line 224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

Line 225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

221: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15),

Line 226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

222: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15),
230: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),

Line 227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15),
230: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
231: object_version_number = DECODE(p_object_version_number,null,object_version_number,FND_API.g_miss_num,null,p_object_version_number+1)

Line 228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15),
230: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
231: object_version_number = DECODE(p_object_version_number,null,object_version_number,FND_API.g_miss_num,null,p_object_version_number+1)
232:

Line 229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15),

225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15),
230: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
231: object_version_number = DECODE(p_object_version_number,null,object_version_number,FND_API.g_miss_num,null,p_object_version_number+1)
232:
233: WHERE qualifier_id = p_qualifier_id

Line 230: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),

226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15),
230: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
231: object_version_number = DECODE(p_object_version_number,null,object_version_number,FND_API.g_miss_num,null,p_object_version_number+1)
232:
233: WHERE qualifier_id = p_qualifier_id
234: AND object_version_number = p_object_version_number;

Line 231: object_version_number = DECODE(p_object_version_number,null,object_version_number,FND_API.g_miss_num,null,p_object_version_number+1)

227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15),
230: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
231: object_version_number = DECODE(p_object_version_number,null,object_version_number,FND_API.g_miss_num,null,p_object_version_number+1)
232:
233: WHERE qualifier_id = p_qualifier_id
234: AND object_version_number = p_object_version_number;
235:

Line 238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

234: AND object_version_number = p_object_version_number;
235:
236:
237: IF (SQL%NOTFOUND) THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: END IF;
240:
241:
242: END Update_Row;

Line 268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

264: DELETE FROM ozf_offer_qualifiers
265: WHERE qualifier_id = p_qualifier_id
266: AND object_version_number = p_object_version_number;
267: If (SQL%NOTFOUND) then
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: End If;
270: END Delete_Row ;
271:
272:

Line 306: RAISE FND_API.g_exc_error;

302: FETCH c INTO Recinfo;
303: IF (c%NOTFOUND) THEN
304: CLOSE c;
305: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
306: RAISE FND_API.g_exc_error;
307: END IF;
308: CLOSE c;
309: END Lock_Row;
310: