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_CL_COLLECTION

Line 262: ,MSC_CL_COLLECTION.v_current_date

258: ,var_aggregate_resource_id
259: ,NULL /* STATUS */
260: ,NULL /* APPLIED */
261: ,2 /* UPDATED */
262: ,MSC_CL_COLLECTION.v_current_date
263: ,MSC_CL_COLLECTION.v_current_user
264: ,MSC_CL_COLLECTION.v_current_date
265: ,MSC_CL_COLLECTION.v_current_user
266: ,v_current_login

Line 263: ,MSC_CL_COLLECTION.v_current_user

259: ,NULL /* STATUS */
260: ,NULL /* APPLIED */
261: ,2 /* UPDATED */
262: ,MSC_CL_COLLECTION.v_current_date
263: ,MSC_CL_COLLECTION.v_current_user
264: ,MSC_CL_COLLECTION.v_current_date
265: ,MSC_CL_COLLECTION.v_current_user
266: ,v_current_login
267: ,v_current_request

Line 264: ,MSC_CL_COLLECTION.v_current_date

260: ,NULL /* APPLIED */
261: ,2 /* UPDATED */
262: ,MSC_CL_COLLECTION.v_current_date
263: ,MSC_CL_COLLECTION.v_current_user
264: ,MSC_CL_COLLECTION.v_current_date
265: ,MSC_CL_COLLECTION.v_current_user
266: ,v_current_login
267: ,v_current_request
268: ,v_current_application

Line 265: ,MSC_CL_COLLECTION.v_current_user

261: ,2 /* UPDATED */
262: ,MSC_CL_COLLECTION.v_current_date
263: ,MSC_CL_COLLECTION.v_current_user
264: ,MSC_CL_COLLECTION.v_current_date
265: ,MSC_CL_COLLECTION.v_current_user
266: ,v_current_login
267: ,v_current_request
268: ,v_current_application
269: ,v_current_conc_program

Line 270: ,MSC_CL_COLLECTION.v_current_date

266: ,v_current_login
267: ,v_current_request
268: ,v_current_application
269: ,v_current_conc_program
270: ,MSC_CL_COLLECTION.v_current_date
271: ,var_refresh_number);
272: if( v_show_warning is null) then
273: v_show_warning := 0;
274: end if;

Line 420: ,MSC_CL_COLLECTION.v_current_date

416: ,arg_aggregate_resource_id
417: ,NULL /* STATUS */
418: ,NULL /* APPLIED */
419: ,2 /* UPDATED */
420: ,MSC_CL_COLLECTION.v_current_date
421: ,MSC_CL_COLLECTION.v_current_user
422: ,MSC_CL_COLLECTION.v_current_date
423: ,MSC_CL_COLLECTION.v_current_user
424: ,v_current_login

Line 421: ,MSC_CL_COLLECTION.v_current_user

417: ,NULL /* STATUS */
418: ,NULL /* APPLIED */
419: ,2 /* UPDATED */
420: ,MSC_CL_COLLECTION.v_current_date
421: ,MSC_CL_COLLECTION.v_current_user
422: ,MSC_CL_COLLECTION.v_current_date
423: ,MSC_CL_COLLECTION.v_current_user
424: ,v_current_login
425: ,v_current_request

Line 422: ,MSC_CL_COLLECTION.v_current_date

418: ,NULL /* APPLIED */
419: ,2 /* UPDATED */
420: ,MSC_CL_COLLECTION.v_current_date
421: ,MSC_CL_COLLECTION.v_current_user
422: ,MSC_CL_COLLECTION.v_current_date
423: ,MSC_CL_COLLECTION.v_current_user
424: ,v_current_login
425: ,v_current_request
426: ,v_current_application

Line 423: ,MSC_CL_COLLECTION.v_current_user

419: ,2 /* UPDATED */
420: ,MSC_CL_COLLECTION.v_current_date
421: ,MSC_CL_COLLECTION.v_current_user
422: ,MSC_CL_COLLECTION.v_current_date
423: ,MSC_CL_COLLECTION.v_current_user
424: ,v_current_login
425: ,v_current_request
426: ,v_current_application
427: ,v_current_conc_program

Line 428: ,MSC_CL_COLLECTION.v_current_date

424: ,v_current_login
425: ,v_current_request
426: ,v_current_application
427: ,v_current_conc_program
428: ,MSC_CL_COLLECTION.v_current_date
429: FROM
430: msc_resource_shifts res_shifts
431: WHERE
432: res_shifts.department_id = arg_department_id

Line 485: ,MSC_CL_COLLECTION.v_current_date

481: ,arg_aggregate_resource_id
482: ,NULL /* STATUS */
483: ,NULL /* APPLIED */
484: ,2 /* UPDATED */
485: ,MSC_CL_COLLECTION.v_current_date
486: ,MSC_CL_COLLECTION.v_current_user
487: ,MSC_CL_COLLECTION.v_current_date
488: ,MSC_CL_COLLECTION.v_current_user
489: ,v_current_login

Line 486: ,MSC_CL_COLLECTION.v_current_user

482: ,NULL /* STATUS */
483: ,NULL /* APPLIED */
484: ,2 /* UPDATED */
485: ,MSC_CL_COLLECTION.v_current_date
486: ,MSC_CL_COLLECTION.v_current_user
487: ,MSC_CL_COLLECTION.v_current_date
488: ,MSC_CL_COLLECTION.v_current_user
489: ,v_current_login
490: ,v_current_request

Line 487: ,MSC_CL_COLLECTION.v_current_date

483: ,NULL /* APPLIED */
484: ,2 /* UPDATED */
485: ,MSC_CL_COLLECTION.v_current_date
486: ,MSC_CL_COLLECTION.v_current_user
487: ,MSC_CL_COLLECTION.v_current_date
488: ,MSC_CL_COLLECTION.v_current_user
489: ,v_current_login
490: ,v_current_request
491: ,v_current_application

Line 488: ,MSC_CL_COLLECTION.v_current_user

484: ,2 /* UPDATED */
485: ,MSC_CL_COLLECTION.v_current_date
486: ,MSC_CL_COLLECTION.v_current_user
487: ,MSC_CL_COLLECTION.v_current_date
488: ,MSC_CL_COLLECTION.v_current_user
489: ,v_current_login
490: ,v_current_request
491: ,v_current_application
492: ,v_current_conc_program

Line 493: ,MSC_CL_COLLECTION.v_current_date

489: ,v_current_login
490: ,v_current_request
491: ,v_current_application
492: ,v_current_conc_program
493: ,MSC_CL_COLLECTION.v_current_date
494: FROM msc_shift_dates dates,
495: msc_shift_times shifts,
496: msc_resource_shifts res_shifts,
497: (select distinct department_id, resource_id,

Line 614: ,MSC_CL_COLLECTION.v_current_date

610: ,arg_aggregate_resource_id
611: ,NULL /* STATUS */
612: ,NULL /* APPLIED */
613: ,2 /* UPDATED */
614: ,MSC_CL_COLLECTION.v_current_date
615: ,MSC_CL_COLLECTION.v_current_user
616: ,MSC_CL_COLLECTION.v_current_date
617: ,MSC_CL_COLLECTION.v_current_user
618: ,v_current_login

Line 615: ,MSC_CL_COLLECTION.v_current_user

611: ,NULL /* STATUS */
612: ,NULL /* APPLIED */
613: ,2 /* UPDATED */
614: ,MSC_CL_COLLECTION.v_current_date
615: ,MSC_CL_COLLECTION.v_current_user
616: ,MSC_CL_COLLECTION.v_current_date
617: ,MSC_CL_COLLECTION.v_current_user
618: ,v_current_login
619: ,v_current_request

Line 616: ,MSC_CL_COLLECTION.v_current_date

612: ,NULL /* APPLIED */
613: ,2 /* UPDATED */
614: ,MSC_CL_COLLECTION.v_current_date
615: ,MSC_CL_COLLECTION.v_current_user
616: ,MSC_CL_COLLECTION.v_current_date
617: ,MSC_CL_COLLECTION.v_current_user
618: ,v_current_login
619: ,v_current_request
620: ,v_current_application

Line 617: ,MSC_CL_COLLECTION.v_current_user

613: ,2 /* UPDATED */
614: ,MSC_CL_COLLECTION.v_current_date
615: ,MSC_CL_COLLECTION.v_current_user
616: ,MSC_CL_COLLECTION.v_current_date
617: ,MSC_CL_COLLECTION.v_current_user
618: ,v_current_login
619: ,v_current_request
620: ,v_current_application
621: ,v_current_conc_program

Line 622: ,MSC_CL_COLLECTION.v_current_date);

618: ,v_current_login
619: ,v_current_request
620: ,v_current_application
621: ,v_current_conc_program
622: ,MSC_CL_COLLECTION.v_current_date);
623:
624: if (arg_disable_date < sysdate) then
625: -- If the disable date is in the past, just return!
626: return;

Line 711: ,MSC_CL_COLLECTION.v_current_date

707: ,arg_aggregate_resource_id
708: ,NULL /* STATUS */
709: ,NULL /* APPLIED */
710: ,2 /* UPDATED */
711: ,MSC_CL_COLLECTION.v_current_date
712: ,MSC_CL_COLLECTION.v_current_user
713: ,MSC_CL_COLLECTION.v_current_date
714: ,MSC_CL_COLLECTION.v_current_user
715: ,v_current_login

Line 712: ,MSC_CL_COLLECTION.v_current_user

708: ,NULL /* STATUS */
709: ,NULL /* APPLIED */
710: ,2 /* UPDATED */
711: ,MSC_CL_COLLECTION.v_current_date
712: ,MSC_CL_COLLECTION.v_current_user
713: ,MSC_CL_COLLECTION.v_current_date
714: ,MSC_CL_COLLECTION.v_current_user
715: ,v_current_login
716: ,v_current_request

Line 713: ,MSC_CL_COLLECTION.v_current_date

709: ,NULL /* APPLIED */
710: ,2 /* UPDATED */
711: ,MSC_CL_COLLECTION.v_current_date
712: ,MSC_CL_COLLECTION.v_current_user
713: ,MSC_CL_COLLECTION.v_current_date
714: ,MSC_CL_COLLECTION.v_current_user
715: ,v_current_login
716: ,v_current_request
717: ,v_current_application

Line 714: ,MSC_CL_COLLECTION.v_current_user

710: ,2 /* UPDATED */
711: ,MSC_CL_COLLECTION.v_current_date
712: ,MSC_CL_COLLECTION.v_current_user
713: ,MSC_CL_COLLECTION.v_current_date
714: ,MSC_CL_COLLECTION.v_current_user
715: ,v_current_login
716: ,v_current_request
717: ,v_current_application
718: ,v_current_conc_program

Line 719: ,MSC_CL_COLLECTION.v_current_date);

715: ,v_current_login
716: ,v_current_request
717: ,v_current_application
718: ,v_current_conc_program
719: ,MSC_CL_COLLECTION.v_current_date);
720:
721: END if; -- arg_24hr_flag
722:
723:

Line 1154: ,MSC_CL_COLLECTION.v_current_date

1150: ,arg_aggregate_resource_id
1151: ,NULL /* STATUS */
1152: ,NULL /* APPLIED */
1153: ,2 /* UPDATED */
1154: ,MSC_CL_COLLECTION.v_current_date
1155: ,MSC_CL_COLLECTION.v_current_user
1156: ,MSC_CL_COLLECTION.v_current_date
1157: ,MSC_CL_COLLECTION.v_current_user
1158: ,v_current_login

Line 1155: ,MSC_CL_COLLECTION.v_current_user

1151: ,NULL /* STATUS */
1152: ,NULL /* APPLIED */
1153: ,2 /* UPDATED */
1154: ,MSC_CL_COLLECTION.v_current_date
1155: ,MSC_CL_COLLECTION.v_current_user
1156: ,MSC_CL_COLLECTION.v_current_date
1157: ,MSC_CL_COLLECTION.v_current_user
1158: ,v_current_login
1159: ,v_current_request

Line 1156: ,MSC_CL_COLLECTION.v_current_date

1152: ,NULL /* APPLIED */
1153: ,2 /* UPDATED */
1154: ,MSC_CL_COLLECTION.v_current_date
1155: ,MSC_CL_COLLECTION.v_current_user
1156: ,MSC_CL_COLLECTION.v_current_date
1157: ,MSC_CL_COLLECTION.v_current_user
1158: ,v_current_login
1159: ,v_current_request
1160: ,v_current_application

Line 1157: ,MSC_CL_COLLECTION.v_current_user

1153: ,2 /* UPDATED */
1154: ,MSC_CL_COLLECTION.v_current_date
1155: ,MSC_CL_COLLECTION.v_current_user
1156: ,MSC_CL_COLLECTION.v_current_date
1157: ,MSC_CL_COLLECTION.v_current_user
1158: ,v_current_login
1159: ,v_current_request
1160: ,v_current_application
1161: ,v_current_conc_program

Line 1162: ,MSC_CL_COLLECTION.v_current_date

1158: ,v_current_login
1159: ,v_current_request
1160: ,v_current_application
1161: ,v_current_conc_program
1162: ,MSC_CL_COLLECTION.v_current_date
1163: ,arg_refresh_number
1164: FROM msc_resource_changes changes
1165: WHERE changes.department_id = arg_department_id
1166: AND changes.resource_id = arg_resource_id

Line 1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;

1271: var_disable_date DATE;
1272:
1273: BEGIN
1274:
1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;

Line 1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;

1272:
1273: BEGIN
1274:
1275: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1276: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1277: v_current_login:= FND_GLOBAL.LOGIN_ID;
1278: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1279: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1280: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;

Line 1773: 'FND', lv_dummy1,lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);

1769:
1770: BEGIN
1771:
1772: lv_retval := FND_INSTALLATION.GET_APP_INFO(
1773: 'FND', lv_dummy1,lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
1774: /* initialize the variables */
1775: SELECT
1776: APPS_VER,
1777: SYSDATE,

Line 1786: MSC_CL_COLLECTION.v_apps_ver,

1782: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1783: INSTANCE_TYPE, -- OPM
1784: nvl(LCID,0)
1785: INTO
1786: MSC_CL_COLLECTION.v_apps_ver,
1787: MSC_CL_COLLECTION.START_TIME,
1788: MSC_CL_COLLECTION.v_current_date,
1789: MSC_CL_COLLECTION.v_current_user,
1790: MSC_CL_COLLECTION.v_current_date,

Line 1787: MSC_CL_COLLECTION.START_TIME,

1783: INSTANCE_TYPE, -- OPM
1784: nvl(LCID,0)
1785: INTO
1786: MSC_CL_COLLECTION.v_apps_ver,
1787: MSC_CL_COLLECTION.START_TIME,
1788: MSC_CL_COLLECTION.v_current_date,
1789: MSC_CL_COLLECTION.v_current_user,
1790: MSC_CL_COLLECTION.v_current_date,
1791: MSC_CL_COLLECTION.v_current_user,

Line 1788: MSC_CL_COLLECTION.v_current_date,

1784: nvl(LCID,0)
1785: INTO
1786: MSC_CL_COLLECTION.v_apps_ver,
1787: MSC_CL_COLLECTION.START_TIME,
1788: MSC_CL_COLLECTION.v_current_date,
1789: MSC_CL_COLLECTION.v_current_user,
1790: MSC_CL_COLLECTION.v_current_date,
1791: MSC_CL_COLLECTION.v_current_user,
1792: MSC_CL_COLLECTION.v_instance_code,

Line 1789: MSC_CL_COLLECTION.v_current_user,

1785: INTO
1786: MSC_CL_COLLECTION.v_apps_ver,
1787: MSC_CL_COLLECTION.START_TIME,
1788: MSC_CL_COLLECTION.v_current_date,
1789: MSC_CL_COLLECTION.v_current_user,
1790: MSC_CL_COLLECTION.v_current_date,
1791: MSC_CL_COLLECTION.v_current_user,
1792: MSC_CL_COLLECTION.v_instance_code,
1793: MSC_CL_COLLECTION.v_instance_type, -- OPM

Line 1790: MSC_CL_COLLECTION.v_current_date,

1786: MSC_CL_COLLECTION.v_apps_ver,
1787: MSC_CL_COLLECTION.START_TIME,
1788: MSC_CL_COLLECTION.v_current_date,
1789: MSC_CL_COLLECTION.v_current_user,
1790: MSC_CL_COLLECTION.v_current_date,
1791: MSC_CL_COLLECTION.v_current_user,
1792: MSC_CL_COLLECTION.v_instance_code,
1793: MSC_CL_COLLECTION.v_instance_type, -- OPM
1794: MSC_CL_COLLECTION.v_last_collection_id

Line 1791: MSC_CL_COLLECTION.v_current_user,

1787: MSC_CL_COLLECTION.START_TIME,
1788: MSC_CL_COLLECTION.v_current_date,
1789: MSC_CL_COLLECTION.v_current_user,
1790: MSC_CL_COLLECTION.v_current_date,
1791: MSC_CL_COLLECTION.v_current_user,
1792: MSC_CL_COLLECTION.v_instance_code,
1793: MSC_CL_COLLECTION.v_instance_type, -- OPM
1794: MSC_CL_COLLECTION.v_last_collection_id
1795: FROM MSC_APPS_INSTANCES

Line 1792: MSC_CL_COLLECTION.v_instance_code,

1788: MSC_CL_COLLECTION.v_current_date,
1789: MSC_CL_COLLECTION.v_current_user,
1790: MSC_CL_COLLECTION.v_current_date,
1791: MSC_CL_COLLECTION.v_current_user,
1792: MSC_CL_COLLECTION.v_instance_code,
1793: MSC_CL_COLLECTION.v_instance_type, -- OPM
1794: MSC_CL_COLLECTION.v_last_collection_id
1795: FROM MSC_APPS_INSTANCES
1796: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 1793: MSC_CL_COLLECTION.v_instance_type, -- OPM

1789: MSC_CL_COLLECTION.v_current_user,
1790: MSC_CL_COLLECTION.v_current_date,
1791: MSC_CL_COLLECTION.v_current_user,
1792: MSC_CL_COLLECTION.v_instance_code,
1793: MSC_CL_COLLECTION.v_instance_type, -- OPM
1794: MSC_CL_COLLECTION.v_last_collection_id
1795: FROM MSC_APPS_INSTANCES
1796: WHERE INSTANCE_ID= pINSTANCE_ID;
1797:

Line 1794: MSC_CL_COLLECTION.v_last_collection_id

1790: MSC_CL_COLLECTION.v_current_date,
1791: MSC_CL_COLLECTION.v_current_user,
1792: MSC_CL_COLLECTION.v_instance_code,
1793: MSC_CL_COLLECTION.v_instance_type, -- OPM
1794: MSC_CL_COLLECTION.v_last_collection_id
1795: FROM MSC_APPS_INSTANCES
1796: WHERE INSTANCE_ID= pINSTANCE_ID;
1797:
1798: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;

Line 1798: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;

1794: MSC_CL_COLLECTION.v_last_collection_id
1795: FROM MSC_APPS_INSTANCES
1796: WHERE INSTANCE_ID= pINSTANCE_ID;
1797:
1798: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;
1799: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;
1800: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;
1801:
1802: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;

Line 1799: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;

1795: FROM MSC_APPS_INSTANCES
1796: WHERE INSTANCE_ID= pINSTANCE_ID;
1797:
1798: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;
1799: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;
1800: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;
1801:
1802: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;
1803:

Line 1800: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;

1796: WHERE INSTANCE_ID= pINSTANCE_ID;
1797:
1798: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;
1799: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;
1800: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;
1801:
1802: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;
1803:
1804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Start date : '|| lv_start_date);

Line 1802: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;

1798: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;
1799: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;
1800: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;
1801:
1802: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;
1803:
1804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Start date : '|| lv_start_date);
1805:
1806: lv_where_clause := ' AND ORGANIZATION_ID IN ( SELECT SR_TP_ID FROM MSC_TRADING_PARTNERS WHERE '||

Line 1807: ' SR_INSTANCE_ID = '||MSC_CL_COLLECTION.v_instance_id ||

1803:
1804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Start date : '|| lv_start_date);
1805:
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

Line 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

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;
1815: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);

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 1815: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);

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:
1818: /* call the function to calc. resource avail */
1819: lv_ret_res_ava:=CALC_RESOURCE_AVAILABILITY(lv_start_date-1,MSC_UTIL.G_ALL_ORGANIZATIONS,TRUE);

Line 1833: ELSIF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_MIXED THEN

1829: RETCODE:= MSC_UTIL.G_ERROR;
1830:
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);

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 1837: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);

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:
1840:
1841: lv_ret_res_ava:=CALC_RESOURCE_AVAILABILITY(lv_start_date-1,MSC_UTIL.G_ALL_ORGANIZATIONS,TRUE);

Line 1896: WHERE tp.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1892: SELECT tp.Organization_ID
1893: FROM MSC_PARAMETERS tp,
1894: MSC_INSTANCE_ORGS ins_org,
1895: MSC_TRADING_PARTNERS mtp
1896: WHERE tp.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1897: AND ins_org.SR_INSTANCE_ID=tp.SR_INSTANCE_ID
1898: AND ins_org.Organization_ID=tp.ORGANIZATION_ID
1899: AND ins_org.ENABLED_FLAG= MSC_UTIL.SYS_YES
1900: AND ((pORG_GROUP = MSC_UTIL.G_ALL_ORGANIZATIONS ) OR (ins_org.ORG_GROUP=pORG_GROUP))

Line 1901: AND mtp.sr_instance_id = MSC_CL_COLLECTION.v_instance_id

1897: AND ins_org.SR_INSTANCE_ID=tp.SR_INSTANCE_ID
1898: AND ins_org.Organization_ID=tp.ORGANIZATION_ID
1899: AND ins_org.ENABLED_FLAG= MSC_UTIL.SYS_YES
1900: AND ((pORG_GROUP = MSC_UTIL.G_ALL_ORGANIZATIONS ) OR (ins_org.ORG_GROUP=pORG_GROUP))
1901: AND mtp.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
1902: AND mtp.sr_tp_id = tp.organization_id
1903: AND mtp.partner_type = 3
1904: AND mtp.organization_type = 1; -- Discrete Mfg.
1905:

Line 1912: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1908:
1909: CURSOR c2 IS
1910: SELECT 1
1911: FROM MSC_ST_RESOURCE_CHANGES
1912: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1913: AND process_flag = 5;
1914:
1915: lv_changes_exists NUMBER := 0;
1916: /*****************LEGACY_CHANGE_ENDS************************/

Line 1949: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN

1945: lv_refresh_flag:= 2;
1946: END IF;
1947: */
1948:
1949: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
1950: lv_refresh_flag := 1;
1951: ELSIF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1952: lv_refresh_flag := 2;
1953: ELSIF MSC_CL_COLLECTION.v_is_partial_refresh THEN

Line 1951: ELSIF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

1947: */
1948:
1949: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
1950: lv_refresh_flag := 1;
1951: ELSIF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1952: lv_refresh_flag := 2;
1953: ELSIF MSC_CL_COLLECTION.v_is_partial_refresh THEN
1954: lv_refresh_flag := 1; -- Functionality is same as complete_refresh
1955: END IF;

Line 1953: ELSIF MSC_CL_COLLECTION.v_is_partial_refresh THEN

1949: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
1950: lv_refresh_flag := 1;
1951: ELSIF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1952: lv_refresh_flag := 2;
1953: ELSIF MSC_CL_COLLECTION.v_is_partial_refresh THEN
1954: lv_refresh_flag := 1; -- Functionality is same as complete_refresh
1955: END IF;
1956:
1957: /************** LEGACY_CHANGE_START*************************/

Line 1961: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN

1957: /************** LEGACY_CHANGE_START*************************/
1958: -- Calling the program as complete refresh for legacy so that new
1959: -- records coming in are considered
1960:
1961: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN
1962: lv_refresh_flag := 1;
1963: END IF;
1964: /*****************LEGACY_CHANGE_ENDS************************/
1965:

Line 1979: MSC_CL_COLLECTION.v_last_collection_id,

1975:
1976: POPULATE_ORG_RESOURCES
1977: ( lv_ret_code,
1978: lv_refresh_flag,
1979: MSC_CL_COLLECTION.v_last_collection_id,
1980: c_rec.organization_id,
1981: MSC_CL_COLLECTION.v_instance_id,
1982: lv_task_start_time,
1983: lv_task_end_time);

Line 1981: MSC_CL_COLLECTION.v_instance_id,

1977: ( lv_ret_code,
1978: lv_refresh_flag,
1979: MSC_CL_COLLECTION.v_last_collection_id,
1980: c_rec.organization_id,
1981: MSC_CL_COLLECTION.v_instance_id,
1982: lv_task_start_time,
1983: lv_task_end_time);
1984:
1985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'RET_CODE: ' ||lv_ret_code);

Line 2005: MSC_CL_COLLECTION.v_last_collection_id,

2001:
2002: POPULATE_ALL_LINES
2003: ( lv_ret_code,
2004: lv_refresh_flag,
2005: MSC_CL_COLLECTION.v_last_collection_id,
2006: c_rec.organization_id,
2007: MSC_CL_COLLECTION.v_instance_id,
2008: lv_task_start_time,
2009: lv_task_end_time);

Line 2007: MSC_CL_COLLECTION.v_instance_id,

2003: ( lv_ret_code,
2004: lv_refresh_flag,
2005: MSC_CL_COLLECTION.v_last_collection_id,
2006: c_rec.organization_id,
2007: MSC_CL_COLLECTION.v_instance_id,
2008: lv_task_start_time,
2009: lv_task_end_time);
2010:
2011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'RET_CODE: ' ||lv_ret_code);

Line 2035: MSC_CL_COLLECTION.v_last_collection_id,

2031:
2032: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES
2033: ( lv_ret_code,
2034: lv_refresh_flag,
2035: MSC_CL_COLLECTION.v_last_collection_id,
2036: c_rec.organization_id,
2037: MSC_CL_COLLECTION.v_instance_id,
2038: lv_task_start_time,
2039: lv_task_end_time);

Line 2037: MSC_CL_COLLECTION.v_instance_id,

2033: ( lv_ret_code,
2034: lv_refresh_flag,
2035: MSC_CL_COLLECTION.v_last_collection_id,
2036: c_rec.organization_id,
2037: MSC_CL_COLLECTION.v_instance_id,
2038: lv_task_start_time,
2039: lv_task_end_time);
2040:
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'RET_CODE: ' ||lv_ret_code);

Line 2065: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN

2061: -- This is to enable resource changes to be
2062: -- considered for legacy. Both, the resource information and
2063: -- resource changes may come in at the same time for legacy.
2064:
2065: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN
2066:
2067: OPEN C2;
2068: FETCH C2 INTO lv_changes_exists;
2069: CLOSE C2;

Line 2086: MSC_CL_COLLECTION.v_last_collection_id,

2082:
2083: POPULATE_ORG_RESOURCES
2084: ( lv_ret_code,
2085: lv_refresh_flag,
2086: MSC_CL_COLLECTION.v_last_collection_id,
2087: c_rec.organization_id,
2088: MSC_CL_COLLECTION.v_instance_id,
2089: lv_task_start_time,
2090: lv_task_end_time);

Line 2088: MSC_CL_COLLECTION.v_instance_id,

2084: ( lv_ret_code,
2085: lv_refresh_flag,
2086: MSC_CL_COLLECTION.v_last_collection_id,
2087: c_rec.organization_id,
2088: MSC_CL_COLLECTION.v_instance_id,
2089: lv_task_start_time,
2090: lv_task_end_time);
2091:
2092: IF lv_ret_code <> 0 THEN

Line 2110: MSC_CL_COLLECTION.v_last_collection_id,

2106:
2107: POPULATE_ALL_LINES
2108: ( lv_ret_code,
2109: lv_refresh_flag,
2110: MSC_CL_COLLECTION.v_last_collection_id,
2111: c_rec.organization_id,
2112: MSC_CL_COLLECTION.v_instance_id,
2113: lv_task_start_time,
2114: lv_task_end_time);

Line 2112: MSC_CL_COLLECTION.v_instance_id,

2108: ( lv_ret_code,
2109: lv_refresh_flag,
2110: MSC_CL_COLLECTION.v_last_collection_id,
2111: c_rec.organization_id,
2112: MSC_CL_COLLECTION.v_instance_id,
2113: lv_task_start_time,
2114: lv_task_end_time);
2115:
2116: IF lv_ret_code <> 0 THEN

Line 2138: MSC_CL_COLLECTION.v_last_collection_id,

2134:
2135: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES
2136: ( lv_ret_code,
2137: lv_refresh_flag,
2138: MSC_CL_COLLECTION.v_last_collection_id,
2139: c_rec.organization_id,
2140: MSC_CL_COLLECTION.v_instance_id,
2141: lv_task_start_time,
2142: lv_task_end_time);

Line 2140: MSC_CL_COLLECTION.v_instance_id,

2136: ( lv_ret_code,
2137: lv_refresh_flag,
2138: MSC_CL_COLLECTION.v_last_collection_id,
2139: c_rec.organization_id,
2140: MSC_CL_COLLECTION.v_instance_id,
2141: lv_task_start_time,
2142: lv_task_end_time);
2143:
2144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'RET_CODE: ' ||lv_ret_code);

Line 2173: AND sr_instance_id = MSC_CL_COLLECTION.v_instance_id

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
2174: AND simulation_set is not null
2175: and shift_date between trunc(lv_task_start_time) and
2176: lv_task_end_time;
2177:

Line 2234: WHERE msnra.sr_instance_id = MSC_CL_COLLECTION.v_instance_id and

2230: msnra.from_time,
2231: msnra.to_time,
2232: msnra.capacity_units
2233: FROM msc_st_net_resource_avail msnra
2234: WHERE msnra.sr_instance_id = MSC_CL_COLLECTION.v_instance_id and
2235: msnra.organization_id=org_id;
2236:
2237:
2238: ---------------------------------------------------------------------

Line 2260: WHERE msnria.sr_instance_id = MSC_CL_COLLECTION.v_instance_id

2256: msnria.from_time,
2257: msnria.to_time
2258: FROM msc_st_net_res_inst_avail msnria,
2259: MSC_ITEM_ID_LID t1
2260: WHERE msnria.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2261: and t1.sr_instance_id (+) = msnria.sr_instance_id
2262: and t1.sr_inventory_item_id (+) = msnria.equipment_item_id
2263: and msnria.organization_id=org_id;
2264:

Line 2269: where mio.sr_instance_id= MSC_CL_COLLECTION.v_instance_id and

2265: CURSOR c_org_list IS
2266: select organization_id
2267: from msc_instance_orgs mio,
2268: msc_trading_partners mtp
2269: where mio.sr_instance_id= MSC_CL_COLLECTION.v_instance_id and
2270: mio.enabled_flag= 1 and
2271: ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (mio.org_group = MSC_CL_COLLECTION.v_coll_prec.org_group_flag)) and
2272: mio.sr_instance_id=mtp.sr_instance_id and
2273: mio.organization_id=mtp.sr_tp_id and

Line 2271: ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (mio.org_group = MSC_CL_COLLECTION.v_coll_prec.org_group_flag)) and

2267: from msc_instance_orgs mio,
2268: msc_trading_partners mtp
2269: where mio.sr_instance_id= MSC_CL_COLLECTION.v_instance_id and
2270: mio.enabled_flag= 1 and
2271: ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (mio.org_group = MSC_CL_COLLECTION.v_coll_prec.org_group_flag)) and
2272: mio.sr_instance_id=mtp.sr_instance_id and
2273: mio.organization_id=mtp.sr_tp_id and
2274: mtp.partner_type=3 and
2275: mtp.organization_type=2;

Line 2284: IF MSC_CL_COLLECTION.v_recalc_nra= MSC_UTIL.SYS_YES THEN

2280: lv_sql_stmt VARCHAR2(2048);
2281:
2282: BEGIN
2283:
2284: IF MSC_CL_COLLECTION.v_recalc_nra= MSC_UTIL.SYS_YES THEN
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:

Line 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

2282: BEGIN
2283:
2284: IF MSC_CL_COLLECTION.v_recalc_nra= MSC_UTIL.SYS_YES THEN
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);

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 2290: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);

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');
2294: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);

Line 2292: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN

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');
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

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 2295: 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');
2299: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);

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 2300: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1,v_sub_str);

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;*/
2304:

Line 2307: IF MSC_CL_COLLECTION.v_process_flag = MSC_UTIL.SYS_YES THEN

2303: END IF;*/
2304:
2305: -- process mfg only. move the rows for the st table to the msc table
2306: -- for net resource avail
2307: IF MSC_CL_COLLECTION.v_process_flag = MSC_UTIL.SYS_YES THEN
2308:
2309: /*
2310: We will do a bulk insert of res avail for OPM orgs. If this fails,
2311: then we will switch to old, row by row processing.

Line 2367: ||' WHERE msnra.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id

2363: ||' :v_current_date,'
2364: ||' :v_current_user,'
2365: ||' :v_last_collection_id'
2366: ||' FROM msc_st_net_resource_avail msnra'
2367: ||' WHERE msnra.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2368: ||' AND msnra.organization_id = ' ||c_rec1.organization_id;
2369:
2370: EXECUTE IMMEDIATE lv_sql_stmt
2371: USING

Line 2372: MSC_CL_COLLECTION.v_current_date,

2368: ||' AND msnra.organization_id = ' ||c_rec1.organization_id;
2369:
2370: EXECUTE IMMEDIATE lv_sql_stmt
2371: USING
2372: MSC_CL_COLLECTION.v_current_date,
2373: MSC_CL_COLLECTION.v_current_user,
2374: MSC_CL_COLLECTION.v_current_date,
2375: MSC_CL_COLLECTION.v_current_user,
2376: MSC_CL_COLLECTION.v_last_collection_id;

Line 2373: MSC_CL_COLLECTION.v_current_user,

2369:
2370: EXECUTE IMMEDIATE lv_sql_stmt
2371: USING
2372: MSC_CL_COLLECTION.v_current_date,
2373: MSC_CL_COLLECTION.v_current_user,
2374: MSC_CL_COLLECTION.v_current_date,
2375: MSC_CL_COLLECTION.v_current_user,
2376: MSC_CL_COLLECTION.v_last_collection_id;
2377:

Line 2374: MSC_CL_COLLECTION.v_current_date,

2370: EXECUTE IMMEDIATE lv_sql_stmt
2371: USING
2372: MSC_CL_COLLECTION.v_current_date,
2373: MSC_CL_COLLECTION.v_current_user,
2374: MSC_CL_COLLECTION.v_current_date,
2375: MSC_CL_COLLECTION.v_current_user,
2376: MSC_CL_COLLECTION.v_last_collection_id;
2377:
2378: COMMIT;

Line 2375: MSC_CL_COLLECTION.v_current_user,

2371: USING
2372: MSC_CL_COLLECTION.v_current_date,
2373: MSC_CL_COLLECTION.v_current_user,
2374: MSC_CL_COLLECTION.v_current_date,
2375: MSC_CL_COLLECTION.v_current_user,
2376: MSC_CL_COLLECTION.v_last_collection_id;
2377:
2378: COMMIT;
2379:

Line 2376: MSC_CL_COLLECTION.v_last_collection_id;

2372: MSC_CL_COLLECTION.v_current_date,
2373: MSC_CL_COLLECTION.v_current_user,
2374: MSC_CL_COLLECTION.v_current_date,
2375: MSC_CL_COLLECTION.v_current_user,
2376: MSC_CL_COLLECTION.v_last_collection_id;
2377:
2378: COMMIT;
2379:
2380: lv_res_avail:=MSC_UTIL.SYS_YES;

Line 2436: MSC_CL_COLLECTION.v_current_date,

2432: c_rec.simulation_set,
2433: NULL, /* STATUS */
2434: NULL, /* APPLIED */
2435: 2, /* UPDATED */
2436: MSC_CL_COLLECTION.v_current_date,
2437: MSC_CL_COLLECTION.v_current_user,
2438: MSC_CL_COLLECTION.v_current_date,
2439: MSC_CL_COLLECTION.v_current_user,
2440: MSC_CL_COLLECTION.v_last_collection_id);

Line 2437: MSC_CL_COLLECTION.v_current_user,

2433: NULL, /* STATUS */
2434: NULL, /* APPLIED */
2435: 2, /* UPDATED */
2436: MSC_CL_COLLECTION.v_current_date,
2437: MSC_CL_COLLECTION.v_current_user,
2438: MSC_CL_COLLECTION.v_current_date,
2439: MSC_CL_COLLECTION.v_current_user,
2440: MSC_CL_COLLECTION.v_last_collection_id);
2441:

Line 2438: MSC_CL_COLLECTION.v_current_date,

2434: NULL, /* APPLIED */
2435: 2, /* UPDATED */
2436: MSC_CL_COLLECTION.v_current_date,
2437: MSC_CL_COLLECTION.v_current_user,
2438: MSC_CL_COLLECTION.v_current_date,
2439: MSC_CL_COLLECTION.v_current_user,
2440: MSC_CL_COLLECTION.v_last_collection_id);
2441:
2442: c_count:= c_count+1;

Line 2439: MSC_CL_COLLECTION.v_current_user,

2435: 2, /* UPDATED */
2436: MSC_CL_COLLECTION.v_current_date,
2437: MSC_CL_COLLECTION.v_current_user,
2438: MSC_CL_COLLECTION.v_current_date,
2439: MSC_CL_COLLECTION.v_current_user,
2440: MSC_CL_COLLECTION.v_last_collection_id);
2441:
2442: c_count:= c_count+1;
2443:

Line 2440: MSC_CL_COLLECTION.v_last_collection_id);

2436: MSC_CL_COLLECTION.v_current_date,
2437: MSC_CL_COLLECTION.v_current_user,
2438: MSC_CL_COLLECTION.v_current_date,
2439: MSC_CL_COLLECTION.v_current_user,
2440: MSC_CL_COLLECTION.v_last_collection_id);
2441:
2442: c_count:= c_count+1;
2443:
2444: IF c_count> MSC_CL_COLLECTION.PBS THEN

Line 2444: IF c_count> MSC_CL_COLLECTION.PBS THEN

2440: MSC_CL_COLLECTION.v_last_collection_id);
2441:
2442: c_count:= c_count+1;
2443:
2444: IF c_count> MSC_CL_COLLECTION.PBS THEN
2445: COMMIT;
2446: c_count:= 0;
2447: END IF;
2448:

Line 2465: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2461: RAISE;
2462:
2463: ELSE
2464:
2465: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
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');

Line 2482: MSC_CL_COLLECTION.v_instance_id));

2478: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2479: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2480: FND_MESSAGE.SET_TOKEN('VALUE',
2481: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2482: MSC_CL_COLLECTION.v_instance_id));
2483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2484:
2485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2486: END IF;

Line 2492: END IF; /* If lv_res_avail:=MSC_CL_COLLECTION.SYS_NO */

2488: END;
2489:
2490: END LOOP;
2491:
2492: END IF; /* If lv_res_avail:=MSC_CL_COLLECTION.SYS_NO */
2493: END LOOP;
2494:
2495: ------------------------------------------------------------------------
2496: -- here is the change for msc_net_res_inst_avail (DS change)

Line 2556: ||' WHERE msnria.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id

2552: ||' :v_current_user,'
2553: ||' :v_last_collection_id'
2554: ||' FROM msc_st_net_res_inst_avail msnria,'
2555: ||' MSC_ITEM_ID_LID t1'
2556: ||' WHERE msnria.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2557: ||' and t1.sr_instance_id (+) = msnria.sr_instance_id'
2558: ||' and t1.sr_inventory_item_id (+) = msnria.equipment_item_id'
2559: ||' and msnria.organization_id = ' ||c_rec1.organization_id;
2560:

Line 2563: MSC_CL_COLLECTION.v_current_date,

2559: ||' and msnria.organization_id = ' ||c_rec1.organization_id;
2560:
2561: EXECUTE IMMEDIATE lv_sql_stmt
2562: USING
2563: MSC_CL_COLLECTION.v_current_date,
2564: MSC_CL_COLLECTION.v_current_user,
2565: MSC_CL_COLLECTION.v_current_date,
2566: MSC_CL_COLLECTION.v_current_user,
2567: MSC_CL_COLLECTION.v_last_collection_id;

Line 2564: MSC_CL_COLLECTION.v_current_user,

2560:
2561: EXECUTE IMMEDIATE lv_sql_stmt
2562: USING
2563: MSC_CL_COLLECTION.v_current_date,
2564: MSC_CL_COLLECTION.v_current_user,
2565: MSC_CL_COLLECTION.v_current_date,
2566: MSC_CL_COLLECTION.v_current_user,
2567: MSC_CL_COLLECTION.v_last_collection_id;
2568:

Line 2565: MSC_CL_COLLECTION.v_current_date,

2561: EXECUTE IMMEDIATE lv_sql_stmt
2562: USING
2563: MSC_CL_COLLECTION.v_current_date,
2564: MSC_CL_COLLECTION.v_current_user,
2565: MSC_CL_COLLECTION.v_current_date,
2566: MSC_CL_COLLECTION.v_current_user,
2567: MSC_CL_COLLECTION.v_last_collection_id;
2568:
2569: COMMIT;

Line 2566: MSC_CL_COLLECTION.v_current_user,

2562: USING
2563: MSC_CL_COLLECTION.v_current_date,
2564: MSC_CL_COLLECTION.v_current_user,
2565: MSC_CL_COLLECTION.v_current_date,
2566: MSC_CL_COLLECTION.v_current_user,
2567: MSC_CL_COLLECTION.v_last_collection_id;
2568:
2569: COMMIT;
2570:

Line 2567: MSC_CL_COLLECTION.v_last_collection_id;

2563: MSC_CL_COLLECTION.v_current_date,
2564: MSC_CL_COLLECTION.v_current_user,
2565: MSC_CL_COLLECTION.v_current_date,
2566: MSC_CL_COLLECTION.v_current_user,
2567: MSC_CL_COLLECTION.v_last_collection_id;
2568:
2569: COMMIT;
2570:
2571: lv_res_inst_avail:=MSC_UTIL.SYS_YES;

Line 2635: MSC_CL_COLLECTION.v_current_date,

2631: c_rec_resinst.to_time,
2632: NULL, /* STATUS */
2633: NULL, /* APPLIED */
2634: 2, /* UPDATED */
2635: MSC_CL_COLLECTION.v_current_date,
2636: MSC_CL_COLLECTION.v_current_user,
2637: MSC_CL_COLLECTION.v_current_date,
2638: MSC_CL_COLLECTION.v_current_user,
2639: MSC_CL_COLLECTION.v_last_collection_id);

Line 2636: MSC_CL_COLLECTION.v_current_user,

2632: NULL, /* STATUS */
2633: NULL, /* APPLIED */
2634: 2, /* UPDATED */
2635: MSC_CL_COLLECTION.v_current_date,
2636: MSC_CL_COLLECTION.v_current_user,
2637: MSC_CL_COLLECTION.v_current_date,
2638: MSC_CL_COLLECTION.v_current_user,
2639: MSC_CL_COLLECTION.v_last_collection_id);
2640:

Line 2637: MSC_CL_COLLECTION.v_current_date,

2633: NULL, /* APPLIED */
2634: 2, /* UPDATED */
2635: MSC_CL_COLLECTION.v_current_date,
2636: MSC_CL_COLLECTION.v_current_user,
2637: MSC_CL_COLLECTION.v_current_date,
2638: MSC_CL_COLLECTION.v_current_user,
2639: MSC_CL_COLLECTION.v_last_collection_id);
2640:
2641: c_count:= c_count+1;

Line 2638: MSC_CL_COLLECTION.v_current_user,

2634: 2, /* UPDATED */
2635: MSC_CL_COLLECTION.v_current_date,
2636: MSC_CL_COLLECTION.v_current_user,
2637: MSC_CL_COLLECTION.v_current_date,
2638: MSC_CL_COLLECTION.v_current_user,
2639: MSC_CL_COLLECTION.v_last_collection_id);
2640:
2641: c_count:= c_count+1;
2642:

Line 2639: MSC_CL_COLLECTION.v_last_collection_id);

2635: MSC_CL_COLLECTION.v_current_date,
2636: MSC_CL_COLLECTION.v_current_user,
2637: MSC_CL_COLLECTION.v_current_date,
2638: MSC_CL_COLLECTION.v_current_user,
2639: MSC_CL_COLLECTION.v_last_collection_id);
2640:
2641: c_count:= c_count+1;
2642:
2643: IF c_count> MSC_CL_COLLECTION.PBS THEN

Line 2643: IF c_count> MSC_CL_COLLECTION.PBS THEN

2639: MSC_CL_COLLECTION.v_last_collection_id);
2640:
2641: c_count:= c_count+1;
2642:
2643: IF c_count> MSC_CL_COLLECTION.PBS THEN
2644: COMMIT;
2645: c_count:= 0;
2646: END IF;
2647:

Line 2664: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2660: RAISE;
2661:
2662: ELSE
2663:
2664: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2665:
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2667: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2668: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');

Line 2681: MSC_CL_COLLECTION.v_instance_id));

2677: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2678: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2679: FND_MESSAGE.SET_TOKEN('VALUE',
2680: MSC_GET_NAME.ORG_CODE( c_rec_resinst.ORGANIZATION_ID,
2681: MSC_CL_COLLECTION.v_instance_id));
2682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2683:
2684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2685: END IF;

Line 2690: END IF; /* IF lv_res_inst_avail = MSC_CL_COLLECTION.SYS_NO THEN */

2686:
2687: END;
2688:
2689: END LOOP;
2690: END IF; /* IF lv_res_inst_avail = MSC_CL_COLLECTION.SYS_NO THEN */
2691: END LOOP;
2692:
2693: COMMIT;
2694: