95: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
96: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
97: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
98: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
99: hz_utility_v2pub.last_update_date,
100: hz_utility_v2pub.last_updated_by,
101: hz_utility_v2pub.creation_date,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.last_update_login,
96: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
97: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
98: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
99: hz_utility_v2pub.last_update_date,
100: hz_utility_v2pub.last_updated_by,
101: hz_utility_v2pub.creation_date,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.last_update_login,
104: hz_utility_v2pub.request_id,
97: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
98: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
99: hz_utility_v2pub.last_update_date,
100: hz_utility_v2pub.last_updated_by,
101: hz_utility_v2pub.creation_date,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.last_update_login,
104: hz_utility_v2pub.request_id,
105: hz_utility_v2pub.program_application_id,
98: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
99: hz_utility_v2pub.last_update_date,
100: hz_utility_v2pub.last_updated_by,
101: hz_utility_v2pub.creation_date,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.last_update_login,
104: hz_utility_v2pub.request_id,
105: hz_utility_v2pub.program_application_id,
106: hz_utility_v2pub.program_id,
99: hz_utility_v2pub.last_update_date,
100: hz_utility_v2pub.last_updated_by,
101: hz_utility_v2pub.creation_date,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.last_update_login,
104: hz_utility_v2pub.request_id,
105: hz_utility_v2pub.program_application_id,
106: hz_utility_v2pub.program_id,
107: hz_utility_v2pub.program_update_date
100: hz_utility_v2pub.last_updated_by,
101: hz_utility_v2pub.creation_date,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.last_update_login,
104: hz_utility_v2pub.request_id,
105: hz_utility_v2pub.program_application_id,
106: hz_utility_v2pub.program_id,
107: hz_utility_v2pub.program_update_date
108: ) RETURNING
101: hz_utility_v2pub.creation_date,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.last_update_login,
104: hz_utility_v2pub.request_id,
105: hz_utility_v2pub.program_application_id,
106: hz_utility_v2pub.program_id,
107: hz_utility_v2pub.program_update_date
108: ) RETURNING
109: cust_receipt_method_id
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.last_update_login,
104: hz_utility_v2pub.request_id,
105: hz_utility_v2pub.program_application_id,
106: hz_utility_v2pub.program_id,
107: hz_utility_v2pub.program_update_date
108: ) RETURNING
109: cust_receipt_method_id
110: INTO
103: hz_utility_v2pub.last_update_login,
104: hz_utility_v2pub.request_id,
105: hz_utility_v2pub.program_application_id,
106: hz_utility_v2pub.program_id,
107: hz_utility_v2pub.program_update_date
108: ) RETURNING
109: cust_receipt_method_id
110: INTO
111: x_cust_receipt_method_id;
209: attribute9 = DECODE(x_attribute9, NULL, attribute9, fnd_api.g_miss_char,
210: NULL, x_attribute9),
211: attribute10 = DECODE(x_attribute10, NULL, attribute10, fnd_api.g_miss_char,
212: NULL, x_attribute10),
213: last_update_date = hz_utility_v2pub.last_update_date,
214: last_updated_by = hz_utility_v2pub.last_updated_by,
215: creation_date = creation_date,
216: created_by = created_by,
217: last_update_login = hz_utility_v2pub.last_update_login,
210: NULL, x_attribute9),
211: attribute10 = DECODE(x_attribute10, NULL, attribute10, fnd_api.g_miss_char,
212: NULL, x_attribute10),
213: last_update_date = hz_utility_v2pub.last_update_date,
214: last_updated_by = hz_utility_v2pub.last_updated_by,
215: creation_date = creation_date,
216: created_by = created_by,
217: last_update_login = hz_utility_v2pub.last_update_login,
218: request_id = hz_utility_v2pub.request_id,
213: last_update_date = hz_utility_v2pub.last_update_date,
214: last_updated_by = hz_utility_v2pub.last_updated_by,
215: creation_date = creation_date,
216: created_by = created_by,
217: last_update_login = hz_utility_v2pub.last_update_login,
218: request_id = hz_utility_v2pub.request_id,
219: program_application_id = hz_utility_v2pub.program_application_id,
220: program_id = hz_utility_v2pub.program_id,
221: program_update_date = hz_utility_v2pub.program_update_date
214: last_updated_by = hz_utility_v2pub.last_updated_by,
215: creation_date = creation_date,
216: created_by = created_by,
217: last_update_login = hz_utility_v2pub.last_update_login,
218: request_id = hz_utility_v2pub.request_id,
219: program_application_id = hz_utility_v2pub.program_application_id,
220: program_id = hz_utility_v2pub.program_id,
221: program_update_date = hz_utility_v2pub.program_update_date
222: WHERE rowid = x_rowid;
215: creation_date = creation_date,
216: created_by = created_by,
217: last_update_login = hz_utility_v2pub.last_update_login,
218: request_id = hz_utility_v2pub.request_id,
219: program_application_id = hz_utility_v2pub.program_application_id,
220: program_id = hz_utility_v2pub.program_id,
221: program_update_date = hz_utility_v2pub.program_update_date
222: WHERE rowid = x_rowid;
223:
216: created_by = created_by,
217: last_update_login = hz_utility_v2pub.last_update_login,
218: request_id = hz_utility_v2pub.request_id,
219: program_application_id = hz_utility_v2pub.program_application_id,
220: program_id = hz_utility_v2pub.program_id,
221: program_update_date = hz_utility_v2pub.program_update_date
222: WHERE rowid = x_rowid;
223:
224: If (SQL%NOTFOUND) then
217: last_update_login = hz_utility_v2pub.last_update_login,
218: request_id = hz_utility_v2pub.request_id,
219: program_application_id = hz_utility_v2pub.program_application_id,
220: program_id = hz_utility_v2pub.program_id,
221: program_update_date = hz_utility_v2pub.program_update_date
222: WHERE rowid = x_rowid;
223:
224: If (SQL%NOTFOUND) then
225: RAISE NO_DATA_FOUND;