APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_COMMON_UTILITIES

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

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

Line 215: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;

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

Line 216: v_sr_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE ;

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

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

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

Line 267: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;

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

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

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

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

705: attribute3, attribute4, attribute5,
706: system_attribute1,system_attribute2, --jarorad
707: dp_enabled_flag) --jarorad
708: VALUES( p_instance_id, p_level_id, a_level_value(j),
709: a_sr_level_pk(j), MSD_COMMON_UTILITIES.get_level_pk(),
710: a_level_value_desc(j),
711: 'I', p_seq_num, p_seq_num,
712: sysdate, FND_GLOBAL.USER_ID,
713: sysdate, FND_GLOBAL.USER_ID,

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

1042: /* Note that we will not be able to get the attributes 1 - 5 for the
1043: Top level as we will not have a separate view for the top level */
1044:
1045: /* For PULL */
1046: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
1047: /* Find deleted top level values, if any */
1048: /* Top Level Values can be modified, but should not be deleted.
1049: comment out this part
1050: IF (p_delete_flag = 'Y') THEN

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

1137:
1138:
1139: BEGIN
1140:
1141: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
1142: /* pulling data */
1143: IF (p_delete_flag = 'Y' and p_level_id = 1) THEN
1144: DELETED_ITEM_LIST_PRICE( errbuf,
1145: retcode,

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

1154: delete from msd_st_item_list_price
1155: where instance = p_instance_id;
1156:
1157:
1158: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1159:
1160: /* Collection */
1161: IF (p_level_id = 1) THEN
1162: delete from msd_st_item_list_price

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

1162: delete from msd_st_item_list_price
1163: where instance = p_instance_id;
1164: END IF;
1165:
1166: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1167: if (retcode = -1) then
1168: retcode :=-1;
1169: return;
1170: end if;

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

1447: p_dest_table IN VARCHAR2,
1448: p_instance_id IN NUMBER) IS
1449:
1450: /* The Type Id for Manufacturing Calendar */
1451: p_man_cal_type VARCHAR2(240) := MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR;
1452:
1453: /* Destination table to insert into */
1454: v_dest_table VARCHAR2(1000);
1455:

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

1460: x_dblink VARCHAR2(2000);
1461:
1462: BEGIN
1463:
1464: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1465: /* Get the x_dblink from p_instance_id */
1466: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1467:
1468: /* Check for errors in getting the db link */

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

1462: BEGIN
1463:
1464: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1465: /* Get the x_dblink from p_instance_id */
1466: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1467:
1468: /* Check for errors in getting the db link */
1469:
1470: if (retcode = -1) then

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

1478:
1479:
1480: /* Refresh the existing Org Calendar relationships for this instance */
1481:
1482: if (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1483:
1484: delete from msd_st_org_calendars
1485: where instance = p_instance_id;
1486:

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

1496: end if;
1497:
1498: /** Insert Data **/
1499:
1500: if (p_source_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1501:
1502: insert into msd_org_calendars
1503: (INSTANCE,
1504: SR_ORG_PK,

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

1594:
1595:
1596: BEGIN
1597:
1598: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1599:
1600: /* Get the x_dblink from p_instance_id */
1601: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1602:

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

1597:
1598: if (p_source_table <> MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1599:
1600: /* Get the x_dblink from p_instance_id */
1601: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
1602:
1603: /* Check for errors in getting the db link */
1604:
1605: if (retcode = -1) then

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

1613:
1614:
1615: /* Refresh the existing Org Calendar relationships for this instance */
1616:
1617: if (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1618:
1619: delete from msd_st_level_org_asscns
1620: where instance = p_instance_id
1621: and level_id = p_lvl_id;

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

1649: end if;
1650:
1651: /** Insert Data **/
1652:
1653: if (p_source_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1654:
1655: insert into msd_level_org_asscns
1656: ( INSTANCE,
1657: LEVEL_ID,