DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_MANAGE_PLAN_PARTITIONS

Line 428: msc_manage_plan_partitions.get_partition_name

424: /* createTempraryTable; */
425:
426: trc('st ' || pTableName);
427:
428: msc_manage_plan_partitions.get_partition_name
429: ( -1,
430: v_instance_id,
431: pTableName,
432: SYS_NO,

Line 579: msc_manage_plan_partitions.get_partition_name

575: trc('st:Exchange_Partition_PVT: v_tempTblList='||to_char(v_tempTblList.COUNT + v_swapTblList.COUNT ));
576: /* exchange partition with temporary table */
577: FOR i IN 1..v_tempTblList.COUNT LOOP
578:
579: msc_manage_plan_partitions.get_partition_name
580: ( -1,
581: v_instance_id,
582: v_partTblList(i),
583: SYS_NO,

Line 598: msc_manage_plan_partitions.get_partition_name

594: END LOOP;
595:
596: FOR i IN 1..v_swapTblList.COUNT LOOP
597:
598: msc_manage_plan_partitions.get_partition_name
599: ( -1,
600: v_instance_id,
601: v_swapTblList(i).ods_table_name,
602: SYS_NO,

Line 893: msc_manage_plan_partitions.get_partition_name

889: else
890: lv_partn_tbl_name := v_partTblList(j);
891: end if;
892:
893: msc_manage_plan_partitions.get_partition_name
894: ( -1,
895: v_instance_id,
896: lv_partn_tbl_name,
897: SYS_NO,

Line 979: msc_manage_plan_partitions.get_partition_name

975: INTO lv_swap_status;
976:
977: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_2 then
978:
979: msc_manage_plan_partitions.get_partition_name
980: ( -1,
981: v_instance_id,
982: v_swapTblList(i).ods_table_name ,
983: SYS_NO,

Line 1880: msc_manage_plan_partitions.get_partition_name

1876: SELECT to_number(fnd_profile.value('MSC_INDEX_PARALLEL_THREADS'))
1877: INTO lv_deg_parallel
1878: FROM dual;
1879:
1880: msc_manage_plan_partitions.get_partition_name
1881: (-1,
1882: p_instance_id,
1883: p_part_table,
1884: p_is_plan,