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_CS_DATA

Line 5879: lv_batch_id msd_st_cs_data.batch_id%TYPE;

5875: IS
5876: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
5877: lb_rowid RowidTab;
5878: lv_sql_stmt VARCHAR2(4000);
5879: lv_batch_id msd_st_cs_data.batch_id%TYPE;
5880: lv_message_text msc_errors.error_text%TYPE;
5881: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
5882: lv_error_text VARCHAR2(250);
5883: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

Line 5893: FROM msd_st_cs_data

5889: lv_column_names VARCHAR2(5000);
5890:
5891: CURSOR c1(p_batch_id NUMBER)IS
5892: SELECT rowid
5893: FROM msd_st_cs_data
5894: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
5895: AND sr_instance_code = p_instance_code
5896: AND batch_id = p_batch_id;
5897:

Line 5943: UPDATE msd_st_cs_data

5939: CLOSE c1;
5940:
5941: v_sql_stmt := 04;
5942: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
5943: UPDATE msd_st_cs_data
5944: SET st_transaction_id = cs_st_data_id,
5945: last_update_date = lv_current_date,
5946: last_updated_by = lv_current_user,
5947: creation_date = lv_current_date,

Line 5953: UPDATE msd_st_cs_data

5949: WHERE rowid = lb_rowid(j);
5950:
5951: /*
5952: Earlier sql statement :
5953: UPDATE msd_st_cs_data
5954: SET st_transaction_id = msd_st_cs_data_s.NEXTVAL,
5955: cs_st_data_id = msd_st_cs_data_s.CURRVAL, -- SEQUENCE
5956: last_update_date = lv_current_date,
5957: last_updated_by = lv_current_user,

Line 5954: SET st_transaction_id = msd_st_cs_data_s.NEXTVAL,

5950:
5951: /*
5952: Earlier sql statement :
5953: UPDATE msd_st_cs_data
5954: SET st_transaction_id = msd_st_cs_data_s.NEXTVAL,
5955: cs_st_data_id = msd_st_cs_data_s.CURRVAL, -- SEQUENCE
5956: last_update_date = lv_current_date,
5957: last_updated_by = lv_current_user,
5958: creation_date = lv_current_date,

Line 5955: cs_st_data_id = msd_st_cs_data_s.CURRVAL, -- SEQUENCE

5951: /*
5952: Earlier sql statement :
5953: UPDATE msd_st_cs_data
5954: SET st_transaction_id = msd_st_cs_data_s.NEXTVAL,
5955: cs_st_data_id = msd_st_cs_data_s.CURRVAL, -- SEQUENCE
5956: last_update_date = lv_current_date,
5957: last_updated_by = lv_current_user,
5958: creation_date = lv_current_date,
5959: created_by = lv_current_user

Line 5966: ' UPDATE msd_st_cs_data mscd'

5962: -- Derive the CS_DEFINITION_ID from msd_cs_definitions
5963:
5964: v_sql_stmt := 05;
5965: lv_sql_stmt :=
5966: ' UPDATE msd_st_cs_data mscd'
5967: ||' SET cs_definition_id = NVL(( SELECT cs_definition_id'
5968: ||' FROM msd_cs_definitions mcd'
5969: ||' WHERE mscd.cs_definition_name = mcd.name),'||NULL_VALUE||')'
5970: ||' WHERE process_flag = '||G_IN_PROCESS

Line 6001: 'UPDATE msd_st_cs_data'

5997: -- This indicates that this custom stream has not been defined via UI
5998:
5999: v_sql_stmt := 06;
6000: lv_sql_stmt :=
6001: 'UPDATE msd_st_cs_data'
6002: ||' SET process_flag = '||G_ERROR_FLG||','
6003: ||' error_text = '||''''||lv_message_text||''''
6004: ||' WHERE NVL(cs_definition_id,'||NULL_VALUE||') = '||NULL_VALUE
6005: ||' AND batch_id = :lv_batch_id'

Line 6020: UPDATE msd_st_cs_data

6016:
6017: -- This code is added for fix 3730302.
6018: -- Updating the two date columns REQUESTED_DATE and SCHEDULED_DATE for the 3 CMRO streams.
6019: /*
6020: UPDATE msd_st_cs_data
6021: SET attribute_45 = attribute_43
6022: WHERE cs_definition_name IN ('MSD_CMRO_FIRM_MTL_REQUIREMENT','MSD_CMRO_UNPLANNED_HISTORY','MSD_CMRO_PLANNED_HISTORY')
6023: AND batch_id = lv_batch_id
6024: AND process_flag = G_IN_PROCESS

Line 6043: 'UPDATE msd_st_cs_data'

6039: END IF;
6040:
6041: v_sql_stmt := 07;
6042: lv_sql_stmt :=
6043: 'UPDATE msd_st_cs_data'
6044: ||' SET process_flag = '||G_ERROR_FLG||','
6045: ||' error_text = '||''''||lv_message_text||''''
6046: ||' WHERE NVL(cs_name, '||''''||NULL_CHAR||''''||') '
6047: ||' = '||''''||NULL_CHAR||''''

Line 6080: (p_table_name => 'MSD_ST_CS_DATA',

6076: -- Derive the level_id , error out if invalid level name
6077: --attribute_2 (prd_level_id)
6078:
6079: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6080: (p_table_name => 'MSD_ST_CS_DATA',
6081: p_level_name_col => 'ATTRIBUTE_2_VAL',
6082: p_level_id_col => 'ATTRIBUTE_2',
6083: p_severity => G_SEV3_ERROR ,
6084: p_message_text => lv_message_text,

Line 6111: (p_table_name => 'MSD_ST_CS_DATA',

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',
6113: p_level_name_col => 'ATTRIBUTE_2_VAL',
6114: p_level_pk_col => 'ATTRIBUTE_3',
6115: p_instance_code => p_instance_code,

Line 6143: (p_table_name => 'MSD_ST_CS_DATA',

6139: -- Derive the level_id , error out if invalid level name
6140: -- Attribute_6 (geo_level_id)
6141:
6142: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6143: (p_table_name => 'MSD_ST_CS_DATA',
6144: p_level_name_col => 'ATTRIBUTE_6_VAL',
6145: p_level_id_col => 'ATTRIBUTE_6',
6146: p_severity => G_SEV3_ERROR ,
6147: p_message_text => lv_message_text,

Line 6174: (p_table_name => 'MSD_ST_CS_DATA',

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',
6176: p_level_name_col => 'ATTRIBUTE_6_VAL',
6177: p_level_pk_col => 'ATTRIBUTE_7',
6178: p_instance_code => p_instance_code,

Line 6206: (p_table_name => 'MSD_ST_CS_DATA',

6202: -- Derive the level_id , error out if invalid level name
6203: -- attribute_10 (org_level_id)
6204:
6205: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6206: (p_table_name => 'MSD_ST_CS_DATA',
6207: p_level_name_col => 'ATTRIBUTE_10_VAL',
6208: p_level_id_col => 'ATTRIBUTE_10',
6209: p_severity => G_SEV3_ERROR ,
6210: p_message_text => lv_message_text,

Line 6237: (p_table_name => 'MSD_ST_CS_DATA',

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',
6239: p_level_name_col => 'ATTRIBUTE_10_VAL',
6240: p_level_pk_col => 'ATTRIBUTE_11',
6241: p_instance_code => p_instance_code,

Line 6268: (p_table_name => 'MSD_ST_CS_DATA',

6264: -- Derive the level_id , error out if invalid level name
6265: --attribute_14 (cus_level_id)
6266:
6267: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6268: (p_table_name => 'MSD_ST_CS_DATA',
6269: p_level_name_col => 'ATTRIBUTE_14_VAL',
6270: p_level_id_col => 'ATTRIBUTE_14',
6271: p_severity => G_SEV3_ERROR ,
6272: p_message_text => lv_message_text,

Line 6284: ' UPDATE msd_st_cs_data mscd'

6280: */
6281:
6282: v_sql_stmt := 08;
6283: lv_sql_stmt :=
6284: ' UPDATE msd_st_cs_data mscd'
6285: ||' SET attribute_14 = 1'
6286: ||' WHERE attribute_16 is not null'
6287: ||' AND process_flag = '||G_IN_PROCESS
6288: ||' AND batch_id = :lv_batch_id'

Line 6318: (p_table_name => 'MSD_ST_CS_DATA',

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',
6320: p_level_name_col => 'ATTRIBUTE_14_VAL',
6321: p_level_pk_col => 'ATTRIBUTE_15',
6322: p_instance_code => p_instance_code,

Line 6351: (p_table_name => 'MSD_ST_CS_DATA',

6347: -- Derive the level_id , error out if invalid level name
6348: --attribute_18 (rep_level_id)
6349:
6350: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6351: (p_table_name => 'MSD_ST_CS_DATA',
6352: p_level_name_col => 'ATTRIBUTE_18_VAL',
6353: p_level_id_col => 'ATTRIBUTE_18',
6354: p_severity => G_SEV3_ERROR ,
6355: p_message_text => lv_message_text,

Line 6383: (p_table_name => 'MSD_ST_CS_DATA',

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',
6385: p_level_name_col => 'ATTRIBUTE_18_VAL',
6386: p_level_pk_col => 'ATTRIBUTE_19',
6387: p_instance_code => p_instance_code,

Line 6415: (p_table_name => 'MSD_ST_CS_DATA',

6411: -- Derive the level_id , error out if invalid level name
6412: --attribute_22 (chn_level_id)
6413:
6414: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6415: (p_table_name => 'MSD_ST_CS_DATA',
6416: p_level_name_col => 'ATTRIBUTE_22_VAL',
6417: p_level_id_col => 'ATTRIBUTE_22',
6418: p_severity => G_SEV3_ERROR ,
6419: p_message_text => lv_message_text,

Line 6446: (p_table_name => 'MSD_ST_CS_DATA',

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',
6448: p_level_name_col => 'ATTRIBUTE_22_VAL',
6449: p_level_pk_col => 'ATTRIBUTE_23',
6450: p_instance_code => p_instance_code,

Line 6478: (p_table_name => 'MSD_ST_CS_DATA',

6474: -- Derive the level_id , error out if invalid level name
6475: --attribute_26 (ud1_level_id)
6476:
6477: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6478: (p_table_name => 'MSD_ST_CS_DATA',
6479: p_level_name_col => 'ATTRIBUTE_26_VAL',
6480: p_level_id_col => 'ATTRIBUTE_26',
6481: p_severity => G_SEV3_ERROR ,
6482: p_message_text => lv_message_text,

Line 6509: (p_table_name => 'MSD_ST_CS_DATA',

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',
6511: p_level_name_col => 'ATTRIBUTE_26_VAL',
6512: p_level_pk_col => 'ATTRIBUTE_27',
6513: p_instance_code => p_instance_code,

Line 6540: (p_table_name => 'MSD_ST_CS_DATA',

6536: -- Derive the level_id , error out if invalid level name
6537: --attribute_30 (ud2_level_id)
6538:
6539: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6540: (p_table_name => 'MSD_ST_CS_DATA',
6541: p_level_name_col => 'ATTRIBUTE_30_VAL',
6542: p_level_id_col => 'ATTRIBUTE_30',
6543: p_severity => G_SEV3_ERROR,
6544: p_message_text => lv_message_text,

Line 6571: (p_table_name => 'MSD_ST_CS_DATA',

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',
6573: p_level_name_col => 'ATTRIBUTE_30_VAL',
6574: p_level_pk_col => 'ATTRIBUTE_31',
6575: p_instance_code => p_instance_code,

Line 6603: (p_table_name => 'MSD_ST_CS_DATA',

6599: -- Derive the level_id , error out if invalid level name
6600: -- attribute_50 (demand_class_level_id)
6601:
6602: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6603: (p_table_name => 'MSD_ST_CS_DATA',
6604: p_level_name_col => 'ATTRIBUTE_50_VAL',
6605: p_level_id_col => 'ATTRIBUTE_50',
6606: p_severity => G_SEV3_ERROR ,
6607: p_message_text => lv_message_text,

Line 6634: (p_table_name => 'MSD_ST_CS_DATA',

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',
6636: p_level_name_col => 'ATTRIBUTE_50_VAL',
6637: p_level_pk_col => 'ATTRIBUTE_51',
6638: p_instance_code => p_instance_code,

Line 6670: p_token_value3 => 'MSD_ST_CS_DATA');

6666: ||' AND ITEM.MRP_PLANNING_CODE',
6667: p_token2 => 'MASTER_TABLE',
6668: p_token_value2 => 'MSC_SYSTEM_ITEMS',
6669: p_token3 => 'CHILD_TABLE',
6670: p_token_value3 => 'MSD_ST_CS_DATA');
6671:
6672: IF lv_return <> 0 THEN
6673: RAISE ex_logging_err;
6674: END IF;

Line 6679: UPDATE msd_st_cs_data mcd

6675:
6676: -- Validate item-org combination
6677: v_sql_stmt := 15;
6678:
6679: UPDATE msd_st_cs_data mcd
6680: SET process_flag = G_ERROR_FLG,
6681: error_text = lv_message_text
6682: WHERE NOT EXISTS(SELECT 1
6683: FROM msc_st_system_items msi

Line 6713: pEntityName => 'MSD_ST_CS_DATA',

6709: (ERRBUF => lv_error_text,
6710: RETCODE => lv_return,
6711: pBatchID => null,
6712: pInstanceCode => p_instance_code,
6713: pEntityName => 'MSD_ST_CS_DATA',
6714: pInstanceID => p_instance_id);
6715:
6716: IF lv_return <> 0 THEN
6717: RAISE ex_logging_err;

Line 6726: pEntityName => 'MSD_ST_CS_DATA',

6722: (ERRBUF => lv_error_text,
6723: RETCODE => lv_return,
6724: pBatchID => lv_batch_id,
6725: pInstanceCode => p_instance_code,
6726: pEntityName => 'MSD_ST_CS_DATA',
6727: pInstanceID => p_instance_id);
6728:
6729: IF NVL(lv_return,0) <> 0 THEN
6730: RAISE ex_logging_err;

Line 6735: (p_table_name => 'MSD_ST_CS_DATA',

6731: END IF;
6732:
6733: -- Set the process flag as Valid and populate instance_id
6734: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
6735: (p_table_name => 'MSD_ST_CS_DATA',
6736: p_instance_id => p_instance_id,
6737: p_instance_code => p_instance_code,
6738: p_process_flag => G_VALID,
6739: p_error_text => lv_error_text,

Line 6750: (p_table_name => 'MSD_ST_CS_DATA',

6746:
6747: -- Inserting all the errored out records into MSC_ERRORS:
6748:
6749: lv_return := MSC_ST_UTIL.LOG_ERROR
6750: (p_table_name => 'MSD_ST_CS_DATA',
6751: p_instance_code => p_instance_code,
6752: p_row => lv_column_names,
6753: p_severity => G_SEV_ERROR,
6754: p_error_text => lv_error_text,

Line 8554: FROM msd_st_cs_data

8550: IS
8551:
8552: CURSOR c1 IS
8553: SELECT distinct cs_name,cs_definition_id
8554: FROM msd_st_cs_data
8555: WHERE attribute_1 = to_char(p_instance_id)
8556: AND request_id = p_request_id; --Bug 3002566
8557:
8558: lv_request_id NUMBER;