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

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

6590: FETCH tab_list INTO var_table_name;
6591:
6592: EXIT WHEN tab_list%NOTFOUND;
6593:
6594: fnd_stats.gather_table_stats(v_msc_schema, var_table_name, 10, 4);
6595:
6596: END LOOP;
6597:
6598: END ANALYZE_ALL_ST_TABLE;

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

6621: IF pTASK_NUMBER= TASK_BOM THEN
6622:
6623: TSK_RM_BOM_COMPONENTS:= TSK_RM_BOM_COMPONENTS - 1;
6624: IF TSK_RM_BOM_COMPONENTS=0 THEN
6625: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BOM_COMPONENTS',lv_pctg,lv_deg);
6626: END IF;
6627:
6628: TSK_RM_BOMS:= TSK_RM_BOMS - 1;
6629: IF TSK_RM_BOMS=0 THEN

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

6626: END IF;
6627:
6628: TSK_RM_BOMS:= TSK_RM_BOMS - 1;
6629: IF TSK_RM_BOMS=0 THEN
6630: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BOMS',lv_pctg,lv_deg);
6631: END IF;
6632:
6633: TSK_RM_COMPONENT_SUBSTITUTES:= TSK_RM_COMPONENT_SUBSTITUTES- 1;
6634: IF TSK_RM_COMPONENT_SUBSTITUTES=0 THEN

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

6631: END IF;
6632:
6633: TSK_RM_COMPONENT_SUBSTITUTES:= TSK_RM_COMPONENT_SUBSTITUTES- 1;
6634: IF TSK_RM_COMPONENT_SUBSTITUTES=0 THEN
6635: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_COMPONENT_SUBSTITUTES',lv_pctg,lv_deg);
6636: END IF;
6637:
6638: ELSIF pTASK_NUMBER= TASK_ROUTING THEN
6639:

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

6638: ELSIF pTASK_NUMBER= TASK_ROUTING THEN
6639:
6640: TSK_RM_ROUTINGS:= TSK_RM_ROUTINGS- 1;
6641: IF TSK_RM_ROUTINGS=0 THEN
6642: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ROUTINGS',lv_pctg,lv_deg);
6643: END IF;
6644:
6645: TSK_RM_ROUTING_OPERATIONS:= TSK_RM_ROUTING_OPERATIONS- 1;
6646: IF TSK_RM_ROUTING_OPERATIONS=0 THEN

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

6643: END IF;
6644:
6645: TSK_RM_ROUTING_OPERATIONS:= TSK_RM_ROUTING_OPERATIONS- 1;
6646: IF TSK_RM_ROUTING_OPERATIONS=0 THEN
6647: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ROUTING_OPERATIONS',lv_pctg,lv_deg);
6648: END IF;
6649:
6650: TSK_RM_OPERATION_RESOURCE_SEQS:= TSK_RM_OPERATION_RESOURCE_SEQS- 1;
6651: IF TSK_RM_OPERATION_RESOURCE_SEQS=0 THEN

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

6648: END IF;
6649:
6650: TSK_RM_OPERATION_RESOURCE_SEQS:= TSK_RM_OPERATION_RESOURCE_SEQS- 1;
6651: IF TSK_RM_OPERATION_RESOURCE_SEQS=0 THEN
6652: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPERATION_RESOURCE_SEQS',lv_pctg,lv_deg);
6653: END IF;
6654:
6655: TSK_RM_OPERATION_RESOURCES:= TSK_RM_OPERATION_RESOURCES- 1;
6656: IF TSK_RM_OPERATION_RESOURCES=0 THEN

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

6653: END IF;
6654:
6655: TSK_RM_OPERATION_RESOURCES:= TSK_RM_OPERATION_RESOURCES- 1;
6656: IF TSK_RM_OPERATION_RESOURCES=0 THEN
6657: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPERATION_RESOURCES',lv_pctg,lv_deg);
6658: END IF;
6659:
6660: TSK_RM_OPERATION_COMPONENTS:= TSK_RM_OPERATION_COMPONENTS- 1;
6661: IF TSK_RM_OPERATION_COMPONENTS=0 THEN

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

6658: END IF;
6659:
6660: TSK_RM_OPERATION_COMPONENTS:= TSK_RM_OPERATION_COMPONENTS- 1;
6661: IF TSK_RM_OPERATION_COMPONENTS=0 THEN
6662: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPERATION_COMPONENTS',lv_pctg,lv_deg);
6663: END IF;
6664:
6665: TSK_RM_PROCESS_EFFECTIVITY:= TSK_RM_PROCESS_EFFECTIVITY- 1;
6666: IF TSK_RM_PROCESS_EFFECTIVITY=0 THEN

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

6663: END IF;
6664:
6665: TSK_RM_PROCESS_EFFECTIVITY:= TSK_RM_PROCESS_EFFECTIVITY- 1;
6666: IF TSK_RM_PROCESS_EFFECTIVITY=0 THEN
6667: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PROCESS_EFFECTIVITY',lv_pctg,lv_deg);
6668: END IF;
6669:
6670: ELSIF pTASK_NUMBER= TASK_BOR THEN
6671:

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

6670: ELSIF pTASK_NUMBER= TASK_BOR THEN
6671:
6672: TSK_RM_BILL_OF_RESOURCES:= TSK_RM_BILL_OF_RESOURCES- 1;
6673: IF TSK_RM_BILL_OF_RESOURCES=0 THEN
6674: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BILL_OF_RESOURCES',lv_pctg,lv_deg);
6675: END IF;
6676:
6677: TSK_RM_BOR_REQUIREMENTS:= TSK_RM_BOR_REQUIREMENTS- 1;
6678: IF TSK_RM_BOR_REQUIREMENTS=0 THEN

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

6675: END IF;
6676:
6677: TSK_RM_BOR_REQUIREMENTS:= TSK_RM_BOR_REQUIREMENTS- 1;
6678: IF TSK_RM_BOR_REQUIREMENTS=0 THEN
6679: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BOR_REQUIREMENTS',lv_pctg,lv_deg);
6680: END IF;
6681:
6682: ELSIF pTASK_NUMBER= TASK_CALENDAR_DATE THEN
6683:

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

6682: ELSIF pTASK_NUMBER= TASK_CALENDAR_DATE THEN
6683:
6684: TSK_RM_RESOURCE_CHANGES:= TSK_RM_RESOURCE_CHANGES- 1;
6685: IF TSK_RM_RESOURCE_CHANGES=0 THEN
6686: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_CHANGES',lv_pctg,lv_deg);
6687: END IF;
6688:
6689: TSK_RM_CALENDAR_DATES:= TSK_RM_CALENDAR_DATES- 1;
6690: IF TSK_RM_CALENDAR_DATES=0 THEN

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

6687: END IF;
6688:
6689: TSK_RM_CALENDAR_DATES:= TSK_RM_CALENDAR_DATES- 1;
6690: IF TSK_RM_CALENDAR_DATES=0 THEN
6691: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_DATES',lv_pctg,lv_deg);
6692: END IF;
6693:
6694: TSK_RM_PERIOD_START_DATES:= TSK_RM_PERIOD_START_DATES- 1;
6695: IF TSK_RM_PERIOD_START_DATES=0 THEN

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

6692: END IF;
6693:
6694: TSK_RM_PERIOD_START_DATES:= TSK_RM_PERIOD_START_DATES- 1;
6695: IF TSK_RM_PERIOD_START_DATES=0 THEN
6696: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PERIOD_START_DATES',lv_pctg,lv_deg);
6697: END IF;
6698:
6699: TSK_RM_CAL_YEAR_START_DATES:= TSK_RM_CAL_YEAR_START_DATES- 1;
6700: IF TSK_RM_CAL_YEAR_START_DATES=0 THEN

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

6697: END IF;
6698:
6699: TSK_RM_CAL_YEAR_START_DATES:= TSK_RM_CAL_YEAR_START_DATES- 1;
6700: IF TSK_RM_CAL_YEAR_START_DATES=0 THEN
6701: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CAL_YEAR_START_DATES',lv_pctg,lv_deg);
6702: END IF;
6703:
6704: TSK_RM_CAL_WEEK_START_DATES:= TSK_RM_CAL_WEEK_START_DATES- 1;
6705: IF TSK_RM_CAL_WEEK_START_DATES=0 THEN

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

6702: END IF;
6703:
6704: TSK_RM_CAL_WEEK_START_DATES:= TSK_RM_CAL_WEEK_START_DATES- 1;
6705: IF TSK_RM_CAL_WEEK_START_DATES=0 THEN
6706: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CAL_WEEK_START_DATES',lv_pctg,lv_deg);
6707: END IF;
6708:
6709: TSK_RM_RESOURCE_SHIFTS:= TSK_RM_RESOURCE_SHIFTS- 1;
6710: IF TSK_RM_RESOURCE_SHIFTS=0 THEN

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

6707: END IF;
6708:
6709: TSK_RM_RESOURCE_SHIFTS:= TSK_RM_RESOURCE_SHIFTS- 1;
6710: IF TSK_RM_RESOURCE_SHIFTS=0 THEN
6711: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_SHIFTS',lv_pctg,lv_deg);
6712: END IF;
6713:
6714: TSK_RM_CALENDAR_SHIFTS:= TSK_RM_CALENDAR_SHIFTS- 1;
6715: IF TSK_RM_CALENDAR_SHIFTS=0 THEN

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

6712: END IF;
6713:
6714: TSK_RM_CALENDAR_SHIFTS:= TSK_RM_CALENDAR_SHIFTS- 1;
6715: IF TSK_RM_CALENDAR_SHIFTS=0 THEN
6716: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_SHIFTS',lv_pctg,lv_deg);
6717: END IF;
6718:
6719: TSK_RM_SHIFT_DATES:= TSK_RM_SHIFT_DATES- 1;
6720: IF TSK_RM_SHIFT_DATES=0 THEN

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

6717: END IF;
6718:
6719: TSK_RM_SHIFT_DATES:= TSK_RM_SHIFT_DATES- 1;
6720: IF TSK_RM_SHIFT_DATES=0 THEN
6721: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHIFT_DATES',lv_pctg,lv_deg);
6722: END IF;
6723:
6724: TSK_RM_SHIFT_TIMES:= TSK_RM_SHIFT_TIMES- 1;
6725: IF TSK_RM_SHIFT_TIMES=0 THEN

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

6722: END IF;
6723:
6724: TSK_RM_SHIFT_TIMES:= TSK_RM_SHIFT_TIMES- 1;
6725: IF TSK_RM_SHIFT_TIMES=0 THEN
6726: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHIFT_TIMES',lv_pctg,lv_deg);
6727: END IF;
6728:
6729: TSK_RM_SHIFT_EXCEPTIONS:= TSK_RM_SHIFT_EXCEPTIONS- 1;
6730: IF TSK_RM_SHIFT_EXCEPTIONS=0 THEN

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

6727: END IF;
6728:
6729: TSK_RM_SHIFT_EXCEPTIONS:= TSK_RM_SHIFT_EXCEPTIONS- 1;
6730: IF TSK_RM_SHIFT_EXCEPTIONS=0 THEN
6731: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHIFT_EXCEPTIONS',lv_pctg,lv_deg);
6732: END IF;
6733:
6734: TSK_RM_CALENDAR_ASSIGNMENTS:= TSK_RM_CALENDAR_ASSIGNMENTS- 1;
6735: IF TSK_RM_CALENDAR_ASSIGNMENTS=0 THEN

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

6732: END IF;
6733:
6734: TSK_RM_CALENDAR_ASSIGNMENTS:= TSK_RM_CALENDAR_ASSIGNMENTS- 1;
6735: IF TSK_RM_CALENDAR_ASSIGNMENTS=0 THEN
6736: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_ASSIGNMENTS',lv_pctg,lv_deg);
6737: END IF;
6738:
6739: TSK_RM_BIS_PERIODS:= TSK_RM_BIS_PERIODS- 1;
6740: IF TSK_RM_BIS_PERIODS=0 THEN

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

6737: END IF;
6738:
6739: TSK_RM_BIS_PERIODS:= TSK_RM_BIS_PERIODS- 1;
6740: IF TSK_RM_BIS_PERIODS=0 THEN
6741: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_PERIODS',lv_pctg,lv_deg);
6742: END IF;
6743:
6744: ELSIF pTASK_NUMBER= TASK_CATEGORY THEN
6745:

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

6744: ELSIF pTASK_NUMBER= TASK_CATEGORY THEN
6745:
6746: TSK_RM_ITEM_CATEGORIES:= TSK_RM_ITEM_CATEGORIES- 1;
6747: IF TSK_RM_ITEM_CATEGORIES=0 THEN
6748: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ITEM_CATEGORIES',lv_pctg,lv_deg);
6749: END IF;
6750:
6751: TSK_RM_CATEGORY_SETS:= TSK_RM_CATEGORY_SETS- 1;
6752: IF TSK_RM_CATEGORY_SETS=0 THEN

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

6749: END IF;
6750:
6751: TSK_RM_CATEGORY_SETS:= TSK_RM_CATEGORY_SETS- 1;
6752: IF TSK_RM_CATEGORY_SETS=0 THEN
6753: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CATEGORY_SETS',lv_pctg,lv_deg);
6754: END IF;
6755:
6756: ELSIF pTASK_NUMBER= TASK_MDS_DEMAND THEN
6757:

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

6756: ELSIF pTASK_NUMBER= TASK_MDS_DEMAND THEN
6757:
6758: TSK_RM_DEMANDS:= TSK_RM_DEMANDS- 1;
6759: IF TSK_RM_DEMANDS=0 THEN
6760: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);
6761: END IF;
6762:
6763: ELSIF pTASK_NUMBER= TASK_WIP_DEMAND THEN
6764:

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

6763: ELSIF pTASK_NUMBER= TASK_WIP_DEMAND THEN
6764:
6765: TSK_RM_DEMANDS:= TSK_RM_DEMANDS- 1;
6766: IF TSK_RM_DEMANDS=0 THEN
6767: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);
6768: END IF;
6769:
6770: ELSIF pTASK_NUMBER in (TASK_SALES_ORDER1,TASK_SALES_ORDER2,TASK_SALES_ORDER3,TASK_AHL) THEN
6771:

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

6770: ELSIF pTASK_NUMBER in (TASK_SALES_ORDER1,TASK_SALES_ORDER2,TASK_SALES_ORDER3,TASK_AHL) THEN
6771:
6772: TSK_RM_SALES_ORDERS:= TSK_RM_SALES_ORDERS- 1;
6773: IF TSK_RM_SALES_ORDERS=0 THEN
6774: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SALES_ORDERS',lv_pctg,lv_deg);
6775: END IF;
6776:
6777: ELSIF pTASK_NUMBER= TASK_HARD_RESERVATION THEN
6778:

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

6777: ELSIF pTASK_NUMBER= TASK_HARD_RESERVATION THEN
6778:
6779: TSK_RM_RESERVATIONS:= TSK_RM_RESERVATIONS- 1;
6780: IF TSK_RM_RESERVATIONS=0 THEN
6781: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESERVATIONS',lv_pctg,lv_deg);
6782: END IF;
6783:
6784: ELSIF pTASK_NUMBER IN ( TASK_ITEM1, TASK_ITEM2, TASK_ITEM3) THEN
6785:

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

6784: ELSIF pTASK_NUMBER IN ( TASK_ITEM1, TASK_ITEM2, TASK_ITEM3) THEN
6785:
6786: TSK_RM_SYSTEM_ITEMS:= TSK_RM_SYSTEM_ITEMS- 1;
6787: IF TSK_RM_SYSTEM_ITEMS=0 THEN
6788: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SYSTEM_ITEMS',lv_pctg,lv_deg);
6789: END IF;
6790:
6791: ELSIF pTASK_NUMBER = TASK_BUYER_CONTACT THEN
6792:

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

6791: ELSIF pTASK_NUMBER = TASK_BUYER_CONTACT THEN
6792:
6793: TSK_RM_PARTNER_CONTACTS:= TSK_RM_PARTNER_CONTACTS- 1;
6794: IF TSK_RM_PARTNER_CONTACTS=0 THEN
6795: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PARTNER_CONTACTS',lv_pctg,lv_deg);
6796: END IF;
6797:
6798: ELSIF pTASK_NUMBER = TASK_RESOURCE THEN
6799:

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

6798: ELSIF pTASK_NUMBER = TASK_RESOURCE THEN
6799:
6800: TSK_RM_DEPARTMENT_RESOURCES:= TSK_RM_DEPARTMENT_RESOURCES- 1;
6801: IF TSK_RM_DEPARTMENT_RESOURCES=0 THEN
6802: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEPARTMENT_RESOURCES',lv_pctg,lv_deg);
6803: END IF;
6804:
6805: TSK_RM_SIMULATION_SETS:= TSK_RM_SIMULATION_SETS- 1;
6806: IF TSK_RM_SIMULATION_SETS=0 THEN

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

6803: END IF;
6804:
6805: TSK_RM_SIMULATION_SETS:= TSK_RM_SIMULATION_SETS- 1;
6806: IF TSK_RM_SIMULATION_SETS=0 THEN
6807: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SIMULATION_SETS',lv_pctg,lv_deg);
6808: END IF;
6809:
6810: TSK_RM_RESOURCE_GROUPS:= TSK_RM_RESOURCE_GROUPS- 1;
6811: IF TSK_RM_RESOURCE_GROUPS=0 THEN

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

6808: END IF;
6809:
6810: TSK_RM_RESOURCE_GROUPS:= TSK_RM_RESOURCE_GROUPS- 1;
6811: IF TSK_RM_RESOURCE_GROUPS=0 THEN
6812: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_GROUPS',lv_pctg,lv_deg);
6813: END IF;
6814:
6815: TSK_RM_RESOURCE_REQUIREMENTS:= TSK_RM_RESOURCE_REQUIREMENTS- 1;
6816: IF TSK_RM_RESOURCE_REQUIREMENTS=0 THEN

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

6813: END IF;
6814:
6815: TSK_RM_RESOURCE_REQUIREMENTS:= TSK_RM_RESOURCE_REQUIREMENTS- 1;
6816: IF TSK_RM_RESOURCE_REQUIREMENTS=0 THEN
6817: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_RESOURCE_REQUIREMENTS',lv_pctg,lv_deg);
6818: END IF;
6819:
6820: ELSIF pTASK_NUMBER = TASK_SAFETY_STOCK THEN
6821:

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

6820: ELSIF pTASK_NUMBER = TASK_SAFETY_STOCK THEN
6821:
6822: TSK_RM_SAFETY_STOCKS:= TSK_RM_SAFETY_STOCKS- 1;
6823: IF TSK_RM_SAFETY_STOCKS=0 THEN
6824: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SAFETY_STOCKS',lv_pctg,lv_deg);
6825: END IF;
6826:
6827: ELSIF pTASK_NUMBER = TASK_SCHEDULE THEN
6828:

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

6827: ELSIF pTASK_NUMBER = TASK_SCHEDULE THEN
6828:
6829: TSK_RM_DESIGNATORS:= TSK_RM_DESIGNATORS- 1;
6830: IF TSK_RM_DESIGNATORS=0 THEN
6831: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DESIGNATORS',lv_pctg,lv_deg);
6832: END IF;
6833:
6834: ELSIF pTASK_NUMBER = TASK_SOURCING THEN
6835:

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

6834: ELSIF pTASK_NUMBER = TASK_SOURCING THEN
6835:
6836: TSK_RM_ASSIGNMENT_SETS:= TSK_RM_ASSIGNMENT_SETS- 1;
6837: IF TSK_RM_ASSIGNMENT_SETS=0 THEN
6838: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ASSIGNMENT_SETS',lv_pctg,lv_deg);
6839: END IF;
6840:
6841: TSK_RM_SR_ASSIGNMENTS:= TSK_RM_SR_ASSIGNMENTS- 1;
6842: IF TSK_RM_SR_ASSIGNMENTS=0 THEN

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

6839: END IF;
6840:
6841: TSK_RM_SR_ASSIGNMENTS:= TSK_RM_SR_ASSIGNMENTS- 1;
6842: IF TSK_RM_SR_ASSIGNMENTS=0 THEN
6843: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_ASSIGNMENTS',lv_pctg,lv_deg);
6844: END IF;
6845:
6846: TSK_RM_SOURCING_RULES:= TSK_RM_SOURCING_RULES- 1;
6847: IF TSK_RM_SOURCING_RULES=0 THEN

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

6844: END IF;
6845:
6846: TSK_RM_SOURCING_RULES:= TSK_RM_SOURCING_RULES- 1;
6847: IF TSK_RM_SOURCING_RULES=0 THEN
6848: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SOURCING_RULES',lv_pctg,lv_deg);
6849: END IF;
6850:
6851: TSK_RM_SR_RECEIPT_ORG:= TSK_RM_SR_RECEIPT_ORG- 1;
6852: IF TSK_RM_SR_RECEIPT_ORG=0 THEN

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

6849: END IF;
6850:
6851: TSK_RM_SR_RECEIPT_ORG:= TSK_RM_SR_RECEIPT_ORG- 1;
6852: IF TSK_RM_SR_RECEIPT_ORG=0 THEN
6853: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_RECEIPT_ORG',lv_pctg,lv_deg);
6854: END IF;
6855:
6856: TSK_RM_SR_SOURCE_ORG:= TSK_RM_SR_SOURCE_ORG- 1;
6857: IF TSK_RM_SR_SOURCE_ORG=0 THEN

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

6854: END IF;
6855:
6856: TSK_RM_SR_SOURCE_ORG:= TSK_RM_SR_SOURCE_ORG- 1;
6857: IF TSK_RM_SR_SOURCE_ORG=0 THEN
6858: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_SOURCE_ORG',lv_pctg,lv_deg);
6859: END IF;
6860:
6861: TSK_RM_INTERORG_SHIP_METHODS:= TSK_RM_INTERORG_SHIP_METHODS- 1;
6862: IF TSK_RM_INTERORG_SHIP_METHODS=0 THEN

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

6859: END IF;
6860:
6861: TSK_RM_INTERORG_SHIP_METHODS:= TSK_RM_INTERORG_SHIP_METHODS- 1;
6862: IF TSK_RM_INTERORG_SHIP_METHODS=0 THEN
6863: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_INTERORG_SHIP_METHODS',lv_pctg,lv_deg);
6864: END IF;
6865:
6866: TSK_RM_REGIONS := TSK_RM_REGIONS - 1;
6867: IF TSK_RM_REGIONS = 0 THEN

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

6864: END IF;
6865:
6866: TSK_RM_REGIONS := TSK_RM_REGIONS - 1;
6867: IF TSK_RM_REGIONS = 0 THEN
6868: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_REGIONS',lv_pctg,lv_deg);
6869: END IF;
6870:
6871: TSK_RM_ZONE_REGIONS := TSK_RM_ZONE_REGIONS - 1;
6872: IF TSK_RM_ZONE_REGIONS = 0 THEN

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

6869: END IF;
6870:
6871: TSK_RM_ZONE_REGIONS := TSK_RM_ZONE_REGIONS - 1;
6872: IF TSK_RM_ZONE_REGIONS = 0 THEN
6873: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ZONE_REGIONS',lv_pctg,lv_deg);
6874: END IF;
6875:
6876: TSK_RM_CARRIER_SERVICES:= TSK_RM_CARRIER_SERVICES- 1;
6877: IF TSK_RM_CARRIER_SERVICES=0 THEN

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

6874: END IF;
6875:
6876: TSK_RM_CARRIER_SERVICES:= TSK_RM_CARRIER_SERVICES- 1;
6877: IF TSK_RM_CARRIER_SERVICES=0 THEN
6878: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CARRIER_SERVICES',lv_pctg,lv_deg);
6879: END IF;
6880:
6881: TSK_RM_REGION_SITES:= TSK_RM_REGION_SITES- 1;
6882: IF TSK_RM_REGION_SITES=0 THEN

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

6879: END IF;
6880:
6881: TSK_RM_REGION_SITES:= TSK_RM_REGION_SITES- 1;
6882: IF TSK_RM_REGION_SITES=0 THEN
6883: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_REGION_SITES',lv_pctg,lv_deg);
6884: END IF;
6885:
6886: ELSIF pTASK_NUMBER = TASK_SUB_INVENTORY THEN
6887:

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

6886: ELSIF pTASK_NUMBER = TASK_SUB_INVENTORY THEN
6887:
6888: TSK_RM_SUB_INVENTORIES:= TSK_RM_SUB_INVENTORIES- 1;
6889: IF TSK_RM_SUB_INVENTORIES=0 THEN
6890: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUB_INVENTORIES',lv_pctg,lv_deg);
6891: END IF;
6892:
6893: ELSIF pTASK_NUMBER = TASK_SUPPLIER_CAPACITY THEN
6894:

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

6893: ELSIF pTASK_NUMBER = TASK_SUPPLIER_CAPACITY THEN
6894:
6895: TSK_RM_ITEM_SUPPLIERS:= TSK_RM_ITEM_SUPPLIERS- 1;
6896: IF TSK_RM_ITEM_SUPPLIERS=0 THEN
6897: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ITEM_SUPPLIERS',lv_pctg,lv_deg);
6898: END IF;
6899:
6900: TSK_RM_SUPPLIER_CAPACITIES:= TSK_RM_SUPPLIER_CAPACITIES- 1;
6901: IF TSK_RM_SUPPLIER_CAPACITIES=0 THEN

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

6898: END IF;
6899:
6900: TSK_RM_SUPPLIER_CAPACITIES:= TSK_RM_SUPPLIER_CAPACITIES- 1;
6901: IF TSK_RM_SUPPLIER_CAPACITIES=0 THEN
6902: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIER_CAPACITIES',lv_pctg,lv_deg);
6903: END IF;
6904:
6905: TSK_RM_SUPPLIER_FLEX_FENCES:= TSK_RM_SUPPLIER_FLEX_FENCES- 1;
6906: IF TSK_RM_SUPPLIER_FLEX_FENCES=0 THEN

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

6903: END IF;
6904:
6905: TSK_RM_SUPPLIER_FLEX_FENCES:= TSK_RM_SUPPLIER_FLEX_FENCES- 1;
6906: IF TSK_RM_SUPPLIER_FLEX_FENCES=0 THEN
6907: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIER_FLEX_FENCES',lv_pctg,lv_deg);
6908: END IF;
6909:
6910: 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
6911:

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

6910: 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
6911:
6912: TSK_RM_SUPPLIES:= TSK_RM_SUPPLIES- 1;
6913: IF TSK_RM_SUPPLIES=0 THEN
6914: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIES',lv_pctg,lv_deg);
6915: END IF;
6916:
6917: TSK_RM_JOB_OP_NETWORKS := TSK_RM_JOB_OP_NETWORKS - 1;
6918: IF TSK_RM_JOB_OP_NETWORKS=0 THEN

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

6915: END IF;
6916:
6917: TSK_RM_JOB_OP_NETWORKS := TSK_RM_JOB_OP_NETWORKS - 1;
6918: IF TSK_RM_JOB_OP_NETWORKS=0 THEN
6919: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_OPERATION_NETWORKS',lv_pctg,lv_deg);
6920: END IF;
6921:
6922: TSK_RM_JOB_OPERATIONS := TSK_RM_JOB_OPERATIONS - 1;
6923: IF TSK_RM_JOB_OPERATIONS=0 THEN

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

6920: END IF;
6921:
6922: TSK_RM_JOB_OPERATIONS := TSK_RM_JOB_OPERATIONS - 1;
6923: IF TSK_RM_JOB_OPERATIONS=0 THEN
6924: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_OPERATIONS',lv_pctg,lv_deg);
6925: END IF;
6926:
6927: TSK_RM_JOB_REQUIREMENT_OPS := TSK_RM_JOB_REQUIREMENT_OPS - 1;
6928: IF TSK_RM_JOB_REQUIREMENT_OPS=0 THEN

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

6925: END IF;
6926:
6927: TSK_RM_JOB_REQUIREMENT_OPS := TSK_RM_JOB_REQUIREMENT_OPS - 1;
6928: IF TSK_RM_JOB_REQUIREMENT_OPS=0 THEN
6929: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_REQUIREMENT_OPS',lv_pctg,lv_deg);
6930: END IF;
6931:
6932: TSK_RM_JOB_OP_RESOURCES := TSK_RM_JOB_OP_RESOURCES - 1;
6933: IF TSK_RM_JOB_OP_RESOURCES=0 THEN

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

6930: END IF;
6931:
6932: TSK_RM_JOB_OP_RESOURCES := TSK_RM_JOB_OP_RESOURCES - 1;
6933: IF TSK_RM_JOB_OP_RESOURCES=0 THEN
6934: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_JOB_OP_RESOURCES',lv_pctg,lv_deg);
6935: END IF;
6936:
6937: ELSIF pTASK_NUMBER = TASK_TRADING_PARTNER THEN
6938:

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

6937: ELSIF pTASK_NUMBER = TASK_TRADING_PARTNER THEN
6938:
6939: TSK_RM_TRADING_PARTNERS:= TSK_RM_TRADING_PARTNERS- 1;
6940: IF TSK_RM_TRADING_PARTNERS=0 THEN
6941: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRADING_PARTNERS',lv_pctg,lv_deg);
6942: END IF;
6943:
6944: TSK_RM_TRADING_PARTNER_SITES:= TSK_RM_TRADING_PARTNER_SITES- 1;
6945: IF TSK_RM_TRADING_PARTNER_SITES=0 THEN

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

6942: END IF;
6943:
6944: TSK_RM_TRADING_PARTNER_SITES:= TSK_RM_TRADING_PARTNER_SITES- 1;
6945: IF TSK_RM_TRADING_PARTNER_SITES=0 THEN
6946: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRADING_PARTNER_SITES',lv_pctg,lv_deg);
6947: END IF;
6948:
6949: TSK_RM_LOCATION_ASSOCIATIONS:= TSK_RM_LOCATION_ASSOCIATIONS- 1;
6950: IF TSK_RM_LOCATION_ASSOCIATIONS=0 THEN

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

6947: END IF;
6948:
6949: TSK_RM_LOCATION_ASSOCIATIONS:= TSK_RM_LOCATION_ASSOCIATIONS- 1;
6950: IF TSK_RM_LOCATION_ASSOCIATIONS=0 THEN
6951: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_LOCATION_ASSOCIATIONS',lv_pctg,lv_deg);
6952: END IF;
6953:
6954: TSK_RM_PARTNER_CONTACTS:= TSK_RM_PARTNER_CONTACTS- 1;
6955: IF TSK_RM_PARTNER_CONTACTS=0 THEN

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

6952: END IF;
6953:
6954: TSK_RM_PARTNER_CONTACTS:= TSK_RM_PARTNER_CONTACTS- 1;
6955: IF TSK_RM_PARTNER_CONTACTS=0 THEN
6956: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PARTNER_CONTACTS',lv_pctg,lv_deg);
6957: END IF;
6958:
6959: ELSIF pTASK_NUMBER = TASK_UNIT_NUMBER THEN
6960:

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

6959: ELSIF pTASK_NUMBER = TASK_UNIT_NUMBER THEN
6960:
6961: TSK_RM_UNIT_NUMBERS:= TSK_RM_UNIT_NUMBERS- 1;
6962: IF TSK_RM_UNIT_NUMBERS=0 THEN
6963: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UNIT_NUMBERS',lv_pctg,lv_deg);
6964: END IF;
6965:
6966: ELSIF pTASK_NUMBER = TASK_PROJECT THEN
6967:

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

6966: ELSIF pTASK_NUMBER = TASK_PROJECT THEN
6967:
6968: TSK_RM_PROJECTS:= TSK_RM_PROJECTS- 1;
6969: IF TSK_RM_PROJECTS=0 THEN
6970: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PROJECTS',lv_pctg,lv_deg);
6971: END IF;
6972:
6973: TSK_RM_PROJECT_TASKS:= TSK_RM_PROJECT_TASKS- 1;
6974: IF TSK_RM_PROJECT_TASKS=0 THEN

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

6971: END IF;
6972:
6973: TSK_RM_PROJECT_TASKS:= TSK_RM_PROJECT_TASKS- 1;
6974: IF TSK_RM_PROJECT_TASKS=0 THEN
6975: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PROJECT_TASKS',lv_pctg,lv_deg);
6976: END IF;
6977:
6978: ELSIF pTASK_NUMBER = TASK_PARAMETER THEN
6979:

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

6978: ELSIF pTASK_NUMBER = TASK_PARAMETER THEN
6979:
6980: TSK_RM_PARAMETERS:= TSK_RM_PARAMETERS- 1;
6981: IF TSK_RM_PARAMETERS=0 THEN
6982: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PARAMETERS',lv_pctg,lv_deg);
6983: END IF;
6984:
6985: ELSIF pTASK_NUMBER = TASK_UOM THEN
6986:

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

6985: ELSIF pTASK_NUMBER = TASK_UOM THEN
6986:
6987: TSK_RM_UNITS_OF_MEASURE:= TSK_RM_UNITS_OF_MEASURE- 1;
6988: IF TSK_RM_UNITS_OF_MEASURE=0 THEN
6989: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UNITS_OF_MEASURE',lv_pctg,lv_deg);
6990: END IF;
6991:
6992: TSK_RM_UOM_CLASS_CONVERSIONS:= TSK_RM_UOM_CLASS_CONVERSIONS- 1;
6993: IF TSK_RM_UOM_CLASS_CONVERSIONS=0 THEN

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

6990: END IF;
6991:
6992: TSK_RM_UOM_CLASS_CONVERSIONS:= TSK_RM_UOM_CLASS_CONVERSIONS- 1;
6993: IF TSK_RM_UOM_CLASS_CONVERSIONS=0 THEN
6994: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UOM_CLASS_CONVERSIONS',lv_pctg,lv_deg);
6995: END IF;
6996:
6997: TSK_RM_UOM_CONVERSIONS:= TSK_RM_UOM_CONVERSIONS- 1;
6998: IF TSK_RM_UOM_CONVERSIONS=0 THEN

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

6995: END IF;
6996:
6997: TSK_RM_UOM_CONVERSIONS:= TSK_RM_UOM_CONVERSIONS- 1;
6998: IF TSK_RM_UOM_CONVERSIONS=0 THEN
6999: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_UOM_CONVERSIONS',lv_pctg,lv_deg);
7000: END IF;
7001:
7002: ELSIF pTASK_NUMBER = TASK_BIS THEN
7003:

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

7002: ELSIF pTASK_NUMBER = TASK_BIS THEN
7003:
7004: TSK_RM_BIS_PFMC_MEASURES:= TSK_RM_BIS_PFMC_MEASURES- 1;
7005: IF TSK_RM_BIS_PFMC_MEASURES=0 THEN
7006: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_PFMC_MEASURES',lv_pctg,lv_deg);
7007: END IF;
7008:
7009: TSK_RM_BIS_TARGET_LEVELS:= TSK_RM_BIS_TARGET_LEVELS- 1;
7010: IF TSK_RM_BIS_TARGET_LEVELS=0 THEN

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

7007: END IF;
7008:
7009: TSK_RM_BIS_TARGET_LEVELS:= TSK_RM_BIS_TARGET_LEVELS- 1;
7010: IF TSK_RM_BIS_TARGET_LEVELS=0 THEN
7011: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_TARGET_LEVELS',lv_pctg,lv_deg);
7012: END IF;
7013:
7014: TSK_RM_BIS_TARGETS:= TSK_RM_BIS_TARGETS- 1;
7015: IF TSK_RM_BIS_TARGETS=0 THEN

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

7012: END IF;
7013:
7014: TSK_RM_BIS_TARGETS:= TSK_RM_BIS_TARGETS- 1;
7015: IF TSK_RM_BIS_TARGETS=0 THEN
7016: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_TARGETS',lv_pctg,lv_deg);
7017: END IF;
7018:
7019: TSK_RM_BIS_BUSINESS_PLANS:= TSK_RM_BIS_BUSINESS_PLANS- 1;
7020: IF TSK_RM_BIS_BUSINESS_PLANS=0 THEN

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

7017: END IF;
7018:
7019: TSK_RM_BIS_BUSINESS_PLANS:= TSK_RM_BIS_BUSINESS_PLANS- 1;
7020: IF TSK_RM_BIS_BUSINESS_PLANS=0 THEN
7021: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_BIS_BUSINESS_PLANS',lv_pctg,lv_deg);
7022: END IF;
7023:
7024: ELSIF pTASK_NUMBER = TASK_ATP_RULES THEN
7025:

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

7024: ELSIF pTASK_NUMBER = TASK_ATP_RULES THEN
7025:
7026: TSK_RM_ATP_RULES:= TSK_RM_ATP_RULES- 1;
7027: IF TSK_RM_ATP_RULES=0 THEN
7028: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ATP_RULES',lv_pctg,lv_deg);
7029: END IF;
7030:
7031: ELSIF pTASK_NUMBER = TASK_USER_SUPPLY THEN
7032:

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

7031: ELSIF pTASK_NUMBER = TASK_USER_SUPPLY THEN
7032:
7033: TSK_RM_SUPPLIES:= TSK_RM_SUPPLIES- 1;
7034: IF TSK_RM_SUPPLIES=0 THEN
7035: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIES',lv_pctg,lv_deg);
7036: END IF;
7037:
7038: ELSIF pTASK_NUMBER = TASK_USER_DEMAND THEN
7039:

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

7038: ELSIF pTASK_NUMBER = TASK_USER_DEMAND THEN
7039:
7040: TSK_RM_DEMANDS:= TSK_RM_DEMANDS- 1;
7041: IF TSK_RM_DEMANDS=0 THEN
7042: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);
7043: END IF;
7044:
7045: ELSIF pTASK_NUMBER = TASK_PLANNERS THEN
7046:

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

7045: ELSIF pTASK_NUMBER = TASK_PLANNERS THEN
7046:
7047: TSK_RM_PLANNERS:= TSK_RM_PLANNERS- 1;
7048: IF TSK_RM_PLANNERS=0 THEN
7049: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_PLANNERS',lv_pctg,lv_deg);
7050: END IF;
7051:
7052: ELSIF pTASK_NUMBER = TASK_DEMAND_CLASS THEN
7053:

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

7052: ELSIF pTASK_NUMBER = TASK_DEMAND_CLASS THEN
7053:
7054: TSK_RM_DEMAND_CLASSES:= TSK_RM_DEMAND_CLASSES- 1;
7055: IF TSK_RM_DEMAND_CLASSES=0 THEN
7056: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMAND_CLASSES',lv_pctg,lv_deg);
7057: END IF;
7058:
7059: ELSIF pTASK_NUMBER = TASK_ITEM_SUBSTITUTES THEN
7060:

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

7059: ELSIF pTASK_NUMBER = TASK_ITEM_SUBSTITUTES THEN
7060:
7061: TSK_RM_ITEM_SUBSTITUTES := TSK_RM_ITEM_SUBSTITUTES - 1;
7062: IF TSK_RM_ITEM_SUBSTITUTES = 0 THEN
7063: FND_STATS.gather_table_stats(lv_owner,'MSC_ST_ITEM_SUBSTITUTES',lv_pctg,lv_deg);
7064: END IF;
7065:
7066: ELSIF pTASK_NUMBER = TASK_TRIP THEN
7067:

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

7066: ELSIF pTASK_NUMBER = TASK_TRIP THEN
7067:
7068: TSK_RM_TRIPS := TSK_RM_TRIPS - 1;
7069: IF TSK_RM_TRIPS = 0 THEN
7070: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRIPS',lv_pctg,lv_deg);
7071: END IF;
7072:
7073: TSK_RM_TRIP_STOPS := TSK_RM_TRIP_STOPS - 1;
7074: IF TSK_RM_TRIP_STOPS = 0 THEN

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

7071: END IF;
7072:
7073: TSK_RM_TRIP_STOPS := TSK_RM_TRIP_STOPS - 1;
7074: IF TSK_RM_TRIP_STOPS = 0 THEN
7075: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_TRIP_STOPS',lv_pctg,lv_deg);
7076: END IF;
7077: /* ds change start */
7078: ELSIF pTASK_NUMBER = TASK_RESOURCE_INSTANCE THEN
7079: TSK_RM_RESOURCE_INSTANCE := TSK_RM_RESOURCE_INSTANCE -1;

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

7077: /* ds change start */
7078: ELSIF pTASK_NUMBER = TASK_RESOURCE_INSTANCE THEN
7079: TSK_RM_RESOURCE_INSTANCE := TSK_RM_RESOURCE_INSTANCE -1;
7080: IF TSK_RM_RESOURCE_INSTANCE = 0 THEN
7081: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_DEPT_RES_INSTANCES',lv_pctg,lv_deg);
7082: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_INSTANCE_REQS',lv_pctg,lv_deg);
7083: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_JOB_OP_RES_INSTANCES',lv_pctg,lv_deg);
7084: END IF;
7085: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN

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

7078: ELSIF pTASK_NUMBER = TASK_RESOURCE_INSTANCE THEN
7079: TSK_RM_RESOURCE_INSTANCE := TSK_RM_RESOURCE_INSTANCE -1;
7080: IF TSK_RM_RESOURCE_INSTANCE = 0 THEN
7081: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_DEPT_RES_INSTANCES',lv_pctg,lv_deg);
7082: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_INSTANCE_REQS',lv_pctg,lv_deg);
7083: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_JOB_OP_RES_INSTANCES',lv_pctg,lv_deg);
7084: END IF;
7085: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN
7086: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;

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

7079: TSK_RM_RESOURCE_INSTANCE := TSK_RM_RESOURCE_INSTANCE -1;
7080: IF TSK_RM_RESOURCE_INSTANCE = 0 THEN
7081: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_DEPT_RES_INSTANCES',lv_pctg,lv_deg);
7082: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_INSTANCE_REQS',lv_pctg,lv_deg);
7083: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_JOB_OP_RES_INSTANCES',lv_pctg,lv_deg);
7084: END IF;
7085: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN
7086: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;
7087: IF TSK_RM_RESOURCE_SETUP = 0 THEN

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

7084: END IF;
7085: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN
7086: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;
7087: IF TSK_RM_RESOURCE_SETUP = 0 THEN
7088: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_SETUPS',lv_pctg,lv_deg);
7089: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_SETUP_TRANSITIONS',lv_pctg,lv_deg);
7090: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_STD_OP_RESOURCES',lv_pctg,lv_deg);
7091: END IF;
7092: /* ds change end */

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

7085: ELSIF pTASK_NUMBER = TASK_RESOURCE_SETUP THEN
7086: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;
7087: IF TSK_RM_RESOURCE_SETUP = 0 THEN
7088: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_SETUPS',lv_pctg,lv_deg);
7089: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_SETUP_TRANSITIONS',lv_pctg,lv_deg);
7090: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_STD_OP_RESOURCES',lv_pctg,lv_deg);
7091: END IF;
7092: /* ds change end */
7093: ELSIF pTASK_NUMBER = TASK_ABC_CLASSES THEN

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

7086: TSK_RM_RESOURCE_SETUP := TSK_RM_RESOURCE_SETUP -1;
7087: IF TSK_RM_RESOURCE_SETUP = 0 THEN
7088: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_RESOURCE_SETUPS',lv_pctg,lv_deg);
7089: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_SETUP_TRANSITIONS',lv_pctg,lv_deg);
7090: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_STD_OP_RESOURCES',lv_pctg,lv_deg);
7091: END IF;
7092: /* ds change end */
7093: ELSIF pTASK_NUMBER = TASK_ABC_CLASSES THEN
7094: TSK_RM_ABC_CLASSES := TSK_RM_ABC_CLASSES - 1;

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

7092: /* ds change end */
7093: ELSIF pTASK_NUMBER = TASK_ABC_CLASSES THEN
7094: TSK_RM_ABC_CLASSES := TSK_RM_ABC_CLASSES - 1;
7095: IF TSK_RM_ABC_CLASSES =0 THEN
7096: FND_STATS.gather_table_stats(lv_owner, 'MSC_ST_ABC_CLASSES',lv_pctg,lv_deg);
7097: END IF;
7098:
7099: ELSIF pTASK_NUMBER = TASK_FISCAL_CALENDAR THEN
7100: TSK_RM_FISCAL_CALENDAR := TSK_RM_FISCAL_CALENDAR - 1;

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

7098:
7099: ELSIF pTASK_NUMBER = TASK_FISCAL_CALENDAR THEN
7100: TSK_RM_FISCAL_CALENDAR := TSK_RM_FISCAL_CALENDAR - 1;
7101: IF TSK_RM_FISCAL_CALENDAR = 0 THEN
7102: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CALENDAR_MONTHS',lv_pctg,lv_deg);
7103: END IF;
7104:
7105: ELSIF pTASK_NUMBER = TASK_SALES_CHANNEL THEN
7106: TSK_RM_SALES_CHANNEL := TSK_RM_SALES_CHANNEL - 1;

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

7104:
7105: ELSIF pTASK_NUMBER = TASK_SALES_CHANNEL THEN
7106: TSK_RM_SALES_CHANNEL := TSK_RM_SALES_CHANNEL - 1;
7107: IF TSK_RM_SALES_CHANNEL = 0 THEN
7108: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SR_LOOKUPS',lv_pctg,lv_deg);
7109: END IF;
7110:
7111: ELSIF pTASK_NUMBER = TASK_IRO THEN
7112: TSK_RM_INTERNAL_REPAIR := TSK_RM_INTERNAL_REPAIR - 1;

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

7110:
7111: ELSIF pTASK_NUMBER = TASK_IRO THEN
7112: TSK_RM_INTERNAL_REPAIR := TSK_RM_INTERNAL_REPAIR - 1;
7113: IF TSK_RM_INTERNAL_REPAIR = 0 THEN
7114: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SUPPLIES',lv_pctg,lv_deg);
7115: END IF;
7116:
7117: ELSIF pTASK_NUMBER = TASK_IRO_DEMAND THEN
7118: TSK_RM_INTERNAL_REPAIR := TSK_RM_INTERNAL_REPAIR - 1;

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

7116:
7117: ELSIF pTASK_NUMBER = TASK_IRO_DEMAND THEN
7118: TSK_RM_INTERNAL_REPAIR := TSK_RM_INTERNAL_REPAIR - 1;
7119: IF TSK_RM_INTERNAL_REPAIR = 0 THEN
7120: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DEMANDS',lv_pctg,lv_deg);
7121: END IF;
7122: ELSIF pTASK_NUMBER = TASK_PAYBACK_DEMAND_SUPPLY THEN
7123: TSK_RM_PAYBACK_DEMAND_SUPPLY := TSK_RM_PAYBACK_DEMAND_SUPPLY - 1;
7124: IF TSK_RM_PAYBACK_DEMAND_SUPPLY = 0 THEN

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

7121: END IF;
7122: ELSIF pTASK_NUMBER = TASK_PAYBACK_DEMAND_SUPPLY THEN
7123: TSK_RM_PAYBACK_DEMAND_SUPPLY := TSK_RM_PAYBACK_DEMAND_SUPPLY - 1;
7124: IF TSK_RM_PAYBACK_DEMAND_SUPPLY = 0 THEN
7125: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_OPEN_PAYBACKS',lv_pctg,lv_deg);
7126: END IF;
7127: ELSIF pTASK_NUMBER = TASK_CURRENCY_CONVERSION THEN
7128: TSK_RM_CURRENCY_CONVERSION := TSK_RM_CURRENCY_CONVERSION - 1;
7129: IF TSK_RM_CURRENCY_CONVERSION = 0 THEN

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

7126: END IF;
7127: ELSIF pTASK_NUMBER = TASK_CURRENCY_CONVERSION THEN
7128: TSK_RM_CURRENCY_CONVERSION := TSK_RM_CURRENCY_CONVERSION - 1;
7129: IF TSK_RM_CURRENCY_CONVERSION = 0 THEN
7130: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_CURRENCY_CONVERSIONS',lv_pctg,lv_deg);
7131: END IF;
7132: ELSIF pTASK_NUMBER = TASK_DELIVERY_DETAILS THEN
7133: TSK_RM_DELIVERY_DETAILS := TSK_RM_DELIVERY_DETAILS - 1;
7134: IF TSK_RM_DELIVERY_DETAILS = 0 THEN

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

7131: END IF;
7132: ELSIF pTASK_NUMBER = TASK_DELIVERY_DETAILS THEN
7133: TSK_RM_DELIVERY_DETAILS := TSK_RM_DELIVERY_DETAILS - 1;
7134: IF TSK_RM_DELIVERY_DETAILS = 0 THEN
7135: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DELIVERY_DETAILS',lv_pctg,lv_deg);
7136: END IF;
7137: ELSIF pTASK_NUMBER = TASK_IBUC_HISTORY THEN
7138: TSK_RM_IBUC_HISTORY := TSK_RM_IBUC_HISTORY - 1;
7139: IF TSK_RM_IBUC_HISTORY = 0 THEN

Line 7140: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ZN_AGGR_IBUC',lv_pctg,lv_deg);

7136: END IF;
7137: ELSIF pTASK_NUMBER = TASK_IBUC_HISTORY THEN
7138: TSK_RM_IBUC_HISTORY := TSK_RM_IBUC_HISTORY - 1;
7139: IF TSK_RM_IBUC_HISTORY = 0 THEN
7140: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_ZN_AGGR_IBUC',lv_pctg,lv_deg);
7141: END IF;
7142: ELSIF pTASK_NUMBER = TASK_SHORT_TEXT THEN
7143: TSK_RM_SHORT_TEXT := TSK_RM_SHORT_TEXT - 1;
7144: IF TSK_RM_SHORT_TEXT = 0 THEN

Line 7145: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DOC_ATTACHMENTS',lv_pctg,lv_deg);

7141: END IF;
7142: ELSIF pTASK_NUMBER = TASK_SHORT_TEXT THEN
7143: TSK_RM_SHORT_TEXT := TSK_RM_SHORT_TEXT - 1;
7144: IF TSK_RM_SHORT_TEXT = 0 THEN
7145: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DOC_ATTACHMENTS',lv_pctg,lv_deg);
7146: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHORT_TEXT',lv_pctg,lv_deg);
7147: END IF;
7148: ELSIF pTASK_NUMBER = TASK_LONG_TEXT THEN
7149: TSK_RM_LONG_TEXT := TSK_RM_LONG_TEXT - 1;

Line 7146: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHORT_TEXT',lv_pctg,lv_deg);

7142: ELSIF pTASK_NUMBER = TASK_SHORT_TEXT THEN
7143: TSK_RM_SHORT_TEXT := TSK_RM_SHORT_TEXT - 1;
7144: IF TSK_RM_SHORT_TEXT = 0 THEN
7145: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_DOC_ATTACHMENTS',lv_pctg,lv_deg);
7146: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_SHORT_TEXT',lv_pctg,lv_deg);
7147: END IF;
7148: ELSIF pTASK_NUMBER = TASK_LONG_TEXT THEN
7149: TSK_RM_LONG_TEXT := TSK_RM_LONG_TEXT - 1;
7150: IF TSK_RM_LONG_TEXT = 0 THEN

Line 7151: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_LONG_TEXT',lv_pctg,lv_deg);

7147: END IF;
7148: ELSIF pTASK_NUMBER = TASK_LONG_TEXT THEN
7149: TSK_RM_LONG_TEXT := TSK_RM_LONG_TEXT - 1;
7150: IF TSK_RM_LONG_TEXT = 0 THEN
7151: FND_STATS.gather_table_stats( lv_owner,'MSC_ST_LONG_TEXT',lv_pctg,lv_deg);
7152: END IF;
7153: END IF;
7154:
7155: