APPS.FND_IMP_PKG dependencies on FND_IMP_LANG_SUMMARY

Line 716: delete from fnd_imp_lang_summary l

712:
713: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');
714:
715: -- Cleanup any records associated with this request_id
716: delete from fnd_imp_lang_summary l
717: where l.snapshot_id = snapshot_id__
718: and patch_id in (
719: select m.virtual_patch_id
720: from fnd_imp_monitor m

Line 727: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' cleaned up fnd_imp_lang_summary');

723: and m.snapshot_id = l.snapshot_id
724: union
725: select 0-request_id__ from dual);
726:
727: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' cleaned up fnd_imp_lang_summary');
728:
729:
730: -- 1) First record for each singletons (top level or pre-reqs)
731: -- whether translation patch is required with count as 1.

Line 745: insert into fnd_imp_lang_summary (

741: where lu.lookup_type = 'OAM_PIA_TRANS_FILE_TYPES')
742: and ( fcv.upgrade > 0 or fcv.new > 0 )
743: and fcv.snapshot_id = snapshot_id__
744: and fcv.bug_no = v_bug.virtual_bug_no;
745: insert into fnd_imp_lang_summary (
746: snapshot_id, patch_id, req_trans_cnt) values
747: (snapshot_id__, v_bug.virtual_bug_no, v_req_trans);
748: exception
749: when no_data_found then

Line 765: from fnd_imp_bugset b, fnd_imp_lang_summary ls

761: begin
762: select sum(req_trans_cnt) into v_req_trans from
763: ( -- get all the prequisites
764: select ls.req_trans_cnt req_trans_cnt
765: from fnd_imp_bugset b, fnd_imp_lang_summary ls
766: where ls.patch_id = b.patch_id
767: and ls.snapshot_id = b.snapshot_id
768: and b.virtual_patch_id = v_bug.virtual_patch_id
769: and b.set_type = 'm'

Line 774: from fnd_imp_lang_summary ls

770: and b.snapshot_id = snapshot_id__
771: union all
772: -- combine with the top level
773: select ls.req_trans_cnt req_trans_cnt
774: from fnd_imp_lang_summary ls
775: where ls.patch_id = (0 - v_bug.virtual_patch_id)
776: );
777: insert into fnd_imp_lang_summary (
778: snapshot_id, patch_id, req_trans_cnt) values

Line 777: insert into fnd_imp_lang_summary (

773: select ls.req_trans_cnt req_trans_cnt
774: from fnd_imp_lang_summary ls
775: where ls.patch_id = (0 - v_bug.virtual_patch_id)
776: );
777: insert into fnd_imp_lang_summary (
778: snapshot_id, patch_id, req_trans_cnt) values
779: (snapshot_id__, v_bug.virtual_patch_id, v_req_trans);
780: exception
781: when no_data_found then

Line 796: from fnd_imp_bugset b, fnd_imp_lang_summary ls

792: declare
793: v_req_trans number := 0;
794: begin
795: select sum(ls.req_trans_cnt) into v_req_trans
796: from fnd_imp_bugset b, fnd_imp_lang_summary ls
797: where ls.patch_id = b.patch_id
798: and ls.snapshot_id = b.snapshot_id
799: and b.virtual_patch_id = (0-request_id__)
800: and b.set_type = 'a'

Line 803: insert into fnd_imp_lang_summary (

799: and b.virtual_patch_id = (0-request_id__)
800: and b.set_type = 'a'
801: and b.snapshot_id = snapshot_id__
802: group by b.virtual_patch_id;
803: insert into fnd_imp_lang_summary (
804: snapshot_id, patch_id, req_trans_cnt) values
805: (snapshot_id__, (0-request_id__), v_req_trans);
806: exception
807: when no_data_found then