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_RESOURCE_AVAILABILITY dependencies on MSC_NET_RESOURCE_AVAIL

Line 139: UPDATE MSC_net_resource_avail

135: v_stmt := 30;
136:
137: if var_from_time >= 86400 AND var_to_time >= 86400 then
138:
139: UPDATE MSC_net_resource_avail
140: SET to_time = var_time1,
141: from_time =var_time2,
142: shift_date = shift_date + 1
143: WHERE rowid = var_rowid;

Line 147: UPDATE MSC_net_resource_avail

143: WHERE rowid = var_rowid;
144:
145: else
146:
147: UPDATE MSC_net_resource_avail
148: SET to_time = var_time1,
149: from_time = var_time2
150: WHERE rowid = var_rowid;
151:

Line 173: DELETE from MSC_net_resource_avail

169: PROCEDURE delete_avail(var_rowid in ROWID) IS
170: BEGIN
171:
172: v_stmt := 40;
173: DELETE from MSC_net_resource_avail
174: WHERE rowid = var_rowid;
175:
176: if( v_show_warning is null) then
177: v_show_warning := 0;

Line 218: INSERT into MSC_net_resource_avail(

214:
215: v_stmt := 50;
216:
217: v_stmt := 60;
218: INSERT into MSC_net_resource_avail(
219: transaction_id,
220: plan_id,
221: department_id,
222: resource_id,

Line 246: msc_net_resource_avail_s.NEXTVAL

242: program_id,
243: program_update_date,
244: refresh_number)
245: VALUES(
246: msc_net_resource_avail_s.NEXTVAL
247: , -1
248: ,var_department_id
249: ,var_resource_id
250: ,var_organization_id

Line 348: SELECT /+ index (nra MSC_NET_RESOURCE_AVAIL_U2 )/

344: var_capacity number;
345:
346: /* add index hint for better performance */
347: CURSOR avail IS
348: SELECT /*+ index (nra MSC_NET_RESOURCE_AVAIL_U2 )*/
349: capacity_units capacity_units,
350: from_time from_time,
351: to_time to_time,
352: rowid

Line 353: FROM MSC_net_resource_avail nra

349: capacity_units capacity_units,
350: from_time from_time,
351: to_time to_time,
352: rowid
353: FROM MSC_net_resource_avail nra
354: WHERE plan_id = -1
355: AND sr_instance_id = arg_sr_instance_id
356: AND organization_id = arg_organization_id
357: AND department_id = arg_department_id

Line 378: INSERT into MSC_net_resource_avail(

374: v_stmt := 70;
375:
376: if (arg_disable_date IS NOT NULL) then
377:
378: INSERT into MSC_net_resource_avail(
379: transaction_id,
380: plan_id,
381: organization_id,
382: sr_instance_id,

Line 404: SELECT msc_net_resource_avail_s.NEXTVAL

400: request_id,
401: program_application_id,
402: program_id,
403: program_update_date)
404: SELECT msc_net_resource_avail_s.NEXTVAL
405: ,-1
406: ,arg_organization_id
407: ,arg_sr_instance_id
408: ,arg_department_id

Line 443: INSERT into MSC_net_resource_avail(

439: end if;
440:
441: end if;
442:
443: INSERT into MSC_net_resource_avail(
444: transaction_id,
445: plan_id,
446: organization_id,
447: sr_instance_id,

Line 469: SELECT msc_net_resource_avail_s.NEXTVAL

465: request_id,
466: program_application_id,
467: program_id,
468: program_update_date)
469: SELECT msc_net_resource_avail_s.NEXTVAL
470: ,-1
471: ,arg_organization_id
472: ,arg_sr_instance_id
473: ,arg_department_id

Line 543: UPDATE MSC_NET_RESOURCE_AVAIL

539:
540:
541: IF arg_simulation_set IS NOT NULL THEN
542:
543: UPDATE MSC_NET_RESOURCE_AVAIL
544: SET capacity_units= 0
545: WHERE ROWID IN
546: ( select /*+ ordered index (nra MSC_NET_RESOURCE_AVAIL_U2 )*/
547: /* nra.ROWID

Line 546: ( select /+ ordered index (nra MSC_NET_RESOURCE_AVAIL_U2 )/

542:
543: UPDATE MSC_NET_RESOURCE_AVAIL
544: SET capacity_units= 0
545: WHERE ROWID IN
546: ( select /*+ ordered index (nra MSC_NET_RESOURCE_AVAIL_U2 )*/
547: /* nra.ROWID
548: from MSC_RESOURCE_CHANGES changes,
549: MSC_NET_RESOURCE_AVAIL nra
550: WHERE changes.department_id = arg_department_id

Line 549: MSC_NET_RESOURCE_AVAIL nra

545: WHERE ROWID IN
546: ( select /*+ ordered index (nra MSC_NET_RESOURCE_AVAIL_U2 )*/
547: /* nra.ROWID
548: from MSC_RESOURCE_CHANGES changes,
549: MSC_NET_RESOURCE_AVAIL nra
550: WHERE changes.department_id = arg_department_id
551: AND changes.resource_id = arg_resource_id
552: AND changes.sr_instance_id = arg_sr_instance_id
553: AND changes.simulation_set= arg_simulation_set

Line 572: INSERT into MSC_net_resource_avail(

568: ELSE
569:
570: if (arg_disable_date IS NOT NULL) then
571:
572: INSERT into MSC_net_resource_avail(
573: transaction_id,
574: plan_id,
575: organization_id,
576: sr_instance_id,

Line 598: VALUES( msc_net_resource_avail_s.NEXTVAL

594: request_id,
595: program_application_id,
596: program_id,
597: program_update_date)
598: VALUES( msc_net_resource_avail_s.NEXTVAL
599: ,-1
600: ,arg_organization_id
601: ,arg_sr_instance_id
602: ,arg_department_id

Line 669: INSERT into MSC_net_resource_avail(

665:
666: END IF; -- calendar_code, calendar_exception_set_id
667:
668: FORALL j IN 1..v_workdate_count
669: INSERT into MSC_net_resource_avail(
670: transaction_id,
671: plan_id,
672: organization_id,
673: sr_instance_id,

Line 695: VALUES( msc_net_resource_avail_s.NEXTVAL

691: request_id,
692: program_application_id,
693: program_id,
694: program_update_date)
695: VALUES( msc_net_resource_avail_s.NEXTVAL
696: ,-1
697: ,arg_organization_id
698: ,arg_sr_instance_id
699: ,arg_department_id

Line 1111: INSERT into MSC_net_resource_avail(

1107:
1108: -- Finally add the availability from the add workday type modifications
1109:
1110: v_stmt := 90;
1111: INSERT into MSC_net_resource_avail(
1112: transaction_id,
1113: plan_id,
1114: organization_id,
1115: sr_instance_id,

Line 1138: SELECT msc_net_resource_avail_s.NEXTVAL

1134: program_application_id,
1135: program_id,
1136: program_update_date,
1137: refresh_number)
1138: SELECT msc_net_resource_avail_s.NEXTVAL
1139: ,-1
1140: ,arg_organization_id
1141: ,arg_sr_instance_id
1142: ,arg_department_id

Line 1430: delete from msc_net_resource_avail

1426: -- all department resources with the new refresh number.
1427:
1428: if arg_refresh_flag = 2 then
1429: v_stmt := 100;
1430: delete from msc_net_resource_avail
1431: where rowid in (select res.rowid
1432: from msc_net_resource_avail res,
1433: msc_resource_changes chg,
1434: msc_department_resources dept

Line 1432: from msc_net_resource_avail res,

1428: if arg_refresh_flag = 2 then
1429: v_stmt := 100;
1430: delete from msc_net_resource_avail
1431: where rowid in (select res.rowid
1432: from msc_net_resource_avail res,
1433: msc_resource_changes chg,
1434: msc_department_resources dept
1435: where res.organization_id = arg_organization_id
1436: and res.sr_instance_id = arg_sr_instance_id

Line 1515: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RESOURCE_AVAIL');

1511:
1512: LOG_MESSAGE('========================================');
1513: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1514: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_ORG_RESOURCES');
1515: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RESOURCE_AVAIL');
1516: LOG_MESSAGE(FND_MESSAGE.GET);
1517:
1518: LOG_MESSAGE(SQLERRM);
1519:

Line 1581: delete from msc_net_resource_avail

1577: -- For net change, refresh_flag = 2, delete resourse availability of
1578: -- lines with the new refresh number.
1579: if arg_refresh_flag = 2 then
1580: v_stmt := 110;
1581: delete from msc_net_resource_avail
1582: where rowid in (select res.rowid
1583: from msc_net_resource_avail res, msc_department_resources line
1584: where res.organization_id = line.organization_id
1585: and res.sr_instance_id = line.sr_instance_id

Line 1583: from msc_net_resource_avail res, msc_department_resources line

1579: if arg_refresh_flag = 2 then
1580: v_stmt := 110;
1581: delete from msc_net_resource_avail
1582: where rowid in (select res.rowid
1583: from msc_net_resource_avail res, msc_department_resources line
1584: where res.organization_id = line.organization_id
1585: and res.sr_instance_id = line.sr_instance_id
1586: and res.department_id = line.department_id
1587: and res.resource_id = -1

Line 1599: INSERT into MSC_net_resource_avail(

1595: /* 2201418 - Added hints to improve performance. Also defined a new index
1596: on msc_department_resources (line_flag, plan_id, sr_instance_id,
1597: organization_id) */
1598:
1599: INSERT into MSC_net_resource_avail(
1600: transaction_id,
1601: plan_id,
1602: organization_id,
1603: sr_instance_id,

Line 1624: msc_net_resource_avail_s.NEXTVAL

1620: program_id,
1621: program_update_date,
1622: refresh_number)
1623: SELECT /*+ leading(line) INDEX(LINE) use_nl(dates) */
1624: msc_net_resource_avail_s.NEXTVAL
1625: ,-1
1626: ,arg_organization_id
1627: ,arg_sr_instance_id
1628: ,line.department_id

Line 1667: INSERT into MSC_net_resource_avail(

1663: AND dates.calendar_date <= least(trunc(v_cutoff_date),
1664: trunc(nvl(line.disable_date-1, v_cutoff_date)) )
1665: AND dates.seq_num is not null;
1666:
1667: INSERT into MSC_net_resource_avail(
1668: transaction_id,
1669: plan_id,
1670: organization_id,
1671: sr_instance_id,

Line 1692: msc_net_resource_avail_s.NEXTVAL

1688: program_id,
1689: program_update_date,
1690: refresh_number)
1691: SELECT /*+ leading(line) INDEX(LINE) use_nl(dates) */
1692: msc_net_resource_avail_s.NEXTVAL
1693: ,-1
1694: ,arg_organization_id
1695: ,arg_sr_instance_id
1696: ,line.department_id

Line 1745: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RESOURCE_AVAIL');

1741:
1742: LOG_MESSAGE('========================================');
1743: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1744: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_ALL_LINES');
1745: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RESOURCE_AVAIL');
1746: LOG_MESSAGE(FND_MESSAGE.GET);
1747:
1748: LOG_MESSAGE(SQLERRM);
1749:

Line 1810: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL debug0 ');

1806: lv_where_clause := ' AND ORGANIZATION_ID IN ( SELECT SR_TP_ID FROM MSC_TRADING_PARTNERS WHERE '||
1807: ' SR_INSTANCE_ID = '||MSC_CL_COLLECTION.v_instance_id ||
1808: ' AND ORGANIZATION_TYPE =1 ) ';
1809:
1810: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL debug0 ');
1811: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_DISCRETE OR MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN
1812: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL ');
1813: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1814: COMMIT;

Line 1812: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL ');

1808: ' AND ORGANIZATION_TYPE =1 ) ';
1809:
1810: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL debug0 ');
1811: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_DISCRETE OR MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN
1812: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL ');
1813: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1814: COMMIT;
1815: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1816: COMMIT;

Line 1813: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);

1809:
1810: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL debug0 ');
1811: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_DISCRETE OR MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN
1812: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL ');
1813: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1814: COMMIT;
1815: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1816: COMMIT;
1817:

Line 1835: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);

1831: END IF;
1832:
1833: ELSIF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_MIXED THEN
1834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-07');
1835: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1836: COMMIT;
1837: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1838: COMMIT;
1839:

Line 2169: update MSC_net_resource_avail

2165:
2166: /* Bug 3295824 - We need to set the capacity units to 0 of any records
2167: having -ve capacity units */
2168:
2169: update MSC_net_resource_avail
2170: set capacity_units = 0
2171: where capacity_units < 0
2172: and plan_id = -1
2173: AND sr_instance_id = MSC_CL_COLLECTION.v_instance_id

Line 2289: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);

2285:
2286: /*IF (v_is_complete_refresh OR (v_is_partial_refresh AND MSC_CL_COLLECTION.v_coll_prec.resource_nra_flag = MSC_CL_COLLECTION.SYS_YES)) THEN
2287: -- We want to delete all NRA related data and get new stuff.
2288:
2289: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2290: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2291:
2292: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');

Line 2294: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);

2290: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2291:
2292: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');
2294: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2295: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2296: ELSE
2297: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');

Line 2299: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);

2295: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2296: ELSE
2297: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');
2299: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);
2300: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1,v_sub_str);
2301: END IF;
2302:
2303: END IF;*/

Line 2324: ' INSERT into MSC_net_resource_avail '

2320:
2321: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading res avail for OPM orgs : ' || c_rec1.organization_id);
2322:
2323: lv_sql_stmt:=
2324: ' INSERT into MSC_net_resource_avail '
2325: ||' ( transaction_id,'
2326: ||' plan_id,'
2327: ||' department_id,'
2328: ||' resource_id,'

Line 2346: ||' msc_net_resource_avail_s.NEXTVAL,'

2342: ||' creation_date,'
2343: ||' created_by,'
2344: ||' refresh_number)'
2345: ||' SELECT'
2346: ||' msc_net_resource_avail_s.NEXTVAL,'
2347: ||' -1,'
2348: ||' msnra.department_id,'
2349: ||' msnra.resource_id,'
2350: ||' msnra.organization_id,'

Line 2399: INSERT into MSC_net_resource_avail(

2395:
2396: FOR c_rec IN c11(c_rec1.organization_id) LOOP
2397:
2398: BEGIN
2399: INSERT into MSC_net_resource_avail(
2400: transaction_id,
2401: plan_id,
2402: department_id,
2403: resource_id,

Line 2421: msc_net_resource_avail_s.NEXTVAL,

2417: creation_date,
2418: created_by,
2419: refresh_number)
2420: VALUES(
2421: msc_net_resource_avail_s.NEXTVAL,
2422: -1,
2423: c_rec.department_id,
2424: c_rec.resource_id,
2425: c_rec.organization_id,

Line 2457: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RESOURCE_AVAIL');

2453:
2454: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2455: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2456: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
2457: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RESOURCE_AVAIL');
2458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2459:
2460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2461: RAISE;

Line 2470: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RESOURCE_AVAIL');

2466:
2467: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2468: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2469: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
2470: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RESOURCE_AVAIL');
2471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2472:
2473: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2474: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');

Line 2723: v_current_date MSC_NET_RESOURCE_AVAIL.LAST_UPDATE_DATE%TYPE;

2719: lv_PLAN_COMPLETION_DATE MSC_PLANS.PLAN_COMPLETION_DATE%TYPE;
2720: lv_UOM MSC_DEPARTMENT_RESOURCES.UNIT_OF_MEASURE%TYPE;
2721: v_dblink MSC_APPS_INSTANCES.M2A_DBLINK%TYPE;
2722: LV_SOURCE_APPLICATION VARCHAR2 (3);
2723: v_current_date MSC_NET_RESOURCE_AVAIL.LAST_UPDATE_DATE%TYPE;
2724: v_current_user MSC_NET_RESOURCE_AVAIL.LAST_UPDATED_BY%TYPE;
2725: lv_TABLE_NAME all_tables.TABLE_NAME%TYPE;
2726: NULL_DBLINK CONSTANT VARCHAR2 (1) := ' ';
2727: lv_ahl_schema VARCHAR2(32);

Line 2724: v_current_user MSC_NET_RESOURCE_AVAIL.LAST_UPDATED_BY%TYPE;

2720: lv_UOM MSC_DEPARTMENT_RESOURCES.UNIT_OF_MEASURE%TYPE;
2721: v_dblink MSC_APPS_INSTANCES.M2A_DBLINK%TYPE;
2722: LV_SOURCE_APPLICATION VARCHAR2 (3);
2723: v_current_date MSC_NET_RESOURCE_AVAIL.LAST_UPDATE_DATE%TYPE;
2724: v_current_user MSC_NET_RESOURCE_AVAIL.LAST_UPDATED_BY%TYPE;
2725: lv_TABLE_NAME all_tables.TABLE_NAME%TYPE;
2726: NULL_DBLINK CONSTANT VARCHAR2 (1) := ' ';
2727: lv_ahl_schema VARCHAR2(32);
2728:

Line 2810: FROM MSC_NET_RESOURCE_AVAIL

2806:
2807:
2808: SELECT COUNT ( * )
2809: INTO V_count
2810: FROM MSC_NET_RESOURCE_AVAIL
2811: WHERE PLAN_ID = lv_plan_id AND SR_INSTANCE_ID = pINSTANCE_ID and rownum <2;
2812:
2813: IF V_count = 0
2814: THEN

Line 2817: LOG_MESSAGE('Error::NO RECORDS for PLAN '|| lv_plan_name || '::IN TABLE MSC_NET_RESOURCE_AVAIL');

2813: IF V_count = 0
2814: THEN
2815: RETCODE := MSC_UTIL.G_WARNING;
2816:
2817: LOG_MESSAGE('Error::NO RECORDS for PLAN '|| lv_plan_name || '::IN TABLE MSC_NET_RESOURCE_AVAIL');
2818:
2819: END IF;
2820:
2821: IF lv_PLAN_COMPLETION_DATE is null

Line 2903: || ' From MSC_NET_RESOURCE_AVAIL MNRA,MSC_DEPARTMENT_RESOURCES MDR '

2899: || ' MNRA.plan_id, '
2900: || '''' || lv_DATA_START_DATE || ''','
2901: || '''' || lv_plan_name || ''','
2902: || ' MNRA.SIMULATION_SET_ID '
2903: || ' From MSC_NET_RESOURCE_AVAIL MNRA,MSC_DEPARTMENT_RESOURCES MDR '
2904: || ' WHERE MNRA.PLAN_ID = MDR.PLAN_ID '
2905: || ' AND MNRA.ORGANIZATION_ID = MDR.ORGANIZATION_ID '
2906: || ' AND MNRA.SR_INSTANCE_ID = MDR.SR_INSTANCE_ID '
2907: || ' AND MNRA.RESOURCE_ID = MDR.RESOURCE_ID '