411: WHERE application_id = -1;
412:
413: begin
414: -- Translate owner to file_last_updated_by
415: f_luby := fnd_load_util.owner_id(X_OWNER);
416:
417: -- Translate char last_update_date to date
418: f_ludate := X_LAST_UPDATE_DATE;
419:
424: FROM JTF_PREFAB_CA_COMPS_B
425: WHERE APPLICATION_ID = X_APPLICATION_ID AND
426: COMPONENT_KEY = X_COMPONENT_KEY;
427:
428: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
429: db_ludate, X_CUSTOM_MODE)) then
430: -- **** call Update row ****
431: JTF_PREFAB_CA_COMPS_PKG.UPDATE_ROW (
432: X_CA_COMP_ID => l_ca_comp_id,
588: db_ludate DATE;
589: l_ca_comp_id NUMBER;
590: begin
591:
592: f_luby := fnd_load_util.owner_id(X_OWNER);
593:
594: f_ludate := X_LAST_UPDATE_DATE;
595:
596: begin
601: b.APPLICATION_ID = X_APPLICATION_ID AND
602: b.COMPONENT_KEY = X_COMPONENT_KEY AND
603: tl.LANGUAGE = userenv('LANG');
604:
605: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
606: db_ludate, X_CUSTOM_MODE))
607: then
608: update JTF_PREFAB_CA_COMPS_TL set
609: DESCRIPTION = nvl(X_DESCRIPTION, DESCRIPTION),