eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_ITEM_PULL dependencies on MSC_UTIL

Line 16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;

12: v_temp_sql3 VARCHAR2(1000);
13: v_temp_sql4 VARCHAR2(1000);
14:
15: -- NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
17:
18: v_gmp_routine_name VARCHAR2(50);
19: GMP_ERROR EXCEPTION;
20:

Line 27: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN

23:
24: PROCEDURE LOAD_CATEGORY IS
25: BEGIN
26:
27: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN
28:
29: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
30: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_CATEGORIES';
31: MSC_CL_PULL.v_view_name := 'MRP_AD_ITEM_CATEGORIES_V';

Line 86: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

82: ||' 2,'
83: ||' :v_refresh_id,'
84: ||' :v_instance_id'
85: ||' from MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink||' x'
86: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
87: --||' AND NVL(x.LANGUAGE, :v_lang)= :v_lang'
88: ||' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')';
89:
90: /*

Line 108: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

104: ||' 2,'
105: ||' :v_refresh_id,'
106: ||' :v_instance_id'
107: ||' from MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink||' x'
108: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
109: ||' AND NVL(x.LANGUAGE, :v_lang)= :v_lang'
110: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'
111: ||' UNION '
112: ||' select'

Line 128: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

124: ||' 2,'
125: ||' :v_refresh_id,'
126: ||' :v_instance_id'
127: ||' from MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink||' x'
128: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
129: ||' AND NVL(x.LANGUAGE, :v_lang)= :v_lang'
130: ||' AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')' ;
131: */
132: ELSE

Line 176: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

172: ||' 2,'
173: ||' :v_refresh_id,'
174: ||' :v_instance_id'
175: ||' from MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink||' x'
176: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
177: -- bug 4365337 remove lang cond ||' AND NVL(x.LANGUAGE, :v_lang)= :v_lang'
178: --bug 4365337 remove v_union_sql and instead add cond. on RN2
179: || v_union_sql ;
180: --||' AND x.RN2 >'||MSC_CL_PULL.v_lrn;

Line 263: p_worker_num, MSC_UTIL.SYS_YES,

259:
260: cursor org IS
261: select /*+ INDEX(MSC_INSTANCE_ORGS MSC_INSTANCE_ORGS_U1) */ organization_id org_id,
262: DECODE( MOD(rownum,MSC_CL_PULL.TOTAL_IWN),
263: p_worker_num, MSC_UTIL.SYS_YES,
264: MSC_UTIL.SYS_NO) yes_flag
265: from msc_instance_orgs
266: where sr_instance_id= MSC_CL_PULL.v_instance_id
267: and enabled_flag= 1

Line 264: MSC_UTIL.SYS_NO) yes_flag

260: cursor org IS
261: select /*+ INDEX(MSC_INSTANCE_ORGS MSC_INSTANCE_ORGS_U1) */ organization_id org_id,
262: DECODE( MOD(rownum,MSC_CL_PULL.TOTAL_IWN),
263: p_worker_num, MSC_UTIL.SYS_YES,
264: MSC_UTIL.SYS_NO) yes_flag
265: from msc_instance_orgs
266: where sr_instance_id= MSC_CL_PULL.v_instance_id
267: and enabled_flag= 1
268: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group))

Line 268: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group))

264: MSC_UTIL.SYS_NO) yes_flag
265: from msc_instance_orgs
266: where sr_instance_id= MSC_CL_PULL.v_instance_id
267: and enabled_flag= 1
268: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group))
269: order by
270: organization_id;
271:
272: lv_org_count NUMBER:=0;

Line 276: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN

272: lv_org_count NUMBER:=0;
273:
274: BEGIN
275:
276: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN
277:
278: FOR lc_ins_org IN org LOOP
279:
280: IF lc_ins_org.yes_flag = MSC_UTIL.SYS_YES THEN

Line 280: IF lc_ins_org.yes_flag = MSC_UTIL.SYS_YES THEN

276: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN
277:
278: FOR lc_ins_org IN org LOOP
279:
280: IF lc_ins_org.yes_flag = MSC_UTIL.SYS_YES THEN
281: lv_org_count := lv_org_count + 1;
282:
283: IF lv_org_count = 1 THEN
284: lv_in_org_str:=' IN ('|| lc_ins_org.org_id;

Line 301: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then

297:
298:
299: MSC_CL_PULL.v_table_name:= 'MSC_ST_SYSTEM_ITEMS';
300:
301: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then
302: MSC_CL_PULL.v_view_name := 'MRP_AP_NOCOST_SYSTEM_ITEMS_V';
303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
304: else
305: MSC_CL_PULL.v_view_name := 'MRP_AP_SYSTEM_ITEMS_V';

Line 303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);

299: MSC_CL_PULL.v_table_name:= 'MSC_ST_SYSTEM_ITEMS';
300:
301: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then
302: MSC_CL_PULL.v_view_name := 'MRP_AP_NOCOST_SYSTEM_ITEMS_V';
303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
304: else
305: MSC_CL_PULL.v_view_name := 'MRP_AP_SYSTEM_ITEMS_V';
306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
307: end if;

Line 306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);

302: MSC_CL_PULL.v_view_name := 'MRP_AP_NOCOST_SYSTEM_ITEMS_V';
303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
304: else
305: MSC_CL_PULL.v_view_name := 'MRP_AP_SYSTEM_ITEMS_V';
306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
307: end if;
308:
309: BEGIN
310:

Line 311: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN

307: end if;
308:
309: BEGIN
310:
311: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN
312:
313: v_temp_sql := 'NULL, NULL, NULL, NULL, NULL, x.DESCRIPTION, x.LIST_PRICE ,x.ITEM_NAME, '
314: ||'NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,'
315: ||' NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,NULL,NULL,NULL, NULL,NULL,'; /* ds change added null*/

Line 317: ELSIF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110 THEN

313: v_temp_sql := 'NULL, NULL, NULL, NULL, NULL, x.DESCRIPTION, x.LIST_PRICE ,x.ITEM_NAME, '
314: ||'NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,'
315: ||' NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,NULL,NULL,NULL, NULL,NULL,'; /* ds change added null*/
316:
317: ELSIF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110 THEN
318:
319: v_temp_sql := 'x.REPLENISH_TO_ORDER_FLAG,x.PICK_COMPONENTS_FLAG ,NULL, NULL,NULL, '
320: ||' x.DESCRIPTION, x.LIST_PRICE , x.ITEM_NAME, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, '
321: ||' NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,NULL,NULL, NULL, NULL,NULL,'; /* ds change added null for eam_item_type*/

Line 323: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN

319: v_temp_sql := 'x.REPLENISH_TO_ORDER_FLAG,x.PICK_COMPONENTS_FLAG ,NULL, NULL,NULL, '
320: ||' x.DESCRIPTION, x.LIST_PRICE , x.ITEM_NAME, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, '
321: ||' NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,NULL,NULL, NULL, NULL,NULL,'; /* ds change added null for eam_item_type*/
322:
323: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
324:
325: v_temp_sql := ' x.REPLENISH_TO_ORDER_FLAG, x.PICK_COMPONENTS_FLAG ,';
326:
327: BEGIN

Line 342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);

338: WHEN OTHERS THEN
339: lv_uom_code := NULL;
340: v_temp_sql := v_temp_sql || ' -99999, ';
341: END ;
342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);
343:
344:
345: v_temp_sql := v_temp_sql || ' x.CREATE_SUPPLY_FLAG,x.SUBSTITUTION_WINDOW, ';
346:

Line 360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');

356:
357: EXCEPTION
358: WHEN NO_DATA_FOUND THEN
359: -- This means that the base installed lang is different than the userenv(LANG)
360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');
361: lv_base_lang_diff := 2;
362: WHEN OTHERS THEN
363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');
364: lv_base_lang_diff := 1;

Line 363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');

359: -- This means that the base installed lang is different than the userenv(LANG)
360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');
361: lv_base_lang_diff := 2;
362: WHEN OTHERS THEN
363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');
364: lv_base_lang_diff := 1;
365: END ;
366:
367: IF (lv_base_lang_diff = 1) THEN

Line 385: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)

381: BEGIN
382: -- check if the base language is different than the installed lang in source instance
383: -- If the base installed_flag is same as userenv lang- then dont go to TL table
384:
385: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)
386: into lv_icode, v_dblink_a2m
387: from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;
388:
389: v_sql_stmt := ' select item_name_from_kfv '

Line 393: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';

389: v_sql_stmt := ' select item_name_from_kfv '
390: ||' from MRP_AP_APPS_INSTANCES_ALL'||MSC_CL_PULL.v_dblink
391: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id
392: ||' AND INSTANCE_CODE= '''||lv_icode||''''
393: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';
394:
395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);
396:
397: execute immediate v_sql_stmt into lv_item_name;

Line 395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);

391: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id
392: ||' AND INSTANCE_CODE= '''||lv_icode||''''
393: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';
394:
395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);
396:
397: execute immediate v_sql_stmt into lv_item_name;
398:
399: EXCEPTION

Line 401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);

397: execute immediate v_sql_stmt into lv_item_name;
398:
399: EXCEPTION
400: WHEN OTHERS THEN
401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);
402: lv_item_name := 'x.SEGMENT1';
403: END ;
404:
405: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);

Line 405: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);

401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);
402: lv_item_name := 'x.SEGMENT1';
403: END ;
404:
405: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);
406: v_temp_sql := v_temp_sql ||' '|| lv_item_name ||', ';
407:
408: -- for Bugfix 3057925
409: v_temp_sql := v_temp_sql ||' x.REDUCE_MPS,x.CRITICAL_COMPONENT_FLAG,x.VMI_MINIMUM_UNITS,x.VMI_MINIMUM_DAYS,x.VMI_MAXIMUM_UNITS, '

Line 419: ELSIF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN --# For Bug 5606037 SRP Changes

415:
416:
417: /* # For Bug 5606037 SRP Changes NULL Colums to collect Item Attribute Data */
418:
419: ELSIF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN --# For Bug 5606037 SRP Changes
420:
421: v_temp_sql := ' x.REPLENISH_TO_ORDER_FLAG, x.PICK_COMPONENTS_FLAG ,';
422:
423: BEGIN

Line 438: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);

434: WHEN OTHERS THEN
435: lv_uom_code := NULL;
436: v_temp_sql := v_temp_sql || ' -99999, ';
437: END ;
438: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);
439: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt of MSC_UTIL.G_APPS120 - ' || v_sql_stmt);
440:
441: v_temp_sql := v_temp_sql || ' x.CREATE_SUPPLY_FLAG,x.SUBSTITUTION_WINDOW, ';
442:

Line 439: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt of MSC_UTIL.G_APPS120 - ' || v_sql_stmt);

435: lv_uom_code := NULL;
436: v_temp_sql := v_temp_sql || ' -99999, ';
437: END ;
438: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);
439: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt of MSC_UTIL.G_APPS120 - ' || v_sql_stmt);
440:
441: v_temp_sql := v_temp_sql || ' x.CREATE_SUPPLY_FLAG,x.SUBSTITUTION_WINDOW, ';
442:
443: BEGIN

Line 456: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');

452:
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: -- This means that the base installed lang is different than the userenv(LANG)
456: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');
457: lv_base_lang_diff := 2;
458: WHEN OTHERS THEN
459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');
460: lv_base_lang_diff := 1;

Line 459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');

455: -- This means that the base installed lang is different than the userenv(LANG)
456: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');
457: lv_base_lang_diff := 2;
458: WHEN OTHERS THEN
459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');
460: lv_base_lang_diff := 1;
461: END ;
462:
463: IF (lv_base_lang_diff = 1) THEN

Line 481: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)

477: BEGIN
478: -- check if the base language is different than the installed lang in source instance
479: -- If the base installed_flag is same as userenv lang- then dont go to TL table
480:
481: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)
482: into lv_icode, v_dblink_a2m
483: from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;
484:
485: v_sql_stmt := ' select item_name_from_kfv '

Line 489: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';

485: v_sql_stmt := ' select item_name_from_kfv '
486: ||' from MRP_AP_APPS_INSTANCES_ALL'||MSC_CL_PULL.v_dblink
487: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id
488: ||' AND INSTANCE_CODE= '''||lv_icode||''''
489: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';
490:
491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);
492:
493: execute immediate v_sql_stmt into lv_item_name;

Line 491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);

487: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id
488: ||' AND INSTANCE_CODE= '''||lv_icode||''''
489: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';
490:
491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);
492:
493: execute immediate v_sql_stmt into lv_item_name;
494:
495: EXCEPTION

Line 497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);

493: execute immediate v_sql_stmt into lv_item_name;
494:
495: EXCEPTION
496: WHEN OTHERS THEN
497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);
498: lv_item_name := 'x.SEGMENT1';
499: END ;
500:
501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);

Line 501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);

497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);
498: lv_item_name := 'x.SEGMENT1';
499: END ;
500:
501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);
502: v_temp_sql := v_temp_sql ||' '|| lv_item_name ||', ';
503:
504: -- for Bugfix 3057925
505: v_temp_sql := v_temp_sql ||' x.REDUCE_MPS,x.CRITICAL_COMPONENT_FLAG,x.VMI_MINIMUM_UNITS,x.VMI_MINIMUM_DAYS,x.VMI_MAXIMUM_UNITS, '

Line 512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: v_temp_sql String: '|| v_temp_sql);

508: ||' x.DAYS_MAX_INV_SUPPLY,x.DAYS_MAX_INV_WINDOW,x.DRP_PLANNED_FLAG,x.CONTINOUS_TRANSFER,x.CONVERGENCE,x.DIVERGENCE,'
509: ||' x.EAM_ITEM_TYPE, x.MSIB_CREATION_DATE, x.SHORTAGE_TYPE , x.EXCESS_TYPE ,x.PLANNING_TIME_FENCE_CODE,x.REPAIR_LEADTIME,x.preposition_point,x.REPAIR_YIELD,x.repair_program,'; /* ds change eam_item_type added */
510: --# For Bug 5606037 SRP Changes
511:
512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: v_temp_sql String: '|| v_temp_sql);
513: END IF; --# For Bug 5606037 SRP Changes
514:
515: End;
516:

Line 518: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then

514:
515: End;
516:
517:
518: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then
519: lv_view_name_stmt := ' from MRP_AP_NOCOST_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
521: else
522: lv_view_name_stmt := ' from MRP_AP_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';

Line 520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);

516:
517:
518: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then
519: lv_view_name_stmt := ' from MRP_AP_NOCOST_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
521: else
522: lv_view_name_stmt := ' from MRP_AP_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
523: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
524: end if;

Line 523: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);

519: lv_view_name_stmt := ' from MRP_AP_NOCOST_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
521: else
522: lv_view_name_stmt := ' from MRP_AP_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
523: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
524: end if;
525:
526:
527:

Line 777: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug : view sql stmt = ' || v_sql_stmt);

773:
774:
775: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
776:
777: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug : view sql stmt = ' || v_sql_stmt);
778: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'debug: v_temp_sql ='||v_temp_sql);
779: EXECUTE IMMEDIATE v_sql_stmt
780: USING MSC_CL_PULL.V_ICODE,
781: MSC_CL_PULL.v_mso_item_dmd_penalty,

Line 778: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'debug: v_temp_sql ='||v_temp_sql);

774:
775: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
776:
777: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug : view sql stmt = ' || v_sql_stmt);
778: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'debug: v_temp_sql ='||v_temp_sql);
779: EXECUTE IMMEDIATE v_sql_stmt
780: USING MSC_CL_PULL.V_ICODE,
781: MSC_CL_PULL.v_mso_item_dmd_penalty,
782: MSC_CL_PULL.v_mso_item_cap_penalty,

Line 816: IF MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED=MSC_UTIL.ASL_YES_RETAIN_CP THEN

812: lv_last_asl_collection_date DATE ;
813: BEGIN
814:
815:
816: IF MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED=MSC_UTIL.ASL_YES_RETAIN_CP THEN
817:
818: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_SUPPLIERS';
819:
820: /*ASL */

Line 823: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental

819:
820: /*ASL */
821: IF MSC_CL_PULL.v_lrnn = -1 THEN
822: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SUPPLIERS_V';
823: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental
824: MSC_CL_PULL.v_view_name := 'MRP_AN_PO_SUPPLIERS_V';
825: v_sql_stmt := 'Select min (nvl(LAST_SUCC_ASL_REF_TIME,SYSDATE-365000))'
826: ||' From msc_instance_orgs '
827: ||' Where sr_instance_id = ' || MSC_CL_PULL.v_instance_id

Line 828: ||' And organization_id '|| MSC_UTIL.v_in_org_str;

824: MSC_CL_PULL.v_view_name := 'MRP_AN_PO_SUPPLIERS_V';
825: v_sql_stmt := 'Select min (nvl(LAST_SUCC_ASL_REF_TIME,SYSDATE-365000))'
826: ||' From msc_instance_orgs '
827: ||' Where sr_instance_id = ' || MSC_CL_PULL.v_instance_id
828: ||' And organization_id '|| MSC_UTIL.v_in_org_str;
829:
830: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
831:
832: EXECUTE IMMEDIATE v_sql_stmt into lv_last_asl_collection_date;

Line 830: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

826: ||' From msc_instance_orgs '
827: ||' Where sr_instance_id = ' || MSC_CL_PULL.v_instance_id
828: ||' And organization_id '|| MSC_UTIL.v_in_org_str;
829:
830: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
831:
832: EXECUTE IMMEDIATE v_sql_stmt into lv_last_asl_collection_date;
833:
834: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

Line 834: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

830: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
831:
832: EXECUTE IMMEDIATE v_sql_stmt into lv_last_asl_collection_date;
833:
834: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
835: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);
836: END IF ;
837: /*ASL*/
838:

Line 835: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);

831:
832: EXECUTE IMMEDIATE v_sql_stmt into lv_last_asl_collection_date;
833:
834: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
835: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);
836: END IF ;
837: /*ASL*/
838:
839: /* Added this to collect Item Price information for a supplier

Line 842: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS107,' NULL,', ' x.ITEM_PRICE,')

838:
839: /* Added this to collect Item Price information for a supplier
840: from 11i/110 source */
841: Begin
842: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS107,' NULL,', ' x.ITEM_PRICE,')
843: into v_temp_sql
844: from dual;
845: End;
846:

Line 848: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

844: from dual;
845: End;
846:
847: /* Added this code for VMI changes */
848: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
849: v_temp_sql1 := ' x.ENABLE_VMI_FLAG, x.VMI_MIN_QTY, x.VMI_MAX_QTY, x.ENABLE_VMI_AUTO_REPLENISH_FLAG, x.VMI_REPLENISHMENT_APPROVAL,'
850: || ' x.REPLENISHMENT_METHOD,x.MIN_MINMAX_DAYS,x.MAX_MINMAX_DAYS,x.FORECAST_HORIZON,x.FIXED_ORDER_QUANTITY, ';
851:
852: ELSE

Line 932: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

928: ||' x.PRIMARY_VENDOR_ITEM,'
929: /* SCE Change end */
930: ||' :v_instance_id'
931: ||' from MRP_AP_PO_SUPPLIERS_V'||MSC_CL_PULL.v_dblink||' x'
932: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
933:
934: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
935: MSC_CL_PULL.v_mso_sup_cap_penalty,
936: MSC_CL_PULL.v_instance_id,

Line 940: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental (ASL net change )

936: MSC_CL_PULL.v_instance_id,
937: MSC_CL_PULL.v_refresh_id,
938: MSC_CL_PULL.v_instance_id;
939:
940: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental (ASL net change )
941:
942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL net change ');
943: v_sql_stmt:=
944: ' insert into MSC_ST_ITEM_SUPPLIERS'

Line 942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL net change ');

938: MSC_CL_PULL.v_instance_id;
939:
940: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental (ASL net change )
941:
942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL net change ');
943: v_sql_stmt:=
944: ' insert into MSC_ST_ITEM_SUPPLIERS'
945: ||' ( INVENTORY_ITEM_ID,'
946: ||' USING_ORGANIZATION_ID,'

Line 1016: ||' WHERE (x.USING_ORGANIZATION_ID = -1 or x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str ||')'

1012: ||' x.PRIMARY_VENDOR_ITEM,'
1013: /* SCE Change end */
1014: ||' :v_instance_id'
1015: ||' from MRP_AN_PO_GLOBAL_ASL_V '||MSC_CL_PULL.v_dblink||' x'
1016: ||' WHERE (x.USING_ORGANIZATION_ID = -1 or x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str ||')'
1017: ||' AND (x.DATE1 > :lv_last_asl_collection_date or x.DATE2 > :lv_last_asl_collection_date )';
1018:
1019: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
1020:

Line 1019: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

1015: ||' from MRP_AN_PO_GLOBAL_ASL_V '||MSC_CL_PULL.v_dblink||' x'
1016: ||' WHERE (x.USING_ORGANIZATION_ID = -1 or x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str ||')'
1017: ||' AND (x.DATE1 > :lv_last_asl_collection_date or x.DATE2 > :lv_last_asl_collection_date )';
1018:
1019: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
1020:
1021:
1022: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1023: MSC_CL_PULL.v_mso_sup_cap_penalty,

Line 1030: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL ROW COUNT IS ' || SQL%ROWCOUNT);

1026: MSC_CL_PULL.v_instance_id,
1027: lv_last_asl_collection_date,
1028: lv_last_asl_collection_date;
1029:
1030: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL ROW COUNT IS ' || SQL%ROWCOUNT);
1031:
1032:
1033: END IF ; --end global ASL
1034:

Line 1043: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN

1039: only global ASLs are in this view and the local ASLs are in
1040: MRP_AP_PO_LOCAL_ASL_V. Hence adding another insert stmt. to insert local ASLs.
1041: */
1042:
1043: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN
1044:
1045: IF MSC_CL_PULL.v_lrnn =-1 THEN -- COMPLETE REFRESH
1046: v_sql_stmt:=
1047: ' insert into MSC_ST_ITEM_SUPPLIERS'

Line 1119: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1115: ||' x.PRIMARY_VENDOR_ITEM,'
1116: /* SCE Change end */
1117: ||' :v_instance_id'
1118: ||' from MRP_AP_PO_LOCAL_ASL_V'||MSC_CL_PULL.v_dblink||' x'
1119: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1120:
1121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Collecting from MRP_AP_PO_LOCAL_ASL_V');
1122:
1123: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,

Line 1121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Collecting from MRP_AP_PO_LOCAL_ASL_V');

1117: ||' :v_instance_id'
1118: ||' from MRP_AP_PO_LOCAL_ASL_V'||MSC_CL_PULL.v_dblink||' x'
1119: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1120:
1121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Collecting from MRP_AP_PO_LOCAL_ASL_V');
1122:
1123: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1124: MSC_CL_PULL.v_mso_sup_cap_penalty,
1125: MSC_CL_PULL.v_instance_id,

Line 1130: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LOCAL ASL net change ');

1126: MSC_CL_PULL.v_refresh_id,
1127: MSC_CL_PULL.v_instance_id;
1128: COMMIT;
1129: ELSE -- LOCAL ASL NET CHANGE
1130: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LOCAL ASL net change ');
1131: v_sql_stmt:=
1132: ' insert into MSC_ST_ITEM_SUPPLIERS'
1133: ||' ( INVENTORY_ITEM_ID,'
1134: ||' USING_ORGANIZATION_ID,'

Line 1204: ||' WHERE x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str

1200: ||' x.PRIMARY_VENDOR_ITEM,'
1201: /* SCE Change end */
1202: ||' :v_instance_id'
1203: ||' from MRP_AN_PO_LOCAL_ASL_V '||MSC_CL_PULL.v_dblink||' x'
1204: ||' WHERE x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str
1205: ||' AND (x.DATE1 > :lv_last_asl_collection_date or x.DATE2 > :lv_last_asl_collection_date )';
1206:
1207: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement lcal ASL ' || v_sql_stmt);
1208:

Line 1207: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement lcal ASL ' || v_sql_stmt);

1203: ||' from MRP_AN_PO_LOCAL_ASL_V '||MSC_CL_PULL.v_dblink||' x'
1204: ||' WHERE x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str
1205: ||' AND (x.DATE1 > :lv_last_asl_collection_date or x.DATE2 > :lv_last_asl_collection_date )';
1206:
1207: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement lcal ASL ' || v_sql_stmt);
1208:
1209: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1210: MSC_CL_PULL.v_mso_sup_cap_penalty,
1211: MSC_CL_PULL.v_instance_id,

Line 1217: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LOCAL ASL ROW COUNT IS ' || SQL%ROWCOUNT);

1213: MSC_CL_PULL.v_instance_id,
1214: lv_last_asl_collection_date,
1215: lv_last_asl_collection_date;
1216:
1217: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LOCAL ASL ROW COUNT IS ' || SQL%ROWCOUNT);
1218: COMMIT ;
1219: END IF ;
1220: END IF; ---- MSC_CL_PULL.v_apps_ver === 115
1221:

Line 1225: IF (MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES_RETAIN_CP) AND

1221:
1222: END IF;
1223:
1224:
1225: IF (MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES_RETAIN_CP) AND
1226: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1227: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1228:
1229: --- LOAD NET_CHAGE for DELETE --------

Line 1226: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND

1222: END IF;
1223:
1224:
1225: IF (MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES_RETAIN_CP) AND
1226: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1227: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1228:
1229: --- LOAD NET_CHAGE for DELETE --------
1230:

Line 1227: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN

1223:
1224:
1225: IF (MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES_RETAIN_CP) AND
1226: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1227: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1228:
1229: --- LOAD NET_CHAGE for DELETE --------
1230:
1231: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 1259: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1255: ||' :v_refresh_id,'
1256: ||' :v_instance_id'
1257: ||' from MRP_AD_SUPPLIER_CAPACITIES_V'||MSC_CL_PULL.v_dblink||' x'
1258: ||' WHERE x.RN> :v_lrn '
1259: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1260:
1261: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1262:
1263: COMMIT;

Line 1288: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1284: ||' 2,'
1285: ||' :v_refresh_id,'
1286: ||' :v_instance_id'
1287: ||' from MRP_AP_SUPPLIER_CAPACITIES_V'||MSC_CL_PULL.v_dblink||' x'
1288: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1289: ||' AND (x.RN2 > :v_lrn)';
1290:
1291: ELSE
1292:

Line 1324: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1320: ||' 2,'
1321: ||' :v_refresh_id,'
1322: ||' :v_instance_id'
1323: ||' from MRP_AP_SUPPLIER_CAPACITIES_V'||MSC_CL_PULL.v_dblink||' x'
1324: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1325: || v_union_sql;
1326:
1327:
1328: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 1371: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str ;

1367: ||' 2,'
1368: ||' :v_refresh_id,'
1369: ||' :v_instance_id'
1370: ||' from MRP_AP_SUPPLIER_FLEX_FENCES_V'||MSC_CL_PULL.v_dblink||' x'
1371: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str ;
1372:
1373: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1374:
1375: COMMIT;

Line 1389: IF MSC_CL_PULL.ITEM_SUBST_ENABLED = MSC_UTIL.SYS_YES THEN

1385: PROCEDURE LOAD_ITEM_SUBSTITUTES IS
1386: v_condition varchar2(1000);
1387: BEGIN
1388:
1389: IF MSC_CL_PULL.ITEM_SUBST_ENABLED = MSC_UTIL.SYS_YES THEN
1390:
1391: -- IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
1392:
1393: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN --For Bug 5632379 SRP Changes

Line 1393: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN --For Bug 5632379 SRP Changes

1389: IF MSC_CL_PULL.ITEM_SUBST_ENABLED = MSC_UTIL.SYS_YES THEN
1390:
1391: -- IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
1392:
1393: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN --For Bug 5632379 SRP Changes
1394: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_SUBSTITUTES';
1395: MSC_CL_PULL.v_view_name := 'MRP_AP_ITEM_SUPERSESSION_REL_V';
1396: v_sql_stmt:=
1397: ' INSERT INTO MSC_ST_ITEM_SUBSTITUTES'

Line 1422: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn || ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1418: ||' :v_instance_id,'
1419: ||' 2,'
1420: ||' x.ORGANIZATION_ID'
1421: ||' FROM MRP_AP_ITEM_SUPERSESSION_REL_V'||MSC_CL_PULL.v_dblink||' x'
1422: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn || ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1423:
1424: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;
1425:
1426: COMMIT;

Line 1465: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1461: ||' 2,'
1462: ||' x.ORGANIZATION_ID'
1463: ||' FROM MRP_AP_ITEM_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
1464: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1465: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1466:
1467:
1468: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;
1469:

Line 1474: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_CL_PULL.v_lrnn<> -1) THEN -- incremental refresh

1470: COMMIT;
1471:
1472: --END IF; --COMPLETE REFRESH For Bug 5702475 SRP Changes
1473:
1474: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_CL_PULL.v_lrnn<> -1) THEN -- incremental refresh
1475:
1476: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_SUBSTITUTES';
1477: MSC_CL_PULL.v_view_name := 'MRP_AD_ITEM_RELATIONSHIPS_V';
1478: v_condition:=null;

Line 1481: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

1477: MSC_CL_PULL.v_view_name := 'MRP_AD_ITEM_RELATIONSHIPS_V';
1478: v_condition:=null;
1479:
1480: --For Bug 5702475 SRP Changes
1481: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
1482: v_condition:= ' and x.relationship_type_id in (2,5,8,18 ) ';
1483: else
1484: v_condition:= ' and x.relationship_type_id in (2) ';
1485: end if;

Line 1508: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1504: ||' :v_instance_id'
1505: ||' FROM MRP_AD_ITEM_RELATIONSHIPS_V'||MSC_CL_PULL.v_dblink||' x'
1506: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1507: || v_condition
1508: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1509:
1510:
1511: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1512:

Line 1534: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))

1530: ( select x.organization_id
1531: FROM msc_instance_orgs x
1532: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1533: and x.enabled_flag= 1
1534: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1535: );
1536: commit;
1537:
1538: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_EAM_NO_ACTIVITY_ITEM'),'No Activity Item');

Line 1590: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group));

1586: MTL_PARAMETERS org
1587: WHERE sr_instance_id= MSC_CL_PULL.v_instance_id
1588: and enabled_flag= 1
1589: and org.ORGANIZATION_ID = x.ORGANIZATION_ID
1590: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group));
1591:
1592: commit;
1593: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_WIP_NONSTD_JOB_ITEM'),'Non Standard Job Item');
1594:

Line 1644: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group));

1640: MTL_PARAMETERS org
1641: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1642: and x.enabled_flag= 1
1643: and org.ORGANIZATION_ID = x.ORGANIZATION_ID
1644: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group));
1645:
1646: commit;
1647:
1648: END INSERT_DUMMY_ITEMS;

Line 1678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug1 - ' || lv_sql_stmt);

1674: lv_sql_stmt:= 'SELECT category_set_id FROM '||lv_table_name
1675: ||' WHERE category_set_name = '''||lv_category_set_name
1676: ||''' AND nvl(language,''' || MSC_CL_PULL.v_lang || ''')=''' || MSC_CL_PULL.v_lang || '''';
1677:
1678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug1 - ' || lv_sql_stmt);
1679:
1680: EXECUTE IMMEDIATE lv_sql_stmt INTO lv_category_set_id ;
1681: EXCEPTION
1682: WHEN NO_DATA_FOUND THEN

Line 1720: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))

1716: ( select x.organization_id
1717: FROM msc_instance_orgs x
1718: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1719: and x.enabled_flag= 1
1720: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1721: );
1722: commit;
1723:
1724: lv_category_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY'),'NEW.MISC');

Line 1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug2 - ' || lv_sql_stmt);

1727: lv_sql_stmt:= 'SELECT category_id,description FROM ' ||lv_table_name
1728: || ' WHERE category_name = '''||lv_category_name
1729: || ''' AND nvl(language,''' || MSC_CL_PULL.v_lang || ''')=''' || MSC_CL_PULL.v_lang || '''and rownum=1';
1730:
1731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug2 - ' || lv_sql_stmt);
1732:
1733: EXECUTE IMMEDIATE lv_sql_stmt INTO lv_category_id,lv_category_description ;
1734: EXCEPTION
1735: WHEN NO_DATA_FOUND THEN

Line 1773: ||' and (('''||MSC_CL_PULL.v_org_group ||'''='''|| MSC_UTIL.G_ALL_ORGANIZATIONS||''' ) or (org_group ='''|| MSC_CL_PULL.v_org_group||'''))';

1769: || lv_table_name ||' org '
1770: ||' WHERE x.sr_instance_id='|| MSC_CL_PULL.v_instance_id
1771: ||' and x.enabled_flag= 1'
1772: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID'
1773: ||' and (('''||MSC_CL_PULL.v_org_group ||'''='''|| MSC_UTIL.G_ALL_ORGANIZATIONS||''' ) or (org_group ='''|| MSC_CL_PULL.v_org_group||'''))';
1774:
1775:
1776:
1777: for lv_item_id in -1001..-1000 loop

Line 1791: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))

1787: ( select x.organization_id
1788: FROM msc_instance_orgs x
1789: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1790: and x.enabled_flag= 1
1791: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1792: );
1793:
1794: commit;
1795:

Line 1820: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1816: ||' x.ORGANIZATION_ID,'
1817: ||' x.ASSIGNMENT_GROUP_ID,'
1818: ||' :v_instance_id'
1819: ||' from MRP_AP_ABC_CLASSES_V'||MSC_CL_PULL.v_dblink||' x'
1820: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1821:
1822:
1823: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;
1824: