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.

[Home] [Help]

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: WHERE dates.calendar_code = v_calendar_code

Line 602: ,MSC_CL_COLLECTION.v_current_date

598: ,arg_aggregate_resource_id
599: ,NULL /* STATUS */
600: ,NULL /* APPLIED */
601: ,2 /* UPDATED */
602: ,MSC_CL_COLLECTION.v_current_date
603: ,MSC_CL_COLLECTION.v_current_user
604: ,MSC_CL_COLLECTION.v_current_date
605: ,MSC_CL_COLLECTION.v_current_user
606: ,v_current_login

Line 603: ,MSC_CL_COLLECTION.v_current_user

599: ,NULL /* STATUS */
600: ,NULL /* APPLIED */
601: ,2 /* UPDATED */
602: ,MSC_CL_COLLECTION.v_current_date
603: ,MSC_CL_COLLECTION.v_current_user
604: ,MSC_CL_COLLECTION.v_current_date
605: ,MSC_CL_COLLECTION.v_current_user
606: ,v_current_login
607: ,v_current_request

Line 604: ,MSC_CL_COLLECTION.v_current_date

600: ,NULL /* APPLIED */
601: ,2 /* UPDATED */
602: ,MSC_CL_COLLECTION.v_current_date
603: ,MSC_CL_COLLECTION.v_current_user
604: ,MSC_CL_COLLECTION.v_current_date
605: ,MSC_CL_COLLECTION.v_current_user
606: ,v_current_login
607: ,v_current_request
608: ,v_current_application

Line 605: ,MSC_CL_COLLECTION.v_current_user

601: ,2 /* UPDATED */
602: ,MSC_CL_COLLECTION.v_current_date
603: ,MSC_CL_COLLECTION.v_current_user
604: ,MSC_CL_COLLECTION.v_current_date
605: ,MSC_CL_COLLECTION.v_current_user
606: ,v_current_login
607: ,v_current_request
608: ,v_current_application
609: ,v_current_conc_program

Line 610: ,MSC_CL_COLLECTION.v_current_date);

606: ,v_current_login
607: ,v_current_request
608: ,v_current_application
609: ,v_current_conc_program
610: ,MSC_CL_COLLECTION.v_current_date);
611:
612: if (arg_disable_date < sysdate) then
613: -- If the disable date is in the past, just return!
614: return;

Line 699: ,MSC_CL_COLLECTION.v_current_date

695: ,arg_aggregate_resource_id
696: ,NULL /* STATUS */
697: ,NULL /* APPLIED */
698: ,2 /* UPDATED */
699: ,MSC_CL_COLLECTION.v_current_date
700: ,MSC_CL_COLLECTION.v_current_user
701: ,MSC_CL_COLLECTION.v_current_date
702: ,MSC_CL_COLLECTION.v_current_user
703: ,v_current_login

Line 700: ,MSC_CL_COLLECTION.v_current_user

696: ,NULL /* STATUS */
697: ,NULL /* APPLIED */
698: ,2 /* UPDATED */
699: ,MSC_CL_COLLECTION.v_current_date
700: ,MSC_CL_COLLECTION.v_current_user
701: ,MSC_CL_COLLECTION.v_current_date
702: ,MSC_CL_COLLECTION.v_current_user
703: ,v_current_login
704: ,v_current_request

Line 701: ,MSC_CL_COLLECTION.v_current_date

697: ,NULL /* APPLIED */
698: ,2 /* UPDATED */
699: ,MSC_CL_COLLECTION.v_current_date
700: ,MSC_CL_COLLECTION.v_current_user
701: ,MSC_CL_COLLECTION.v_current_date
702: ,MSC_CL_COLLECTION.v_current_user
703: ,v_current_login
704: ,v_current_request
705: ,v_current_application

Line 702: ,MSC_CL_COLLECTION.v_current_user

698: ,2 /* UPDATED */
699: ,MSC_CL_COLLECTION.v_current_date
700: ,MSC_CL_COLLECTION.v_current_user
701: ,MSC_CL_COLLECTION.v_current_date
702: ,MSC_CL_COLLECTION.v_current_user
703: ,v_current_login
704: ,v_current_request
705: ,v_current_application
706: ,v_current_conc_program

Line 707: ,MSC_CL_COLLECTION.v_current_date);

703: ,v_current_login
704: ,v_current_request
705: ,v_current_application
706: ,v_current_conc_program
707: ,MSC_CL_COLLECTION.v_current_date);
708:
709: END if; -- arg_24hr_flag
710:
711:

Line 1142: ,MSC_CL_COLLECTION.v_current_date

1138: ,arg_aggregate_resource_id
1139: ,NULL /* STATUS */
1140: ,NULL /* APPLIED */
1141: ,2 /* UPDATED */
1142: ,MSC_CL_COLLECTION.v_current_date
1143: ,MSC_CL_COLLECTION.v_current_user
1144: ,MSC_CL_COLLECTION.v_current_date
1145: ,MSC_CL_COLLECTION.v_current_user
1146: ,v_current_login

Line 1143: ,MSC_CL_COLLECTION.v_current_user

1139: ,NULL /* STATUS */
1140: ,NULL /* APPLIED */
1141: ,2 /* UPDATED */
1142: ,MSC_CL_COLLECTION.v_current_date
1143: ,MSC_CL_COLLECTION.v_current_user
1144: ,MSC_CL_COLLECTION.v_current_date
1145: ,MSC_CL_COLLECTION.v_current_user
1146: ,v_current_login
1147: ,v_current_request

Line 1144: ,MSC_CL_COLLECTION.v_current_date

1140: ,NULL /* APPLIED */
1141: ,2 /* UPDATED */
1142: ,MSC_CL_COLLECTION.v_current_date
1143: ,MSC_CL_COLLECTION.v_current_user
1144: ,MSC_CL_COLLECTION.v_current_date
1145: ,MSC_CL_COLLECTION.v_current_user
1146: ,v_current_login
1147: ,v_current_request
1148: ,v_current_application

Line 1145: ,MSC_CL_COLLECTION.v_current_user

1141: ,2 /* UPDATED */
1142: ,MSC_CL_COLLECTION.v_current_date
1143: ,MSC_CL_COLLECTION.v_current_user
1144: ,MSC_CL_COLLECTION.v_current_date
1145: ,MSC_CL_COLLECTION.v_current_user
1146: ,v_current_login
1147: ,v_current_request
1148: ,v_current_application
1149: ,v_current_conc_program

Line 1150: ,MSC_CL_COLLECTION.v_current_date

1146: ,v_current_login
1147: ,v_current_request
1148: ,v_current_application
1149: ,v_current_conc_program
1150: ,MSC_CL_COLLECTION.v_current_date
1151: ,arg_refresh_number
1152: FROM msc_resource_changes changes
1153: WHERE changes.department_id = arg_department_id
1154: AND changes.resource_id = arg_resource_id

Line 1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;

1259: var_disable_date DATE;
1260:
1261: BEGIN
1262:
1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;

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

1260:
1261: BEGIN
1262:
1263: MSC_CL_COLLECTION.v_current_date:= SYSDATE;
1264: MSC_CL_COLLECTION.v_current_user:= FND_GLOBAL.USER_ID;
1265: v_current_login:= FND_GLOBAL.LOGIN_ID;
1266: v_current_request:= FND_GLOBAL.CONC_REQUEST_ID;
1267: v_current_application:= FND_GLOBAL.PROG_APPL_ID;
1268: v_current_conc_program:= FND_GLOBAL.CONC_PROGRAM_ID;

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

1757:
1758: BEGIN
1759:
1760: lv_retval := FND_INSTALLATION.GET_APP_INFO(
1761: 'FND', lv_dummy1,lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
1762: /* initialize the variables */
1763: SELECT
1764: APPS_VER,
1765: SYSDATE,

Line 1774: MSC_CL_COLLECTION.v_apps_ver,

1770: UPPER(INSTANCE_CODE), /* Bug 2129155 */
1771: INSTANCE_TYPE, -- OPM
1772: nvl(LCID,0)
1773: INTO
1774: MSC_CL_COLLECTION.v_apps_ver,
1775: MSC_CL_COLLECTION.START_TIME,
1776: MSC_CL_COLLECTION.v_current_date,
1777: MSC_CL_COLLECTION.v_current_user,
1778: MSC_CL_COLLECTION.v_current_date,

Line 1775: MSC_CL_COLLECTION.START_TIME,

1771: INSTANCE_TYPE, -- OPM
1772: nvl(LCID,0)
1773: INTO
1774: MSC_CL_COLLECTION.v_apps_ver,
1775: MSC_CL_COLLECTION.START_TIME,
1776: MSC_CL_COLLECTION.v_current_date,
1777: MSC_CL_COLLECTION.v_current_user,
1778: MSC_CL_COLLECTION.v_current_date,
1779: MSC_CL_COLLECTION.v_current_user,

Line 1776: MSC_CL_COLLECTION.v_current_date,

1772: nvl(LCID,0)
1773: INTO
1774: MSC_CL_COLLECTION.v_apps_ver,
1775: MSC_CL_COLLECTION.START_TIME,
1776: MSC_CL_COLLECTION.v_current_date,
1777: MSC_CL_COLLECTION.v_current_user,
1778: MSC_CL_COLLECTION.v_current_date,
1779: MSC_CL_COLLECTION.v_current_user,
1780: MSC_CL_COLLECTION.v_instance_code,

Line 1777: MSC_CL_COLLECTION.v_current_user,

1773: INTO
1774: MSC_CL_COLLECTION.v_apps_ver,
1775: MSC_CL_COLLECTION.START_TIME,
1776: MSC_CL_COLLECTION.v_current_date,
1777: MSC_CL_COLLECTION.v_current_user,
1778: MSC_CL_COLLECTION.v_current_date,
1779: MSC_CL_COLLECTION.v_current_user,
1780: MSC_CL_COLLECTION.v_instance_code,
1781: MSC_CL_COLLECTION.v_instance_type, -- OPM

Line 1778: MSC_CL_COLLECTION.v_current_date,

1774: MSC_CL_COLLECTION.v_apps_ver,
1775: MSC_CL_COLLECTION.START_TIME,
1776: MSC_CL_COLLECTION.v_current_date,
1777: MSC_CL_COLLECTION.v_current_user,
1778: MSC_CL_COLLECTION.v_current_date,
1779: MSC_CL_COLLECTION.v_current_user,
1780: MSC_CL_COLLECTION.v_instance_code,
1781: MSC_CL_COLLECTION.v_instance_type, -- OPM
1782: MSC_CL_COLLECTION.v_last_collection_id

Line 1779: MSC_CL_COLLECTION.v_current_user,

1775: MSC_CL_COLLECTION.START_TIME,
1776: MSC_CL_COLLECTION.v_current_date,
1777: MSC_CL_COLLECTION.v_current_user,
1778: MSC_CL_COLLECTION.v_current_date,
1779: MSC_CL_COLLECTION.v_current_user,
1780: MSC_CL_COLLECTION.v_instance_code,
1781: MSC_CL_COLLECTION.v_instance_type, -- OPM
1782: MSC_CL_COLLECTION.v_last_collection_id
1783: FROM MSC_APPS_INSTANCES

Line 1780: MSC_CL_COLLECTION.v_instance_code,

1776: MSC_CL_COLLECTION.v_current_date,
1777: MSC_CL_COLLECTION.v_current_user,
1778: MSC_CL_COLLECTION.v_current_date,
1779: MSC_CL_COLLECTION.v_current_user,
1780: MSC_CL_COLLECTION.v_instance_code,
1781: MSC_CL_COLLECTION.v_instance_type, -- OPM
1782: MSC_CL_COLLECTION.v_last_collection_id
1783: FROM MSC_APPS_INSTANCES
1784: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 1781: MSC_CL_COLLECTION.v_instance_type, -- OPM

1777: MSC_CL_COLLECTION.v_current_user,
1778: MSC_CL_COLLECTION.v_current_date,
1779: MSC_CL_COLLECTION.v_current_user,
1780: MSC_CL_COLLECTION.v_instance_code,
1781: MSC_CL_COLLECTION.v_instance_type, -- OPM
1782: MSC_CL_COLLECTION.v_last_collection_id
1783: FROM MSC_APPS_INSTANCES
1784: WHERE INSTANCE_ID= pINSTANCE_ID;
1785:

Line 1782: MSC_CL_COLLECTION.v_last_collection_id

1778: MSC_CL_COLLECTION.v_current_date,
1779: MSC_CL_COLLECTION.v_current_user,
1780: MSC_CL_COLLECTION.v_instance_code,
1781: MSC_CL_COLLECTION.v_instance_type, -- OPM
1782: MSC_CL_COLLECTION.v_last_collection_id
1783: FROM MSC_APPS_INSTANCES
1784: WHERE INSTANCE_ID= pINSTANCE_ID;
1785:
1786: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;

Line 1786: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;

1782: MSC_CL_COLLECTION.v_last_collection_id
1783: FROM MSC_APPS_INSTANCES
1784: WHERE INSTANCE_ID= pINSTANCE_ID;
1785:
1786: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;
1787: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;
1788: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;
1789:
1790: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;

Line 1787: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;

1783: FROM MSC_APPS_INSTANCES
1784: WHERE INSTANCE_ID= pINSTANCE_ID;
1785:
1786: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;
1787: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;
1788: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;
1789:
1790: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;
1791:

Line 1788: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;

1784: WHERE INSTANCE_ID= pINSTANCE_ID;
1785:
1786: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;
1787: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;
1788: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;
1789:
1790: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;
1791:
1792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Start date : '|| lv_start_date);

Line 1790: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;

1786: MSC_CL_COLLECTION.v_is_complete_refresh := TRUE;
1787: MSC_CL_COLLECTION.v_is_incremental_refresh := FALSE;
1788: MSC_CL_COLLECTION.v_is_partial_refresh := FALSE;
1789:
1790: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;
1791:
1792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Start date : '|| lv_start_date);
1793:
1794: lv_where_clause := ' AND ORGANIZATION_ID IN ( SELECT SR_TP_ID FROM MSC_TRADING_PARTNERS WHERE '||

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

1791:
1792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Start date : '|| lv_start_date);
1793:
1794: lv_where_clause := ' AND ORGANIZATION_ID IN ( SELECT SR_TP_ID FROM MSC_TRADING_PARTNERS WHERE '||
1795: ' SR_INSTANCE_ID = '||MSC_CL_COLLECTION.v_instance_id ||
1796: ' AND ORGANIZATION_TYPE =1 ) ';
1797:
1798: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL debug0 ');
1799: 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 1799: 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

1795: ' SR_INSTANCE_ID = '||MSC_CL_COLLECTION.v_instance_id ||
1796: ' AND ORGANIZATION_TYPE =1 ) ';
1797:
1798: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL debug0 ');
1799: 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
1800: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL ');
1801: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1802: COMMIT;
1803: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);

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

1797:
1798: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL debug0 ');
1799: 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
1800: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL ');
1801: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1802: COMMIT;
1803: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1804: COMMIT;
1805:

Line 1803: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);

1799: 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
1800: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL ');
1801: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1802: COMMIT;
1803: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1804: COMMIT;
1805:
1806: /* call the function to calc. resource avail */
1807: lv_ret_res_ava:=CALC_RESOURCE_AVAILABILITY(lv_start_date-1,MSC_UTIL.G_ALL_ORGANIZATIONS,TRUE);

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

1817: RETCODE:= MSC_UTIL.G_ERROR;
1818:
1819: END IF;
1820:
1821: ELSIF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_MIXED THEN
1822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-07');
1823: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1824: COMMIT;
1825: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);

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

1819: END IF;
1820:
1821: ELSIF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_MIXED THEN
1822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-07');
1823: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1824: COMMIT;
1825: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1826: COMMIT;
1827:

Line 1825: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);

1821: ELSIF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_MIXED THEN
1822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-07');
1823: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1824: COMMIT;
1825: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1826: COMMIT;
1827:
1828:
1829: lv_ret_res_ava:=CALC_RESOURCE_AVAILABILITY(lv_start_date-1,MSC_UTIL.G_ALL_ORGANIZATIONS,TRUE);

Line 1884: WHERE tp.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1880: SELECT tp.Organization_ID
1881: FROM MSC_PARAMETERS tp,
1882: MSC_INSTANCE_ORGS ins_org,
1883: MSC_TRADING_PARTNERS mtp
1884: WHERE tp.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1885: AND ins_org.SR_INSTANCE_ID=tp.SR_INSTANCE_ID
1886: AND ins_org.Organization_ID=tp.ORGANIZATION_ID
1887: AND ins_org.ENABLED_FLAG= MSC_UTIL.SYS_YES
1888: AND ((pORG_GROUP = MSC_UTIL.G_ALL_ORGANIZATIONS ) OR (ins_org.ORG_GROUP=pORG_GROUP))

Line 1889: AND mtp.sr_instance_id = MSC_CL_COLLECTION.v_instance_id

1885: AND ins_org.SR_INSTANCE_ID=tp.SR_INSTANCE_ID
1886: AND ins_org.Organization_ID=tp.ORGANIZATION_ID
1887: AND ins_org.ENABLED_FLAG= MSC_UTIL.SYS_YES
1888: AND ((pORG_GROUP = MSC_UTIL.G_ALL_ORGANIZATIONS ) OR (ins_org.ORG_GROUP=pORG_GROUP))
1889: AND mtp.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
1890: AND mtp.sr_tp_id = tp.organization_id
1891: AND mtp.partner_type = 3
1892: AND mtp.organization_type = 1; -- Discrete Mfg.
1893:

Line 1900: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

1896:
1897: CURSOR c2 IS
1898: SELECT 1
1899: FROM MSC_ST_RESOURCE_CHANGES
1900: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1901: AND process_flag = 5;
1902:
1903: lv_changes_exists NUMBER := 0;
1904: /*****************LEGACY_CHANGE_ENDS************************/

Line 1937: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN

1933: lv_refresh_flag:= 2;
1934: END IF;
1935: */
1936:
1937: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
1938: lv_refresh_flag := 1;
1939: ELSIF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1940: lv_refresh_flag := 2;
1941: ELSIF MSC_CL_COLLECTION.v_is_partial_refresh THEN

Line 1939: ELSIF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

1935: */
1936:
1937: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
1938: lv_refresh_flag := 1;
1939: ELSIF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1940: lv_refresh_flag := 2;
1941: ELSIF MSC_CL_COLLECTION.v_is_partial_refresh THEN
1942: lv_refresh_flag := 1; -- Functionality is same as complete_refresh
1943: END IF;

Line 1941: ELSIF MSC_CL_COLLECTION.v_is_partial_refresh THEN

1937: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
1938: lv_refresh_flag := 1;
1939: ELSIF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1940: lv_refresh_flag := 2;
1941: ELSIF MSC_CL_COLLECTION.v_is_partial_refresh THEN
1942: lv_refresh_flag := 1; -- Functionality is same as complete_refresh
1943: END IF;
1944:
1945: /************** LEGACY_CHANGE_START*************************/

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

1945: /************** LEGACY_CHANGE_START*************************/
1946: -- Calling the program as complete refresh for legacy so that new
1947: -- records coming in are considered
1948:
1949: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN
1950: lv_refresh_flag := 1;
1951: END IF;
1952: /*****************LEGACY_CHANGE_ENDS************************/
1953:

Line 1967: MSC_CL_COLLECTION.v_last_collection_id,

1963:
1964: POPULATE_ORG_RESOURCES
1965: ( lv_ret_code,
1966: lv_refresh_flag,
1967: MSC_CL_COLLECTION.v_last_collection_id,
1968: c_rec.organization_id,
1969: MSC_CL_COLLECTION.v_instance_id,
1970: lv_task_start_time,
1971: lv_task_end_time);

Line 1969: MSC_CL_COLLECTION.v_instance_id,

1965: ( lv_ret_code,
1966: lv_refresh_flag,
1967: MSC_CL_COLLECTION.v_last_collection_id,
1968: c_rec.organization_id,
1969: MSC_CL_COLLECTION.v_instance_id,
1970: lv_task_start_time,
1971: lv_task_end_time);
1972:
1973: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'RET_CODE: ' ||lv_ret_code);

Line 1993: MSC_CL_COLLECTION.v_last_collection_id,

1989:
1990: POPULATE_ALL_LINES
1991: ( lv_ret_code,
1992: lv_refresh_flag,
1993: MSC_CL_COLLECTION.v_last_collection_id,
1994: c_rec.organization_id,
1995: MSC_CL_COLLECTION.v_instance_id,
1996: lv_task_start_time,
1997: lv_task_end_time);

Line 1995: MSC_CL_COLLECTION.v_instance_id,

1991: ( lv_ret_code,
1992: lv_refresh_flag,
1993: MSC_CL_COLLECTION.v_last_collection_id,
1994: c_rec.organization_id,
1995: MSC_CL_COLLECTION.v_instance_id,
1996: lv_task_start_time,
1997: lv_task_end_time);
1998:
1999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'RET_CODE: ' ||lv_ret_code);

Line 2023: MSC_CL_COLLECTION.v_last_collection_id,

2019:
2020: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES
2021: ( lv_ret_code,
2022: lv_refresh_flag,
2023: MSC_CL_COLLECTION.v_last_collection_id,
2024: c_rec.organization_id,
2025: MSC_CL_COLLECTION.v_instance_id,
2026: lv_task_start_time,
2027: lv_task_end_time);

Line 2025: MSC_CL_COLLECTION.v_instance_id,

2021: ( lv_ret_code,
2022: lv_refresh_flag,
2023: MSC_CL_COLLECTION.v_last_collection_id,
2024: c_rec.organization_id,
2025: MSC_CL_COLLECTION.v_instance_id,
2026: lv_task_start_time,
2027: lv_task_end_time);
2028:
2029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'RET_CODE: ' ||lv_ret_code);

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

2049: -- This is to enable resource changes to be
2050: -- considered for legacy. Both, the resource information and
2051: -- resource changes may come in at the same time for legacy.
2052:
2053: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN
2054:
2055: OPEN C2;
2056: FETCH C2 INTO lv_changes_exists;
2057: CLOSE C2;

Line 2074: MSC_CL_COLLECTION.v_last_collection_id,

2070:
2071: POPULATE_ORG_RESOURCES
2072: ( lv_ret_code,
2073: lv_refresh_flag,
2074: MSC_CL_COLLECTION.v_last_collection_id,
2075: c_rec.organization_id,
2076: MSC_CL_COLLECTION.v_instance_id,
2077: lv_task_start_time,
2078: lv_task_end_time);

Line 2076: MSC_CL_COLLECTION.v_instance_id,

2072: ( lv_ret_code,
2073: lv_refresh_flag,
2074: MSC_CL_COLLECTION.v_last_collection_id,
2075: c_rec.organization_id,
2076: MSC_CL_COLLECTION.v_instance_id,
2077: lv_task_start_time,
2078: lv_task_end_time);
2079:
2080: IF lv_ret_code <> 0 THEN

Line 2098: MSC_CL_COLLECTION.v_last_collection_id,

2094:
2095: POPULATE_ALL_LINES
2096: ( lv_ret_code,
2097: lv_refresh_flag,
2098: MSC_CL_COLLECTION.v_last_collection_id,
2099: c_rec.organization_id,
2100: MSC_CL_COLLECTION.v_instance_id,
2101: lv_task_start_time,
2102: lv_task_end_time);

Line 2100: MSC_CL_COLLECTION.v_instance_id,

2096: ( lv_ret_code,
2097: lv_refresh_flag,
2098: MSC_CL_COLLECTION.v_last_collection_id,
2099: c_rec.organization_id,
2100: MSC_CL_COLLECTION.v_instance_id,
2101: lv_task_start_time,
2102: lv_task_end_time);
2103:
2104: IF lv_ret_code <> 0 THEN

Line 2126: MSC_CL_COLLECTION.v_last_collection_id,

2122:
2123: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES
2124: ( lv_ret_code,
2125: lv_refresh_flag,
2126: MSC_CL_COLLECTION.v_last_collection_id,
2127: c_rec.organization_id,
2128: MSC_CL_COLLECTION.v_instance_id,
2129: lv_task_start_time,
2130: lv_task_end_time);

Line 2128: MSC_CL_COLLECTION.v_instance_id,

2124: ( lv_ret_code,
2125: lv_refresh_flag,
2126: MSC_CL_COLLECTION.v_last_collection_id,
2127: c_rec.organization_id,
2128: MSC_CL_COLLECTION.v_instance_id,
2129: lv_task_start_time,
2130: lv_task_end_time);
2131:
2132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'RET_CODE: ' ||lv_ret_code);

Line 2161: AND sr_instance_id = MSC_CL_COLLECTION.v_instance_id

2157: update MSC_net_resource_avail
2158: set capacity_units = 0
2159: where capacity_units < 0
2160: and plan_id = -1
2161: AND sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2162: AND simulation_set is not null
2163: and shift_date between trunc(lv_task_start_time) and
2164: lv_task_end_time;
2165:

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

2218: msnra.from_time,
2219: msnra.to_time,
2220: msnra.capacity_units
2221: FROM msc_st_net_resource_avail msnra
2222: WHERE msnra.sr_instance_id = MSC_CL_COLLECTION.v_instance_id and
2223: msnra.organization_id=org_id;
2224:
2225:
2226: ---------------------------------------------------------------------

Line 2248: WHERE msnria.sr_instance_id = MSC_CL_COLLECTION.v_instance_id

2244: msnria.from_time,
2245: msnria.to_time
2246: FROM msc_st_net_res_inst_avail msnria,
2247: MSC_ITEM_ID_LID t1
2248: WHERE msnria.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2249: and t1.sr_instance_id (+) = msnria.sr_instance_id
2250: and t1.sr_inventory_item_id (+) = msnria.equipment_item_id
2251: and msnria.organization_id=org_id;
2252:

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

2253: CURSOR c_org_list IS
2254: select organization_id
2255: from msc_instance_orgs mio,
2256: msc_trading_partners mtp
2257: where mio.sr_instance_id= MSC_CL_COLLECTION.v_instance_id and
2258: mio.enabled_flag= 1 and
2259: ((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
2260: mio.sr_instance_id=mtp.sr_instance_id and
2261: mio.organization_id=mtp.sr_tp_id and

Line 2259: ((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

2255: from msc_instance_orgs mio,
2256: msc_trading_partners mtp
2257: where mio.sr_instance_id= MSC_CL_COLLECTION.v_instance_id and
2258: mio.enabled_flag= 1 and
2259: ((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
2260: mio.sr_instance_id=mtp.sr_instance_id and
2261: mio.organization_id=mtp.sr_tp_id and
2262: mtp.partner_type=3 and
2263: mtp.organization_type=2;

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

2268: lv_sql_stmt VARCHAR2(2048);
2269:
2270: BEGIN
2271:
2272: IF MSC_CL_COLLECTION.v_recalc_nra= MSC_UTIL.SYS_YES THEN
2273:
2274: /*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
2275: -- We want to delete all NRA related data and get new stuff.
2276:

Line 2274: /*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

2270: BEGIN
2271:
2272: IF MSC_CL_COLLECTION.v_recalc_nra= MSC_UTIL.SYS_YES THEN
2273:
2274: /*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
2275: -- We want to delete all NRA related data and get new stuff.
2276:
2277: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2278: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);

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

2273:
2274: /*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
2275: -- We want to delete all NRA related data and get new stuff.
2276:
2277: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2278: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2279:
2280: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');

Line 2278: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);

2274: /*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
2275: -- We want to delete all NRA related data and get new stuff.
2276:
2277: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2278: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2279:
2280: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');
2282: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);

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

2276:
2277: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2278: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2279:
2280: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');
2282: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2283: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2284: ELSE

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

2278: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2279:
2280: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');
2282: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2283: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2284: ELSE
2285: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');

Line 2283: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);

2279:
2280: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');
2282: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2283: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2284: ELSE
2285: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');
2287: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);

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

2283: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2284: ELSE
2285: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');
2287: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);
2288: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1,v_sub_str);
2289: END IF;
2290:
2291: END IF;*/

Line 2288: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1,v_sub_str);

2284: ELSE
2285: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');
2287: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);
2288: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1,v_sub_str);
2289: END IF;
2290:
2291: END IF;*/
2292:

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

2291: END IF;*/
2292:
2293: -- process mfg only. move the rows for the st table to the msc table
2294: -- for net resource avail
2295: IF MSC_CL_COLLECTION.v_process_flag = MSC_UTIL.SYS_YES THEN
2296:
2297: /*
2298: We will do a bulk insert of res avail for OPM orgs. If this fails,
2299: then we will switch to old, row by row processing.

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

2351: ||' :v_current_date,'
2352: ||' :v_current_user,'
2353: ||' :v_last_collection_id'
2354: ||' FROM msc_st_net_resource_avail msnra'
2355: ||' WHERE msnra.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2356: ||' AND msnra.organization_id = ' ||c_rec1.organization_id;
2357:
2358: EXECUTE IMMEDIATE lv_sql_stmt
2359: USING

Line 2360: MSC_CL_COLLECTION.v_current_date,

2356: ||' AND msnra.organization_id = ' ||c_rec1.organization_id;
2357:
2358: EXECUTE IMMEDIATE lv_sql_stmt
2359: USING
2360: MSC_CL_COLLECTION.v_current_date,
2361: MSC_CL_COLLECTION.v_current_user,
2362: MSC_CL_COLLECTION.v_current_date,
2363: MSC_CL_COLLECTION.v_current_user,
2364: MSC_CL_COLLECTION.v_last_collection_id;

Line 2361: MSC_CL_COLLECTION.v_current_user,

2357:
2358: EXECUTE IMMEDIATE lv_sql_stmt
2359: USING
2360: MSC_CL_COLLECTION.v_current_date,
2361: MSC_CL_COLLECTION.v_current_user,
2362: MSC_CL_COLLECTION.v_current_date,
2363: MSC_CL_COLLECTION.v_current_user,
2364: MSC_CL_COLLECTION.v_last_collection_id;
2365:

Line 2362: MSC_CL_COLLECTION.v_current_date,

2358: EXECUTE IMMEDIATE lv_sql_stmt
2359: USING
2360: MSC_CL_COLLECTION.v_current_date,
2361: MSC_CL_COLLECTION.v_current_user,
2362: MSC_CL_COLLECTION.v_current_date,
2363: MSC_CL_COLLECTION.v_current_user,
2364: MSC_CL_COLLECTION.v_last_collection_id;
2365:
2366: COMMIT;

Line 2363: MSC_CL_COLLECTION.v_current_user,

2359: USING
2360: MSC_CL_COLLECTION.v_current_date,
2361: MSC_CL_COLLECTION.v_current_user,
2362: MSC_CL_COLLECTION.v_current_date,
2363: MSC_CL_COLLECTION.v_current_user,
2364: MSC_CL_COLLECTION.v_last_collection_id;
2365:
2366: COMMIT;
2367:

Line 2364: MSC_CL_COLLECTION.v_last_collection_id;

2360: MSC_CL_COLLECTION.v_current_date,
2361: MSC_CL_COLLECTION.v_current_user,
2362: MSC_CL_COLLECTION.v_current_date,
2363: MSC_CL_COLLECTION.v_current_user,
2364: MSC_CL_COLLECTION.v_last_collection_id;
2365:
2366: COMMIT;
2367:
2368: lv_res_avail:=MSC_UTIL.SYS_YES;

Line 2424: MSC_CL_COLLECTION.v_current_date,

2420: c_rec.simulation_set,
2421: NULL, /* STATUS */
2422: NULL, /* APPLIED */
2423: 2, /* UPDATED */
2424: MSC_CL_COLLECTION.v_current_date,
2425: MSC_CL_COLLECTION.v_current_user,
2426: MSC_CL_COLLECTION.v_current_date,
2427: MSC_CL_COLLECTION.v_current_user,
2428: MSC_CL_COLLECTION.v_last_collection_id);

Line 2425: MSC_CL_COLLECTION.v_current_user,

2421: NULL, /* STATUS */
2422: NULL, /* APPLIED */
2423: 2, /* UPDATED */
2424: MSC_CL_COLLECTION.v_current_date,
2425: MSC_CL_COLLECTION.v_current_user,
2426: MSC_CL_COLLECTION.v_current_date,
2427: MSC_CL_COLLECTION.v_current_user,
2428: MSC_CL_COLLECTION.v_last_collection_id);
2429:

Line 2426: MSC_CL_COLLECTION.v_current_date,

2422: NULL, /* APPLIED */
2423: 2, /* UPDATED */
2424: MSC_CL_COLLECTION.v_current_date,
2425: MSC_CL_COLLECTION.v_current_user,
2426: MSC_CL_COLLECTION.v_current_date,
2427: MSC_CL_COLLECTION.v_current_user,
2428: MSC_CL_COLLECTION.v_last_collection_id);
2429:
2430: c_count:= c_count+1;

Line 2427: MSC_CL_COLLECTION.v_current_user,

2423: 2, /* UPDATED */
2424: MSC_CL_COLLECTION.v_current_date,
2425: MSC_CL_COLLECTION.v_current_user,
2426: MSC_CL_COLLECTION.v_current_date,
2427: MSC_CL_COLLECTION.v_current_user,
2428: MSC_CL_COLLECTION.v_last_collection_id);
2429:
2430: c_count:= c_count+1;
2431:

Line 2428: MSC_CL_COLLECTION.v_last_collection_id);

2424: MSC_CL_COLLECTION.v_current_date,
2425: MSC_CL_COLLECTION.v_current_user,
2426: MSC_CL_COLLECTION.v_current_date,
2427: MSC_CL_COLLECTION.v_current_user,
2428: MSC_CL_COLLECTION.v_last_collection_id);
2429:
2430: c_count:= c_count+1;
2431:
2432: IF c_count> MSC_CL_COLLECTION.PBS THEN

Line 2432: IF c_count> MSC_CL_COLLECTION.PBS THEN

2428: MSC_CL_COLLECTION.v_last_collection_id);
2429:
2430: c_count:= c_count+1;
2431:
2432: IF c_count> MSC_CL_COLLECTION.PBS THEN
2433: COMMIT;
2434: c_count:= 0;
2435: END IF;
2436:

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

2449: RAISE;
2450:
2451: ELSE
2452:
2453: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2454:
2455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2456: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2457: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');

Line 2470: MSC_CL_COLLECTION.v_instance_id));

2466: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2467: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2468: FND_MESSAGE.SET_TOKEN('VALUE',
2469: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2470: MSC_CL_COLLECTION.v_instance_id));
2471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2472:
2473: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2474: END IF;

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

2476: END;
2477:
2478: END LOOP;
2479:
2480: END IF; /* If lv_res_avail:=MSC_CL_COLLECTION.SYS_NO */
2481: END LOOP;
2482:
2483: ------------------------------------------------------------------------
2484: -- here is the change for msc_net_res_inst_avail (DS change)

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

2540: ||' :v_current_user,'
2541: ||' :v_last_collection_id'
2542: ||' FROM msc_st_net_res_inst_avail msnria,'
2543: ||' MSC_ITEM_ID_LID t1'
2544: ||' WHERE msnria.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2545: ||' and t1.sr_instance_id (+) = msnria.sr_instance_id'
2546: ||' and t1.sr_inventory_item_id (+) = msnria.equipment_item_id'
2547: ||' and msnria.organization_id = ' ||c_rec1.organization_id;
2548:

Line 2551: MSC_CL_COLLECTION.v_current_date,

2547: ||' and msnria.organization_id = ' ||c_rec1.organization_id;
2548:
2549: EXECUTE IMMEDIATE lv_sql_stmt
2550: USING
2551: MSC_CL_COLLECTION.v_current_date,
2552: MSC_CL_COLLECTION.v_current_user,
2553: MSC_CL_COLLECTION.v_current_date,
2554: MSC_CL_COLLECTION.v_current_user,
2555: MSC_CL_COLLECTION.v_last_collection_id;

Line 2552: MSC_CL_COLLECTION.v_current_user,

2548:
2549: EXECUTE IMMEDIATE lv_sql_stmt
2550: USING
2551: MSC_CL_COLLECTION.v_current_date,
2552: MSC_CL_COLLECTION.v_current_user,
2553: MSC_CL_COLLECTION.v_current_date,
2554: MSC_CL_COLLECTION.v_current_user,
2555: MSC_CL_COLLECTION.v_last_collection_id;
2556:

Line 2553: MSC_CL_COLLECTION.v_current_date,

2549: EXECUTE IMMEDIATE lv_sql_stmt
2550: USING
2551: MSC_CL_COLLECTION.v_current_date,
2552: MSC_CL_COLLECTION.v_current_user,
2553: MSC_CL_COLLECTION.v_current_date,
2554: MSC_CL_COLLECTION.v_current_user,
2555: MSC_CL_COLLECTION.v_last_collection_id;
2556:
2557: COMMIT;

Line 2554: MSC_CL_COLLECTION.v_current_user,

2550: USING
2551: MSC_CL_COLLECTION.v_current_date,
2552: MSC_CL_COLLECTION.v_current_user,
2553: MSC_CL_COLLECTION.v_current_date,
2554: MSC_CL_COLLECTION.v_current_user,
2555: MSC_CL_COLLECTION.v_last_collection_id;
2556:
2557: COMMIT;
2558:

Line 2555: MSC_CL_COLLECTION.v_last_collection_id;

2551: MSC_CL_COLLECTION.v_current_date,
2552: MSC_CL_COLLECTION.v_current_user,
2553: MSC_CL_COLLECTION.v_current_date,
2554: MSC_CL_COLLECTION.v_current_user,
2555: MSC_CL_COLLECTION.v_last_collection_id;
2556:
2557: COMMIT;
2558:
2559: lv_res_inst_avail:=MSC_UTIL.SYS_YES;

Line 2623: MSC_CL_COLLECTION.v_current_date,

2619: c_rec_resinst.to_time,
2620: NULL, /* STATUS */
2621: NULL, /* APPLIED */
2622: 2, /* UPDATED */
2623: MSC_CL_COLLECTION.v_current_date,
2624: MSC_CL_COLLECTION.v_current_user,
2625: MSC_CL_COLLECTION.v_current_date,
2626: MSC_CL_COLLECTION.v_current_user,
2627: MSC_CL_COLLECTION.v_last_collection_id);

Line 2624: MSC_CL_COLLECTION.v_current_user,

2620: NULL, /* STATUS */
2621: NULL, /* APPLIED */
2622: 2, /* UPDATED */
2623: MSC_CL_COLLECTION.v_current_date,
2624: MSC_CL_COLLECTION.v_current_user,
2625: MSC_CL_COLLECTION.v_current_date,
2626: MSC_CL_COLLECTION.v_current_user,
2627: MSC_CL_COLLECTION.v_last_collection_id);
2628:

Line 2625: MSC_CL_COLLECTION.v_current_date,

2621: NULL, /* APPLIED */
2622: 2, /* UPDATED */
2623: MSC_CL_COLLECTION.v_current_date,
2624: MSC_CL_COLLECTION.v_current_user,
2625: MSC_CL_COLLECTION.v_current_date,
2626: MSC_CL_COLLECTION.v_current_user,
2627: MSC_CL_COLLECTION.v_last_collection_id);
2628:
2629: c_count:= c_count+1;

Line 2626: MSC_CL_COLLECTION.v_current_user,

2622: 2, /* UPDATED */
2623: MSC_CL_COLLECTION.v_current_date,
2624: MSC_CL_COLLECTION.v_current_user,
2625: MSC_CL_COLLECTION.v_current_date,
2626: MSC_CL_COLLECTION.v_current_user,
2627: MSC_CL_COLLECTION.v_last_collection_id);
2628:
2629: c_count:= c_count+1;
2630:

Line 2627: MSC_CL_COLLECTION.v_last_collection_id);

2623: MSC_CL_COLLECTION.v_current_date,
2624: MSC_CL_COLLECTION.v_current_user,
2625: MSC_CL_COLLECTION.v_current_date,
2626: MSC_CL_COLLECTION.v_current_user,
2627: MSC_CL_COLLECTION.v_last_collection_id);
2628:
2629: c_count:= c_count+1;
2630:
2631: IF c_count> MSC_CL_COLLECTION.PBS THEN

Line 2631: IF c_count> MSC_CL_COLLECTION.PBS THEN

2627: MSC_CL_COLLECTION.v_last_collection_id);
2628:
2629: c_count:= c_count+1;
2630:
2631: IF c_count> MSC_CL_COLLECTION.PBS THEN
2632: COMMIT;
2633: c_count:= 0;
2634: END IF;
2635:

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

2648: RAISE;
2649:
2650: ELSE
2651:
2652: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2653:
2654: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2655: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2656: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');

Line 2669: MSC_CL_COLLECTION.v_instance_id));

2665: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2666: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2667: FND_MESSAGE.SET_TOKEN('VALUE',
2668: MSC_GET_NAME.ORG_CODE( c_rec_resinst.ORGANIZATION_ID,
2669: MSC_CL_COLLECTION.v_instance_id));
2670: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2671:
2672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2673: END IF;

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

2674:
2675: END;
2676:
2677: END LOOP;
2678: END IF; /* IF lv_res_inst_avail = MSC_CL_COLLECTION.SYS_NO THEN */
2679: END LOOP;
2680:
2681: COMMIT;
2682: