eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on MSC_INST_PARTITIONS

Line 478: INSERT INTO MSC_INST_PARTITIONS (

474:
475: END LOOP;
476: --dbms_output.put_line('****returning success****'||x_msg_data);
477:
478: INSERT INTO MSC_INST_PARTITIONS (
479: INSTANCE_ID,
480: FREE_FLAG,
481: LAST_UPDATE_DATE,
482: LAST_UPDATED_BY,

Line 749: INSERT INTO MSC_INST_PARTITIONS (

745: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
746: exit;
747: end if;
748:
749: INSERT INTO MSC_INST_PARTITIONS (
750: INSTANCE_ID,
751: FREE_FLAG,
752: LAST_UPDATE_DATE,
753: LAST_UPDATED_BY,

Line 791: FROM MSC_INST_PARTITIONS

787: x_msg_data OUT NOCOPY VARCHAR2) RETURN NUMBER IS
788:
789: CURSOR C_FREE_INSTANCE IS
790: SELECT instance_id
791: FROM MSC_INST_PARTITIONS
792: WHERE free_flag = 1;
793:
794: sql_stmt VARCHAR2(200);
795: l_inst_id NUMBER:= NULL;

Line 835: UPDATE MSC_INST_PARTITIONS

831: -- dbms_output.put_line('Found a free instance'||l_inst_id);
832: end if;
833:
834: begin
835: UPDATE MSC_INST_PARTITIONS
836: SET free_flag = 2
837: WHERE instance_id = l_inst_id;
838:
839: exception

Line 881: FROM MSC_INST_PARTITIONS

877: WHERE plan_id = P_plan_id;
878:
879: CURSOR Instance_exists_C(P_instance_id IN NUMBER) IS
880: SELECT count(*)
881: FROM MSC_INST_PARTITIONS
882: WHERE instance_id = P_instance_id;
883:
884: BEGIN
885: msc_util.msc_debug('P_table_name = '||P_table_name );

Line 1016: INSERT INTO MSC_INST_PARTITIONS (

1012: 1,
1013: 1
1014: );
1015: else
1016: INSERT INTO MSC_INST_PARTITIONS (
1017: INSTANCE_ID,
1018: FREE_FLAG,
1019: LAST_UPDATE_DATE,
1020: LAST_UPDATED_BY,

Line 1094: DELETE FROM MSC_INST_PARTITIONS

1090: DELETE FROM MSC_PLAN_PARTITIONS
1091: WHERE plan_id = partition_num;
1092: commit;
1093: else
1094: DELETE FROM MSC_INST_PARTITIONS
1095: WHERE instance_id = partition_num;
1096: commit;
1097: end if;
1098:

Line 1350: -- update msc_inst_partitions to mark the partition

1346:
1347: create_inst_partitions_pvt(l_instance_id,x_return_status,errbuf);
1348:
1349: --
1350: -- update msc_inst_partitions to mark the partition
1351: -- as free since the pvt api defaults it to used.
1352: --
1353: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1354: UPDATE MSC_INST_PARTITIONS

Line 1354: UPDATE MSC_INST_PARTITIONS

1350: -- update msc_inst_partitions to mark the partition
1351: -- as free since the pvt api defaults it to used.
1352: --
1353: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1354: UPDATE MSC_INST_PARTITIONS
1355: SET free_flag = 1
1356: WHERE instance_id = l_instance_id;
1357: end if;
1358:

Line 1661: -- update msc_inst_partitions to mark the partition

1657: retcode := G_ERROR;
1658: return;
1659: end if;
1660: --
1661: -- update msc_inst_partitions to mark the partition
1662: -- as free since the pvt api defaults it to used.
1663: --
1664: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1665: UPDATE MSC_INST_PARTITIONS

Line 1665: UPDATE MSC_INST_PARTITIONS

1661: -- update msc_inst_partitions to mark the partition
1662: -- as free since the pvt api defaults it to used.
1663: --
1664: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1665: UPDATE MSC_INST_PARTITIONS
1666: SET free_flag = 1
1667: WHERE instance_id = l_inst_id;
1668: end if;
1669: