DBA Data[Home] [Help]

APPS.OKL_FPR_PVT dependencies on FND_LOAD_UTIL

Line 3190: f_luby := fnd_load_util.owner_id(p_owner);

3186: db_ludate DATE; -- entity update date in db
3187:
3188: BEGIN
3189: -- Translate owner to file_last_updated_by
3190: f_luby := fnd_load_util.owner_id(p_owner);
3191:
3192: -- Translate char last_update_date to date
3193: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
3194:

Line 3201: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

3197: FROM OKL_FNCTN_PRMTRS_TL
3198: where ID = to_number(p_fprv_rec.id)
3199: and USERENV('LANG') =language;
3200:
3201: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3202: db_ludate, '')) then
3203:
3204: UPDATE OKL_FNCTN_PRMTRS_TL
3205: SET VALUE = p_fprv_rec.value,

Line 3231: f_luby := fnd_load_util.owner_id(p_owner);

3227: db_luby NUMBER; -- entity owner in db
3228: db_ludate DATE; -- entity update date in db
3229: BEGIN
3230: -- Translate owner to file_last_updated_by
3231: f_luby := fnd_load_util.owner_id(p_owner);
3232:
3233: -- Translate char last_update_date to date
3234: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
3235:

Line 3242: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

3238: INTO id, db_luby, db_ludate
3239: FROM OKL_FNCTN_PRMTRS_B
3240: where ID = p_fprv_rec.id;
3241:
3242: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3243: db_ludate, '')) then
3244: --Update _b
3245: UPDATE OKL_FNCTN_PRMTRS_B
3246: SET FPR_TYPE = p_fprv_rec.fpr_type,