APPS.FND_HELP dependencies on AD_ZD_SEED

Line 636: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');

632: num_file_id number := to_number(x_file_id);
633: num_custom_level number := to_number(x_custom_level);
634: begin
635: -- Bug 13689517 Adding PREPARE calls for Online patching for seed tables.
636: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');
637:
638: update fnd_help_documents set
639: title = x_title,
640: version = x_version

Line 681: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');

677: num_file_id number := to_number(x_file_id);
678: begin
679:
680: -- Bug 13689517 Adding PREPARE calls for Online patching for seed tables
681: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');
682:
683: insert into fnd_help_targets (file_id, target_name)
684: values (num_file_id, upper(translate(x_target_name,'.','_')));
685:

Line 728: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');

724: and file_id <> num_file_id;
725: begin
726: -- Bug 13689517 Adding PREPARE calls for Online patching for seed tables.
727: -- FND_LOBS has not been designated as a seed table so no PREPARE is needed.
728: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');
729: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');
730:
731: for f in fileid_cursor loop
732: delete from fnd_help_targets where file_id = f.file_id;

Line 729: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');

725: begin
726: -- Bug 13689517 Adding PREPARE calls for Online patching for seed tables.
727: -- FND_LOBS has not been designated as a seed table so no PREPARE is needed.
728: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');
729: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');
730:
731: for f in fileid_cursor loop
732: delete from fnd_help_targets where file_id = f.file_id;
733: delete from fnd_lobs where file_id = f.file_id;