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 429: INSERT INTO MSC_INST_PARTITIONS (

425:
426: END LOOP;
427: --dbms_output.put_line('****returning success****'||x_msg_data);
428:
429: INSERT INTO MSC_INST_PARTITIONS (
430: INSTANCE_ID,
431: FREE_FLAG,
432: LAST_UPDATE_DATE,
433: LAST_UPDATED_BY,

Line 700: INSERT INTO MSC_INST_PARTITIONS (

696: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
697: exit;
698: end if;
699:
700: INSERT INTO MSC_INST_PARTITIONS (
701: INSTANCE_ID,
702: FREE_FLAG,
703: LAST_UPDATE_DATE,
704: LAST_UPDATED_BY,

Line 742: FROM MSC_INST_PARTITIONS

738: x_msg_data OUT NOCOPY VARCHAR2) RETURN NUMBER IS
739:
740: CURSOR C_FREE_INSTANCE IS
741: SELECT instance_id
742: FROM MSC_INST_PARTITIONS
743: WHERE free_flag = 1;
744:
745: sql_stmt VARCHAR2(200);
746: l_inst_id NUMBER:= NULL;

Line 786: UPDATE MSC_INST_PARTITIONS

782: -- dbms_output.put_line('Found a free instance'||l_inst_id);
783: end if;
784:
785: begin
786: UPDATE MSC_INST_PARTITIONS
787: SET free_flag = 2
788: WHERE instance_id = l_inst_id;
789:
790: exception

Line 832: FROM MSC_INST_PARTITIONS

828: WHERE plan_id = P_plan_id;
829:
830: CURSOR Instance_exists_C(P_instance_id IN NUMBER) IS
831: SELECT count(*)
832: FROM MSC_INST_PARTITIONS
833: WHERE instance_id = P_instance_id;
834:
835: BEGIN
836: msc_util.msc_debug('P_table_name = '||P_table_name );

Line 966: INSERT INTO MSC_INST_PARTITIONS (

962: 1,
963: 1
964: );
965: else
966: INSERT INTO MSC_INST_PARTITIONS (
967: INSTANCE_ID,
968: FREE_FLAG,
969: LAST_UPDATE_DATE,
970: LAST_UPDATED_BY,

Line 1044: DELETE FROM MSC_INST_PARTITIONS

1040: DELETE FROM MSC_PLAN_PARTITIONS
1041: WHERE plan_id = partition_num;
1042: commit;
1043: else
1044: DELETE FROM MSC_INST_PARTITIONS
1045: WHERE instance_id = partition_num;
1046: commit;
1047: end if;
1048:

Line 1300: -- update msc_inst_partitions to mark the partition

1296:
1297: create_inst_partitions_pvt(l_instance_id,x_return_status,errbuf);
1298:
1299: --
1300: -- update msc_inst_partitions to mark the partition
1301: -- as free since the pvt api defaults it to used.
1302: --
1303: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1304: UPDATE MSC_INST_PARTITIONS

Line 1304: UPDATE MSC_INST_PARTITIONS

1300: -- update msc_inst_partitions to mark the partition
1301: -- as free since the pvt api defaults it to used.
1302: --
1303: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1304: UPDATE MSC_INST_PARTITIONS
1305: SET free_flag = 1
1306: WHERE instance_id = l_instance_id;
1307: end if;
1308:

Line 1607: -- update msc_inst_partitions to mark the partition

1603: retcode := G_ERROR;
1604: return;
1605: end if;
1606: --
1607: -- update msc_inst_partitions to mark the partition
1608: -- as free since the pvt api defaults it to used.
1609: --
1610: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1611: UPDATE MSC_INST_PARTITIONS

Line 1611: UPDATE MSC_INST_PARTITIONS

1607: -- update msc_inst_partitions to mark the partition
1608: -- as free since the pvt api defaults it to used.
1609: --
1610: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1611: UPDATE MSC_INST_PARTITIONS
1612: SET free_flag = 1
1613: WHERE instance_id = l_inst_id;
1614: end if;
1615: