APPS.FND_MENU_ENTRIES_PKG dependencies on FND_LOAD_UTIL

Line 84: fnd_load_util.null_value, null,

80: X_LAST_UPDATE_LOGIN,
81: X_CREATION_DATE,
82: X_CREATED_BY,
83: decode(x_PROMPT,
84: fnd_load_util.null_value, null,
85: null, x_prompt,
86: X_PROMPT),
87: X_DESCRIPTION,
88: L.LANGUAGE_CODE,

Line 291: -- This is becoz of the changes in fnd_load_util.upload_test() api in R12

287:
288: begin
289: -- Bump tl table
290: -- Bug 5579233. Commented WHO col's update during bumping.
291: -- This is becoz of the changes in fnd_load_util.upload_test() api in R12
292: -- which is now considering only LUD but not LUB to return TRUE/FALSE.
293: -- Complete details can be found in bug#5579233
294: update fnd_menu_entries_tl
295: set entry_sequence = entry_sequence + X_SHIFT_VALUE

Line 332: -- This is becoz of the changes in fnd_load_util.upload_test() api in R12

328: end;
329:
330: -- Bump base table
331: -- Bug 5579233. Commented WHO col's update during bumping.
332: -- This is becoz of the changes in fnd_load_util.upload_test() api in R12
333: -- which is now considering only LUD but not LUB to return TRUE/FALSE.
334: -- Complete details can be found in bug#5579233
335: update fnd_menu_entries
336: set entry_sequence = entry_sequence + X_SHIFT_VALUE

Line 441: fnd_load_util.null_value, null,

437:
438: X_ENTRY_SEQUENCE := to_number(X_ENT_SEQUENCE);
439:
440: select decode(X_SUB_MENU_NAME,
441: fnd_load_util.null_value, null,
442: null, X_SUB_MENU_NAME,
443: X_SUB_MENU_NAME) into l_sub_menu_name from dual;
444:
445: sub_mnu_id := NULL;

Line 487: fnd_load_util.null_value, null,

483: sub_mnu_id := null;
484: end if;
485:
486: select decode(X_FUNCTION_NAME,
487: fnd_load_util.null_value, null,
488: null, X_FUNCTION_NAME,
489: X_FUNCTION_NAME) into l_function_name from dual;
490:
491: fun_id := NULL;

Line 528: f_luby := fnd_load_util.owner_id(x_owner);

524: return;
525: end;
526:
527: -- Translate owner to file_last_updated_by
528: f_luby := fnd_load_util.owner_id(x_owner);
529:
530: -- Translate char last_update_date to date
531: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
532:

Line 616: (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

612: and userenv('LANG') = t.language;
613:
614:
615: if ((v_mode = 'MERGE_OVERWRITE') or
616: (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
617: db_ludate, X_CUSTOM_MODE))) then
618:
619: if (eseqmatch = 'N') then
620: -- If row is found, but position mismatches,

Line 739: fnd_load_util.null_value, null,

735: when the upload test passes even if neither prompt nor
736: description have changed. */
737: update fnd_menu_entries_tl
738: set prompt = decode(X_PROMPT,
739: fnd_load_util.null_value, null,
740: null, prompt,
741: X_PROMPT),
742: description = X_DESCRIPTION,
743: last_update_date = f_ludate,

Line 978: f_luby := fnd_load_util.owner_id(x_owner);

974: and nvl(function_id, -1) = nvl(X_FUNCTION_ID, -1)
975: and menu_id = X_MENU_ID;
976:
977: -- Translate owner to file_last_updated_by
978: f_luby := fnd_load_util.owner_id(x_owner);
979:
980: -- Translate char last_update_date to date
981: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
982:

Line 990: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

986: where MENU_ID = X_MENU_ID
987: and ENTRY_SEQUENCE = ent_seq
988: and userenv('LANG') = LANGUAGE;
989:
990: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
991: db_ludate, X_CUSTOM_MODE)) then
992: update FND_MENU_ENTRIES_TL
993: set prompt = decode(X_PROMPT,
994: fnd_load_util.null_value, null,

Line 994: fnd_load_util.null_value, null,

990: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
991: db_ludate, X_CUSTOM_MODE)) then
992: update FND_MENU_ENTRIES_TL
993: set prompt = decode(X_PROMPT,
994: fnd_load_util.null_value, null,
995: null, prompt,
996: X_PROMPT),
997: DESCRIPTION = X_DESCRIPTION,
998: LAST_UPDATE_DATE = f_ludate,