APPS.AMS_WEB_RECOMMS_PKG dependencies on FND_API

Line 110: DECODE( px_web_recomm_id, FND_API.G_MISS_NUM, NULL, px_web_recomm_id),

106: attribute13,
107: attribute14,
108: attribute15
109: ) VALUES (
110: DECODE( px_web_recomm_id, FND_API.G_MISS_NUM, NULL, px_web_recomm_id),
111: DECODE( p_web_tracking_id, FND_API.G_MISS_NUM, NULL, p_web_tracking_id),
112: DECODE( p_recomm_object_id, FND_API.G_MISS_NUM, NULL, p_recomm_object_id),
113: DECODE( p_recomm_type, FND_API.g_miss_char, NULL, p_recomm_type),
114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),

Line 111: DECODE( p_web_tracking_id, FND_API.G_MISS_NUM, NULL, p_web_tracking_id),

107: attribute14,
108: attribute15
109: ) VALUES (
110: DECODE( px_web_recomm_id, FND_API.G_MISS_NUM, NULL, px_web_recomm_id),
111: DECODE( p_web_tracking_id, FND_API.G_MISS_NUM, NULL, p_web_tracking_id),
112: DECODE( p_recomm_object_id, FND_API.G_MISS_NUM, NULL, p_recomm_object_id),
113: DECODE( p_recomm_type, FND_API.g_miss_char, NULL, p_recomm_type),
114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),
115: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),

Line 112: DECODE( p_recomm_object_id, FND_API.G_MISS_NUM, NULL, p_recomm_object_id),

108: attribute15
109: ) VALUES (
110: DECODE( px_web_recomm_id, FND_API.G_MISS_NUM, NULL, px_web_recomm_id),
111: DECODE( p_web_tracking_id, FND_API.G_MISS_NUM, NULL, p_web_tracking_id),
112: DECODE( p_recomm_object_id, FND_API.G_MISS_NUM, NULL, p_recomm_object_id),
113: DECODE( p_recomm_type, FND_API.g_miss_char, NULL, p_recomm_type),
114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),
115: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),

Line 113: DECODE( p_recomm_type, FND_API.g_miss_char, NULL, p_recomm_type),

109: ) VALUES (
110: DECODE( px_web_recomm_id, FND_API.G_MISS_NUM, NULL, px_web_recomm_id),
111: DECODE( p_web_tracking_id, FND_API.G_MISS_NUM, NULL, p_web_tracking_id),
112: DECODE( p_recomm_object_id, FND_API.G_MISS_NUM, NULL, p_recomm_object_id),
113: DECODE( p_recomm_type, FND_API.g_miss_char, NULL, p_recomm_type),
114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),
115: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),
117: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),

110: DECODE( px_web_recomm_id, FND_API.G_MISS_NUM, NULL, px_web_recomm_id),
111: DECODE( p_web_tracking_id, FND_API.G_MISS_NUM, NULL, p_web_tracking_id),
112: DECODE( p_recomm_object_id, FND_API.G_MISS_NUM, NULL, p_recomm_object_id),
113: DECODE( p_recomm_type, FND_API.g_miss_char, NULL, p_recomm_type),
114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),
115: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),
117: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

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

111: DECODE( p_web_tracking_id, FND_API.G_MISS_NUM, NULL, p_web_tracking_id),
112: DECODE( p_recomm_object_id, FND_API.G_MISS_NUM, NULL, p_recomm_object_id),
113: DECODE( p_recomm_type, FND_API.g_miss_char, NULL, p_recomm_type),
114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),
115: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),
117: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),

112: DECODE( p_recomm_object_id, FND_API.G_MISS_NUM, NULL, p_recomm_object_id),
113: DECODE( p_recomm_type, FND_API.g_miss_char, NULL, p_recomm_type),
114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),
115: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),
117: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
120: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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

113: DECODE( p_recomm_type, FND_API.g_miss_char, NULL, p_recomm_type),
114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),
115: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),
117: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
120: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

114: DECODE( p_rule_id, FND_API.G_MISS_NUM, NULL, p_rule_id),
115: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),
117: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
120: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

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

115: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),
117: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
120: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
123: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

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

116: DECODE( p_offer_src_code, FND_API.g_miss_char, NULL, p_offer_src_code),
117: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
120: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
123: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
124: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

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

117: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
120: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
123: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
124: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
125: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

118: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
120: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
123: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
124: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
125: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
126: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

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

119: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
120: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
123: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
124: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
125: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
126: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
127: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

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

120: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
123: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
124: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
125: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
126: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
127: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
128: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

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

121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
123: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
124: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
125: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
126: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
127: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
128: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
129: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

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

122: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
123: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
124: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
125: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
126: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
127: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
128: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
129: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
130: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

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

123: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
124: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
125: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
126: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
127: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
128: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
129: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
130: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
131: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

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

124: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
125: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
126: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
127: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
128: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
129: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
130: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
131: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
132: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

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

125: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
126: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
127: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
128: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
129: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
130: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
131: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
132: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
133: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

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

126: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
127: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
128: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
129: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
130: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
131: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
132: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
133: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
134: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

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

127: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
128: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
129: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
130: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
131: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
132: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
133: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
134: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
135: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

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

128: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
129: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
130: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
131: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
132: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
133: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
134: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
135: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
136: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

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

129: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
130: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
131: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
132: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
133: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
134: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
135: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
136: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
137: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

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

130: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
131: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
132: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
133: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
134: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
135: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
136: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
137: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
138: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

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

131: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
132: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
133: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
134: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
135: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
136: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
137: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
138: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
139:

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

132: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
133: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
134: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
135: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
136: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
137: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
138: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
139:
140: END Insert_Row;

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

133: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
134: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
135: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
136: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
137: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
138: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
139:
140: END Insert_Row;
141:

Line 138: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

134: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
135: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
136: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
137: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
138: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
139:
140: END Insert_Row;
141:
142:

Line 190: web_recomm_id = DECODE( p_web_recomm_id, null, web_recomm_id, FND_API.G_MISS_NUM, null, p_web_recomm_id),

186: IS
187: BEGIN
188: Update ams_web_recomms
189: SET
190: web_recomm_id = DECODE( p_web_recomm_id, null, web_recomm_id, FND_API.G_MISS_NUM, null, p_web_recomm_id),
191: web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),
192: recomm_object_id = DECODE( p_recomm_object_id, null, recomm_object_id, FND_API.G_MISS_NUM, null, p_recomm_object_id),
193: recomm_type = DECODE( p_recomm_type, null, recomm_type, FND_API.g_miss_char, null, p_recomm_type),
194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),

Line 191: web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),

187: BEGIN
188: Update ams_web_recomms
189: SET
190: web_recomm_id = DECODE( p_web_recomm_id, null, web_recomm_id, FND_API.G_MISS_NUM, null, p_web_recomm_id),
191: web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),
192: recomm_object_id = DECODE( p_recomm_object_id, null, recomm_object_id, FND_API.G_MISS_NUM, null, p_recomm_object_id),
193: recomm_type = DECODE( p_recomm_type, null, recomm_type, FND_API.g_miss_char, null, p_recomm_type),
194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),
195: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),

Line 192: recomm_object_id = DECODE( p_recomm_object_id, null, recomm_object_id, FND_API.G_MISS_NUM, null, p_recomm_object_id),

188: Update ams_web_recomms
189: SET
190: web_recomm_id = DECODE( p_web_recomm_id, null, web_recomm_id, FND_API.G_MISS_NUM, null, p_web_recomm_id),
191: web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),
192: recomm_object_id = DECODE( p_recomm_object_id, null, recomm_object_id, FND_API.G_MISS_NUM, null, p_recomm_object_id),
193: recomm_type = DECODE( p_recomm_type, null, recomm_type, FND_API.g_miss_char, null, p_recomm_type),
194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),
195: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
196: offer_src_code = DECODE( p_offer_src_code, null, offer_src_code, FND_API.g_miss_char, null, p_offer_src_code),

Line 193: recomm_type = DECODE( p_recomm_type, null, recomm_type, FND_API.g_miss_char, null, p_recomm_type),

189: SET
190: web_recomm_id = DECODE( p_web_recomm_id, null, web_recomm_id, FND_API.G_MISS_NUM, null, p_web_recomm_id),
191: web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),
192: recomm_object_id = DECODE( p_recomm_object_id, null, recomm_object_id, FND_API.G_MISS_NUM, null, p_recomm_object_id),
193: recomm_type = DECODE( p_recomm_type, null, recomm_type, FND_API.g_miss_char, null, p_recomm_type),
194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),
195: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
196: offer_src_code = DECODE( p_offer_src_code, null, offer_src_code, FND_API.g_miss_char, null, p_offer_src_code),
197: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),

190: web_recomm_id = DECODE( p_web_recomm_id, null, web_recomm_id, FND_API.G_MISS_NUM, null, p_web_recomm_id),
191: web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),
192: recomm_object_id = DECODE( p_recomm_object_id, null, recomm_object_id, FND_API.G_MISS_NUM, null, p_recomm_object_id),
193: recomm_type = DECODE( p_recomm_type, null, recomm_type, FND_API.g_miss_char, null, p_recomm_type),
194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),
195: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
196: offer_src_code = DECODE( p_offer_src_code, null, offer_src_code, FND_API.g_miss_char, null, p_offer_src_code),
197: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
198: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

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

191: web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),
192: recomm_object_id = DECODE( p_recomm_object_id, null, recomm_object_id, FND_API.G_MISS_NUM, null, p_recomm_object_id),
193: recomm_type = DECODE( p_recomm_type, null, recomm_type, FND_API.g_miss_char, null, p_recomm_type),
194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),
195: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
196: offer_src_code = DECODE( p_offer_src_code, null, offer_src_code, FND_API.g_miss_char, null, p_offer_src_code),
197: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
198: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
199: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 196: offer_src_code = DECODE( p_offer_src_code, null, offer_src_code, FND_API.g_miss_char, null, p_offer_src_code),

192: recomm_object_id = DECODE( p_recomm_object_id, null, recomm_object_id, FND_API.G_MISS_NUM, null, p_recomm_object_id),
193: recomm_type = DECODE( p_recomm_type, null, recomm_type, FND_API.g_miss_char, null, p_recomm_type),
194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),
195: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
196: offer_src_code = DECODE( p_offer_src_code, null, offer_src_code, FND_API.g_miss_char, null, p_offer_src_code),
197: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
198: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
199: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
200: object_version_number = nvl(p_object_version_number,0) + 1 ,

Line 197: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

193: recomm_type = DECODE( p_recomm_type, null, recomm_type, FND_API.g_miss_char, null, p_recomm_type),
194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),
195: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
196: offer_src_code = DECODE( p_offer_src_code, null, offer_src_code, FND_API.g_miss_char, null, p_offer_src_code),
197: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
198: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
199: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
200: object_version_number = nvl(p_object_version_number,0) + 1 ,
201: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

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

194: rule_id = DECODE( p_rule_id, null, rule_id, FND_API.G_MISS_NUM, null, p_rule_id),
195: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
196: offer_src_code = DECODE( p_offer_src_code, null, offer_src_code, FND_API.g_miss_char, null, p_offer_src_code),
197: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
198: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
199: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
200: object_version_number = nvl(p_object_version_number,0) + 1 ,
201: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
202: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

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

195: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
196: offer_src_code = DECODE( p_offer_src_code, null, offer_src_code, FND_API.g_miss_char, null, p_offer_src_code),
197: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
198: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
199: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
200: object_version_number = nvl(p_object_version_number,0) + 1 ,
201: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
202: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
203: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

Line 201: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

197: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
198: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
199: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
200: object_version_number = nvl(p_object_version_number,0) + 1 ,
201: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
202: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
203: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
204: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
205: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

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

198: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
199: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
200: object_version_number = nvl(p_object_version_number,0) + 1 ,
201: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
202: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
203: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
204: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
205: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
206: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

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

199: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
200: object_version_number = nvl(p_object_version_number,0) + 1 ,
201: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
202: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
203: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
204: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
205: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
206: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
207: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

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

200: object_version_number = nvl(p_object_version_number,0) + 1 ,
201: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
202: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
203: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
204: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
205: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
206: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
207: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
208: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

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

201: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
202: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
203: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
204: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
205: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
206: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
207: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
208: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
209: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

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

202: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
203: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
204: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
205: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
206: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
207: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
208: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
209: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
210: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

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

203: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
204: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
205: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
206: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
207: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
208: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
209: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
210: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
211: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

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

204: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
205: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
206: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
207: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
208: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
209: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
210: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
211: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
212: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

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

205: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
206: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
207: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
208: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
209: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
210: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
211: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
212: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
213: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

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

206: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
207: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
208: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
209: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
210: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
211: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
212: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
213: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
214: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

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

207: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
208: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
209: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
210: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
211: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
212: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
213: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
214: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
215: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

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

208: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
209: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
210: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
211: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
212: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
213: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
214: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
215: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
216: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

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

209: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
210: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
211: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
212: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
213: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
214: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
215: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
216: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
217: WHERE web_recomm_id = p_web_recomm_id

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

210: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
211: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
212: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
213: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
214: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
215: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
216: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
217: WHERE web_recomm_id = p_web_recomm_id
218: AND object_version_number = p_object_version_number;

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

211: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
212: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
213: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
214: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
215: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
216: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
217: WHERE web_recomm_id = p_web_recomm_id
218: AND object_version_number = p_object_version_number;
219:

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

212: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
213: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
214: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
215: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
216: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
217: WHERE web_recomm_id = p_web_recomm_id
218: AND object_version_number = p_object_version_number;
219:
220:

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: AND object_version_number = p_object_version_number;
219:
220:
221: IF (SQL%NOTFOUND) THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224:
225:
226: END Update_Row;

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

248: DELETE FROM ams_web_recomms
249: WHERE web_recomm_id = p_web_recomm_id
250: AND object_version_number = p_object_version_number;
251: If (SQL%NOTFOUND) then
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: End If;
254: END Delete_Row ;
255:
256:

Line 290: RAISE FND_API.g_exc_error;

286: FETCH c INTO Recinfo;
287: IF (c%NOTFOUND) THEN
288: CLOSE c;
289: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
290: RAISE FND_API.g_exc_error;
291: END IF;
292: CLOSE c;
293: END Lock_Row;
294: