DBA Data[Home] [Help]

APPS.OKL_ECC_PVT dependencies on FND_LOAD_UTIL

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

2795: db_ludate DATE; -- entity update date in db
2796:
2797: BEGIN
2798: -- Translate owner to file_last_updated_by
2799: f_luby := fnd_load_util.owner_id(p_owner);
2800:
2801: -- Translate char last_update_date to date
2802: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
2803:

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

2806: FROM OKL_FE_CRIT_CAT_DEF_TL
2807: where crit_cat_def_id = p_eccv_rec.crit_cat_def_id
2808: and USERENV('LANG') =language;
2809:
2810: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2811: db_ludate, '')) then
2812: UPDATE OKL_FE_CRIT_CAT_DEF_TL
2813: SET
2814: CRIT_CAT_DESC = p_eccv_rec.crit_cat_desc,

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

2835: db_luby NUMBER; -- entity owner in db
2836: db_ludate DATE; -- entity update date in db
2837: BEGIN
2838: -- Translate owner to file_last_updated_by
2839: f_luby := fnd_load_util.owner_id(p_owner);
2840:
2841: -- Translate char last_update_date to date
2842: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
2843:

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

2846: INTO id, db_luby, db_ludate
2847: FROM OKL_FE_CRIT_CAT_DEF_B
2848: where crit_cat_def_id = p_eccv_rec.crit_cat_def_id;
2849:
2850: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2851: db_ludate, '')) then
2852: --Update _b
2853: UPDATE okl_fe_crit_cat_def_b
2854: SET crit_cat_def_id = p_eccv_rec.crit_cat_def_id