138: x_attribute17,
139: x_attribute18,
140: x_attribute19,
141: x_attribute20,
142: NVL(FND_GLOBAL.user_id,-1),
143: SYSDATE,
144: DECODE(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),
145: SYSDATE,
146: NVL(FND_GLOBAL.user_id,-1)
140: x_attribute19,
141: x_attribute20,
142: NVL(FND_GLOBAL.user_id,-1),
143: SYSDATE,
144: DECODE(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),
145: SYSDATE,
146: NVL(FND_GLOBAL.user_id,-1)
147: );
148:
142: NVL(FND_GLOBAL.user_id,-1),
143: SYSDATE,
144: DECODE(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),
145: SYSDATE,
146: NVL(FND_GLOBAL.user_id,-1)
147: );
148:
149: IF ( SQL%NOTFOUND ) THEN
150: RAISE NO_DATA_FOUND;
236: attribute17 = x_attribute17,
237: attribute18 = x_attribute18,
238: attribute19 = x_attribute19,
239: attribute20 = x_attribute20,
240: last_update_login = DECODE(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),
241: last_update_date = SYSDATE,
242: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
243: WHERE agreement_id = x_agreement_id;
244:
238: attribute19 = x_attribute19,
239: attribute20 = x_attribute20,
240: last_update_login = DECODE(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),
241: last_update_date = SYSDATE,
242: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
243: WHERE agreement_id = x_agreement_id;
244:
245: IF ( SQL%NOTFOUND ) THEN
246: RAISE NO_DATA_FOUND;