DBA Data[Home] [Help]

APPS.PN_VAR_RENTS_PKG dependencies on FND_PROFILE

Line 776: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

772: X_ATTRIBUTE14 => p_pn_var_rents_rec.attribute14,
773: X_ATTRIBUTE15 => p_pn_var_rents_rec.attribute15,
774: X_ORG_ID => p_pn_var_rents_rec.org_id,
775: X_CREATION_DATE => sysdate,
776: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
777: X_LAST_UPDATE_DATE => sysdate,
778: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
779: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
780: X_CURRENCY_CODE => p_pn_var_rents_rec.currency_code,

Line 778: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

774: X_ORG_ID => p_pn_var_rents_rec.org_id,
775: X_CREATION_DATE => sysdate,
776: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
777: X_LAST_UPDATE_DATE => sysdate,
778: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
779: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
780: X_CURRENCY_CODE => p_pn_var_rents_rec.currency_code,
781: X_PRORATION_RULE => p_pn_var_rents_rec.proration_rule,
782: X_AGREEMENT_TEMPLATE_ID => p_pn_var_rents_rec.agreement_template_id

Line 779: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),

775: X_CREATION_DATE => sysdate,
776: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
777: X_LAST_UPDATE_DATE => sysdate,
778: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
779: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
780: X_CURRENCY_CODE => p_pn_var_rents_rec.currency_code,
781: X_PRORATION_RULE => p_pn_var_rents_rec.proration_rule,
782: X_AGREEMENT_TEMPLATE_ID => p_pn_var_rents_rec.agreement_template_id
783: );

Line 826: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

822: X_ATTRIBUTE14 => p_var_rent_dates_rec.attribute14,
823: X_ATTRIBUTE15 => p_var_rent_dates_rec.attribute15,
824: X_ORG_ID => p_var_rent_dates_rec.org_id,
825: X_CREATION_DATE => sysdate,
826: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
827: X_LAST_UPDATE_DATE => sysdate,
828: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
829: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
830: X_USE_GL_CALENDAR => p_var_rent_dates_rec.use_gl_calendar,

Line 828: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

824: X_ORG_ID => p_var_rent_dates_rec.org_id,
825: X_CREATION_DATE => sysdate,
826: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
827: X_LAST_UPDATE_DATE => sysdate,
828: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
829: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
830: X_USE_GL_CALENDAR => p_var_rent_dates_rec.use_gl_calendar,
831: X_PERIOD_TYPE => p_var_rent_dates_rec.period_type,
832: X_YEAR_START_DATE => p_var_rent_dates_rec.year_start_date,

Line 829: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),

825: X_CREATION_DATE => sysdate,
826: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
827: X_LAST_UPDATE_DATE => sysdate,
828: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
829: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
830: X_USE_GL_CALENDAR => p_var_rent_dates_rec.use_gl_calendar,
831: X_PERIOD_TYPE => p_var_rent_dates_rec.period_type,
832: X_YEAR_START_DATE => p_var_rent_dates_rec.year_start_date,
833: X_COMMENTS => p_var_rent_dates_rec.comments,

Line 870: LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'),-1),

866: UPDATE pn_var_rents_all
867: SET excess_abat_code = x_excess_abat_code,
868: order_of_appl_code = x_order_of_appl_code,
869: LAST_UPDATE_DATE = sysdate,
870: LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'),-1),
871: LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'),-1)
872: WHERE var_rent_id=x_var_rent_id ;
873:
874: IF (sql%notfound) THEN

Line 871: LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'),-1)

867: SET excess_abat_code = x_excess_abat_code,
868: order_of_appl_code = x_order_of_appl_code,
869: LAST_UPDATE_DATE = sysdate,
870: LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'),-1),
871: LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'),-1)
872: WHERE var_rent_id=x_var_rent_id ;
873:
874: IF (sql%notfound) THEN
875: RAISE NO_DATA_FOUND;