DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_MANAGE_PLAN_PARTITIONS

Line 309: msc_manage_plan_partitions.get_partition_name

305: /* createTempraryTable; */
306:
307: trc('st ' || pTableName);
308:
309: msc_manage_plan_partitions.get_partition_name
310: ( -1,
311: v_instance_id,
312: pTableName,
313: SYS_NO,

Line 459: msc_manage_plan_partitions.get_partition_name

455: trc('st:Exchange_Partition_PVT: v_tempTblList='||to_char(v_tempTblList.COUNT + v_swapTblList.COUNT ));
456: /* exchange partition with temporary table */
457: FOR i IN 1..v_tempTblList.COUNT LOOP
458:
459: msc_manage_plan_partitions.get_partition_name
460: ( -1,
461: v_instance_id,
462: v_partTblList(i),
463: SYS_NO,

Line 478: msc_manage_plan_partitions.get_partition_name

474: END LOOP;
475:
476: FOR i IN 1..v_swapTblList.COUNT LOOP
477:
478: msc_manage_plan_partitions.get_partition_name
479: ( -1,
480: v_instance_id,
481: v_swapTblList(i).ods_table_name,
482: SYS_NO,

Line 764: msc_manage_plan_partitions.get_partition_name

760: else
761: lv_partn_tbl_name := v_partTblList(j);
762: end if;
763:
764: msc_manage_plan_partitions.get_partition_name
765: ( -1,
766: v_instance_id,
767: lv_partn_tbl_name,
768: SYS_NO,

Line 851: msc_manage_plan_partitions.get_partition_name

847: INTO lv_swap_status;
848:
849: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_2 then
850:
851: msc_manage_plan_partitions.get_partition_name
852: ( -1,
853: v_instance_id,
854: v_swapTblList(i).ods_table_name ,
855: SYS_NO,

Line 1609: msc_manage_plan_partitions.get_partition_name

1605: SELECT to_number(fnd_profile.value('MSC_INDEX_PARALLEL_THREADS'))
1606: INTO lv_deg_parallel
1607: FROM dual;
1608:
1609: msc_manage_plan_partitions.get_partition_name
1610: (-1,
1611: p_instance_id,
1612: p_part_table,
1613: p_is_plan,