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_ASSOCIATIONS

Line 582: -- Insert into msd_st_level_associations.

578: -1,
579: sysdate);
580:
581:
582: -- Insert into msd_st_level_associations.
583:
584: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS
585: (INSTANCE ,
586: LEVEL_ID,

Line 584: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS

580:
581:
582: -- Insert into msd_st_level_associations.
583:
584: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS
585: (INSTANCE ,
586: LEVEL_ID,
587: SR_LEVEL_PK,
588: PARENT_LEVEL_ID,

Line 633: ' INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS'

629:
630: /* v_sql_stmt := 04; -- bug 5586170
631:
632: lv_sql_stmt :=
633: ' INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS'
634: ||' (INSTANCE , '
635: ||' LEVEL_ID, '
636: ||' SR_LEVEL_PK, '
637: ||' PARENT_LEVEL_ID,'

Line 873: ' INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS'

869:
870: v_sql_stmt := 02;
871:
872: lv_sql_stmt :=
873: ' INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS'
874: ||' (INSTANCE , '
875: ||' LEVEL_ID, '
876: ||' SR_LEVEL_PK, '
877: ||' PARENT_LEVEL_ID,'

Line 1076: ' INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS'

1072: IF lv_other_exist >= 1 THEN
1073:
1074: v_sql_stmt := 02;
1075: lv_sql_stmt :=
1076: ' INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS'
1077: ||' (INSTANCE , '
1078: ||' LEVEL_ID, '
1079: ||' SR_LEVEL_PK, '
1080: ||' PARENT_LEVEL_ID,'

Line 1303: ' INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS'

1299:
1300: v_sql_stmt := 02;
1301:
1302: lv_sql_stmt :=
1303: ' INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS'
1304: ||' (INSTANCE , '
1305: ||' LEVEL_ID, '
1306: ||' SR_LEVEL_PK, '
1307: ||' PARENT_LEVEL_ID,'

Line 1821: lv_batch_id msd_st_level_associations.batch_id%TYPE;

1817: IS
1818: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1819: lb_rowid RowidTab;
1820: lv_sql_stmt VARCHAR2(4000);
1821: lv_batch_id msd_st_level_associations.batch_id%TYPE;
1822: lv_message_text msc_errors.error_text%TYPE;
1823: lv_error_text VARCHAR2(250);
1824: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
1825: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 1834: FROM msd_st_level_associations

1830: lv_column_names VARCHAR2(5000);
1831:
1832: CURSOR c1(p_batch_id NUMBER)IS
1833: SELECT rowid
1834: FROM msd_st_level_associations
1835: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
1836: AND sr_instance_code = p_instance_code
1837: AND batch_id = p_batch_id;
1838:

Line 1863: UPDATE msd_st_level_associations

1859: CLOSE c1;
1860:
1861: v_sql_stmt := 04;
1862: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1863: UPDATE msd_st_level_associations
1864: SET st_transaction_id = msd_st_level_associations_s.NEXTVAL,
1865: last_update_date = lv_current_date,
1866: last_updated_by = lv_current_user,
1867: creation_date = lv_current_date,

Line 1864: SET st_transaction_id = msd_st_level_associations_s.NEXTVAL,

1860:
1861: v_sql_stmt := 04;
1862: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1863: UPDATE msd_st_level_associations
1864: SET st_transaction_id = msd_st_level_associations_s.NEXTVAL,
1865: last_update_date = lv_current_date,
1866: last_updated_by = lv_current_user,
1867: creation_date = lv_current_date,
1868: created_by = lv_current_user

Line 1887: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',

1883: END IF;
1884:
1885: -- Derive LEVEL_ID from msd_levels
1886: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
1887: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',
1888: p_level_name_col => 'LEVEL_NAME',
1889: p_level_id_col => 'LEVEL_ID',
1890: p_severity => G_SEV_ERROR,
1891: p_message_text => lv_message_text,

Line 1915: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',

1911: END IF;
1912:
1913: -- Derive PARENT_LEVEL_ID from msd_levels
1914: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
1915: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',
1916: p_level_name_col => 'PARENT_LEVEL_NAME',
1917: p_level_id_col => 'PARENT_LEVEL_ID',
1918: p_severity => G_SEV_ERROR,
1919: p_message_text => lv_message_text,

Line 1945: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',

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',
1947: p_level_name_col => 'LEVEL_NAME',
1948: p_level_pk_col => 'SR_LEVEL_PK',
1949: p_instance_code => p_instance_code,

Line 1976: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',

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',
1978: p_level_name_col => 'PARENT_LEVEL_NAME',
1979: p_level_pk_col => 'SR_PARENT_LEVEL_PK',
1980: p_instance_code => p_instance_code,

Line 2011: 'UPDATE msd_st_level_associations mla'

2007: --Error out if parent child-association not there in any hierarchy
2008: v_sql_stmt := 07;
2009:
2010: lv_sql_Stmt:=
2011: 'UPDATE msd_st_level_associations mla'
2012: ||' SET process_flag ='||G_ERROR_FLG||','
2013: ||' error_text = '||''''||lv_message_text||''''
2014: ||' WHERE NOT EXISTS ( SELECT 1'
2015: ||' FROM msd_hierarchy_levels mhl'

Line 2037: pEntityName => 'MSD_ST_LEVEL_ASSOCIATIONS',

2033: (ERRBUF => lv_error_text,
2034: RETCODE => lv_return,
2035: pBatchID => null,
2036: pInstanceCode => p_instance_code,
2037: pEntityName => 'MSD_ST_LEVEL_ASSOCIATIONS',
2038: pInstanceID => p_instance_id);
2039:
2040: IF lv_return <> 0 THEN
2041: RAISE ex_logging_err;

Line 2046: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',

2042: END IF;
2043:
2044: -- Set the process flag as Valid and populate instance_id
2045: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
2046: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',
2047: p_instance_id => p_instance_id,
2048: p_instance_code => p_instance_code,
2049: p_process_flag => G_VALID,
2050: p_error_text => lv_error_text,

Line 2061: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',

2057:
2058: -- Inserting all the errored out records into MSC_ERRORS:
2059:
2060: lv_return := MSC_ST_UTIL.LOG_ERROR
2061: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',
2062: p_instance_code => p_instance_code,
2063: p_row => lv_column_names,
2064: p_severity => G_SEV_ERROR,
2065: p_error_text => lv_error_text,

Line 2336: -- Insert into msd_st_level_associations.

2332: -1,
2333: sysdate);
2334:
2335:
2336: -- Insert into msd_st_level_associations.
2337:
2338: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS
2339: (INSTANCE ,
2340: LEVEL_ID,

Line 2338: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS

2334:
2335:
2336: -- Insert into msd_st_level_associations.
2337:
2338: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS
2339: (INSTANCE ,
2340: LEVEL_ID,
2341: SR_LEVEL_PK,
2342: PARENT_LEVEL_ID,

Line 2676: FROM msd_st_level_associations msla

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
2677: WHERE msla.level_id = 11
2678: AND msla.parent_level_id = 15
2679: AND mbd.sr_customer_pk = msla.sr_parent_level_pk
2680: AND mbd.sr_ship_to_loc_pk = msla.sr_level_pk

Line 3226: -- Insert into msd_st_level_associations.

3222: -1,
3223: sysdate);
3224:
3225:
3226: -- Insert into msd_st_level_associations.
3227:
3228: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS
3229: (INSTANCE ,
3230: LEVEL_ID,

Line 3228: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS

3224:
3225:
3226: -- Insert into msd_st_level_associations.
3227:
3228: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS
3229: (INSTANCE ,
3230: LEVEL_ID,
3231: SR_LEVEL_PK,
3232: PARENT_LEVEL_ID,

Line 3567: FROM msd_st_level_associations msla

3563: UPDATE msd_st_shipment_data msd
3564: SET process_flag = G_ERROR_FLG,
3565: error_text = lv_message_text
3566: WHERE NOT EXISTS(SELECT 1
3567: FROM msd_st_level_associations msla
3568: WHERE msla.level_id = 11
3569: AND msla.parent_level_id = 15
3570: AND msd.sr_customer_pk = msla.sr_parent_level_pk
3571: AND msd.sr_ship_to_loc_pk = msla.sr_level_pk

Line 4112: --Inserting the level value 'Others' rolling to 'All Demand Classes' in MSD_ST_LEVEL_ASSOCIATIONS

4108: -1,
4109: sysdate);
4110:
4111:
4112: --Inserting the level value 'Others' rolling to 'All Demand Classes' in MSD_ST_LEVEL_ASSOCIATIONS
4113:
4114: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS
4115: (INSTANCE ,
4116: LEVEL_ID,

Line 4114: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS

4110:
4111:
4112: --Inserting the level value 'Others' rolling to 'All Demand Classes' in MSD_ST_LEVEL_ASSOCIATIONS
4113:
4114: INSERT INTO MSD_ST_LEVEL_ASSOCIATIONS
4115: (INSTANCE ,
4116: LEVEL_ID,
4117: SR_LEVEL_PK,
4118: PARENT_LEVEL_ID,

Line 8508: delete from msd_st_level_associations m1

8504: commit ;
8505:
8506: v_sql_stmt := 02;
8507:
8508: delete from msd_st_level_associations m1
8509: where rowid<> (select max(rowid)
8510: from msd_st_level_associations m2
8511: where m2.level_id= m1.level_id
8512: and m2.instance = m1.instance

Line 8510: from msd_st_level_associations m2

8506: v_sql_stmt := 02;
8507:
8508: delete from msd_st_level_associations m1
8509: where rowid<> (select max(rowid)
8510: from msd_st_level_associations m2
8511: where m2.level_id= m1.level_id
8512: and m2.instance = m1.instance
8513: and m2.sr_level_pk = m1.sr_level_pk
8514: and m2.PARENT_LEVEL_ID=m1.PARENT_LEVEL_ID