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_BOOKING_DATA

Line 2108: lv_batch_id msd_st_booking_data.batch_id%TYPE;

2104: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
2105: lb_rowid RowidTab;
2106: /* lb_rowid1 RowidTab; Bug3749959 */
2107: lv_sql_stmt VARCHAR2(4000);
2108: lv_batch_id msd_st_booking_data.batch_id%TYPE;
2109: lv_message_text msc_errors.error_text%TYPE;
2110: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
2111: lv_error_text VARCHAR2(250);
2112: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

Line 2136: FROM msd_st_booking_data

2132: WHERE instance_id=p_instance_id;
2133:
2134: CURSOR c1(p_batch_id NUMBER)IS
2135: SELECT rowid
2136: FROM msd_st_booking_data
2137: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
2138: AND sr_instance_code = p_instance_code
2139: AND batch_id = p_batch_id;
2140: /*

Line 2143: FROM msd_st_booking_data

2139: AND batch_id = p_batch_id;
2140: /*
2141: CURSOR c2(p_batch_id NUMBER)IS
2142: SELECT rowid
2143: FROM msd_st_booking_data
2144: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
2145: AND nvl(DEMAND_CLASS_LVL_VAL,'-1') = '-1'
2146: AND sr_instance_code = p_instance_code
2147: AND batch_id = p_batch_id;

Line 2193: UPDATE msd_st_booking_data

2189: CLOSE c1;
2190:
2191: v_sql_stmt := 04;
2192: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
2193: UPDATE msd_st_booking_data
2194: SET st_transaction_id = msd_st_booking_data_s.NEXTVAL,
2195: last_update_date = lv_current_date,
2196: last_updated_by = lv_current_user,
2197: creation_date = lv_current_date,

Line 2194: SET st_transaction_id = msd_st_booking_data_s.NEXTVAL,

2190:
2191: v_sql_stmt := 04;
2192: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
2193: UPDATE msd_st_booking_data
2194: SET st_transaction_id = msd_st_booking_data_s.NEXTVAL,
2195: last_update_date = lv_current_date,
2196: last_updated_by = lv_current_user,
2197: creation_date = lv_current_date,
2198: created_by = lv_current_user

Line 2213: UPDATE msd_st_booking_data

2209: lv_all_dcs_desc := msd_sr_util.get_all_dcs_desc; --Calling fuction - msd_sr_util.get_all_dcs_desc, to fetch the level value 'All Demand Classes'
2210:
2211: v_sql_stmt := 05;
2212: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST
2213: UPDATE msd_st_booking_data
2214: SET DEMAND_CLASS_LVL_VAL = lv_other_desc --Using the value fetched from function - msd_sr_util.get_null_desc
2215: WHERE rowid = lb_rowid1(j);
2216:
2217:

Line 2403: p_token_value3 => 'MSD_ST_BOOKING_DATA');

2399: ||' CUSTOMER AND SHIP_TO_LOC',
2400: p_token2 => 'MASTER_TABLE',
2401: p_token_value2 => 'MSC_TRADING_PARTNER_SITES',
2402: p_token3 => 'CHILD_TABLE',
2403: p_token_value3 => 'MSD_ST_BOOKING_DATA');
2404:
2405: IF lv_return <> 0 THEN
2406: RAISE ex_logging_err;
2407: END IF;

Line 2411: UPDATE msd_st_booking_data mbd

2407: END IF;
2408:
2409: -- Validate customer-ship to location combination
2410: v_sql_stmt := 06;
2411: UPDATE msd_st_booking_data mbd
2412: SET process_flag = G_ERROR_FLG,
2413: error_text = lv_message_text
2414: WHERE NOT EXISTS(SELECT 1
2415: FROM msc_local_id_setup mls

Line 2444: (p_table_name => 'MSD_ST_BOOKING_DATA',

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',
2446: p_pk_col_name => 'SR_ITEM_PK',
2447: p_level_id => 1,
2448: p_instance_code => p_instance_code,

Line 2463: 'UPDATE msd_st_booking_data '

2459: -- Code generated against the bug number : 2357511
2460: v_sql_stmt := 07;
2461:
2462: lv_sql_Stmt:=
2463: 'UPDATE msd_st_booking_data '
2464: ||' SET ORIGINAL_ITEM =ITEM '
2465: ||' WHERE ORIGINAL_ITEM IS NULL '
2466: ||' AND process_flag ='|| G_IN_PROCESS
2467: ||' AND batch_id = :lv_batch_id'

Line 2494: (p_table_name => 'MSD_ST_BOOKING_DATA',

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',
2496: p_pk_col_name => 'SR_ORIGINAL_ITEM_PK',
2497: p_level_id => 1,
2498: p_instance_code => p_instance_code,

Line 2525: (p_table_name => 'MSD_ST_BOOKING_DATA',

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',
2527: p_pk_col_name => 'SR_INV_ORG_PK',
2528: p_level_id => 7,
2529: p_instance_code => p_instance_code,

Line 2554: p_token_value3 => 'MSD_ST_BOOKING_DATA');

2550: ||' AND ITEM.MRP_PLANNING_CODE',
2551: p_token2 => 'MASTER_TABLE',
2552: p_token_value2 => 'MSC_SYSTEM_ITEMS',
2553: p_token3 => 'CHILD_TABLE',
2554: p_token_value3 => 'MSD_ST_BOOKING_DATA');
2555:
2556: IF lv_return <> 0 THEN
2557: RAISE ex_logging_err;
2558: END IF;

Line 2563: UPDATE msd_st_booking_data mbd

2559:
2560: -- Validate item-org combination
2561: v_sql_stmt := 15;
2562:
2563: UPDATE msd_st_booking_data mbd
2564: SET process_flag = G_ERROR_FLG,
2565: error_text = lv_message_text
2566: WHERE NOT EXISTS(SELECT 1
2567: FROM msc_st_system_items msi

Line 2606: (p_table_name => 'MSD_ST_BOOKING_DATA',

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',
2608: p_pk_col_name => 'SR_CUSTOMER_PK',
2609: p_level_id => 15,
2610: p_instance_code => p_instance_code,

Line 2635: (p_table_name => 'MSD_ST_BOOKING_DATA',

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',
2637: p_pk_col_name => 'SR_SHIP_TO_LOC_PK',
2638: p_level_id => 11,
2639: p_instance_code => p_instance_code,

Line 2664: p_token_value3 => 'MSD_ST_BOOKING_DATA');

2660: ||' CUSTOMER AND SHIP_TO_LOC',
2661: p_token2 => 'MASTER_TABLE',
2662: p_token_value2 => 'MSD_LEVEL_ASSOCIATIONS',
2663: p_token3 => 'CHILD_TABLE',
2664: p_token_value3 => 'MSD_ST_BOOKING_DATA');
2665:
2666: IF lv_return <> 0 THEN
2667: RAISE ex_logging_err;
2668: END IF;

Line 2672: UPDATE msd_st_booking_data mbd

2668: END IF;
2669:
2670:
2671: -- Validate customer-ship to location combination for ERP Data
2672: UPDATE msd_st_booking_data mbd
2673: SET process_flag = G_ERROR_FLG,
2674: error_text = lv_message_text
2675: WHERE NOT EXISTS(SELECT 1
2676: FROM msd_st_level_associations msla

Line 2714: (p_table_name => 'MSD_ST_BOOKING_DATA',

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',
2716: p_pk_col_name => 'SR_SALES_CHANNEL_PK',
2717: p_level_id => 27,
2718: p_instance_code => p_instance_code,

Line 2744: (p_table_name => 'MSD_ST_BOOKING_DATA',

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',
2746: p_pk_col_name => 'SR_SALES_REP_PK',
2747: p_level_id => 18,
2748: p_instance_code => p_instance_code,

Line 2776: (p_table_name => 'MSD_ST_BOOKING_DATA',

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',
2778: p_pk_col_name => 'SR_DEMAND_CLASS_PK',
2779: p_level_id => 34,
2780: p_instance_code => p_instance_code,

Line 2809: (p_table_name => 'MSD_ST_BOOKING_DATA',

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',
2811: p_pk_col_name => 'SR_PARENT_ITEM_PK',
2812: p_level_id => 1,
2813: p_instance_code => p_instance_code,

Line 2842: (p_table_name => 'MSD_ST_BOOKING_DATA',

2838:
2839: -- Derive SR_USER_DEFINED1_LVL_PK
2840:
2841: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
2842: (p_table_name => 'MSD_ST_BOOKING_DATA',
2843: p_level_val_col => 'USER_DEFINED1',
2844: p_level_name_col => 'USER_DEFINED_LEVEL1',
2845: p_level_pk_col => 'SR_USER_DEFINED1_PK',
2846: p_instance_code => p_instance_code,

Line 2873: (p_table_name => 'MSD_ST_BOOKING_DATA',

2869:
2870: -- Derive SR_USER_DEFINED2_LVL_PK
2871:
2872: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
2873: (p_table_name => 'MSD_ST_BOOKING_DATA',
2874: p_level_val_col => 'USER_DEFINED2',
2875: p_level_name_col => 'USER_DEFINED_LEVEL2',
2876: p_level_pk_col => 'SR_USER_DEFINED2_PK',
2877: p_instance_code => p_instance_code,

Line 2904: 'UPDATE msd_st_booking_data '

2900: --booked_date cannot be null.
2901: v_sql_stmt := 07;
2902:
2903: lv_sql_Stmt:=
2904: 'UPDATE msd_st_booking_data '
2905: ||' SET process_flag ='||G_ERROR_FLG||','
2906: ||' error_text = '||''''||lv_message_text||''''
2907: ||' WHERE NVL(booked_date,(sysdate-36500)) = (sysdate-36500)'
2908: ||' AND process_flag ='|| G_IN_PROCESS

Line 2926: pEntityName => 'MSD_ST_BOOKING_DATA',

2922: (ERRBUF => lv_error_text,
2923: RETCODE => lv_return,
2924: pBatchID => null,
2925: pInstanceCode => p_instance_code,
2926: pEntityName => 'MSD_ST_BOOKING_DATA',
2927: pInstanceID => p_instance_id);
2928:
2929: IF lv_return <> 0 THEN
2930: RAISE ex_logging_err;

Line 2935: (p_table_name => 'MSD_ST_BOOKING_DATA',

2931: END IF;
2932:
2933: -- Set the process flag as Valid and populate instance_id
2934: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
2935: (p_table_name => 'MSD_ST_BOOKING_DATA',
2936: p_instance_id => p_instance_id,
2937: p_instance_code => p_instance_code,
2938: p_process_flag => G_VALID,
2939: p_error_text => lv_error_text,

Line 2950: (p_table_name => 'MSD_ST_BOOKING_DATA',

2946:
2947: -- Inserting all the errored out records into MSC_ERRORS:
2948:
2949: lv_return := MSC_ST_UTIL.LOG_ERROR
2950: (p_table_name => 'MSD_ST_BOOKING_DATA',
2951: p_instance_code => p_instance_code,
2952: p_row => lv_column_names,
2953: p_severity => G_SEV_ERROR,
2954: p_error_text => lv_error_text,