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.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_COMMON_UTILITIES

Line 216: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN

212:
213: Savepoint Before_Delete ;
214:
215: /* Beginning of IF 1 */
216: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
217:
218: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;
219: v_sr_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE ;
220:

Line 218: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;

214:
215: /* Beginning of IF 1 */
216: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
217:
218: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;
219: v_sr_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE ;
220:
221: /* First time to process this level_id */
222: IF (p_update_lvl_table = 1) THEN

Line 219: v_sr_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE ;

215: /* Beginning of IF 1 */
216: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
217:
218: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;
219: v_sr_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE ;
220:
221: /* First time to process this level_id */
222: IF (p_update_lvl_table = 1) THEN
223: /* Insert deleted level values into deleted_level_value table and delete it

Line 266: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN

262: p_parent_level_id,
263: p_seq_num);
264:
265: /* ELSE for IF 1. COLLECTION */
266: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN
267:
268: log_debug(' Entering Collect Level values Condition');
269:
270: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;

Line 270: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;

266: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN
267:
268: log_debug(' Entering Collect Level values Condition');
269:
270: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;
271:
272: /* Delete Staging Table only if delete flag = Yes */
273: IF (p_delete_flag = 'Y') THEN
274: /* First time to process this level_id */

Line 290: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);

286: /* Logic to figure out if the source view contains the relevant columns required for
287: Sales and Operation Planning */
288:
289: /* Get the x_dblink from p_instance_id */
290: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
291:
292: /* Check for errors in getting the db link */
293:
294: if (retcode = -1) then

Line 545: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN

541: if p_update_lvl_table is set to 1 (i.e. the level_id had not been
542: processed before) and level_id is the lowest level or intermediate level
543: in the product dimension */
544:
545: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN
546:
547: IF(MSD_COMMON_UTILITIES.COLLECT_ILP = 1 and p_update_lvl_table = 0) THEN
548:
549: MSD_COMMON_UTILITIES.COLLECT_ILP := 3;

Line 547: IF(MSD_COMMON_UTILITIES.COLLECT_ILP = 1 and p_update_lvl_table = 0) THEN

543: in the product dimension */
544:
545: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN
546:
547: IF(MSD_COMMON_UTILITIES.COLLECT_ILP = 1 and p_update_lvl_table = 0) THEN
548:
549: MSD_COMMON_UTILITIES.COLLECT_ILP := 3;
550:
551: END IF;

Line 549: MSD_COMMON_UTILITIES.COLLECT_ILP := 3;

545: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN
546:
547: IF(MSD_COMMON_UTILITIES.COLLECT_ILP = 1 and p_update_lvl_table = 0) THEN
548:
549: MSD_COMMON_UTILITIES.COLLECT_ILP := 3;
550:
551: END IF;
552:
553: END IF;

Line 563: IF ((p_update_lvl_table = 1 and MSD_COMMON_UTILITIES.COLLECT_ILP = 2) or MSD_COMMON_UTILITIES.COLLECT_ILP = 3) THEN /* IF 1 */

559: from msd_levels
560: where level_id = p_level_id
561: and plan_type is null; --vinekuma
562:
563: IF ((p_update_lvl_table = 1 and MSD_COMMON_UTILITIES.COLLECT_ILP = 2) or MSD_COMMON_UTILITIES.COLLECT_ILP = 3) THEN /* IF 1 */
564: --fnd_file.put_line(fnd_file.log,'came here' || p_update_lvl_table ||' ' || MSD_COMMON_UTILITIES.COLLECT_ILP);
565:
566: IF (p_level_id = 1 OR p_level_id = 3) THEN /* IF 2 */
567:

Line 564: --fnd_file.put_line(fnd_file.log,'came here' || p_update_lvl_table ||' ' || MSD_COMMON_UTILITIES.COLLECT_ILP);

560: where level_id = p_level_id
561: and plan_type is null; --vinekuma
562:
563: IF ((p_update_lvl_table = 1 and MSD_COMMON_UTILITIES.COLLECT_ILP = 2) or MSD_COMMON_UTILITIES.COLLECT_ILP = 3) THEN /* IF 1 */
564: --fnd_file.put_line(fnd_file.log,'came here' || p_update_lvl_table ||' ' || MSD_COMMON_UTILITIES.COLLECT_ILP);
565:
566: IF (p_level_id = 1 OR p_level_id = 3) THEN /* IF 2 */
567:
568: CREATE_ITEM_LIST_PRICE(

Line 741: a_sr_level_pk(j), MSD_COMMON_UTILITIES.get_level_pk(),

737: attribute3, attribute4, attribute5,
738: system_attribute1,system_attribute2, --jarorad
739: dp_enabled_flag) --jarorad
740: VALUES( p_instance_id, p_level_id, a_level_value(j),
741: a_sr_level_pk(j), MSD_COMMON_UTILITIES.get_level_pk(),
742: a_level_value_desc(j),
743: 'I', p_seq_num, p_seq_num,
744: sysdate, FND_GLOBAL.USER_ID,
745: sysdate, FND_GLOBAL.USER_ID,

Line 1078: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN

1074: /* Note that we will not be able to get the attributes 1 - 5 for the
1075: Top level as we will not have a separate view for the top level */
1076:
1077: /* For PULL */
1078: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
1079: /* Find deleted top level values, if any */
1080: /* Top Level Values can be modified, but should not be deleted.
1081: comment out this part
1082: IF (p_delete_flag = 'Y') THEN

Line 1173: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN

1169:
1170:
1171: BEGIN
1172:
1173: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
1174: /* pulling data */
1175: IF (p_delete_flag = 'Y' and p_level_id = 1) THEN
1176: DELETED_ITEM_LIST_PRICE( errbuf,
1177: retcode,

Line 1190: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then

1186: delete from msd_st_item_list_price
1187: where instance = p_instance_id;
1188:
1189:
1190: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1191:
1192: /* Collection */
1193: IF (p_level_id = 1) THEN
1194: delete from msd_st_item_list_price

Line 1198: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);

1194: delete from msd_st_item_list_price
1195: where instance = p_instance_id;
1196: END IF;
1197:
1198: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1199: if (retcode = -1) then
1200: retcode :=-1;
1201: return;
1202: end if;

Line 1483: p_man_cal_type VARCHAR2(240) := MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR;

1479: p_dest_table IN VARCHAR2,
1480: p_instance_id IN NUMBER) IS
1481:
1482: /* The Type Id for Manufacturing Calendar */
1483: p_man_cal_type VARCHAR2(240) := MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR;
1484:
1485: /* Destination table to insert into */
1486: v_dest_table VARCHAR2(1000);
1487:

Line 1496: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then

1492: x_dblink VARCHAR2(2000);
1493:
1494: BEGIN
1495:
1496: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1497: /* Get the x_dblink from p_instance_id */
1498: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1499:
1500: /* Check for errors in getting the db link */

Line 1498: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);

1494: BEGIN
1495:
1496: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1497: /* Get the x_dblink from p_instance_id */
1498: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1499:
1500: /* Check for errors in getting the db link */
1501:
1502: if (retcode = -1) then

Line 1514: if (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then

1510:
1511:
1512: /* Refresh the existing Org Calendar relationships for this instance */
1513:
1514: if (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1515:
1516: delete from msd_st_org_calendars
1517: where instance = p_instance_id;
1518:

Line 1532: if (p_source_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then

1528: end if;
1529:
1530: /** Insert Data **/
1531:
1532: if (p_source_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1533:
1534: insert into msd_org_calendars
1535: (INSTANCE,
1536: SR_ORG_PK,

Line 1630: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then

1626:
1627:
1628: BEGIN
1629:
1630: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1631:
1632: /* Get the x_dblink from p_instance_id */
1633: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1634:

Line 1633: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);

1629:
1630: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1631:
1632: /* Get the x_dblink from p_instance_id */
1633: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1634:
1635: /* Check for errors in getting the db link */
1636:
1637: if (retcode = -1) then

Line 1649: if (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then

1645:
1646:
1647: /* Refresh the existing Org Calendar relationships for this instance */
1648:
1649: if (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1650:
1651: delete from msd_st_level_org_asscns
1652: where instance = p_instance_id
1653: and level_id = p_lvl_id;

Line 1685: if (p_source_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then

1681: end if;
1682:
1683: /** Insert Data **/
1684:
1685: if (p_source_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1686:
1687: insert into msd_level_org_asscns
1688: ( INSTANCE,
1689: LEVEL_ID,