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_CL_PRE_PROCESS dependencies on MSD_ST_LEVEL_VALUES

Line 96: ' INSERT INTO MSD_ST_LEVEL_VALUES '

92: BEGIN
93:
94: v_sql_stmt := 01;
95: lv_sql_stmt :=
96: ' INSERT INTO MSD_ST_LEVEL_VALUES '
97: ||' (INSTANCE , '
98: ||' LEVEL_ID, '
99: ||' LEVEL_VALUE, '
100: ||' SR_LEVEL_PK, '

Line 263: ' INSERT INTO MSD_ST_LEVEL_VALUES '

259: BEGIN
260:
261: v_sql_stmt := 01;
262: lv_sql_stmt :=
263: ' INSERT INTO MSD_ST_LEVEL_VALUES '
264: ||' (INSTANCE , '
265: ||' LEVEL_ID, '
266: ||' LEVEL_VALUE, '
267: ||' SR_LEVEL_PK, '

Line 463: INSERT INTO MSD_ST_LEVEL_VALUES

459:
460: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'
461: lv_all_prd_desc := msd_sr_util.get_all_prd_desc; --Calling fuction - msd_sr_util.get_all_prd_desc, to fetch the level value 'All Products'
462:
463: INSERT INTO MSD_ST_LEVEL_VALUES
464: (INSTANCE ,
465: LEVEL_ID,
466: LEVEL_VALUE,
467: SR_LEVEL_PK,

Line 540: --Inserting into MSD_ST_LEVEL_VALUES

536: sysdate,
537: -1);
538:
539:
540: --Inserting into MSD_ST_LEVEL_VALUES
541:
542: INSERT INTO MSD_ST_LEVEL_VALUES
543: (INSTANCE ,
544: LEVEL_ID,

Line 542: INSERT INTO MSD_ST_LEVEL_VALUES

538:
539:
540: --Inserting into MSD_ST_LEVEL_VALUES
541:
542: INSERT INTO MSD_ST_LEVEL_VALUES
543: (INSTANCE ,
544: LEVEL_ID,
545: LEVEL_VALUE,
546: SR_LEVEL_PK,

Line 760: ' INSERT INTO MSD_ST_LEVEL_VALUES '

756:
757: v_sql_stmt := 01;
758:
759: lv_sql_stmt :=
760: ' INSERT INTO MSD_ST_LEVEL_VALUES '
761: ||' (INSTANCE , '
762: ||' LEVEL_ID, '
763: ||' LEVEL_VALUE, '
764: ||' SR_LEVEL_PK, '

Line 1016: ' INSERT INTO MSD_ST_LEVEL_VALUES '

1012:
1013: BEGIN
1014: v_sql_stmt := 01;
1015: lv_sql_stmt :=
1016: ' INSERT INTO MSD_ST_LEVEL_VALUES '
1017: ||' (INSTANCE , '
1018: ||' LEVEL_ID, '
1019: ||' LEVEL_VALUE, '
1020: ||' SR_LEVEL_PK, '

Line 1174: ' INSERT INTO MSD_ST_LEVEL_VALUES '

1170:
1171: v_sql_stmt := 01;
1172:
1173: lv_sql_stmt :=
1174: ' INSERT INTO MSD_ST_LEVEL_VALUES '
1175: ||' (INSTANCE , '
1176: ||' LEVEL_ID, '
1177: ||' LEVEL_VALUE, '
1178: ||' SR_LEVEL_PK, '

Line 1259: INSERT INTO MSD_ST_LEVEL_VALUES --insert into msd_st_level_values

1255: -1,
1256: sysdate,
1257: -1);
1258:
1259: INSERT INTO MSD_ST_LEVEL_VALUES --insert into msd_st_level_values
1260: (INSTANCE ,
1261: LEVEL_ID,
1262: LEVEL_VALUE,
1263: SR_LEVEL_PK,

Line 1387: lv_batch_id msd_st_level_values.batch_id%TYPE;

1383: lb_rowid RowidTab;
1384: lb_level_value LevelValueTab;
1385: lb_sr_level_pk SrLevelPk;
1386: lv_sql_stmt VARCHAR2(4000);
1387: lv_batch_id msd_st_level_values.batch_id%TYPE;
1388: lv_message_text msc_errors.error_text%TYPE;
1389: lv_error_text VARCHAR2(250);
1390: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
1391: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 1401: FROM msd_st_level_values

1397: ex_logging_err EXCEPTION;
1398:
1399: CURSOR c1(p_batch_id NUMBER)IS
1400: SELECT rowid
1401: FROM msd_st_level_values
1402: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
1403: AND sr_instance_code = p_instance_code
1404: AND batch_id = p_batch_id;
1405:

Line 1408: FROM msd_st_level_values

1404: AND batch_id = p_batch_id;
1405:
1406: CURSOR c2(p_batch_id NUMBER) IS
1407: SELECT rowid
1408: FROM msd_st_level_values
1409: WHERE process_flag = G_IN_PROCESS
1410: AND sr_instance_code = p_instance_code
1411: AND batch_id = p_batch_id
1412: AND NVL(sr_level_pk,NULL_CHAR) = NULL_CHAR ;

Line 1429: FROM msd_st_level_values

1425: AND instance_id = p_instance_id;
1426: */
1427: CURSOR c3(p_batch_id NUMBER)IS
1428: SELECT level_value
1429: FROM msd_st_level_values
1430: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
1431: AND sr_instance_code = p_instance_code
1432: AND level_id = 1
1433: AND batch_id = p_batch_id;

Line 1458: UPDATE msd_st_level_values

1454:
1455: v_sql_stmt := 01;
1456:
1457: FORALL j IN 1..lb_rowid.COUNT
1458: UPDATE msd_st_level_values
1459: SET st_transaction_id = msd_st_level_values_s.NEXTVAL,
1460: last_update_date = lv_current_date,
1461: last_updated_by = lv_current_user,
1462: creation_date = lv_current_date,

Line 1459: SET st_transaction_id = msd_st_level_values_s.NEXTVAL,

1455: v_sql_stmt := 01;
1456:
1457: FORALL j IN 1..lb_rowid.COUNT
1458: UPDATE msd_st_level_values
1459: SET st_transaction_id = msd_st_level_values_s.NEXTVAL,
1460: last_update_date = lv_current_date,
1461: last_updated_by = lv_current_user,
1462: creation_date = lv_current_date,
1463: created_by = lv_current_user

Line 1482: (p_table_name => 'MSD_ST_LEVEL_VALUES',

1478: END IF;
1479:
1480: -- Derive LEVEL_ID from msd_levels
1481: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
1482: (p_table_name => 'MSD_ST_LEVEL_VALUES',
1483: p_level_name_col => 'LEVEL_NAME',
1484: p_level_id_col => 'LEVEL_ID',
1485: p_severity => G_SEV_ERROR,
1486: p_message_text => lv_message_text,

Line 1524: 'UPDATE msd_st_level_values'

1520: -- Error out the records if Level_id is IN (1,2,3,7,11,15,34) ASCP/DP common
1521: -- level values to be collected via MSC flat file
1522:
1523: lv_sql_stmt :=
1524: 'UPDATE msd_st_level_values'
1525: ||' SET process_flag = '||G_ERROR_FLG||','
1526: ||' error_text = '||''''||lv_message_text||''''
1527: ||' WHERE level_id IN (1,2,3,7,11,15,34)'
1528: ||' AND process_flag = '||G_IN_PROCESS

Line 1556: 'UPDATE msd_st_level_values'

1552: END IF;
1553:
1554: v_sql_stmt := 03;
1555: lv_sql_stmt :=
1556: 'UPDATE msd_st_level_values'
1557: ||' SET process_flag = '||G_ERROR_FLG||','
1558: ||' error_text = '||''''||lv_message_text||''''
1559: ||' WHERE NVL(level_value, '||''''||NULL_CHAR||''''||') '
1560: ||' = '||''''||NULL_CHAR||''''

Line 1580: (p_table_name => 'MSD_ST_LEVEL_VALUES',

1576:
1577: -- Now derive sr_level_pk from the ASCP tables if Level Values are loaded forERP data.
1578: v_sql_stmt := 05;
1579: lv_return := MSC_ST_UTIL.DERIVE_SETUP_SR_LEVEL_PK
1580: (p_table_name => 'MSD_ST_LEVEL_VALUES',
1581: p_level_val_col => 'LEVEL_VALUE',
1582: p_level_pk_col => 'SR_LEVEL_PK',
1583: p_level_id_col => 'LEVEL_ID',
1584: p_instance_code => p_instance_code,

Line 1668: (p_table_name => 'MSD_ST_LEVEL_VALUES',

1664:
1665: -- Now derive sr_level_pk from the msd_local_id_setup
1666: v_sql_stmt := 08;
1667: lv_return := MSC_ST_UTIL.DERIVE_SR_LEVEL_PK
1668: (p_table_name => 'MSD_ST_LEVEL_VALUES',
1669: p_level_val_col => 'LEVEL_VALUE',
1670: p_level_pk_col => 'SR_LEVEL_PK',
1671: p_level_id_col => 'LEVEL_ID',
1672: p_instance_code => p_instance_code,

Line 1686: pEntityName => 'MSD_ST_LEVEL_VALUES',

1682: (ERRBUF => lv_error_text,
1683: RETCODE => lv_return,
1684: pBatchID => lv_batch_id,
1685: pInstanceCode => p_instance_code,
1686: pEntityName => 'MSD_ST_LEVEL_VALUES',
1687: pInstanceID => p_instance_id);
1688:
1689: IF NVL(lv_return,0) <> 0 THEN
1690: RAISE ex_logging_err;

Line 1701: UPDATE msd_st_level_values

1697:
1698: IF c2%ROWCOUNT > 0 THEN
1699:
1700: /* FORALL j IN 1..lb_rowid.COUNT
1701: UPDATE msd_st_level_values
1702: SET sr_level_pk = msd_common_utilities.get_sr_level_pk(p_instance_id,p_instance_code)
1703: WHERE rowid = lb_rowid(j);
1704: */
1705:

Line 1713: UPDATE msd_st_level_values

1709: EXIT WHEN v_index = lb_rowid.COUNT;
1710: END LOOP;
1711:
1712: FORALL j IN 1..lb_rowid.COUNT
1713: UPDATE msd_st_level_values
1714: SET sr_level_pk = lb_sr_level_pk(j)
1715: WHERE rowid = lb_rowid(j);
1716:
1717:

Line 1743: FROM msd_st_level_values

1739: last_update_date,
1740: last_updated_by,
1741: creation_date,
1742: created_by
1743: FROM msd_st_level_values
1744: WHERE rowid = lb_rowid(j);
1745:
1746: END IF ;
1747:

Line 1752: (p_table_name => 'MSD_ST_LEVEL_VALUES',

1748: CLOSE c2;
1749:
1750: -- Set the process flag as Valid and populate instance_id
1751: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
1752: (p_table_name => 'MSD_ST_LEVEL_VALUES',
1753: p_instance_id => p_instance_id,
1754: p_instance_code => p_instance_code,
1755: p_process_flag => G_VALID,
1756: p_error_text => lv_error_text,

Line 1767: (p_table_name => 'MSD_ST_LEVEL_VALUES',

1763:
1764: -- Inserting all the errored out records into MSC_ERRORS
1765:
1766: lv_return := MSC_ST_UTIL.LOG_ERROR
1767: (p_table_name => 'MSD_ST_LEVEL_VALUES',
1768: p_instance_code => p_instance_code,
1769: p_row => lv_column_names,
1770: p_severity => G_SEV_ERROR,
1771: p_error_text => lv_error_text,

Line 1942: -- Derive SR_LEVEL_PK from msd_level_value or msd_st_level_values

1938: IF lv_return <> 0 THEN
1939: RAISE ex_logging_err;
1940: END IF;
1941:
1942: -- Derive SR_LEVEL_PK from msd_level_value or msd_st_level_values
1943:
1944: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
1945: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',
1946: p_level_val_col => 'SR_LEVEL_VALUE',

Line 1973: -- Derive SR_PARENT_LEVEL_PK from msd_level_values or msd_st_level_values

1969: IF lv_return <> 0 THEN
1970: RAISE ex_logging_err;
1971: END IF;
1972:
1973: -- Derive SR_PARENT_LEVEL_PK from msd_level_values or msd_st_level_values
1974:
1975: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
1976: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',
1977: p_level_val_col => 'SR_PARENT_LEVEL_VALUE',

Line 2223: INSERT INTO MSD_ST_LEVEL_VALUES

2219: FETCH c3 into lv_other_exist;
2220: CLOSE c3;
2221:
2222: IF lv_other_exist = 0 THEN
2223: INSERT INTO MSD_ST_LEVEL_VALUES
2224: (INSTANCE ,
2225: LEVEL_ID,
2226: LEVEL_VALUE,
2227: SR_LEVEL_PK,

Line 2296: INSERT INTO MSD_ST_LEVEL_VALUES --Inserting into MSD_ST_LEVEL_VALUES

2292:
2293: -- lv_sr_level_pk := -6; -- Inserting 'All Demand Classes' records with sr_level_pk as -6
2294:
2295:
2296: INSERT INTO MSD_ST_LEVEL_VALUES --Inserting into MSD_ST_LEVEL_VALUES
2297: (INSTANCE ,
2298: LEVEL_ID,
2299: LEVEL_VALUE,
2300: SR_LEVEL_PK,

Line 2441: -- Derive sr_item_pk from msd_st_level_values and msd_level_values

2437: IF lv_return <> 0 THEN
2438: RAISE ex_logging_err;
2439: END IF;
2440:
2441: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
2442:
2443: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2444: (p_table_name => 'MSD_ST_BOOKING_DATA',
2445: p_column_name => 'ITEM',

Line 2491: -- Derive SR_ORIGINAL_ITEM_PK from msd_st_level_values and msd_level_values

2487: IF lv_return <> 0 THEN
2488: RAISE ex_logging_err;
2489: END IF;
2490:
2491: -- Derive SR_ORIGINAL_ITEM_PK from msd_st_level_values and msd_level_values
2492:
2493: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2494: (p_table_name => 'MSD_ST_BOOKING_DATA',
2495: p_column_name => 'ORIGINAL_ITEM',

Line 2522: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values

2518: IF lv_return <> 0 THEN
2519: RAISE ex_logging_err;
2520: END IF;
2521:
2522: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values
2523:
2524: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2525: (p_table_name => 'MSD_ST_BOOKING_DATA',
2526: p_column_name => 'INV_ORG',

Line 2603: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values

2599: IF lv_return <> 0 THEN
2600: RAISE ex_logging_err;
2601: END IF;
2602:
2603: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values
2604:
2605: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2606: (p_table_name => 'MSD_ST_BOOKING_DATA',
2607: p_column_name => 'CUSTOMER',

Line 2632: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values

2628:
2629: IF lv_return <> 0 THEN
2630: RAISE ex_logging_err;
2631: END IF;
2632: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values
2633:
2634: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2635: (p_table_name => 'MSD_ST_BOOKING_DATA',
2636: p_column_name => 'SHIP_TO_LOC',

Line 2711: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

2707: IF lv_return <> 0 THEN
2708: RAISE ex_logging_err;
2709: END IF;
2710:
2711: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
2712:
2713: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2714: (p_table_name => 'MSD_ST_BOOKING_DATA',
2715: p_column_name => 'SALES_CHANNEL',

Line 2741: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values

2737:
2738: IF lv_return <> 0 THEN
2739: RAISE ex_logging_err;
2740: END IF;
2741: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
2742:
2743: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2744: (p_table_name => 'MSD_ST_BOOKING_DATA',
2745: p_column_name => 'SALES_REP',

Line 2773: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

2769: IF lv_return <> 0 THEN
2770: RAISE ex_logging_err;
2771: END IF;
2772:
2773: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
2774:
2775: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2776: (p_table_name => 'MSD_ST_BOOKING_DATA',
2777: p_column_name => 'DEMAND_CLASS_LVL_VAL',

Line 2806: -- Derive sr_parent_item_pk from msd_st_level_values and msd_level_values

2802: IF lv_return <> 0 THEN
2803: RAISE ex_logging_err;
2804: END IF;
2805:
2806: -- Derive sr_parent_item_pk from msd_st_level_values and msd_level_values
2807:
2808: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
2809: (p_table_name => 'MSD_ST_BOOKING_DATA',
2810: p_column_name => 'PARENT_ITEM',

Line 3113: INSERT INTO MSD_ST_LEVEL_VALUES

3109: FETCH c3 into lv_other_exist;
3110: CLOSE c3;
3111:
3112: IF lv_other_exist = 0 THEN
3113: INSERT INTO MSD_ST_LEVEL_VALUES
3114: (INSTANCE ,
3115: LEVEL_ID,
3116: LEVEL_VALUE,
3117: SR_LEVEL_PK,

Line 3186: INSERT INTO MSD_ST_LEVEL_VALUES --Inserting into MSD_ST_LEVEL_VALUES

3182:
3183: -- lv_sr_level_pk := -6; -- Inserting 'All Demand Classes' records with sr_level_pk as -6
3184:
3185:
3186: INSERT INTO MSD_ST_LEVEL_VALUES --Inserting into MSD_ST_LEVEL_VALUES
3187: (INSTANCE ,
3188: LEVEL_ID,
3189: LEVEL_VALUE,
3190: SR_LEVEL_PK,

Line 3331: -- Derive sr_item_pk from msd_st_level_values and msd_level_values

3327: IF lv_return <> 0 THEN
3328: RAISE ex_logging_err;
3329: END IF;
3330:
3331: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
3332:
3333: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3334: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3335: p_column_name => 'ITEM',

Line 3383: -- Derive sr_original_item_pk from msd_st_level_values and msd_level_values

3379: IF lv_return <> 0 THEN
3380: RAISE ex_logging_err;
3381: END IF;
3382:
3383: -- Derive sr_original_item_pk from msd_st_level_values and msd_level_values
3384:
3385: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3386: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3387: p_column_name => 'ORIGINAL_ITEM',

Line 3414: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values

3410: IF lv_return <> 0 THEN
3411: RAISE ex_logging_err;
3412: END IF;
3413:
3414: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values
3415:
3416: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3417: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3418: p_column_name => 'INV_ORG',

Line 3494: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values

3490: IF lv_return <> 0 THEN
3491: RAISE ex_logging_err;
3492: END IF;
3493:
3494: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values
3495:
3496: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3497: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3498: p_column_name => 'CUSTOMER',

Line 3524: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values

3520: IF lv_return <> 0 THEN
3521: RAISE ex_logging_err;
3522: END IF;
3523:
3524: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values
3525:
3526: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3527: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3528: p_column_name => 'SHIP_TO_LOC',

Line 3600: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

3596: IF lv_return <> 0 THEN
3597: RAISE ex_logging_err;
3598: END IF;
3599:
3600: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
3601:
3602: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3603: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3604: p_column_name => 'SALES_CHANNEL',

Line 3630: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values

3626:
3627: IF lv_return <> 0 THEN
3628: RAISE ex_logging_err;
3629: END IF;
3630: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
3631:
3632: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3633: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3634: p_column_name => 'SALES_REP',

Line 3661: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values

3657:
3658: IF lv_return <> 0 THEN
3659: RAISE ex_logging_err;
3660: END IF;
3661: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
3662:
3663: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3664: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3665: p_column_name => 'DEMAND_CLASS_LVL_VAL',

Line 3692: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values

3688:
3689: IF lv_return <> 0 THEN
3690: RAISE ex_logging_err;
3691: END IF;
3692: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
3693:
3694: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3695: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3696: p_column_name => 'PARENT_ITEM',

Line 3999: INSERT INTO MSD_ST_LEVEL_VALUES --Inserting the level value 'Others' at 'Demand Class' level in MSD_ST_LEVEL_VALUES.

3995: CLOSE c3;
3996:
3997: IF lv_other_exist = 0 THEN
3998:
3999: INSERT INTO MSD_ST_LEVEL_VALUES --Inserting the level value 'Others' at 'Demand Class' level in MSD_ST_LEVEL_VALUES.
4000: (INSTANCE ,
4001: LEVEL_ID,
4002: LEVEL_VALUE,
4003: SR_LEVEL_PK,

Line 4072: INSERT INTO MSD_ST_LEVEL_VALUES --Inserting the level value 'All Demand Classes' in MSD_ST_LEVEL_VALUES.

4068:
4069: -- lv_sr_level_pk := -6; -- Inserting 'All Demand Classes' records with sr_level_pk as -6
4070:
4071:
4072: INSERT INTO MSD_ST_LEVEL_VALUES --Inserting the level value 'All Demand Classes' in MSD_ST_LEVEL_VALUES.
4073: (INSTANCE ,
4074: LEVEL_ID,
4075: LEVEL_VALUE,
4076: SR_LEVEL_PK,

Line 4175: -- Derive sr_item_pk from msd_st_level_values and msd_level_values

4171: IF lv_return <> 0 THEN
4172: RAISE ex_logging_err;
4173: END IF;
4174:
4175: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
4176:
4177: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4178: (p_table_name => 'MSD_ST_MFG_FORECAST',
4179: p_column_name => 'ITEM',

Line 4204: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values

4200: IF lv_return <> 0 THEN
4201: RAISE ex_logging_err;
4202: END IF;
4203:
4204: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values
4205:
4206: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4207: (p_table_name => 'MSD_ST_MFG_FORECAST',
4208: p_column_name => 'INV_ORG',

Line 4234: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values

4230: IF lv_return <> 0 THEN
4231: RAISE ex_logging_err;
4232: END IF;
4233:
4234: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values
4235:
4236: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4237: (p_table_name => 'MSD_ST_MFG_FORECAST',
4238: p_column_name => 'CUSTOMER',

Line 4263: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values

4259:
4260: IF lv_return <> 0 THEN
4261: RAISE ex_logging_err;
4262: END IF;
4263: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values
4264:
4265: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4266: (p_table_name => 'MSD_ST_MFG_FORECAST',
4267: p_column_name => 'SHIP_TO_LOC',

Line 4293: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

4289: IF lv_return <> 0 THEN
4290: RAISE ex_logging_err;
4291: END IF;
4292:
4293: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
4294:
4295: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4296: (p_table_name => 'MSD_ST_MFG_FORECAST',
4297: p_column_name => 'SALES_CHANNEL',

Line 4324: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values

4320: IF lv_return <> 0 THEN
4321: RAISE ex_logging_err;
4322: END IF;
4323:
4324: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
4325:
4326: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4327: (p_table_name => 'MSD_ST_MFG_FORECAST',
4328: p_column_name => 'DEMAND_CLASS_LVL_VAL',

Line 6108: -- or msd_st_level_values

6104: RAISE ex_logging_err;
6105: END IF;
6106:
6107: -- Derive SR_LEVEL_PK - attribute_3 from msd_level_values
6108: -- or msd_st_level_values
6109:
6110: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6111: (p_table_name => 'MSD_ST_CS_DATA',
6112: p_level_val_col => 'ATTRIBUTE_4',

Line 6171: -- or msd_st_level_values

6167: RAISE ex_logging_err;
6168: END IF;
6169:
6170: -- Derive SR_LEVEL_PK - attribute_7 from msd_level_values
6171: -- or msd_st_level_values
6172:
6173: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6174: (p_table_name => 'MSD_ST_CS_DATA',
6175: p_level_val_col => 'ATTRIBUTE_8',

Line 6234: -- or msd_st_level_values

6230: RAISE ex_logging_err;
6231: END IF;
6232:
6233: -- Derive SR_LEVEL_PK - attribute_11 from msd_level_values
6234: -- or msd_st_level_values
6235:
6236: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6237: (p_table_name => 'MSD_ST_CS_DATA',
6238: p_level_val_col => 'ATTRIBUTE_12',

Line 6315: -- or msd_st_level_values

6311: RAISE ex_logging_err;
6312: END IF;
6313:
6314: -- Derive SR_LEVEL_PK - attribute_15 from msd_level_values
6315: -- or msd_st_level_values
6316:
6317: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6318: (p_table_name => 'MSD_ST_CS_DATA',
6319: p_level_val_col => 'ATTRIBUTE_16',

Line 6380: -- or msd_st_level_values

6376: RAISE ex_logging_err;
6377: END IF;
6378:
6379: -- Derive SR_LEVEL_PK - attribute_19 from msd_level_values
6380: -- or msd_st_level_values
6381:
6382: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6383: (p_table_name => 'MSD_ST_CS_DATA',
6384: p_level_val_col => 'ATTRIBUTE_20',

Line 6443: -- or msd_st_level_values

6439: RAISE ex_logging_err;
6440: END IF;
6441:
6442: -- Derive SR_LEVEL_PK - attribute_23 from msd_level_values
6443: -- or msd_st_level_values
6444:
6445: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6446: (p_table_name => 'MSD_ST_CS_DATA',
6447: p_level_val_col => 'ATTRIBUTE_24',

Line 6506: -- or msd_st_level_values

6502: RAISE ex_logging_err;
6503: END IF;
6504:
6505: -- Derive SR_LEVEL_PK - attribute_27 from msd_level_values
6506: -- or msd_st_level_values
6507:
6508: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6509: (p_table_name => 'MSD_ST_CS_DATA',
6510: p_level_val_col => 'ATTRIBUTE_28',

Line 6568: -- or msd_st_level_values

6564: RAISE ex_logging_err;
6565: END IF;
6566:
6567: -- Derive SR_LEVEL_PK - attribute_31 from msd_level_values
6568: -- or msd_st_level_values
6569:
6570: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6571: (p_table_name => 'MSD_ST_CS_DATA',
6572: p_level_val_col => 'ATTRIBUTE_32',

Line 6631: -- or msd_st_level_values

6627: RAISE ex_logging_err;
6628: END IF;
6629:
6630: -- Derive SR_LEVEL_PK - attribute_51 from msd_level_values
6631: -- or msd_st_level_values
6632:
6633: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6634: (p_table_name => 'MSD_ST_CS_DATA',
6635: p_level_val_col => 'ATTRIBUTE_52',

Line 7646: -- Derive sr_item_pk from msd_st_level_values and msd_level_values

7642: IF lv_return <> 0 THEN
7643: RAISE ex_logging_err;
7644: END IF;
7645:
7646: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
7647:
7648: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
7649: (p_table_name => 'MSD_ST_UOM_CONVERSIONS',
7650: p_column_name => 'ITEM',

Line 7999: -- Derive INVENTORY_ITEM_ID from msd_st_level_values and msd_level_values

7995: IF lv_return <> 0 THEN
7996: RAISE ex_logging_err;
7997: END IF;
7998:
7999: -- Derive INVENTORY_ITEM_ID from msd_st_level_values and msd_level_values
8000:
8001: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
8002: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',
8003: p_column_name => 'INVENTORY_ITEM',

Line 8030: -- Derive RELATED_ITEM_ID from msd_st_level_values and msd_level_values

8026: IF lv_return <> 0 THEN
8027: RAISE ex_logging_err;
8028: END IF;
8029:
8030: -- Derive RELATED_ITEM_ID from msd_st_level_values and msd_level_values
8031:
8032: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
8033: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',
8034: p_column_name => 'RELATED_ITEM',

Line 8380: -- Derive SR_LEVEL_PK from msd_level_values or msd_st_level_values

8376: IF lv_return <> 0 THEN
8377: RAISE ex_logging_err;
8378: END IF;
8379:
8380: -- Derive SR_LEVEL_PK from msd_level_values or msd_st_level_values
8381:
8382: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
8383: (p_table_name => 'MSD_ST_LEVEL_ORG_ASSCNS',
8384: p_level_val_col => 'LEVEL_VALUE',

Line 8410: -- Derive ORG_SR_LEVEL_PK from msd_level_values or msd_st_level_values

8406: IF lv_return <> 0 THEN
8407: RAISE ex_logging_err;
8408: END IF;
8409:
8410: -- Derive ORG_SR_LEVEL_PK from msd_level_values or msd_st_level_values
8411:
8412: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
8413: (p_table_name => 'MSD_ST_LEVEL_ORG_ASSCNS',
8414: p_level_val_col => 'ORG_LEVEL_VALUE',

Line 8496: delete from msd_st_level_values m1

8492: IS
8493: lv_error_text VARCHAR2(250);
8494: BEGIN
8495: v_sql_stmt := 01;
8496: delete from msd_st_level_values m1
8497: where rowid<>(select max(rowid) from msd_st_level_values m2
8498: where m2.level_id= m1.level_id and m2.instance = m1.instance
8499: and m2.sr_level_pk = m1.sr_level_pk )
8500: and m1.instance=p_instance_id ;

Line 8497: where rowid<>(select max(rowid) from msd_st_level_values m2

8493: lv_error_text VARCHAR2(250);
8494: BEGIN
8495: v_sql_stmt := 01;
8496: delete from msd_st_level_values m1
8497: where rowid<>(select max(rowid) from msd_st_level_values m2
8498: where m2.level_id= m1.level_id and m2.instance = m1.instance
8499: and m2.sr_level_pk = m1.sr_level_pk )
8500: and m1.instance=p_instance_id ;
8501: