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.MSC_CL_COLLECTION dependencies on MSC_SOURCING_HISTORY

Line 5014: -- So we can safely truncate the msc_sourcing_history table to improve performance

5010: SELECT DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
5011: INTO lv_delete_flag
5012: FROM DUAL;
5013: -- If the above profile option is set then we are assuming that there is only one source
5014: -- So we can safely truncate the msc_sourcing_history table to improve performance
5015: IF (lv_delete_flag = 2) THEN
5016: DELETE MSC_SOURCING_HISTORY
5017: WHERE SR_INSTANCE_ID = v_instance_id;
5018: ELSE

Line 5016: DELETE MSC_SOURCING_HISTORY

5012: FROM DUAL;
5013: -- If the above profile option is set then we are assuming that there is only one source
5014: -- So we can safely truncate the msc_sourcing_history table to improve performance
5015: IF (lv_delete_flag = 2) THEN
5016: DELETE MSC_SOURCING_HISTORY
5017: WHERE SR_INSTANCE_ID = v_instance_id;
5018: ELSE
5019: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');
5020: END IF;

Line 5019: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');

5015: IF (lv_delete_flag = 2) THEN
5016: DELETE MSC_SOURCING_HISTORY
5017: WHERE SR_INSTANCE_ID = v_instance_id;
5018: ELSE
5019: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');
5020: END IF;
5021:
5022: COMMIT;
5023:

Line 5024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Table MSC_SOURCING_HISTORY Deleted');

5020: END IF;
5021:
5022: COMMIT;
5023:
5024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Table MSC_SOURCING_HISTORY Deleted');
5025:
5026: END IF;
5027:
5028: IF pRECALC_SH= MSC_UTIL.SYS_YES THEN

Line 6979: DELETE MSC_SOURCING_HISTORY

6975: INTO lv_delete_flag
6976: FROM DUAL;
6977:
6978: IF (lv_delete_flag = 2) THEN
6979: DELETE MSC_SOURCING_HISTORY
6980: WHERE SR_INSTANCE_ID= v_instance_id;
6981: ELSE
6982: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');
6983: END IF;

Line 6982: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');

6978: IF (lv_delete_flag = 2) THEN
6979: DELETE MSC_SOURCING_HISTORY
6980: WHERE SR_INSTANCE_ID= v_instance_id;
6981: ELSE
6982: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');
6983: END IF;
6984:
6985: COMMIT;
6986:

Line 6987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Table MSC_SOURCING_HISTORY Deleted');

6983: END IF;
6984:
6985: COMMIT;
6986:
6987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Table MSC_SOURCING_HISTORY Deleted');
6988: END IF;
6989:
6990: IF ((pRECALC_SH=MSC_UTIL.SYS_YES) AND (v_coll_prec.source_hist_flag=MSC_UTIL.SYS_YES)) THEN
6991: