DBA Data[Home] [Help]

APPS.FUN_NET_AGREEMENTS_PKG dependencies on FND_GLOBAL

Line 142: NVL(FND_GLOBAL.user_id,-1),

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)

Line 144: DECODE(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),

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:

Line 146: NVL(FND_GLOBAL.user_id,-1)

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;

Line 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),

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:

Line 242: last_updated_by = NVL(FND_GLOBAL.user_id,-1)

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;