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_PULL dependencies on FND_STATS

Line 6244: fnd_stats.gather_table_stats(v_msc_schema, var_table_name, 10, 4);

6240: FETCH tab_list INTO var_table_name;
6241:
6242: EXIT WHEN tab_list%NOTFOUND;
6243:
6244: fnd_stats.gather_table_stats(v_msc_schema, var_table_name, 10, 4);
6245:
6246: END LOOP;
6247:
6248: END ANALYZE_ALL_ST_TABLE;

Line 6275: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BOM_COMPONENTS',lv_pctg,lv_deg);

6271: IF pTASK_NUMBER= TASK_BOM THEN
6272:
6273: TSK_RM_BOM_COMPONENTS:= TSK_RM_BOM_COMPONENTS - 1;
6274: IF TSK_RM_BOM_COMPONENTS=0 THEN
6275: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BOM_COMPONENTS',lv_pctg,lv_deg);
6276: END IF;
6277:
6278: TSK_RM_BOMS:= TSK_RM_BOMS - 1;
6279: IF TSK_RM_BOMS=0 THEN

Line 6280: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BOMS',lv_pctg,lv_deg);

6276: END IF;
6277:
6278: TSK_RM_BOMS:= TSK_RM_BOMS - 1;
6279: IF TSK_RM_BOMS=0 THEN
6280: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BOMS',lv_pctg,lv_deg);
6281: END IF;
6282:
6283: TSK_RM_COMPONENT_SUBSTITUTES:= TSK_RM_COMPONENT_SUBSTITUTES- 1;
6284: IF TSK_RM_COMPONENT_SUBSTITUTES=0 THEN

Line 6285: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_COMPONENT_SUBSTITUTES',lv_pctg,lv_deg);

6281: END IF;
6282:
6283: TSK_RM_COMPONENT_SUBSTITUTES:= TSK_RM_COMPONENT_SUBSTITUTES- 1;
6284: IF TSK_RM_COMPONENT_SUBSTITUTES=0 THEN
6285: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_COMPONENT_SUBSTITUTES',lv_pctg,lv_deg);
6286: END IF;
6287:
6288: ELSIF pTASK_NUMBER= TASK_ROUTING THEN
6289:

Line 6292: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ROUTINGS',lv_pctg,lv_deg);

6288: ELSIF pTASK_NUMBER= TASK_ROUTING THEN
6289:
6290: TSK_RM_ROUTINGS:= TSK_RM_ROUTINGS- 1;
6291: IF TSK_RM_ROUTINGS=0 THEN
6292: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ROUTINGS',lv_pctg,lv_deg);
6293: END IF;
6294:
6295: TSK_RM_ROUTING_OPERATIONS:= TSK_RM_ROUTING_OPERATIONS- 1;
6296: IF TSK_RM_ROUTING_OPERATIONS=0 THEN

Line 6297: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ROUTING_OPERATIONS',lv_pctg,lv_deg);

6293: END IF;
6294:
6295: TSK_RM_ROUTING_OPERATIONS:= TSK_RM_ROUTING_OPERATIONS- 1;
6296: IF TSK_RM_ROUTING_OPERATIONS=0 THEN
6297: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ROUTING_OPERATIONS',lv_pctg,lv_deg);
6298: END IF;
6299:
6300: TSK_RM_OPERATION_RESOURCE_SEQS:= TSK_RM_OPERATION_RESOURCE_SEQS- 1;
6301: IF TSK_RM_OPERATION_RESOURCE_SEQS=0 THEN

Line 6302: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPERATION_RESOURCE_SEQS',lv_pctg,lv_deg);

6298: END IF;
6299:
6300: TSK_RM_OPERATION_RESOURCE_SEQS:= TSK_RM_OPERATION_RESOURCE_SEQS- 1;
6301: IF TSK_RM_OPERATION_RESOURCE_SEQS=0 THEN
6302: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPERATION_RESOURCE_SEQS',lv_pctg,lv_deg);
6303: END IF;
6304:
6305: TSK_RM_OPERATION_RESOURCES:= TSK_RM_OPERATION_RESOURCES- 1;
6306: IF TSK_RM_OPERATION_RESOURCES=0 THEN

Line 6307: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPERATION_RESOURCES',lv_pctg,lv_deg);

6303: END IF;
6304:
6305: TSK_RM_OPERATION_RESOURCES:= TSK_RM_OPERATION_RESOURCES- 1;
6306: IF TSK_RM_OPERATION_RESOURCES=0 THEN
6307: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPERATION_RESOURCES',lv_pctg,lv_deg);
6308: END IF;
6309:
6310: TSK_RM_OPERATION_COMPONENTS:= TSK_RM_OPERATION_COMPONENTS- 1;
6311: IF TSK_RM_OPERATION_COMPONENTS=0 THEN

Line 6312: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPERATION_COMPONENTS',lv_pctg,lv_deg);

6308: END IF;
6309:
6310: TSK_RM_OPERATION_COMPONENTS:= TSK_RM_OPERATION_COMPONENTS- 1;
6311: IF TSK_RM_OPERATION_COMPONENTS=0 THEN
6312: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPERATION_COMPONENTS',lv_pctg,lv_deg);
6313: END IF;
6314:
6315: TSK_RM_PROCESS_EFFECTIVITY:= TSK_RM_PROCESS_EFFECTIVITY- 1;
6316: IF TSK_RM_PROCESS_EFFECTIVITY=0 THEN

Line 6317: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PROCESS_EFFECTIVITY',lv_pctg,lv_deg);

6313: END IF;
6314:
6315: TSK_RM_PROCESS_EFFECTIVITY:= TSK_RM_PROCESS_EFFECTIVITY- 1;
6316: IF TSK_RM_PROCESS_EFFECTIVITY=0 THEN
6317: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PROCESS_EFFECTIVITY',lv_pctg,lv_deg);
6318: END IF;
6319:
6320: ELSIF pTASK_NUMBER= TASK_BOR THEN
6321:

Line 6324: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BILL_OF_RESOURCES',lv_pctg,lv_deg);

6320: ELSIF pTASK_NUMBER= TASK_BOR THEN
6321:
6322: TSK_RM_BILL_OF_RESOURCES:= TSK_RM_BILL_OF_RESOURCES- 1;
6323: IF TSK_RM_BILL_OF_RESOURCES=0 THEN
6324: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BILL_OF_RESOURCES',lv_pctg,lv_deg);
6325: END IF;
6326:
6327: TSK_RM_BOR_REQUIREMENTS:= TSK_RM_BOR_REQUIREMENTS- 1;
6328: IF TSK_RM_BOR_REQUIREMENTS=0 THEN

Line 6329: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BOR_REQUIREMENTS',lv_pctg,lv_deg);

6325: END IF;
6326:
6327: TSK_RM_BOR_REQUIREMENTS:= TSK_RM_BOR_REQUIREMENTS- 1;
6328: IF TSK_RM_BOR_REQUIREMENTS=0 THEN
6329: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BOR_REQUIREMENTS',lv_pctg,lv_deg);
6330: END IF;
6331:
6332: ELSIF pTASK_NUMBER= TASK_CALENDAR_DATE THEN
6333:

Line 6336: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_CHANGES',lv_pctg,lv_deg);

6332: ELSIF pTASK_NUMBER= TASK_CALENDAR_DATE THEN
6333:
6334: TSK_RM_RESOURCE_CHANGES:= TSK_RM_RESOURCE_CHANGES- 1;
6335: IF TSK_RM_RESOURCE_CHANGES=0 THEN
6336: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_CHANGES',lv_pctg,lv_deg);
6337: END IF;
6338:
6339: TSK_RM_CALENDAR_DATES:= TSK_RM_CALENDAR_DATES- 1;
6340: IF TSK_RM_CALENDAR_DATES=0 THEN

Line 6341: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_DATES',lv_pctg,lv_deg);

6337: END IF;
6338:
6339: TSK_RM_CALENDAR_DATES:= TSK_RM_CALENDAR_DATES- 1;
6340: IF TSK_RM_CALENDAR_DATES=0 THEN
6341: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_DATES',lv_pctg,lv_deg);
6342: END IF;
6343:
6344: TSK_RM_PERIOD_START_DATES:= TSK_RM_PERIOD_START_DATES- 1;
6345: IF TSK_RM_PERIOD_START_DATES=0 THEN

Line 6346: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PERIOD_START_DATES',lv_pctg,lv_deg);

6342: END IF;
6343:
6344: TSK_RM_PERIOD_START_DATES:= TSK_RM_PERIOD_START_DATES- 1;
6345: IF TSK_RM_PERIOD_START_DATES=0 THEN
6346: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PERIOD_START_DATES',lv_pctg,lv_deg);
6347: END IF;
6348:
6349: TSK_RM_CAL_YEAR_START_DATES:= TSK_RM_CAL_YEAR_START_DATES- 1;
6350: IF TSK_RM_CAL_YEAR_START_DATES=0 THEN

Line 6351: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CAL_YEAR_START_DATES',lv_pctg,lv_deg);

6347: END IF;
6348:
6349: TSK_RM_CAL_YEAR_START_DATES:= TSK_RM_CAL_YEAR_START_DATES- 1;
6350: IF TSK_RM_CAL_YEAR_START_DATES=0 THEN
6351: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CAL_YEAR_START_DATES',lv_pctg,lv_deg);
6352: END IF;
6353:
6354: TSK_RM_CAL_WEEK_START_DATES:= TSK_RM_CAL_WEEK_START_DATES- 1;
6355: IF TSK_RM_CAL_WEEK_START_DATES=0 THEN

Line 6356: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CAL_WEEK_START_DATES',lv_pctg,lv_deg);

6352: END IF;
6353:
6354: TSK_RM_CAL_WEEK_START_DATES:= TSK_RM_CAL_WEEK_START_DATES- 1;
6355: IF TSK_RM_CAL_WEEK_START_DATES=0 THEN
6356: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CAL_WEEK_START_DATES',lv_pctg,lv_deg);
6357: END IF;
6358:
6359: TSK_RM_RESOURCE_SHIFTS:= TSK_RM_RESOURCE_SHIFTS- 1;
6360: IF TSK_RM_RESOURCE_SHIFTS=0 THEN

Line 6361: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_SHIFTS',lv_pctg,lv_deg);

6357: END IF;
6358:
6359: TSK_RM_RESOURCE_SHIFTS:= TSK_RM_RESOURCE_SHIFTS- 1;
6360: IF TSK_RM_RESOURCE_SHIFTS=0 THEN
6361: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_SHIFTS',lv_pctg,lv_deg);
6362: END IF;
6363:
6364: TSK_RM_CALENDAR_SHIFTS:= TSK_RM_CALENDAR_SHIFTS- 1;
6365: IF TSK_RM_CALENDAR_SHIFTS=0 THEN

Line 6366: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_SHIFTS',lv_pctg,lv_deg);

6362: END IF;
6363:
6364: TSK_RM_CALENDAR_SHIFTS:= TSK_RM_CALENDAR_SHIFTS- 1;
6365: IF TSK_RM_CALENDAR_SHIFTS=0 THEN
6366: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_SHIFTS',lv_pctg,lv_deg);
6367: END IF;
6368:
6369: TSK_RM_SHIFT_DATES:= TSK_RM_SHIFT_DATES- 1;
6370: IF TSK_RM_SHIFT_DATES=0 THEN

Line 6371: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHIFT_DATES',lv_pctg,lv_deg);

6367: END IF;
6368:
6369: TSK_RM_SHIFT_DATES:= TSK_RM_SHIFT_DATES- 1;
6370: IF TSK_RM_SHIFT_DATES=0 THEN
6371: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHIFT_DATES',lv_pctg,lv_deg);
6372: END IF;
6373:
6374: TSK_RM_SHIFT_TIMES:= TSK_RM_SHIFT_TIMES- 1;
6375: IF TSK_RM_SHIFT_TIMES=0 THEN

Line 6376: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHIFT_TIMES',lv_pctg,lv_deg);

6372: END IF;
6373:
6374: TSK_RM_SHIFT_TIMES:= TSK_RM_SHIFT_TIMES- 1;
6375: IF TSK_RM_SHIFT_TIMES=0 THEN
6376: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHIFT_TIMES',lv_pctg,lv_deg);
6377: END IF;
6378:
6379: TSK_RM_SHIFT_EXCEPTIONS:= TSK_RM_SHIFT_EXCEPTIONS- 1;
6380: IF TSK_RM_SHIFT_EXCEPTIONS=0 THEN

Line 6381: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHIFT_EXCEPTIONS',lv_pctg,lv_deg);

6377: END IF;
6378:
6379: TSK_RM_SHIFT_EXCEPTIONS:= TSK_RM_SHIFT_EXCEPTIONS- 1;
6380: IF TSK_RM_SHIFT_EXCEPTIONS=0 THEN
6381: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHIFT_EXCEPTIONS',lv_pctg,lv_deg);
6382: END IF;
6383:
6384: TSK_RM_CALENDAR_ASSIGNMENTS:= TSK_RM_CALENDAR_ASSIGNMENTS- 1;
6385: IF TSK_RM_CALENDAR_ASSIGNMENTS=0 THEN

Line 6386: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_ASSIGNMENTS',lv_pctg,lv_deg);

6382: END IF;
6383:
6384: TSK_RM_CALENDAR_ASSIGNMENTS:= TSK_RM_CALENDAR_ASSIGNMENTS- 1;
6385: IF TSK_RM_CALENDAR_ASSIGNMENTS=0 THEN
6386: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_ASSIGNMENTS',lv_pctg,lv_deg);
6387: END IF;
6388:
6389: ELSIF pTASK_NUMBER= TASK_CATEGORY THEN
6390:

Line 6393: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ITEM_CATEGORIES',lv_pctg,lv_deg);

6389: ELSIF pTASK_NUMBER= TASK_CATEGORY THEN
6390:
6391: TSK_RM_ITEM_CATEGORIES:= TSK_RM_ITEM_CATEGORIES- 1;
6392: IF TSK_RM_ITEM_CATEGORIES=0 THEN
6393: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ITEM_CATEGORIES',lv_pctg,lv_deg);
6394: END IF;
6395:
6396: TSK_RM_CATEGORY_SETS:= TSK_RM_CATEGORY_SETS- 1;
6397: IF TSK_RM_CATEGORY_SETS=0 THEN

Line 6398: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CATEGORY_SETS',lv_pctg,lv_deg);

6394: END IF;
6395:
6396: TSK_RM_CATEGORY_SETS:= TSK_RM_CATEGORY_SETS- 1;
6397: IF TSK_RM_CATEGORY_SETS=0 THEN
6398: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CATEGORY_SETS',lv_pctg,lv_deg);
6399: END IF;
6400:
6401: ELSIF pTASK_NUMBER= TASK_MDS_DEMAND THEN
6402:

Line 6405: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);

6401: ELSIF pTASK_NUMBER= TASK_MDS_DEMAND THEN
6402:
6403: TSK_RM_DEMANDS:= TSK_RM_DEMANDS- 1;
6404: IF TSK_RM_DEMANDS=0 THEN
6405: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);
6406: END IF;
6407:
6408: ELSIF pTASK_NUMBER= TASK_WIP_DEMAND THEN
6409:

Line 6412: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);

6408: ELSIF pTASK_NUMBER= TASK_WIP_DEMAND THEN
6409:
6410: TSK_RM_DEMANDS:= TSK_RM_DEMANDS- 1;
6411: IF TSK_RM_DEMANDS=0 THEN
6412: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);
6413: END IF;
6414:
6415: ELSIF pTASK_NUMBER in (TASK_SALES_ORDER1,TASK_SALES_ORDER2,TASK_SALES_ORDER3,TASK_AHL) THEN
6416:

Line 6419: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SALES_ORDERS',lv_pctg,lv_deg);

6415: ELSIF pTASK_NUMBER in (TASK_SALES_ORDER1,TASK_SALES_ORDER2,TASK_SALES_ORDER3,TASK_AHL) THEN
6416:
6417: TSK_RM_SALES_ORDERS:= TSK_RM_SALES_ORDERS- 1;
6418: IF TSK_RM_SALES_ORDERS=0 THEN
6419: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SALES_ORDERS',lv_pctg,lv_deg);
6420: END IF;
6421:
6422: ELSIF pTASK_NUMBER= TASK_HARD_RESERVATION THEN
6423:

Line 6426: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESERVATIONS',lv_pctg,lv_deg);

6422: ELSIF pTASK_NUMBER= TASK_HARD_RESERVATION THEN
6423:
6424: TSK_RM_RESERVATIONS:= TSK_RM_RESERVATIONS- 1;
6425: IF TSK_RM_RESERVATIONS=0 THEN
6426: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESERVATIONS',lv_pctg,lv_deg);
6427: END IF;
6428:
6429: ELSIF pTASK_NUMBER IN ( TASK_ITEM1, TASK_ITEM2, TASK_ITEM3) THEN
6430:

Line 6433: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SYSTEM_ITEMS',lv_pctg,lv_deg);

6429: ELSIF pTASK_NUMBER IN ( TASK_ITEM1, TASK_ITEM2, TASK_ITEM3) THEN
6430:
6431: TSK_RM_SYSTEM_ITEMS:= TSK_RM_SYSTEM_ITEMS- 1;
6432: IF TSK_RM_SYSTEM_ITEMS=0 THEN
6433: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SYSTEM_ITEMS',lv_pctg,lv_deg);
6434: END IF;
6435:
6436: ELSIF pTASK_NUMBER = TASK_BUYER_CONTACT THEN
6437:

Line 6440: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PARTNER_CONTACTS',lv_pctg,lv_deg);

6436: ELSIF pTASK_NUMBER = TASK_BUYER_CONTACT THEN
6437:
6438: TSK_RM_PARTNER_CONTACTS:= TSK_RM_PARTNER_CONTACTS- 1;
6439: IF TSK_RM_PARTNER_CONTACTS=0 THEN
6440: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PARTNER_CONTACTS',lv_pctg,lv_deg);
6441: END IF;
6442:
6443: ELSIF pTASK_NUMBER = TASK_RESOURCE THEN
6444:

Line 6447: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEPARTMENT_RESOURCES',lv_pctg,lv_deg);

6443: ELSIF pTASK_NUMBER = TASK_RESOURCE THEN
6444:
6445: TSK_RM_DEPARTMENT_RESOURCES:= TSK_RM_DEPARTMENT_RESOURCES- 1;
6446: IF TSK_RM_DEPARTMENT_RESOURCES=0 THEN
6447: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEPARTMENT_RESOURCES',lv_pctg,lv_deg);
6448: END IF;
6449:
6450: TSK_RM_SIMULATION_SETS:= TSK_RM_SIMULATION_SETS- 1;
6451: IF TSK_RM_SIMULATION_SETS=0 THEN

Line 6452: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SIMULATION_SETS',lv_pctg,lv_deg);

6448: END IF;
6449:
6450: TSK_RM_SIMULATION_SETS:= TSK_RM_SIMULATION_SETS- 1;
6451: IF TSK_RM_SIMULATION_SETS=0 THEN
6452: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SIMULATION_SETS',lv_pctg,lv_deg);
6453: END IF;
6454:
6455: TSK_RM_RESOURCE_GROUPS:= TSK_RM_RESOURCE_GROUPS- 1;
6456: IF TSK_RM_RESOURCE_GROUPS=0 THEN

Line 6457: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_GROUPS',lv_pctg,lv_deg);

6453: END IF;
6454:
6455: TSK_RM_RESOURCE_GROUPS:= TSK_RM_RESOURCE_GROUPS- 1;
6456: IF TSK_RM_RESOURCE_GROUPS=0 THEN
6457: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_GROUPS',lv_pctg,lv_deg);
6458: END IF;
6459:
6460: TSK_RM_RESOURCE_REQUIREMENTS:= TSK_RM_RESOURCE_REQUIREMENTS- 1;
6461: IF TSK_RM_RESOURCE_REQUIREMENTS=0 THEN

Line 6462: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_REQUIREMENTS',lv_pctg,lv_deg);

6458: END IF;
6459:
6460: TSK_RM_RESOURCE_REQUIREMENTS:= TSK_RM_RESOURCE_REQUIREMENTS- 1;
6461: IF TSK_RM_RESOURCE_REQUIREMENTS=0 THEN
6462: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_REQUIREMENTS',lv_pctg,lv_deg);
6463: END IF;
6464:
6465: ELSIF pTASK_NUMBER = TASK_SAFETY_STOCK THEN
6466:

Line 6469: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SAFETY_STOCKS',lv_pctg,lv_deg);

6465: ELSIF pTASK_NUMBER = TASK_SAFETY_STOCK THEN
6466:
6467: TSK_RM_SAFETY_STOCKS:= TSK_RM_SAFETY_STOCKS- 1;
6468: IF TSK_RM_SAFETY_STOCKS=0 THEN
6469: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SAFETY_STOCKS',lv_pctg,lv_deg);
6470: END IF;
6471:
6472: ELSIF pTASK_NUMBER = TASK_SCHEDULE THEN
6473:

Line 6476: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DESIGNATORS',lv_pctg,lv_deg);

6472: ELSIF pTASK_NUMBER = TASK_SCHEDULE THEN
6473:
6474: TSK_RM_DESIGNATORS:= TSK_RM_DESIGNATORS- 1;
6475: IF TSK_RM_DESIGNATORS=0 THEN
6476: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DESIGNATORS',lv_pctg,lv_deg);
6477: END IF;
6478:
6479: ELSIF pTASK_NUMBER = TASK_SOURCING THEN
6480:

Line 6483: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ASSIGNMENT_SETS',lv_pctg,lv_deg);

6479: ELSIF pTASK_NUMBER = TASK_SOURCING THEN
6480:
6481: TSK_RM_ASSIGNMENT_SETS:= TSK_RM_ASSIGNMENT_SETS- 1;
6482: IF TSK_RM_ASSIGNMENT_SETS=0 THEN
6483: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ASSIGNMENT_SETS',lv_pctg,lv_deg);
6484: END IF;
6485:
6486: TSK_RM_SR_ASSIGNMENTS:= TSK_RM_SR_ASSIGNMENTS- 1;
6487: IF TSK_RM_SR_ASSIGNMENTS=0 THEN

Line 6488: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_ASSIGNMENTS',lv_pctg,lv_deg);

6484: END IF;
6485:
6486: TSK_RM_SR_ASSIGNMENTS:= TSK_RM_SR_ASSIGNMENTS- 1;
6487: IF TSK_RM_SR_ASSIGNMENTS=0 THEN
6488: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_ASSIGNMENTS',lv_pctg,lv_deg);
6489: END IF;
6490:
6491: TSK_RM_SOURCING_RULES:= TSK_RM_SOURCING_RULES- 1;
6492: IF TSK_RM_SOURCING_RULES=0 THEN

Line 6493: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SOURCING_RULES',lv_pctg,lv_deg);

6489: END IF;
6490:
6491: TSK_RM_SOURCING_RULES:= TSK_RM_SOURCING_RULES- 1;
6492: IF TSK_RM_SOURCING_RULES=0 THEN
6493: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SOURCING_RULES',lv_pctg,lv_deg);
6494: END IF;
6495:
6496: TSK_RM_SR_RECEIPT_ORG:= TSK_RM_SR_RECEIPT_ORG- 1;
6497: IF TSK_RM_SR_RECEIPT_ORG=0 THEN

Line 6498: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_RECEIPT_ORG',lv_pctg,lv_deg);

6494: END IF;
6495:
6496: TSK_RM_SR_RECEIPT_ORG:= TSK_RM_SR_RECEIPT_ORG- 1;
6497: IF TSK_RM_SR_RECEIPT_ORG=0 THEN
6498: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_RECEIPT_ORG',lv_pctg,lv_deg);
6499: END IF;
6500:
6501: TSK_RM_SR_SOURCE_ORG:= TSK_RM_SR_SOURCE_ORG- 1;
6502: IF TSK_RM_SR_SOURCE_ORG=0 THEN

Line 6503: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_SOURCE_ORG',lv_pctg,lv_deg);

6499: END IF;
6500:
6501: TSK_RM_SR_SOURCE_ORG:= TSK_RM_SR_SOURCE_ORG- 1;
6502: IF TSK_RM_SR_SOURCE_ORG=0 THEN
6503: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_SOURCE_ORG',lv_pctg,lv_deg);
6504: END IF;
6505:
6506: TSK_RM_INTERORG_SHIP_METHODS:= TSK_RM_INTERORG_SHIP_METHODS- 1;
6507: IF TSK_RM_INTERORG_SHIP_METHODS=0 THEN

Line 6508: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_INTERORG_SHIP_METHODS',lv_pctg,lv_deg);

6504: END IF;
6505:
6506: TSK_RM_INTERORG_SHIP_METHODS:= TSK_RM_INTERORG_SHIP_METHODS- 1;
6507: IF TSK_RM_INTERORG_SHIP_METHODS=0 THEN
6508: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_INTERORG_SHIP_METHODS',lv_pctg,lv_deg);
6509: END IF;
6510:
6511: TSK_RM_REGIONS := TSK_RM_REGIONS - 1;
6512: IF TSK_RM_REGIONS = 0 THEN

Line 6513: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_REGIONS',lv_pctg,lv_deg);

6509: END IF;
6510:
6511: TSK_RM_REGIONS := TSK_RM_REGIONS - 1;
6512: IF TSK_RM_REGIONS = 0 THEN
6513: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_REGIONS',lv_pctg,lv_deg);
6514: END IF;
6515:
6516: TSK_RM_ZONE_REGIONS := TSK_RM_ZONE_REGIONS - 1;
6517: IF TSK_RM_ZONE_REGIONS = 0 THEN

Line 6518: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ZONE_REGIONS',lv_pctg,lv_deg);

6514: END IF;
6515:
6516: TSK_RM_ZONE_REGIONS := TSK_RM_ZONE_REGIONS - 1;
6517: IF TSK_RM_ZONE_REGIONS = 0 THEN
6518: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ZONE_REGIONS',lv_pctg,lv_deg);
6519: END IF;
6520:
6521: TSK_RM_CARRIER_SERVICES:= TSK_RM_CARRIER_SERVICES- 1;
6522: IF TSK_RM_CARRIER_SERVICES=0 THEN

Line 6523: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CARRIER_SERVICES',lv_pctg,lv_deg);

6519: END IF;
6520:
6521: TSK_RM_CARRIER_SERVICES:= TSK_RM_CARRIER_SERVICES- 1;
6522: IF TSK_RM_CARRIER_SERVICES=0 THEN
6523: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CARRIER_SERVICES',lv_pctg,lv_deg);
6524: END IF;
6525:
6526: TSK_RM_REGION_SITES:= TSK_RM_REGION_SITES- 1;
6527: IF TSK_RM_REGION_SITES=0 THEN

Line 6528: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_REGION_SITES',lv_pctg,lv_deg);

6524: END IF;
6525:
6526: TSK_RM_REGION_SITES:= TSK_RM_REGION_SITES- 1;
6527: IF TSK_RM_REGION_SITES=0 THEN
6528: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_REGION_SITES',lv_pctg,lv_deg);
6529: END IF;
6530:
6531: ELSIF pTASK_NUMBER = TASK_SUB_INVENTORY THEN
6532:

Line 6535: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUB_INVENTORIES',lv_pctg,lv_deg);

6531: ELSIF pTASK_NUMBER = TASK_SUB_INVENTORY THEN
6532:
6533: TSK_RM_SUB_INVENTORIES:= TSK_RM_SUB_INVENTORIES- 1;
6534: IF TSK_RM_SUB_INVENTORIES=0 THEN
6535: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUB_INVENTORIES',lv_pctg,lv_deg);
6536: END IF;
6537:
6538: ELSIF pTASK_NUMBER = TASK_SUPPLIER_CAPACITY THEN
6539:

Line 6542: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ITEM_SUPPLIERS',lv_pctg,lv_deg);

6538: ELSIF pTASK_NUMBER = TASK_SUPPLIER_CAPACITY THEN
6539:
6540: TSK_RM_ITEM_SUPPLIERS:= TSK_RM_ITEM_SUPPLIERS- 1;
6541: IF TSK_RM_ITEM_SUPPLIERS=0 THEN
6542: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ITEM_SUPPLIERS',lv_pctg,lv_deg);
6543: END IF;
6544:
6545: TSK_RM_SUPPLIER_CAPACITIES:= TSK_RM_SUPPLIER_CAPACITIES- 1;
6546: IF TSK_RM_SUPPLIER_CAPACITIES=0 THEN

Line 6547: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIER_CAPACITIES',lv_pctg,lv_deg);

6543: END IF;
6544:
6545: TSK_RM_SUPPLIER_CAPACITIES:= TSK_RM_SUPPLIER_CAPACITIES- 1;
6546: IF TSK_RM_SUPPLIER_CAPACITIES=0 THEN
6547: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIER_CAPACITIES',lv_pctg,lv_deg);
6548: END IF;
6549:
6550: TSK_RM_SUPPLIER_FLEX_FENCES:= TSK_RM_SUPPLIER_FLEX_FENCES- 1;
6551: IF TSK_RM_SUPPLIER_FLEX_FENCES=0 THEN

Line 6552: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIER_FLEX_FENCES',lv_pctg,lv_deg);

6548: END IF;
6549:
6550: TSK_RM_SUPPLIER_FLEX_FENCES:= TSK_RM_SUPPLIER_FLEX_FENCES- 1;
6551: IF TSK_RM_SUPPLIER_FLEX_FENCES=0 THEN
6552: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIER_FLEX_FENCES',lv_pctg,lv_deg);
6553: END IF;
6554:
6555: ELSIF pTASK_NUMBER IN ( TASK_PO_SUPPLY, TASK_WIP_SUPPLY, TASK_OH_SUPPLY, TASK_MPS_SUPPLY, TASK_PO_PO_SUPPLY, TASK_PO_REQ_SUPPLY) THEN
6556:

Line 6559: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIES',lv_pctg,lv_deg);

6555: ELSIF pTASK_NUMBER IN ( TASK_PO_SUPPLY, TASK_WIP_SUPPLY, TASK_OH_SUPPLY, TASK_MPS_SUPPLY, TASK_PO_PO_SUPPLY, TASK_PO_REQ_SUPPLY) THEN
6556:
6557: TSK_RM_SUPPLIES:= TSK_RM_SUPPLIES- 1;
6558: IF TSK_RM_SUPPLIES=0 THEN
6559: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIES',lv_pctg,lv_deg);
6560: END IF;
6561:
6562: TSK_RM_JOB_OP_NETWORKS := TSK_RM_JOB_OP_NETWORKS - 1;
6563: IF TSK_RM_JOB_OP_NETWORKS=0 THEN

Line 6564: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_OPERATION_NETWORKS',lv_pctg,lv_deg);

6560: END IF;
6561:
6562: TSK_RM_JOB_OP_NETWORKS := TSK_RM_JOB_OP_NETWORKS - 1;
6563: IF TSK_RM_JOB_OP_NETWORKS=0 THEN
6564: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_OPERATION_NETWORKS',lv_pctg,lv_deg);
6565: END IF;
6566:
6567: TSK_RM_JOB_OPERATIONS := TSK_RM_JOB_OPERATIONS - 1;
6568: IF TSK_RM_JOB_OPERATIONS=0 THEN

Line 6569: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_OPERATIONS',lv_pctg,lv_deg);

6565: END IF;
6566:
6567: TSK_RM_JOB_OPERATIONS := TSK_RM_JOB_OPERATIONS - 1;
6568: IF TSK_RM_JOB_OPERATIONS=0 THEN
6569: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_OPERATIONS',lv_pctg,lv_deg);
6570: END IF;
6571:
6572: TSK_RM_JOB_REQUIREMENT_OPS := TSK_RM_JOB_REQUIREMENT_OPS - 1;
6573: IF TSK_RM_JOB_REQUIREMENT_OPS=0 THEN

Line 6574: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_REQUIREMENT_OPS',lv_pctg,lv_deg);

6570: END IF;
6571:
6572: TSK_RM_JOB_REQUIREMENT_OPS := TSK_RM_JOB_REQUIREMENT_OPS - 1;
6573: IF TSK_RM_JOB_REQUIREMENT_OPS=0 THEN
6574: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_REQUIREMENT_OPS',lv_pctg,lv_deg);
6575: END IF;
6576:
6577: TSK_RM_JOB_OP_RESOURCES := TSK_RM_JOB_OP_RESOURCES - 1;
6578: IF TSK_RM_JOB_OP_RESOURCES=0 THEN

Line 6579: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_OP_RESOURCES',lv_pctg,lv_deg);

6575: END IF;
6576:
6577: TSK_RM_JOB_OP_RESOURCES := TSK_RM_JOB_OP_RESOURCES - 1;
6578: IF TSK_RM_JOB_OP_RESOURCES=0 THEN
6579: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_OP_RESOURCES',lv_pctg,lv_deg);
6580: END IF;
6581:
6582: ELSIF pTASK_NUMBER = TASK_TRADING_PARTNER THEN
6583:

Line 6586: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRADING_PARTNERS',lv_pctg,lv_deg);

6582: ELSIF pTASK_NUMBER = TASK_TRADING_PARTNER THEN
6583:
6584: TSK_RM_TRADING_PARTNERS:= TSK_RM_TRADING_PARTNERS- 1;
6585: IF TSK_RM_TRADING_PARTNERS=0 THEN
6586: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRADING_PARTNERS',lv_pctg,lv_deg);
6587: END IF;
6588:
6589: TSK_RM_TRADING_PARTNER_SITES:= TSK_RM_TRADING_PARTNER_SITES- 1;
6590: IF TSK_RM_TRADING_PARTNER_SITES=0 THEN

Line 6591: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRADING_PARTNER_SITES',lv_pctg,lv_deg);

6587: END IF;
6588:
6589: TSK_RM_TRADING_PARTNER_SITES:= TSK_RM_TRADING_PARTNER_SITES- 1;
6590: IF TSK_RM_TRADING_PARTNER_SITES=0 THEN
6591: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRADING_PARTNER_SITES',lv_pctg,lv_deg);
6592: END IF;
6593:
6594: TSK_RM_LOCATION_ASSOCIATIONS:= TSK_RM_LOCATION_ASSOCIATIONS- 1;
6595: IF TSK_RM_LOCATION_ASSOCIATIONS=0 THEN

Line 6596: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_LOCATION_ASSOCIATIONS',lv_pctg,lv_deg);

6592: END IF;
6593:
6594: TSK_RM_LOCATION_ASSOCIATIONS:= TSK_RM_LOCATION_ASSOCIATIONS- 1;
6595: IF TSK_RM_LOCATION_ASSOCIATIONS=0 THEN
6596: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_LOCATION_ASSOCIATIONS',lv_pctg,lv_deg);
6597: END IF;
6598:
6599: TSK_RM_PARTNER_CONTACTS:= TSK_RM_PARTNER_CONTACTS- 1;
6600: IF TSK_RM_PARTNER_CONTACTS=0 THEN

Line 6601: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PARTNER_CONTACTS',lv_pctg,lv_deg);

6597: END IF;
6598:
6599: TSK_RM_PARTNER_CONTACTS:= TSK_RM_PARTNER_CONTACTS- 1;
6600: IF TSK_RM_PARTNER_CONTACTS=0 THEN
6601: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PARTNER_CONTACTS',lv_pctg,lv_deg);
6602: END IF;
6603:
6604: ELSIF pTASK_NUMBER = TASK_UNIT_NUMBER THEN
6605:

Line 6608: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UNIT_NUMBERS',lv_pctg,lv_deg);

6604: ELSIF pTASK_NUMBER = TASK_UNIT_NUMBER THEN
6605:
6606: TSK_RM_UNIT_NUMBERS:= TSK_RM_UNIT_NUMBERS- 1;
6607: IF TSK_RM_UNIT_NUMBERS=0 THEN
6608: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UNIT_NUMBERS',lv_pctg,lv_deg);
6609: END IF;
6610:
6611: ELSIF pTASK_NUMBER = TASK_PROJECT THEN
6612:

Line 6615: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PROJECTS',lv_pctg,lv_deg);

6611: ELSIF pTASK_NUMBER = TASK_PROJECT THEN
6612:
6613: TSK_RM_PROJECTS:= TSK_RM_PROJECTS- 1;
6614: IF TSK_RM_PROJECTS=0 THEN
6615: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PROJECTS',lv_pctg,lv_deg);
6616: END IF;
6617:
6618: TSK_RM_PROJECT_TASKS:= TSK_RM_PROJECT_TASKS- 1;
6619: IF TSK_RM_PROJECT_TASKS=0 THEN

Line 6620: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PROJECT_TASKS',lv_pctg,lv_deg);

6616: END IF;
6617:
6618: TSK_RM_PROJECT_TASKS:= TSK_RM_PROJECT_TASKS- 1;
6619: IF TSK_RM_PROJECT_TASKS=0 THEN
6620: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PROJECT_TASKS',lv_pctg,lv_deg);
6621: END IF;
6622:
6623: ELSIF pTASK_NUMBER = TASK_PARAMETER THEN
6624:

Line 6627: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PARAMETERS',lv_pctg,lv_deg);

6623: ELSIF pTASK_NUMBER = TASK_PARAMETER THEN
6624:
6625: TSK_RM_PARAMETERS:= TSK_RM_PARAMETERS- 1;
6626: IF TSK_RM_PARAMETERS=0 THEN
6627: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PARAMETERS',lv_pctg,lv_deg);
6628: END IF;
6629:
6630: ELSIF pTASK_NUMBER = TASK_UOM THEN
6631:

Line 6634: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UNITS_OF_MEASURE',lv_pctg,lv_deg);

6630: ELSIF pTASK_NUMBER = TASK_UOM THEN
6631:
6632: TSK_RM_UNITS_OF_MEASURE:= TSK_RM_UNITS_OF_MEASURE- 1;
6633: IF TSK_RM_UNITS_OF_MEASURE=0 THEN
6634: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UNITS_OF_MEASURE',lv_pctg,lv_deg);
6635: END IF;
6636:
6637: TSK_RM_UOM_CLASS_CONVERSIONS:= TSK_RM_UOM_CLASS_CONVERSIONS- 1;
6638: IF TSK_RM_UOM_CLASS_CONVERSIONS=0 THEN

Line 6639: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UOM_CLASS_CONVERSIONS',lv_pctg,lv_deg);

6635: END IF;
6636:
6637: TSK_RM_UOM_CLASS_CONVERSIONS:= TSK_RM_UOM_CLASS_CONVERSIONS- 1;
6638: IF TSK_RM_UOM_CLASS_CONVERSIONS=0 THEN
6639: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UOM_CLASS_CONVERSIONS',lv_pctg,lv_deg);
6640: END IF;
6641:
6642: TSK_RM_UOM_CONVERSIONS:= TSK_RM_UOM_CONVERSIONS- 1;
6643: IF TSK_RM_UOM_CONVERSIONS=0 THEN

Line 6644: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UOM_CONVERSIONS',lv_pctg,lv_deg);

6640: END IF;
6641:
6642: TSK_RM_UOM_CONVERSIONS:= TSK_RM_UOM_CONVERSIONS- 1;
6643: IF TSK_RM_UOM_CONVERSIONS=0 THEN
6644: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UOM_CONVERSIONS',lv_pctg,lv_deg);
6645: END IF;
6646:
6647: ELSIF pTASK_NUMBER = TASK_BIS THEN
6648:

Line 6651: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_PERIODS',lv_pctg,lv_deg);

6647: ELSIF pTASK_NUMBER = TASK_BIS THEN
6648:
6649: TSK_RM_BIS_PERIODS:= TSK_RM_BIS_PERIODS- 1;
6650: IF TSK_RM_BIS_PERIODS=0 THEN
6651: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_PERIODS',lv_pctg,lv_deg);
6652: END IF;
6653:
6654: TSK_RM_BIS_PFMC_MEASURES:= TSK_RM_BIS_PFMC_MEASURES- 1;
6655: IF TSK_RM_BIS_PFMC_MEASURES=0 THEN

Line 6656: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_PFMC_MEASURES',lv_pctg,lv_deg);

6652: END IF;
6653:
6654: TSK_RM_BIS_PFMC_MEASURES:= TSK_RM_BIS_PFMC_MEASURES- 1;
6655: IF TSK_RM_BIS_PFMC_MEASURES=0 THEN
6656: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_PFMC_MEASURES',lv_pctg,lv_deg);
6657: END IF;
6658:
6659: TSK_RM_BIS_TARGET_LEVELS:= TSK_RM_BIS_TARGET_LEVELS- 1;
6660: IF TSK_RM_BIS_TARGET_LEVELS=0 THEN

Line 6661: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_TARGET_LEVELS',lv_pctg,lv_deg);

6657: END IF;
6658:
6659: TSK_RM_BIS_TARGET_LEVELS:= TSK_RM_BIS_TARGET_LEVELS- 1;
6660: IF TSK_RM_BIS_TARGET_LEVELS=0 THEN
6661: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_TARGET_LEVELS',lv_pctg,lv_deg);
6662: END IF;
6663:
6664: TSK_RM_BIS_TARGETS:= TSK_RM_BIS_TARGETS- 1;
6665: IF TSK_RM_BIS_TARGETS=0 THEN

Line 6666: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_TARGETS',lv_pctg,lv_deg);

6662: END IF;
6663:
6664: TSK_RM_BIS_TARGETS:= TSK_RM_BIS_TARGETS- 1;
6665: IF TSK_RM_BIS_TARGETS=0 THEN
6666: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_TARGETS',lv_pctg,lv_deg);
6667: END IF;
6668:
6669: TSK_RM_BIS_BUSINESS_PLANS:= TSK_RM_BIS_BUSINESS_PLANS- 1;
6670: IF TSK_RM_BIS_BUSINESS_PLANS=0 THEN

Line 6671: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_BUSINESS_PLANS',lv_pctg,lv_deg);

6667: END IF;
6668:
6669: TSK_RM_BIS_BUSINESS_PLANS:= TSK_RM_BIS_BUSINESS_PLANS- 1;
6670: IF TSK_RM_BIS_BUSINESS_PLANS=0 THEN
6671: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_BUSINESS_PLANS',lv_pctg,lv_deg);
6672: END IF;
6673:
6674: ELSIF pTASK_NUMBER = TASK_ATP_RULES THEN
6675:

Line 6678: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ATP_RULES',lv_pctg,lv_deg);

6674: ELSIF pTASK_NUMBER = TASK_ATP_RULES THEN
6675:
6676: TSK_RM_ATP_RULES:= TSK_RM_ATP_RULES- 1;
6677: IF TSK_RM_ATP_RULES=0 THEN
6678: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ATP_RULES',lv_pctg,lv_deg);
6679: END IF;
6680:
6681: ELSIF pTASK_NUMBER = TASK_USER_SUPPLY THEN
6682:

Line 6685: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIES',lv_pctg,lv_deg);

6681: ELSIF pTASK_NUMBER = TASK_USER_SUPPLY THEN
6682:
6683: TSK_RM_SUPPLIES:= TSK_RM_SUPPLIES- 1;
6684: IF TSK_RM_SUPPLIES=0 THEN
6685: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIES',lv_pctg,lv_deg);
6686: END IF;
6687:
6688: ELSIF pTASK_NUMBER = TASK_USER_DEMAND THEN
6689:

Line 6692: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);

6688: ELSIF pTASK_NUMBER = TASK_USER_DEMAND THEN
6689:
6690: TSK_RM_DEMANDS:= TSK_RM_DEMANDS- 1;
6691: IF TSK_RM_DEMANDS=0 THEN
6692: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);
6693: END IF;
6694:
6695: ELSIF pTASK_NUMBER = TASK_PLANNERS THEN
6696:

Line 6699: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PLANNERS',lv_pctg,lv_deg);

6695: ELSIF pTASK_NUMBER = TASK_PLANNERS THEN
6696:
6697: TSK_RM_PLANNERS:= TSK_RM_PLANNERS- 1;
6698: IF TSK_RM_PLANNERS=0 THEN
6699: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PLANNERS',lv_pctg,lv_deg);
6700: END IF;
6701:
6702: ELSIF pTASK_NUMBER = TASK_DEMAND_CLASS THEN
6703:

Line 6706: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMAND_CLASSES',lv_pctg,lv_deg);

6702: ELSIF pTASK_NUMBER = TASK_DEMAND_CLASS THEN
6703:
6704: TSK_RM_DEMAND_CLASSES:= TSK_RM_DEMAND_CLASSES- 1;
6705: IF TSK_RM_DEMAND_CLASSES=0 THEN
6706: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMAND_CLASSES',lv_pctg,lv_deg);
6707: END IF;
6708:
6709: ELSIF pTASK_NUMBER = TASK_ITEM_SUBSTITUTES THEN
6710:

Line 6713: FND_STATS.gather_table_stats(lv_owner,'MSC_ST_ITEM_SUBSTITUTES',lv_pctg,lv_deg);

6709: ELSIF pTASK_NUMBER = TASK_ITEM_SUBSTITUTES THEN
6710:
6711: TSK_RM_ITEM_SUBSTITUTES := TSK_RM_ITEM_SUBSTITUTES - 1;
6712: IF TSK_RM_ITEM_SUBSTITUTES = 0 THEN
6713: FND_STATS.gather_table_stats(lv_owner,'MSC_ST_ITEM_SUBSTITUTES',lv_pctg,lv_deg);
6714: END IF;
6715:
6716: ELSIF pTASK_NUMBER = TASK_TRIP THEN
6717:

Line 6720: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRIPS',lv_pctg,lv_deg);

6716: ELSIF pTASK_NUMBER = TASK_TRIP THEN
6717:
6718: TSK_RM_TRIPS := TSK_RM_TRIPS - 1;
6719: IF TSK_RM_TRIPS = 0 THEN
6720: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRIPS',lv_pctg,lv_deg);
6721: END IF;
6722:
6723: TSK_RM_TRIP_STOPS := TSK_RM_TRIP_STOPS - 1;
6724: IF TSK_RM_TRIP_STOPS = 0 THEN

Line 6725: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRIP_STOPS',lv_pctg,lv_deg);

6721: END IF;
6722:
6723: TSK_RM_TRIP_STOPS := TSK_RM_TRIP_STOPS - 1;
6724: IF TSK_RM_TRIP_STOPS = 0 THEN
6725: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRIP_STOPS',lv_pctg,lv_deg);
6726: END IF;
6727: /* ds change start */
6728: ELSIF pTASK_NUMBER = TASK_RESOURCE_INSTANCE THEN
6729: TSK_RM_RESOURCE_INSTANCE := TSK_RM_RESOURCE_INSTANCE -1;

Line 6731: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_DEPT_RES_INSTANCES',lv_pctg,lv_deg);

6727: /* ds change start */
6728: ELSIF pTASK_NUMBER = TASK_RESOURCE_INSTANCE THEN
6729: TSK_RM_RESOURCE_INSTANCE := TSK_RM_RESOURCE_INSTANCE -1;
6730: IF TSK_RM_RESOURCE_INSTANCE = 0 THEN
6731: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_DEPT_RES_INSTANCES',lv_pctg,lv_deg);
6732: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_INSTANCE_REQS',lv_pctg,lv_deg);
6733: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_JOB_OP_RES_INSTANCES',lv_pctg,lv_deg);
6734: END IF;
6735: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN

Line 6732: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_INSTANCE_REQS',lv_pctg,lv_deg);

6728: ELSIF pTASK_NUMBER = TASK_RESOURCE_INSTANCE THEN
6729: TSK_RM_RESOURCE_INSTANCE := TSK_RM_RESOURCE_INSTANCE -1;
6730: IF TSK_RM_RESOURCE_INSTANCE = 0 THEN
6731: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_DEPT_RES_INSTANCES',lv_pctg,lv_deg);
6732: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_INSTANCE_REQS',lv_pctg,lv_deg);
6733: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_JOB_OP_RES_INSTANCES',lv_pctg,lv_deg);
6734: END IF;
6735: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN
6736: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;

Line 6733: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_JOB_OP_RES_INSTANCES',lv_pctg,lv_deg);

6729: TSK_RM_RESOURCE_INSTANCE := TSK_RM_RESOURCE_INSTANCE -1;
6730: IF TSK_RM_RESOURCE_INSTANCE = 0 THEN
6731: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_DEPT_RES_INSTANCES',lv_pctg,lv_deg);
6732: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_INSTANCE_REQS',lv_pctg,lv_deg);
6733: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_JOB_OP_RES_INSTANCES',lv_pctg,lv_deg);
6734: END IF;
6735: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN
6736: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;
6737: IF TSK_RM_RESOURCE_SETUP = 0 THEN

Line 6738: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_SETUPS',lv_pctg,lv_deg);

6734: END IF;
6735: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN
6736: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;
6737: IF TSK_RM_RESOURCE_SETUP = 0 THEN
6738: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_SETUPS',lv_pctg,lv_deg);
6739: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_SETUP_TRANSITIONS',lv_pctg,lv_deg);
6740: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_STD_OP_RESOURCES',lv_pctg,lv_deg);
6741: END IF;
6742: /* ds change end */

Line 6739: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_SETUP_TRANSITIONS',lv_pctg,lv_deg);

6735: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN
6736: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;
6737: IF TSK_RM_RESOURCE_SETUP = 0 THEN
6738: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_SETUPS',lv_pctg,lv_deg);
6739: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_SETUP_TRANSITIONS',lv_pctg,lv_deg);
6740: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_STD_OP_RESOURCES',lv_pctg,lv_deg);
6741: END IF;
6742: /* ds change end */
6743: ELSIF pTASK_NUMBER = TASK_ABC_CLASSES THEN

Line 6740: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_STD_OP_RESOURCES',lv_pctg,lv_deg);

6736: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;
6737: IF TSK_RM_RESOURCE_SETUP = 0 THEN
6738: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_SETUPS',lv_pctg,lv_deg);
6739: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_SETUP_TRANSITIONS',lv_pctg,lv_deg);
6740: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_STD_OP_RESOURCES',lv_pctg,lv_deg);
6741: END IF;
6742: /* ds change end */
6743: ELSIF pTASK_NUMBER = TASK_ABC_CLASSES THEN
6744: TSK_RM_ABC_CLASSES := TSK_RM_ABC_CLASSES - 1;

Line 6746: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_ABC_CLASSES',lv_pctg,lv_deg);

6742: /* ds change end */
6743: ELSIF pTASK_NUMBER = TASK_ABC_CLASSES THEN
6744: TSK_RM_ABC_CLASSES := TSK_RM_ABC_CLASSES - 1;
6745: IF TSK_RM_ABC_CLASSES =0 THEN
6746: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_ABC_CLASSES',lv_pctg,lv_deg);
6747: END IF;
6748:
6749: ELSIF pTASK_NUMBER = TASK_FISCAL_CALENDAR THEN
6750: TSK_RM_FISCAL_CALENDAR := TSK_RM_FISCAL_CALENDAR - 1;

Line 6752: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_MONTHS',lv_pctg,lv_deg);

6748:
6749: ELSIF pTASK_NUMBER = TASK_FISCAL_CALENDAR THEN
6750: TSK_RM_FISCAL_CALENDAR := TSK_RM_FISCAL_CALENDAR - 1;
6751: IF TSK_RM_FISCAL_CALENDAR = 0 THEN
6752: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_MONTHS',lv_pctg,lv_deg);
6753: END IF;
6754:
6755: ELSIF pTASK_NUMBER = TASK_SALES_CHANNEL THEN
6756: TSK_RM_SALES_CHANNEL := TSK_RM_SALES_CHANNEL - 1;

Line 6758: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_LOOKUPS',lv_pctg,lv_deg);

6754:
6755: ELSIF pTASK_NUMBER = TASK_SALES_CHANNEL THEN
6756: TSK_RM_SALES_CHANNEL := TSK_RM_SALES_CHANNEL - 1;
6757: IF TSK_RM_SALES_CHANNEL = 0 THEN
6758: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_LOOKUPS',lv_pctg,lv_deg);
6759: END IF;
6760:
6761: ELSIF pTASK_NUMBER = TASK_IRO THEN
6762: TSK_RM_INTERNAL_REPAIR := TSK_RM_INTERNAL_REPAIR - 1;

Line 6764: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIES',lv_pctg,lv_deg);

6760:
6761: ELSIF pTASK_NUMBER = TASK_IRO THEN
6762: TSK_RM_INTERNAL_REPAIR := TSK_RM_INTERNAL_REPAIR - 1;
6763: IF TSK_RM_INTERNAL_REPAIR = 0 THEN
6764: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIES',lv_pctg,lv_deg);
6765: END IF;
6766:
6767: ELSIF pTASK_NUMBER = TASK_IRO_DEMAND THEN
6768: TSK_RM_INTERNAL_REPAIR := TSK_RM_INTERNAL_REPAIR - 1;

Line 6770: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);

6766:
6767: ELSIF pTASK_NUMBER = TASK_IRO_DEMAND THEN
6768: TSK_RM_INTERNAL_REPAIR := TSK_RM_INTERNAL_REPAIR - 1;
6769: IF TSK_RM_INTERNAL_REPAIR = 0 THEN
6770: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);
6771: END IF;
6772: ELSIF pTASK_NUMBER = TASK_PAYBACK_DEMAND_SUPPLY THEN
6773: TSK_RM_PAYBACK_DEMAND_SUPPLY := TSK_RM_PAYBACK_DEMAND_SUPPLY - 1;
6774: IF TSK_RM_PAYBACK_DEMAND_SUPPLY = 0 THEN

Line 6775: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPEN_PAYBACKS',lv_pctg,lv_deg);

6771: END IF;
6772: ELSIF pTASK_NUMBER = TASK_PAYBACK_DEMAND_SUPPLY THEN
6773: TSK_RM_PAYBACK_DEMAND_SUPPLY := TSK_RM_PAYBACK_DEMAND_SUPPLY - 1;
6774: IF TSK_RM_PAYBACK_DEMAND_SUPPLY = 0 THEN
6775: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPEN_PAYBACKS',lv_pctg,lv_deg);
6776: END IF;
6777: ELSIF pTASK_NUMBER = TASK_CURRENCY_CONVERSION THEN
6778: TSK_RM_CURRENCY_CONVERSION := TSK_RM_CURRENCY_CONVERSION - 1;
6779: IF TSK_RM_CURRENCY_CONVERSION = 0 THEN

Line 6780: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CURRENCY_CONVERSIONS',lv_pctg,lv_deg);

6776: END IF;
6777: ELSIF pTASK_NUMBER = TASK_CURRENCY_CONVERSION THEN
6778: TSK_RM_CURRENCY_CONVERSION := TSK_RM_CURRENCY_CONVERSION - 1;
6779: IF TSK_RM_CURRENCY_CONVERSION = 0 THEN
6780: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CURRENCY_CONVERSIONS',lv_pctg,lv_deg);
6781: END IF;
6782: ELSIF pTASK_NUMBER = TASK_DELIVERY_DETAILS THEN
6783: TSK_RM_DELIVERY_DETAILS := TSK_RM_DELIVERY_DETAILS - 1;
6784: IF TSK_RM_DELIVERY_DETAILS = 0 THEN

Line 6785: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DELIVERY_DETAILS',lv_pctg,lv_deg);

6781: END IF;
6782: ELSIF pTASK_NUMBER = TASK_DELIVERY_DETAILS THEN
6783: TSK_RM_DELIVERY_DETAILS := TSK_RM_DELIVERY_DETAILS - 1;
6784: IF TSK_RM_DELIVERY_DETAILS = 0 THEN
6785: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DELIVERY_DETAILS',lv_pctg,lv_deg);
6786: END IF;
6787: END IF;
6788:
6789: