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 MSC_APPS_INSTANCES

Line 249: from msc_apps_instances

245: and level_id = 28;
246:
247: cursor c3 (p_instance_id number) is
248: select instance_code
249: from msc_apps_instances
250: where instance_id=p_instance_id;
251:
252: lv_other_exist PLS_INTEGER := 0;
253: lv_instance_code VARCHAR2(5) :='';

Line 1414: lv_instance_type msc_apps_instances.instance_type%TYPE;

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 ;
1413:
1414: lv_instance_type msc_apps_instances.instance_type%TYPE;
1415:
1416: CURSOR instance_type IS
1417: SELECT instance_type
1418: FROM msc_apps_instances

Line 1418: FROM msc_apps_instances

1414: lv_instance_type msc_apps_instances.instance_type%TYPE;
1415:
1416: CURSOR instance_type IS
1417: SELECT instance_type
1418: FROM msc_apps_instances
1419: WHERE instance_id=p_instance_id;
1420: /*
1421: CURSOR master_org(p_instance_id NUMBER) IS
1422: SELECT parameter_value

Line 2124: lv_instance_type msc_apps_instances.instance_type%TYPE;

2120: lv_other_desc varchar2(240) := NULL; --Adding this to insert level value - 'Others'
2121: lv_all_dcs_desc varchar2(240) := NULL; --Adding this to insert level value - 'All Demand Classes'
2122: Bug3749959 */
2123:
2124: lv_instance_type msc_apps_instances.instance_type%TYPE;
2125: /* lv_other_exist NUMBER :=0;
2126: lv_all_dcs_pk NUMBER :=0; --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
2127: Bug3749959 */
2128:

Line 2131: FROM msc_apps_instances

2127: Bug3749959 */
2128:
2129: CURSOR instance_type IS
2130: SELECT instance_type
2131: FROM msc_apps_instances
2132: WHERE instance_id=p_instance_id;
2133:
2134: CURSOR c1(p_batch_id NUMBER)IS
2135: SELECT rowid

Line 3012: lv_instance_type msc_apps_instances.instance_type%TYPE;

3008: /*
3009: lv_other_desc varchar2(240) := NULL; --Adding this to insert level value - 'Others'
3010: lv_all_dcs_desc varchar2(240) := NULL; --Adding this to insert level value - 'All Demand Classes'
3011: Bug3749959 */
3012: lv_instance_type msc_apps_instances.instance_type%TYPE;
3013:
3014: /* lv_other_exist NUMBER :=0;
3015: lv_all_dcs_pk NUMBER :=0; --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
3016: Bug3749959 */

Line 3020: FROM msc_apps_instances

3016: Bug3749959 */
3017:
3018: CURSOR instance_type IS
3019: SELECT instance_type
3020: FROM msc_apps_instances
3021: WHERE instance_id=p_instance_id;
3022:
3023: CURSOR c1(p_batch_id NUMBER)IS
3024: SELECT rowid

Line 3906: FROM msc_apps_instances

3902: AND batch_id = p_batch_id;
3903:
3904: CURSOR instance_type IS
3905: SELECT instance_type
3906: FROM msc_apps_instances
3907: WHERE instance_id=p_instance_id;
3908: /*
3909: lv_other_desc varchar2(240) := NULL; --Adding this to insert level value - 'Others' -Bug 3749959
3910: lv_all_dcs_desc varchar2(240) := NULL; --Adding this to insert level value - 'All Demand Classes' -Bug 3749959

Line 3913: lv_instance_type msc_apps_instances.instance_type%TYPE;

3909: lv_other_desc varchar2(240) := NULL; --Adding this to insert level value - 'Others' -Bug 3749959
3910: lv_all_dcs_desc varchar2(240) := NULL; --Adding this to insert level value - 'All Demand Classes' -Bug 3749959
3911: Bug3749959 */
3912:
3913: lv_instance_type msc_apps_instances.instance_type%TYPE;
3914:
3915: /* lv_other_exist NUMBER :=0; --Bug 3749959
3916: lv_all_dcs_pk NUMBER :=0; --Bug 3749959
3917:

Line 5900: FROM msc_apps_instances

5896: AND batch_id = p_batch_id;
5897:
5898: CURSOR instance_type IS
5899: SELECT instance_type
5900: FROM msc_apps_instances
5901: WHERE instance_id=p_instance_id;
5902:
5903: lv_instance_type msc_apps_instances.instance_type%TYPE;
5904:

Line 5903: lv_instance_type msc_apps_instances.instance_type%TYPE;

5899: SELECT instance_type
5900: FROM msc_apps_instances
5901: WHERE instance_id=p_instance_id;
5902:
5903: lv_instance_type msc_apps_instances.instance_type%TYPE;
5904:
5905: BEGIN
5906:
5907: lv_batch_id := p_batch_id;

Line 6818: FROM msc_apps_instances

6814: AND batch_id = p_batch_id;
6815:
6816: CURSOR instance_type IS
6817: SELECT instance_type
6818: FROM msc_apps_instances
6819: WHERE instance_id=p_instance_id;
6820:
6821: lv_instance_type msc_apps_instances.instance_type%TYPE;
6822:

Line 6821: lv_instance_type msc_apps_instances.instance_type%TYPE;

6817: SELECT instance_type
6818: FROM msc_apps_instances
6819: WHERE instance_id=p_instance_id;
6820:
6821: lv_instance_type msc_apps_instances.instance_type%TYPE;
6822:
6823: BEGIN
6824:
6825: lv_batch_id := p_batch_id;

Line 8208: lv_instance_type msc_apps_instances.instance_type%TYPE;

8204:
8205: ex_logging_err EXCEPTION;
8206: lv_column_names VARCHAR2(5000);
8207:
8208: lv_instance_type msc_apps_instances.instance_type%TYPE;
8209:
8210: CURSOR instance_type IS
8211: SELECT instance_type
8212: FROM msc_apps_instances

Line 8212: FROM msc_apps_instances

8208: lv_instance_type msc_apps_instances.instance_type%TYPE;
8209:
8210: CURSOR instance_type IS
8211: SELECT instance_type
8212: FROM msc_apps_instances
8213: WHERE instance_id=p_instance_id;
8214:
8215: CURSOR c1(p_batch_id NUMBER)IS
8216: SELECT rowid