APPS.MTH_UPDATE_ERR_PKG dependencies on FND_DATE

Line 166: ,REPORT_DATE = fnd_date.canonical_to_date(p_report_date)

162: ELSIF p_rowid IS NOT NULL THEN
163:
164: UPDATE MTH_DAY_ERR SET
165: REPROCESS_READY_YN = p_reprocess_ready_yn
166: ,REPORT_DATE = fnd_date.canonical_to_date(p_report_date)
167: ,USER_ATTR1 = p_user_attr1
168: ,USER_ATTR2 = p_user_attr2
169: ,USER_ATTR3 = p_user_attr3
170: ,USER_ATTR4 = p_user_attr4

Line 415: ,INSTALLATION_DATE = fnd_date.canonical_to_date(p_installation_date)

411: ,SERIAL_NUMBER = p_serial_number
412: ,PRODUCTION_EQUIPMENT = p_production_equipment
413: ,EQUIPMENT_MANUFACTURER = p_equipment_manufacturer
414: ,MODEL_NUMBER = p_model_number
415: ,INSTALLATION_DATE = fnd_date.canonical_to_date(p_installation_date)
416: ,LAST_CALIBRATED = fnd_date.canonical_to_date(p_last_calibrated)
417: ,POWER_RATING = p_power_rating
418: ,STANDARD_CAPACITY = p_standard_capacity
419: ,STD_CYCLE_TIME = p_std_cycle_time

Line 416: ,LAST_CALIBRATED = fnd_date.canonical_to_date(p_last_calibrated)

412: ,PRODUCTION_EQUIPMENT = p_production_equipment
413: ,EQUIPMENT_MANUFACTURER = p_equipment_manufacturer
414: ,MODEL_NUMBER = p_model_number
415: ,INSTALLATION_DATE = fnd_date.canonical_to_date(p_installation_date)
416: ,LAST_CALIBRATED = fnd_date.canonical_to_date(p_last_calibrated)
417: ,POWER_RATING = p_power_rating
418: ,STANDARD_CAPACITY = p_standard_capacity
419: ,STD_CYCLE_TIME = p_std_cycle_time
420: ,STATUS = p_status

Line 487: ,fnd_date.canonical_to_date(p_installation_date)

483: ,p_serial_number
484: ,p_production_equipment
485: ,p_equipment_manufacturer
486: ,p_model_number
487: ,fnd_date.canonical_to_date(p_installation_date)
488: ,fnd_date.canonical_to_date(p_last_calibrated)
489: ,p_power_rating
490: ,p_standard_capacity
491: ,p_std_cycle_time

Line 488: ,fnd_date.canonical_to_date(p_last_calibrated)

484: ,p_production_equipment
485: ,p_equipment_manufacturer
486: ,p_model_number
487: ,fnd_date.canonical_to_date(p_installation_date)
488: ,fnd_date.canonical_to_date(p_last_calibrated)
489: ,p_power_rating
490: ,p_standard_capacity
491: ,p_std_cycle_time
492: ,p_status

Line 573: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)

569: REPROCESS_READY_YN = p_reprocess_ready_yn
570: ,ENTITY_PK = p_entity_pk
571: ,ENTITY_TYPE = p_entity_type
572: ,LINE_NUM = p_line_num
573: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
574: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
575: ,SHIFT_WORKDAY_FK = p_shift_workday_fk
576: ,AVAILABILITY_FLAG = p_availability_flag
577: ,REASON = p_reason

Line 574: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)

570: ,ENTITY_PK = p_entity_pk
571: ,ENTITY_TYPE = p_entity_type
572: ,LINE_NUM = p_line_num
573: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
574: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
575: ,SHIFT_WORKDAY_FK = p_shift_workday_fk
576: ,AVAILABILITY_FLAG = p_availability_flag
577: ,REASON = p_reason
578: WHERE ROWID = p_rowid;

Line 597: ,fnd_date.canonical_to_date(p_from_date)

593: p_reprocess_ready_yn
594: ,p_entity_pk
595: ,p_entity_type
596: ,p_line_num
597: ,fnd_date.canonical_to_date(p_from_date)
598: ,fnd_date.canonical_to_date(p_to_date)
599: ,p_shift_workday_fk
600: ,p_availability_flag
601: ,p_reason

Line 598: ,fnd_date.canonical_to_date(p_to_date)

594: ,p_entity_pk
595: ,p_entity_type
596: ,p_line_num
597: ,fnd_date.canonical_to_date(p_from_date)
598: ,fnd_date.canonical_to_date(p_to_date)
599: ,p_shift_workday_fk
600: ,p_availability_flag
601: ,p_reason
602: );

Line 657: ,EFFECTIVE_DATE = fnd_date.canonical_to_date(p_effective_date)

653: ,DESCRIPTION = p_description
654: ,STATUS = p_status
655: ,AREA = p_area
656: ,HEAD_COUNT = p_head_count
657: ,EFFECTIVE_DATE = fnd_date.canonical_to_date(p_effective_date)
658: ,USER_ATTR1 = p_user_attr1
659: ,USER_ATTR2 = p_user_attr2
660: ,USER_ATTR3 = p_user_attr3
661: ,USER_ATTR4 = p_user_attr4

Line 709: ,fnd_date.canonical_to_date(p_effective_date)

705: ,p_description
706: ,p_status
707: ,p_area
708: ,p_head_count
709: ,fnd_date.canonical_to_date(p_effective_date)
710: ,p_user_attr1
711: ,p_user_attr2
712: ,p_user_attr3
713: ,p_user_attr4

Line 753: ,EFFECTIVE_DATE = fnd_date.canonical_to_date(p_effective_date)

749: ,LEVEL_NUM = p_level_num
750: ,LEVEL_FK = p_level_fk
751: ,PARENT_FK = p_parent_fk
752: ,SYSTEM_FK = p_system_fk
753: ,EFFECTIVE_DATE = fnd_date.canonical_to_date(p_effective_date)
754: WHERE ROWID = p_rowid;
755:
756: ELSE
757:

Line 773: ,fnd_date.canonical_to_date(p_effective_date)

769: ,p_level_num
770: ,p_level_fk
771: ,p_parent_fk
772: ,p_system_fk
773: ,fnd_date.canonical_to_date(p_effective_date)
774: );
775:
776: END IF;
777:

Line 832: ,READING_TIME = fnd_date.canonical_to_date(p_reading_time)

828: ,EQUIPMENT_FK = p_equipment_fk
829: ,ITEM_FK = p_item_fk
830: ,SHIFT_WORKDAY_FK = p_shift_workday_fk
831: ,WORKORDER_FK = p_workorder_fk
832: ,READING_TIME = fnd_date.canonical_to_date(p_reading_time)
833: ,QTY_COMPLETED = p_qty_completed
834: ,QTY_SCRAP = p_qty_scrap
835: ,QTY_REJECTED = p_qty_rejected
836: ,QTY_REWORK = p_qty_rework

Line 904: ,fnd_date.canonical_to_date(p_reading_time)

900: ,p_equipment_fk
901: ,p_item_fk
902: ,p_shift_workday_fk
903: ,p_workorder_fk
904: ,fnd_date.canonical_to_date(p_reading_time)
905: ,p_qty_completed
906: ,p_qty_scrap
907: ,p_qty_rejected
908: ,p_qty_rework

Line 988: ,SCHEDULE_FROM_DATE = fnd_date.canonical_to_date(p_schedule_from_date)

984: ,WORKORDER_FK = p_workorder_fk
985: ,SEGMENT_FK = p_segment_fk
986: ,SHIFT_WORKDAY_FK = p_shift_workday_fk
987: ,ITEM_FK = p_item_fk
988: ,SCHEDULE_FROM_DATE = fnd_date.canonical_to_date(p_schedule_from_date)
989: ,SCHEDULE_TO_DATE = fnd_date.canonical_to_date(p_schedule_to_date)
990: ,PLANNED_QTY_G = p_planned_qty_g
991: ,PLANNED_QTY_SG = p_planned_qty_sg
992: ,PRIMARY_UOM = p_primary_uom

Line 989: ,SCHEDULE_TO_DATE = fnd_date.canonical_to_date(p_schedule_to_date)

985: ,SEGMENT_FK = p_segment_fk
986: ,SHIFT_WORKDAY_FK = p_shift_workday_fk
987: ,ITEM_FK = p_item_fk
988: ,SCHEDULE_FROM_DATE = fnd_date.canonical_to_date(p_schedule_from_date)
989: ,SCHEDULE_TO_DATE = fnd_date.canonical_to_date(p_schedule_to_date)
990: ,PLANNED_QTY_G = p_planned_qty_g
991: ,PLANNED_QTY_SG = p_planned_qty_sg
992: ,PRIMARY_UOM = p_primary_uom
993: ,SECONDARY_UOM = p_secondary_uom

Line 1052: ,fnd_date.canonical_to_date(p_schedule_from_date)

1048: ,p_workorder_fk
1049: ,p_segment_fk
1050: ,p_shift_workday_fk
1051: ,p_item_fk
1052: ,fnd_date.canonical_to_date(p_schedule_from_date)
1053: ,fnd_date.canonical_to_date(p_schedule_to_date)
1054: ,p_planned_qty_g
1055: ,p_planned_qty_sg
1056: ,p_primary_uom

Line 1053: ,fnd_date.canonical_to_date(p_schedule_to_date)

1049: ,p_segment_fk
1050: ,p_shift_workday_fk
1051: ,p_item_fk
1052: ,fnd_date.canonical_to_date(p_schedule_from_date)
1053: ,fnd_date.canonical_to_date(p_schedule_to_date)
1054: ,p_planned_qty_g
1055: ,p_planned_qty_sg
1056: ,p_primary_uom
1057: ,p_secondary_uom

Line 1250: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)

1246: UPDATE MTH_EQUIP_STATUSES_ERR SET
1247: REPROCESS_READY_YN = p_reprocess_ready_yn
1248: ,EQUIPMENT_FK = p_equipment_fk
1249: ,SHIFT_WORKDAY_FK = p_shift_workday_fk
1250: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
1251: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
1252: ,STATUS = p_status
1253: ,SYSTEM_FK = p_system_fk
1254: ,USER_DIM1_FK = p_user_dim1_fk

Line 1251: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)

1247: REPROCESS_READY_YN = p_reprocess_ready_yn
1248: ,EQUIPMENT_FK = p_equipment_fk
1249: ,SHIFT_WORKDAY_FK = p_shift_workday_fk
1250: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
1251: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
1252: ,STATUS = p_status
1253: ,SYSTEM_FK = p_system_fk
1254: ,USER_DIM1_FK = p_user_dim1_fk
1255: ,USER_DIM2_FK = p_user_dim2_fk

Line 1302: ,fnd_date.canonical_to_date(p_from_date)

1298: ) VALUES (
1299: p_reprocess_ready_yn
1300: ,p_equipment_fk
1301: ,p_shift_workday_fk
1302: ,fnd_date.canonical_to_date(p_from_date)
1303: ,fnd_date.canonical_to_date(p_to_date)
1304: ,p_status
1305: ,p_system_fk
1306: ,p_user_dim1_fk

Line 1303: ,fnd_date.canonical_to_date(p_to_date)

1299: p_reprocess_ready_yn
1300: ,p_equipment_fk
1301: ,p_shift_workday_fk
1302: ,fnd_date.canonical_to_date(p_from_date)
1303: ,fnd_date.canonical_to_date(p_to_date)
1304: ,p_status
1305: ,p_system_fk
1306: ,p_user_dim1_fk
1307: ,p_user_dim2_fk

Line 1820: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)

1816: REPROCESS_READY_YN = p_reprocess_ready_yn
1817: ,SYSTEM_FK = p_system_fk
1818: ,ITEM_FK = p_item_fk
1819: ,ITEM_COST = p_item_cost
1820: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
1821: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
1822: ,COST_ELEMENT = p_cost_element
1823: ,USER_ATTR1 = p_user_attr1
1824: ,USER_ATTR2 = p_user_attr2

Line 1821: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)

1817: ,SYSTEM_FK = p_system_fk
1818: ,ITEM_FK = p_item_fk
1819: ,ITEM_COST = p_item_cost
1820: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
1821: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
1822: ,COST_ELEMENT = p_cost_element
1823: ,USER_ATTR1 = p_user_attr1
1824: ,USER_ATTR2 = p_user_attr2
1825: ,USER_ATTR3 = p_user_attr3

Line 1850: ,fnd_date.canonical_to_date(p_from_date)

1846: p_reprocess_ready_yn
1847: ,p_system_fk
1848: ,p_item_fk
1849: ,p_item_cost
1850: ,fnd_date.canonical_to_date(p_from_date)
1851: ,fnd_date.canonical_to_date(p_to_date)
1852: ,p_cost_element
1853: ,p_user_attr1
1854: ,p_user_attr2

Line 1851: ,fnd_date.canonical_to_date(p_to_date)

1847: ,p_system_fk
1848: ,p_item_fk
1849: ,p_item_cost
1850: ,fnd_date.canonical_to_date(p_from_date)
1851: ,fnd_date.canonical_to_date(p_to_date)
1852: ,p_cost_element
1853: ,p_user_attr1
1854: ,p_user_attr2
1855: ,p_user_attr3

Line 1941: ,FROM_TIME = fnd_date.canonical_to_date(p_from_time)

1937: UPDATE MTH_METER_READINGS_ERR SET
1938: REPROCESS_READY_YN = p_reprocess_ready_yn
1939: ,METER_READINGS_ERR_PK_KEY = p_meter_readings_err_pk_key
1940: ,METER_CODE = p_meter_code
1941: ,FROM_TIME = fnd_date.canonical_to_date(p_from_time)
1942: ,TO_TIME = fnd_date.canonical_to_date(p_to_time)
1943: ,USAGE_VALUE = p_usage_value
1944: ,TAG_CODE = p_tag_code
1945: ,ERR_SOURCE = p_err_source

Line 1942: ,TO_TIME = fnd_date.canonical_to_date(p_to_time)

1938: REPROCESS_READY_YN = p_reprocess_ready_yn
1939: ,METER_READINGS_ERR_PK_KEY = p_meter_readings_err_pk_key
1940: ,METER_CODE = p_meter_code
1941: ,FROM_TIME = fnd_date.canonical_to_date(p_from_time)
1942: ,TO_TIME = fnd_date.canonical_to_date(p_to_time)
1943: ,USAGE_VALUE = p_usage_value
1944: ,TAG_CODE = p_tag_code
1945: ,ERR_SOURCE = p_err_source
1946: ,CREATION_DATE = fnd_date.canonical_to_date(p_creation_date)

Line 1946: ,CREATION_DATE = fnd_date.canonical_to_date(p_creation_date)

1942: ,TO_TIME = fnd_date.canonical_to_date(p_to_time)
1943: ,USAGE_VALUE = p_usage_value
1944: ,TAG_CODE = p_tag_code
1945: ,ERR_SOURCE = p_err_source
1946: ,CREATION_DATE = fnd_date.canonical_to_date(p_creation_date)
1947: ,LAST_UPDATE_DATE = fnd_date.canonical_to_date(p_last_update_date)
1948: WHERE ROWID = p_rowid;
1949:
1950: ELSE

Line 1947: ,LAST_UPDATE_DATE = fnd_date.canonical_to_date(p_last_update_date)

1943: ,USAGE_VALUE = p_usage_value
1944: ,TAG_CODE = p_tag_code
1945: ,ERR_SOURCE = p_err_source
1946: ,CREATION_DATE = fnd_date.canonical_to_date(p_creation_date)
1947: ,LAST_UPDATE_DATE = fnd_date.canonical_to_date(p_last_update_date)
1948: WHERE ROWID = p_rowid;
1949:
1950: ELSE
1951:

Line 1967: ,fnd_date.canonical_to_date(p_from_time)

1963: ) VALUES (
1964: p_reprocess_ready_yn
1965: ,p_meter_readings_err_pk_key
1966: ,p_meter_code
1967: ,fnd_date.canonical_to_date(p_from_time)
1968: ,fnd_date.canonical_to_date(p_to_time)
1969: ,p_usage_value
1970: ,p_tag_code
1971: ,p_err_source

Line 1968: ,fnd_date.canonical_to_date(p_to_time)

1964: p_reprocess_ready_yn
1965: ,p_meter_readings_err_pk_key
1966: ,p_meter_code
1967: ,fnd_date.canonical_to_date(p_from_time)
1968: ,fnd_date.canonical_to_date(p_to_time)
1969: ,p_usage_value
1970: ,p_tag_code
1971: ,p_err_source
1972: ,fnd_date.canonical_to_date(p_creation_date)

Line 1972: ,fnd_date.canonical_to_date(p_creation_date)

1968: ,fnd_date.canonical_to_date(p_to_time)
1969: ,p_usage_value
1970: ,p_tag_code
1971: ,p_err_source
1972: ,fnd_date.canonical_to_date(p_creation_date)
1973: ,fnd_date.canonical_to_date(p_last_update_date)
1974: );
1975:
1976: END IF;

Line 1973: ,fnd_date.canonical_to_date(p_last_update_date)

1969: ,p_usage_value
1970: ,p_tag_code
1971: ,p_err_source
1972: ,fnd_date.canonical_to_date(p_creation_date)
1973: ,fnd_date.canonical_to_date(p_last_update_date)
1974: );
1975:
1976: END IF;
1977:

Line 2312: ,END_DATE = fnd_date.canonical_to_date(p_end_date)

2308: ,USER_MEASURE3 = p_user_measure3
2309: ,USER_MEASURE4 = p_user_measure4
2310: ,USER_MEASURE5 = p_user_measure5
2311: ,SYSTEM_FK = p_system_fk
2312: ,END_DATE = fnd_date.canonical_to_date(p_end_date)
2313: ,START_DATE = fnd_date.canonical_to_date(p_start_date)
2314: WHERE ROWID = p_rowid;
2315:
2316: ELSE

Line 2313: ,START_DATE = fnd_date.canonical_to_date(p_start_date)

2309: ,USER_MEASURE4 = p_user_measure4
2310: ,USER_MEASURE5 = p_user_measure5
2311: ,SYSTEM_FK = p_system_fk
2312: ,END_DATE = fnd_date.canonical_to_date(p_end_date)
2313: ,START_DATE = fnd_date.canonical_to_date(p_start_date)
2314: WHERE ROWID = p_rowid;
2315:
2316: ELSE
2317:

Line 2396: ,EFFECTIVE_START_DATE = fnd_date.canonical_to_date(p_effective_start_date)

2392: ,SEX = p_sex
2393: ,EMAIL_ADDRESS = p_email_address
2394: ,WORK_TELEPHONE = p_work_telephone
2395: ,MOBILE_PHONE_NUMBER = p_mobile_phone_number
2396: ,EFFECTIVE_START_DATE = fnd_date.canonical_to_date(p_effective_start_date)
2397: ,EFFECTIVE_END_DATE = fnd_date.canonical_to_date(p_effective_end_date)
2398: WHERE ROWID = p_rowid;
2399:
2400: ELSE

Line 2397: ,EFFECTIVE_END_DATE = fnd_date.canonical_to_date(p_effective_end_date)

2393: ,EMAIL_ADDRESS = p_email_address
2394: ,WORK_TELEPHONE = p_work_telephone
2395: ,MOBILE_PHONE_NUMBER = p_mobile_phone_number
2396: ,EFFECTIVE_START_DATE = fnd_date.canonical_to_date(p_effective_start_date)
2397: ,EFFECTIVE_END_DATE = fnd_date.canonical_to_date(p_effective_end_date)
2398: WHERE ROWID = p_rowid;
2399:
2400: ELSE
2401:

Line 2462: ,fnd_date.canonical_to_date(p_effective_start_date)

2458: ,p_sex
2459: ,p_email_address
2460: ,p_work_telephone
2461: ,p_mobile_phone_number
2462: ,fnd_date.canonical_to_date(p_effective_start_date)
2463: ,fnd_date.canonical_to_date(p_effective_end_date)
2464: );
2465:
2466: END IF;

Line 2463: ,fnd_date.canonical_to_date(p_effective_end_date)

2459: ,p_email_address
2460: ,p_work_telephone
2461: ,p_mobile_phone_number
2462: ,fnd_date.canonical_to_date(p_effective_start_date)
2463: ,fnd_date.canonical_to_date(p_effective_end_date)
2464: );
2465:
2466: END IF;
2467:

Line 2561: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)

2557: ,WORKORDER_PK = p_workorder_pk
2558: ,SYSTEM_FK = p_system_fk
2559: ,WORKORDER_TYPE = p_workorder_type
2560: ,STATUS = p_status
2561: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2562: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2563: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2564: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2565: ,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)

Line 2562: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)

2558: ,SYSTEM_FK = p_system_fk
2559: ,WORKORDER_TYPE = p_workorder_type
2560: ,STATUS = p_status
2561: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2562: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2563: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2564: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2565: ,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)
2566: ,ERP_ACTUAL_START_DATE = fnd_date.canonical_to_date(p_erp_actual_start_date)

Line 2563: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)

2559: ,WORKORDER_TYPE = p_workorder_type
2560: ,STATUS = p_status
2561: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2562: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2563: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2564: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2565: ,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)
2566: ,ERP_ACTUAL_START_DATE = fnd_date.canonical_to_date(p_erp_actual_start_date)
2567: ,ERP_ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_erp_actual_completion_date)

Line 2564: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)

2560: ,STATUS = p_status
2561: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2562: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2563: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2564: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2565: ,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)
2566: ,ERP_ACTUAL_START_DATE = fnd_date.canonical_to_date(p_erp_actual_start_date)
2567: ,ERP_ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_erp_actual_completion_date)
2568: ,EBS_ENTITY_ID = p_ebs_entity_id

Line 2565: ,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)

2561: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2562: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2563: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2564: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2565: ,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)
2566: ,ERP_ACTUAL_START_DATE = fnd_date.canonical_to_date(p_erp_actual_start_date)
2567: ,ERP_ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_erp_actual_completion_date)
2568: ,EBS_ENTITY_ID = p_ebs_entity_id
2569: ,EBS_ORGANIZATION_ID = p_ebs_organization_id

Line 2566: ,ERP_ACTUAL_START_DATE = fnd_date.canonical_to_date(p_erp_actual_start_date)

2562: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2563: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2564: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2565: ,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)
2566: ,ERP_ACTUAL_START_DATE = fnd_date.canonical_to_date(p_erp_actual_start_date)
2567: ,ERP_ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_erp_actual_completion_date)
2568: ,EBS_ENTITY_ID = p_ebs_entity_id
2569: ,EBS_ORGANIZATION_ID = p_ebs_organization_id
2570: ,BOM_REVISION = p_bom_revision

Line 2567: ,ERP_ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_erp_actual_completion_date)

2563: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2564: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2565: ,DATE_RELEASED = fnd_date.canonical_to_date(p_date_released)
2566: ,ERP_ACTUAL_START_DATE = fnd_date.canonical_to_date(p_erp_actual_start_date)
2567: ,ERP_ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_erp_actual_completion_date)
2568: ,EBS_ENTITY_ID = p_ebs_entity_id
2569: ,EBS_ORGANIZATION_ID = p_ebs_organization_id
2570: ,BOM_REVISION = p_bom_revision
2571: ,ROUTING_REVISION = p_routing_revision

Line 2572: ,BOM_REVISION_DATE = fnd_date.canonical_to_date(p_bom_revision_date)

2568: ,EBS_ENTITY_ID = p_ebs_entity_id
2569: ,EBS_ORGANIZATION_ID = p_ebs_organization_id
2570: ,BOM_REVISION = p_bom_revision
2571: ,ROUTING_REVISION = p_routing_revision
2572: ,BOM_REVISION_DATE = fnd_date.canonical_to_date(p_bom_revision_date)
2573: ,ROUTING_REVISION_DATE = fnd_date.canonical_to_date(p_routing_revision_date)
2574: ,ALTERNATE_BOM_DESIGNATOR = p_alternate_bom_designator
2575: ,ALTERNATE_ROUTING_DESIGNATOR = p_alternate_routing_designator
2576: ,COMPLETION_SUBINVENTORY = p_completion_subinventory

Line 2573: ,ROUTING_REVISION_DATE = fnd_date.canonical_to_date(p_routing_revision_date)

2569: ,EBS_ORGANIZATION_ID = p_ebs_organization_id
2570: ,BOM_REVISION = p_bom_revision
2571: ,ROUTING_REVISION = p_routing_revision
2572: ,BOM_REVISION_DATE = fnd_date.canonical_to_date(p_bom_revision_date)
2573: ,ROUTING_REVISION_DATE = fnd_date.canonical_to_date(p_routing_revision_date)
2574: ,ALTERNATE_BOM_DESIGNATOR = p_alternate_bom_designator
2575: ,ALTERNATE_ROUTING_DESIGNATOR = p_alternate_routing_designator
2576: ,COMPLETION_SUBINVENTORY = p_completion_subinventory
2577: ,COMPLETION_LOCATOR_ID = p_completion_locator_id

Line 2625: ,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)

2621: ,RECIPE_NUM = p_recipe_num
2622: ,RECIPE_VERSION = p_recipe_version
2623: ,FORMULA_NUM = p_formula_num
2624: ,FORMULA_VERSION = p_formula_version
2625: ,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)
2626: ,BATCH_TYPE = p_batch_type
2627: ,TERMINATED_IND = p_terminated_ind
2628: WHERE ROWID = p_rowid;
2629:

Line 2711: ,fnd_date.canonical_to_date(p_planned_start_date)

2707: ,p_workorder_pk
2708: ,p_system_fk
2709: ,p_workorder_type
2710: ,p_status
2711: ,fnd_date.canonical_to_date(p_planned_start_date)
2712: ,fnd_date.canonical_to_date(p_planned_completion_date)
2713: ,fnd_date.canonical_to_date(p_actual_start_date)
2714: ,fnd_date.canonical_to_date(p_actual_completion_date)
2715: ,fnd_date.canonical_to_date(p_date_released)

Line 2712: ,fnd_date.canonical_to_date(p_planned_completion_date)

2708: ,p_system_fk
2709: ,p_workorder_type
2710: ,p_status
2711: ,fnd_date.canonical_to_date(p_planned_start_date)
2712: ,fnd_date.canonical_to_date(p_planned_completion_date)
2713: ,fnd_date.canonical_to_date(p_actual_start_date)
2714: ,fnd_date.canonical_to_date(p_actual_completion_date)
2715: ,fnd_date.canonical_to_date(p_date_released)
2716: ,fnd_date.canonical_to_date(p_erp_actual_start_date)

Line 2713: ,fnd_date.canonical_to_date(p_actual_start_date)

2709: ,p_workorder_type
2710: ,p_status
2711: ,fnd_date.canonical_to_date(p_planned_start_date)
2712: ,fnd_date.canonical_to_date(p_planned_completion_date)
2713: ,fnd_date.canonical_to_date(p_actual_start_date)
2714: ,fnd_date.canonical_to_date(p_actual_completion_date)
2715: ,fnd_date.canonical_to_date(p_date_released)
2716: ,fnd_date.canonical_to_date(p_erp_actual_start_date)
2717: ,fnd_date.canonical_to_date(p_erp_actual_completion_date)

Line 2714: ,fnd_date.canonical_to_date(p_actual_completion_date)

2710: ,p_status
2711: ,fnd_date.canonical_to_date(p_planned_start_date)
2712: ,fnd_date.canonical_to_date(p_planned_completion_date)
2713: ,fnd_date.canonical_to_date(p_actual_start_date)
2714: ,fnd_date.canonical_to_date(p_actual_completion_date)
2715: ,fnd_date.canonical_to_date(p_date_released)
2716: ,fnd_date.canonical_to_date(p_erp_actual_start_date)
2717: ,fnd_date.canonical_to_date(p_erp_actual_completion_date)
2718: ,p_ebs_entity_id

Line 2715: ,fnd_date.canonical_to_date(p_date_released)

2711: ,fnd_date.canonical_to_date(p_planned_start_date)
2712: ,fnd_date.canonical_to_date(p_planned_completion_date)
2713: ,fnd_date.canonical_to_date(p_actual_start_date)
2714: ,fnd_date.canonical_to_date(p_actual_completion_date)
2715: ,fnd_date.canonical_to_date(p_date_released)
2716: ,fnd_date.canonical_to_date(p_erp_actual_start_date)
2717: ,fnd_date.canonical_to_date(p_erp_actual_completion_date)
2718: ,p_ebs_entity_id
2719: ,p_ebs_organization_id

Line 2716: ,fnd_date.canonical_to_date(p_erp_actual_start_date)

2712: ,fnd_date.canonical_to_date(p_planned_completion_date)
2713: ,fnd_date.canonical_to_date(p_actual_start_date)
2714: ,fnd_date.canonical_to_date(p_actual_completion_date)
2715: ,fnd_date.canonical_to_date(p_date_released)
2716: ,fnd_date.canonical_to_date(p_erp_actual_start_date)
2717: ,fnd_date.canonical_to_date(p_erp_actual_completion_date)
2718: ,p_ebs_entity_id
2719: ,p_ebs_organization_id
2720: ,p_bom_revision

Line 2717: ,fnd_date.canonical_to_date(p_erp_actual_completion_date)

2713: ,fnd_date.canonical_to_date(p_actual_start_date)
2714: ,fnd_date.canonical_to_date(p_actual_completion_date)
2715: ,fnd_date.canonical_to_date(p_date_released)
2716: ,fnd_date.canonical_to_date(p_erp_actual_start_date)
2717: ,fnd_date.canonical_to_date(p_erp_actual_completion_date)
2718: ,p_ebs_entity_id
2719: ,p_ebs_organization_id
2720: ,p_bom_revision
2721: ,p_routing_revision

Line 2722: ,fnd_date.canonical_to_date(p_bom_revision_date)

2718: ,p_ebs_entity_id
2719: ,p_ebs_organization_id
2720: ,p_bom_revision
2721: ,p_routing_revision
2722: ,fnd_date.canonical_to_date(p_bom_revision_date)
2723: ,fnd_date.canonical_to_date(p_routing_revision_date)
2724: ,p_alternate_bom_designator
2725: ,p_alternate_routing_designator
2726: ,p_completion_subinventory

Line 2723: ,fnd_date.canonical_to_date(p_routing_revision_date)

2719: ,p_ebs_organization_id
2720: ,p_bom_revision
2721: ,p_routing_revision
2722: ,fnd_date.canonical_to_date(p_bom_revision_date)
2723: ,fnd_date.canonical_to_date(p_routing_revision_date)
2724: ,p_alternate_bom_designator
2725: ,p_alternate_routing_designator
2726: ,p_completion_subinventory
2727: ,p_completion_locator_id

Line 2775: ,fnd_date.canonical_to_date(p_req_completion_date)

2771: ,p_recipe_num
2772: ,p_recipe_version
2773: ,p_formula_num
2774: ,p_formula_version
2775: ,fnd_date.canonical_to_date(p_req_completion_date)
2776: ,p_batch_type
2777: ,p_terminated_ind
2778: );
2779:

Line 2852: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)

2848: ,ACTUAL_SCRAP_QTY_G = p_actual_scrap_qty_g
2849: ,ACTUAL_REJECTED_QTY_SG = p_actual_rejected_qty_sg
2850: ,ACTUAL_REWORKED_QTY_SG = p_actual_reworked_qty_sg
2851: ,ACTUAL_SCRAP_QTY_SG = p_actual_scrap_qty_sg
2852: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2853: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2854: ,SYSTEM_FK = p_system_fk
2855: ,USER_DIM1_FK = p_user_dim1_fk
2856: ,USER_DIM2_FK = p_user_dim2_fk

Line 2853: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)

2849: ,ACTUAL_REJECTED_QTY_SG = p_actual_rejected_qty_sg
2850: ,ACTUAL_REWORKED_QTY_SG = p_actual_reworked_qty_sg
2851: ,ACTUAL_SCRAP_QTY_SG = p_actual_scrap_qty_sg
2852: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
2853: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
2854: ,SYSTEM_FK = p_system_fk
2855: ,USER_DIM1_FK = p_user_dim1_fk
2856: ,USER_DIM2_FK = p_user_dim2_fk
2857: ,USER_DIM3_FK = p_user_dim3_fk

Line 2871: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)

2867: ,USER_MEASURE3 = p_user_measure3
2868: ,USER_MEASURE4 = p_user_measure4
2869: ,USER_MEASURE5 = p_user_measure5
2870: ,SEGMENT_STATUS = p_segment_status
2871: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2872: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2873: ,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)
2874: WHERE ROWID = p_rowid;
2875:

Line 2872: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)

2868: ,USER_MEASURE4 = p_user_measure4
2869: ,USER_MEASURE5 = p_user_measure5
2870: ,SEGMENT_STATUS = p_segment_status
2871: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2872: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2873: ,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)
2874: WHERE ROWID = p_rowid;
2875:
2876: ELSE

Line 2873: ,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)

2869: ,USER_MEASURE5 = p_user_measure5
2870: ,SEGMENT_STATUS = p_segment_status
2871: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
2872: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
2873: ,REQ_COMPLETION_DATE = fnd_date.canonical_to_date(p_req_completion_date)
2874: WHERE ROWID = p_rowid;
2875:
2876: ELSE
2877:

Line 2934: ,fnd_date.canonical_to_date(p_actual_start_date)

2930: ,p_actual_scrap_qty_g
2931: ,p_actual_rejected_qty_sg
2932: ,p_actual_reworked_qty_sg
2933: ,p_actual_scrap_qty_sg
2934: ,fnd_date.canonical_to_date(p_actual_start_date)
2935: ,fnd_date.canonical_to_date(p_actual_completion_date)
2936: ,p_system_fk
2937: ,p_user_dim1_fk
2938: ,p_user_dim2_fk

Line 2935: ,fnd_date.canonical_to_date(p_actual_completion_date)

2931: ,p_actual_rejected_qty_sg
2932: ,p_actual_reworked_qty_sg
2933: ,p_actual_scrap_qty_sg
2934: ,fnd_date.canonical_to_date(p_actual_start_date)
2935: ,fnd_date.canonical_to_date(p_actual_completion_date)
2936: ,p_system_fk
2937: ,p_user_dim1_fk
2938: ,p_user_dim2_fk
2939: ,p_user_dim3_fk

Line 2953: ,fnd_date.canonical_to_date(p_planned_start_date)

2949: ,p_user_measure3
2950: ,p_user_measure4
2951: ,p_user_measure5
2952: ,p_segment_status
2953: ,fnd_date.canonical_to_date(p_planned_start_date)
2954: ,fnd_date.canonical_to_date(p_planned_completion_date)
2955: ,fnd_date.canonical_to_date(p_req_completion_date)
2956: );
2957:

Line 2954: ,fnd_date.canonical_to_date(p_planned_completion_date)

2950: ,p_user_measure4
2951: ,p_user_measure5
2952: ,p_segment_status
2953: ,fnd_date.canonical_to_date(p_planned_start_date)
2954: ,fnd_date.canonical_to_date(p_planned_completion_date)
2955: ,fnd_date.canonical_to_date(p_req_completion_date)
2956: );
2957:
2958: END IF;

Line 2955: ,fnd_date.canonical_to_date(p_req_completion_date)

2951: ,p_user_measure5
2952: ,p_segment_status
2953: ,fnd_date.canonical_to_date(p_planned_start_date)
2954: ,fnd_date.canonical_to_date(p_planned_completion_date)
2955: ,fnd_date.canonical_to_date(p_req_completion_date)
2956: );
2957:
2958: END IF;
2959:

Line 3023: ,REQUIRED_BY_DATE = fnd_date.canonical_to_date(p_required_by_date)

3019: ,ACTUAL_QTY_G = p_actual_qty_g
3020: ,ACTUAL_QTY_SG = p_actual_qty_sg
3021: ,UNIT_STANDARD_QTY_G = p_unit_standard_qty_g
3022: ,UNIT_STANDARD_QTY_SG = p_unit_standard_qty_sg
3023: ,REQUIRED_BY_DATE = fnd_date.canonical_to_date(p_required_by_date)
3024: ,SOURCE_ORG_CODE = p_source_org_code
3025: ,SYSTEM_FK = p_system_fk
3026: ,USER_DIM1_FK = p_user_dim1_fk
3027: ,USER_DIM2_FK = p_user_dim2_fk

Line 3097: ,fnd_date.canonical_to_date(p_required_by_date)

3093: ,p_actual_qty_g
3094: ,p_actual_qty_sg
3095: ,p_unit_standard_qty_g
3096: ,p_unit_standard_qty_sg
3097: ,fnd_date.canonical_to_date(p_required_by_date)
3098: ,p_source_org_code
3099: ,p_system_fk
3100: ,p_user_dim1_fk
3101: ,p_user_dim2_fk

Line 3180: ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)

3176: ,TRANSACTION_QTY_SG = p_transaction_qty_sg
3177: ,TRANSACTION_UOM = p_transaction_uom
3178: ,PRIMARY_UOM = p_primary_uom
3179: ,SECONDARY_UOM = p_secondary_uom
3180: ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
3181: ,SYSTEM_FK = p_system_fk
3182: ,SOURCE_ORG_CODE = p_source_org_code
3183: ,USER_DIM1_FK = p_user_dim1_fk
3184: ,USER_DIM2_FK = p_user_dim2_fk

Line 3246: ,fnd_date.canonical_to_date(p_transaction_date)

3242: ,p_transaction_qty_sg
3243: ,p_transaction_uom
3244: ,p_primary_uom
3245: ,p_secondary_uom
3246: ,fnd_date.canonical_to_date(p_transaction_date)
3247: ,p_system_fk
3248: ,p_source_org_code
3249: ,p_user_dim1_fk
3250: ,p_user_dim2_fk

Line 3496: ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)

3492: ,TRANSACTION_QTY_SG = p_transaction_qty_sg
3493: ,TRANSACTION_UOM = p_transaction_uom
3494: ,PRIMARY_UOM = p_primary_uom
3495: ,SECONDARY_UOM = p_secondary_uom
3496: ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
3497: ,SOURCE_ORG_CODE = p_source_org_code
3498: ,SYSTEM_FK = p_system_fk
3499: ,USER_DIM1_FK = p_user_dim1_fk
3500: ,USER_DIM2_FK = p_user_dim2_fk

Line 3562: ,fnd_date.canonical_to_date(p_transaction_date)

3558: ,p_transaction_qty_sg
3559: ,p_transaction_uom
3560: ,p_primary_uom
3561: ,p_secondary_uom
3562: ,fnd_date.canonical_to_date(p_transaction_date)
3563: ,p_source_org_code
3564: ,p_system_fk
3565: ,p_user_dim1_fk
3566: ,p_user_dim2_fk

Line 3637: ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)

3633: ,FROM_SEGMENT_FK = p_from_segment_fk
3634: ,TO_SEGMENT_FK = p_to_segment_fk
3635: ,ITEM_FK = p_item_fk
3636: ,SYSTEM_FK = p_system_fk
3637: ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
3638: ,TRANSACTION_QTY = p_transaction_qty
3639: ,TRANSACTION_QTY_G = p_transaction_qty_g
3640: ,TRANSACTION_QTY_SG = p_transaction_qty_sg
3641: ,PRIMARY_UOM = p_primary_uom

Line 3705: ,fnd_date.canonical_to_date(p_transaction_date)

3701: ,p_from_segment_fk
3702: ,p_to_segment_fk
3703: ,p_item_fk
3704: ,p_system_fk
3705: ,fnd_date.canonical_to_date(p_transaction_date)
3706: ,p_transaction_qty
3707: ,p_transaction_qty_g
3708: ,p_transaction_qty_sg
3709: ,p_primary_uom

Line 3774: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)

3770: ,SUB_SEGMENT_PK = p_sub_segment_pk
3771: ,SEGMENT_FK = p_segment_fk
3772: ,SYSTEM_FK = p_system_fk
3773: ,DESCRIPTION = p_description
3774: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
3775: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
3776: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
3777: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
3778: ,USER_ATTR1 = p_user_attr1

Line 3775: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)

3771: ,SEGMENT_FK = p_segment_fk
3772: ,SYSTEM_FK = p_system_fk
3773: ,DESCRIPTION = p_description
3774: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
3775: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
3776: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
3777: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
3778: ,USER_ATTR1 = p_user_attr1
3779: ,USER_ATTR2 = p_user_attr2

Line 3776: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)

3772: ,SYSTEM_FK = p_system_fk
3773: ,DESCRIPTION = p_description
3774: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
3775: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
3776: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
3777: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
3778: ,USER_ATTR1 = p_user_attr1
3779: ,USER_ATTR2 = p_user_attr2
3780: ,USER_ATTR3 = p_user_attr3

Line 3777: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)

3773: ,DESCRIPTION = p_description
3774: ,ACTUAL_START_DATE = fnd_date.canonical_to_date(p_actual_start_date)
3775: ,ACTUAL_COMPLETION_DATE = fnd_date.canonical_to_date(p_actual_completion_date)
3776: ,PLANNED_START_DATE = fnd_date.canonical_to_date(p_planned_start_date)
3777: ,PLANNED_COMPLETION_DATE = fnd_date.canonical_to_date(p_planned_completion_date)
3778: ,USER_ATTR1 = p_user_attr1
3779: ,USER_ATTR2 = p_user_attr2
3780: ,USER_ATTR3 = p_user_attr3
3781: ,USER_ATTR4 = p_user_attr4

Line 3818: ,fnd_date.canonical_to_date(p_actual_start_date)

3814: ,p_sub_segment_pk
3815: ,p_segment_fk
3816: ,p_system_fk
3817: ,p_description
3818: ,fnd_date.canonical_to_date(p_actual_start_date)
3819: ,fnd_date.canonical_to_date(p_actual_completion_date)
3820: ,fnd_date.canonical_to_date(p_planned_start_date)
3821: ,fnd_date.canonical_to_date(p_planned_completion_date)
3822: ,p_user_attr1

Line 3819: ,fnd_date.canonical_to_date(p_actual_completion_date)

3815: ,p_segment_fk
3816: ,p_system_fk
3817: ,p_description
3818: ,fnd_date.canonical_to_date(p_actual_start_date)
3819: ,fnd_date.canonical_to_date(p_actual_completion_date)
3820: ,fnd_date.canonical_to_date(p_planned_start_date)
3821: ,fnd_date.canonical_to_date(p_planned_completion_date)
3822: ,p_user_attr1
3823: ,p_user_attr2

Line 3820: ,fnd_date.canonical_to_date(p_planned_start_date)

3816: ,p_system_fk
3817: ,p_description
3818: ,fnd_date.canonical_to_date(p_actual_start_date)
3819: ,fnd_date.canonical_to_date(p_actual_completion_date)
3820: ,fnd_date.canonical_to_date(p_planned_start_date)
3821: ,fnd_date.canonical_to_date(p_planned_completion_date)
3822: ,p_user_attr1
3823: ,p_user_attr2
3824: ,p_user_attr3

Line 3821: ,fnd_date.canonical_to_date(p_planned_completion_date)

3817: ,p_description
3818: ,fnd_date.canonical_to_date(p_actual_start_date)
3819: ,fnd_date.canonical_to_date(p_actual_completion_date)
3820: ,fnd_date.canonical_to_date(p_planned_start_date)
3821: ,fnd_date.canonical_to_date(p_planned_completion_date)
3822: ,p_user_attr1
3823: ,p_user_attr2
3824: ,p_user_attr3
3825: ,p_user_attr4

Line 3882: ,END_DATE = fnd_date.canonical_to_date(p_end_date)

3878: ,USER_MEASURE3 = p_user_measure3
3879: ,USER_MEASURE4 = p_user_measure4
3880: ,USER_MEASURE5 = p_user_measure5
3881: ,SYSTEM_FK = p_system_fk
3882: ,END_DATE = fnd_date.canonical_to_date(p_end_date)
3883: ,START_DATE = fnd_date.canonical_to_date(p_start_date)
3884: WHERE ROWID = p_rowid;
3885:
3886: ELSE

Line 3883: ,START_DATE = fnd_date.canonical_to_date(p_start_date)

3879: ,USER_MEASURE4 = p_user_measure4
3880: ,USER_MEASURE5 = p_user_measure5
3881: ,SYSTEM_FK = p_system_fk
3882: ,END_DATE = fnd_date.canonical_to_date(p_end_date)
3883: ,START_DATE = fnd_date.canonical_to_date(p_start_date)
3884: WHERE ROWID = p_rowid;
3885:
3886: ELSE
3887:

Line 3962: ,DISABLE_DATE = fnd_date.canonical_to_date(p_disable_date)

3958: ,USAGE_UOM = p_usage_uom
3959: ,CAPACITY_UNITS = p_capacity_units
3960: ,AVAILABLE_24_HOUR_FLAG = p_available_24_hour_flag
3961: ,SYSTEM_FK = p_system_fk
3962: ,DISABLE_DATE = fnd_date.canonical_to_date(p_disable_date)
3963: ,RESOURCE_NAME = p_resource_name
3964: ,USER_ATTR1 = p_user_attr1
3965: ,USER_ATTR2 = p_user_attr2
3966: ,USER_ATTR3 = p_user_attr3

Line 4056: ,fnd_date.canonical_to_date(p_disable_date)

4052: ,p_usage_uom
4053: ,p_capacity_units
4054: ,p_available_24_hour_flag
4055: ,p_system_fk
4056: ,fnd_date.canonical_to_date(p_disable_date)
4057: ,p_resource_name
4058: ,p_user_attr1
4059: ,p_user_attr2
4060: ,p_user_attr3

Line 4124: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)

4120:
4121: UPDATE MTH_RESOURCE_COST_ERR SET
4122: REPROCESS_READY_YN = p_reprocess_ready_yn
4123: ,RESOURCE_FK = p_resource_fk
4124: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
4125: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
4126: ,COST_ELEMENT = p_cost_element
4127: ,COST = p_cost
4128: ,SYSTEM_FK = p_system_fk

Line 4125: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)

4121: UPDATE MTH_RESOURCE_COST_ERR SET
4122: REPROCESS_READY_YN = p_reprocess_ready_yn
4123: ,RESOURCE_FK = p_resource_fk
4124: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
4125: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
4126: ,COST_ELEMENT = p_cost_element
4127: ,COST = p_cost
4128: ,SYSTEM_FK = p_system_fk
4129: ,USER_ATTR1 = p_user_attr1

Line 4154: ,fnd_date.canonical_to_date(p_from_date)

4150: ,USER_ATTR5
4151: ) VALUES (
4152: p_reprocess_ready_yn
4153: ,p_resource_fk
4154: ,fnd_date.canonical_to_date(p_from_date)
4155: ,fnd_date.canonical_to_date(p_to_date)
4156: ,p_cost_element
4157: ,p_cost
4158: ,p_system_fk

Line 4155: ,fnd_date.canonical_to_date(p_to_date)

4151: ) VALUES (
4152: p_reprocess_ready_yn
4153: ,p_resource_fk
4154: ,fnd_date.canonical_to_date(p_from_date)
4155: ,fnd_date.canonical_to_date(p_to_date)
4156: ,p_cost_element
4157: ,p_cost
4158: ,p_system_fk
4159: ,p_user_attr1

Line 4347: ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)

4343: ,PRODUCT_FK = p_product_fk
4344: ,SEGMENT_FK = p_segment_fk
4345: ,USAGE_QTY = p_usage_qty
4346: ,USAGE_UOM = p_usage_uom
4347: ,TRANSACTION_DATE = fnd_date.canonical_to_date(p_transaction_date)
4348: ,SOURCE_ORG_CODE = p_source_org_code
4349: ,SYSTEM_FK = p_system_fk
4350: ,USER_DIM1_FK = p_user_dim1_fk
4351: ,USER_DIM2_FK = p_user_dim2_fk

Line 4405: ,fnd_date.canonical_to_date(p_transaction_date)

4401: ,p_product_fk
4402: ,p_segment_fk
4403: ,p_usage_qty
4404: ,p_usage_uom
4405: ,fnd_date.canonical_to_date(p_transaction_date)
4406: ,p_source_org_code
4407: ,p_system_fk
4408: ,p_user_dim1_fk
4409: ,p_user_dim2_fk

Line 4776: ,END_DATE = fnd_date.canonical_to_date(p_end_date)

4772: ,USER_MEASURE3 = p_user_measure3
4773: ,USER_MEASURE4 = p_user_measure4
4774: ,USER_MEASURE5 = p_user_measure5
4775: ,SYSTEM_FK = p_system_fk
4776: ,END_DATE = fnd_date.canonical_to_date(p_end_date)
4777: ,START_DATE = fnd_date.canonical_to_date(p_start_date)
4778: WHERE ROWID = p_rowid;
4779:
4780: ELSE

Line 4777: ,START_DATE = fnd_date.canonical_to_date(p_start_date)

4773: ,USER_MEASURE4 = p_user_measure4
4774: ,USER_MEASURE5 = p_user_measure5
4775: ,SYSTEM_FK = p_system_fk
4776: ,END_DATE = fnd_date.canonical_to_date(p_end_date)
4777: ,START_DATE = fnd_date.canonical_to_date(p_start_date)
4778: WHERE ROWID = p_rowid;
4779:
4780: ELSE
4781:

Line 4824: ,SHIFT_DATE = fnd_date.canonical_to_date(p_shift_date)

4820: ELSIF p_rowid IS NOT NULL THEN
4821:
4822: UPDATE MTH_WORKDAY_SHIFTS_ERR SET
4823: REPROCESS_READY_YN = p_reprocess_ready_yn
4824: ,SHIFT_DATE = fnd_date.canonical_to_date(p_shift_date)
4825: ,SOURCE_ORG_CODE = p_source_org_code
4826: ,USER_ATTR1 = p_user_attr1
4827: ,USER_ATTR2 = p_user_attr2
4828: ,USER_ATTR3 = p_user_attr3

Line 4838: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)

4834: ,USER_MEASURE4 = p_user_measure4
4835: ,USER_MEASURE5 = p_user_measure5
4836: ,SHIFT_WORKDAY_PK = p_shift_workday_pk
4837: ,SYSTEM_FK = p_system_fk
4838: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
4839: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
4840: ,SHIFT_NUM = p_shift_num
4841: ,SHIFT_NAME = p_shift_name
4842: ,SHIFT_TYPE = p_shift_type

Line 4839: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)

4835: ,USER_MEASURE5 = p_user_measure5
4836: ,SHIFT_WORKDAY_PK = p_shift_workday_pk
4837: ,SYSTEM_FK = p_system_fk
4838: ,FROM_DATE = fnd_date.canonical_to_date(p_from_date)
4839: ,TO_DATE = fnd_date.canonical_to_date(p_to_date)
4840: ,SHIFT_NUM = p_shift_num
4841: ,SHIFT_NAME = p_shift_name
4842: ,SHIFT_TYPE = p_shift_type
4843: ,GRAVEYARD_SHIFT = p_graveyard_shift

Line 4872: ,fnd_date.canonical_to_date(p_shift_date)

4868: ,SHIFT_TYPE
4869: ,GRAVEYARD_SHIFT
4870: ) VALUES (
4871: p_reprocess_ready_yn
4872: ,fnd_date.canonical_to_date(p_shift_date)
4873: ,p_source_org_code
4874: ,p_user_attr1
4875: ,p_user_attr2
4876: ,p_user_attr3

Line 4886: ,fnd_date.canonical_to_date(p_from_date)

4882: ,p_user_measure4
4883: ,p_user_measure5
4884: ,p_shift_workday_pk
4885: ,p_system_fk
4886: ,fnd_date.canonical_to_date(p_from_date)
4887: ,fnd_date.canonical_to_date(p_to_date)
4888: ,p_shift_num
4889: ,p_shift_name
4890: ,p_shift_type

Line 4887: ,fnd_date.canonical_to_date(p_to_date)

4883: ,p_user_measure5
4884: ,p_shift_workday_pk
4885: ,p_system_fk
4886: ,fnd_date.canonical_to_date(p_from_date)
4887: ,fnd_date.canonical_to_date(p_to_date)
4888: ,p_shift_num
4889: ,p_shift_name
4890: ,p_shift_type
4891: ,p_graveyard_shift

Line 4945: ,REQUESTED_DATE = fnd_date.canonical_to_date(p_requested_date)

4941: ,WORKORDER_FK = p_workorder_fk
4942: ,SALESORDER_NUMBER = p_salesorder_number
4943: ,SALESORDER_LNUMBER = p_salesorder_lnumber
4944: ,CUSTOMER = p_customer
4945: ,REQUESTED_DATE = fnd_date.canonical_to_date(p_requested_date)
4946: ,PROMISED_DATE = fnd_date.canonical_to_date(p_promised_date)
4947: ,SCHEDULED_SHIP_DATE = fnd_date.canonical_to_date(p_scheduled_ship_date)
4948: ,SYSTEM_FK = p_system_fk
4949: ,QUANTITY_G = p_quantity_g

Line 4946: ,PROMISED_DATE = fnd_date.canonical_to_date(p_promised_date)

4942: ,SALESORDER_NUMBER = p_salesorder_number
4943: ,SALESORDER_LNUMBER = p_salesorder_lnumber
4944: ,CUSTOMER = p_customer
4945: ,REQUESTED_DATE = fnd_date.canonical_to_date(p_requested_date)
4946: ,PROMISED_DATE = fnd_date.canonical_to_date(p_promised_date)
4947: ,SCHEDULED_SHIP_DATE = fnd_date.canonical_to_date(p_scheduled_ship_date)
4948: ,SYSTEM_FK = p_system_fk
4949: ,QUANTITY_G = p_quantity_g
4950: ,PRIMARY_UOM = p_primary_uom

Line 4947: ,SCHEDULED_SHIP_DATE = fnd_date.canonical_to_date(p_scheduled_ship_date)

4943: ,SALESORDER_LNUMBER = p_salesorder_lnumber
4944: ,CUSTOMER = p_customer
4945: ,REQUESTED_DATE = fnd_date.canonical_to_date(p_requested_date)
4946: ,PROMISED_DATE = fnd_date.canonical_to_date(p_promised_date)
4947: ,SCHEDULED_SHIP_DATE = fnd_date.canonical_to_date(p_scheduled_ship_date)
4948: ,SYSTEM_FK = p_system_fk
4949: ,QUANTITY_G = p_quantity_g
4950: ,PRIMARY_UOM = p_primary_uom
4951: ,PRODUCT_FK = p_product_fk

Line 5007: ,fnd_date.canonical_to_date(p_requested_date)

5003: ,p_workorder_fk
5004: ,p_salesorder_number
5005: ,p_salesorder_lnumber
5006: ,p_customer
5007: ,fnd_date.canonical_to_date(p_requested_date)
5008: ,fnd_date.canonical_to_date(p_promised_date)
5009: ,fnd_date.canonical_to_date(p_scheduled_ship_date)
5010: ,p_system_fk
5011: ,p_quantity_g

Line 5008: ,fnd_date.canonical_to_date(p_promised_date)

5004: ,p_salesorder_number
5005: ,p_salesorder_lnumber
5006: ,p_customer
5007: ,fnd_date.canonical_to_date(p_requested_date)
5008: ,fnd_date.canonical_to_date(p_promised_date)
5009: ,fnd_date.canonical_to_date(p_scheduled_ship_date)
5010: ,p_system_fk
5011: ,p_quantity_g
5012: ,p_primary_uom

Line 5009: ,fnd_date.canonical_to_date(p_scheduled_ship_date)

5005: ,p_salesorder_lnumber
5006: ,p_customer
5007: ,fnd_date.canonical_to_date(p_requested_date)
5008: ,fnd_date.canonical_to_date(p_promised_date)
5009: ,fnd_date.canonical_to_date(p_scheduled_ship_date)
5010: ,p_system_fk
5011: ,p_quantity_g
5012: ,p_primary_uom
5013: ,p_product_fk

Line 5080: ,END_DATE = fnd_date.canonical_to_date(p_end_date)

5076: ,USER_MEASURE3 = p_user_measure3
5077: ,USER_MEASURE4 = p_user_measure4
5078: ,USER_MEASURE5 = p_user_measure5
5079: ,SYSTEM_FK = p_system_fk
5080: ,END_DATE = fnd_date.canonical_to_date(p_end_date)
5081: ,START_DATE = fnd_date.canonical_to_date(p_start_date)
5082: WHERE ROWID = p_rowid;
5083:
5084: ELSE

Line 5081: ,START_DATE = fnd_date.canonical_to_date(p_start_date)

5077: ,USER_MEASURE4 = p_user_measure4
5078: ,USER_MEASURE5 = p_user_measure5
5079: ,SYSTEM_FK = p_system_fk
5080: ,END_DATE = fnd_date.canonical_to_date(p_end_date)
5081: ,START_DATE = fnd_date.canonical_to_date(p_start_date)
5082: WHERE ROWID = p_rowid;
5083:
5084: ELSE
5085: