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.EAM_WORKORDERTRANSACTIONS_PUB dependencies on WIP_OPERATIONS

Line 685: l_operation_completed wip_operations.operation_completed%type;

681: l_shutdown_end_date DATE ;
682: l_shutdown_duration NUMBER;
683: l_err_code NUMBER;
684: l_err_msg VARCHAR2(1000);
685: l_operation_completed wip_operations.operation_completed%type;
686: l_shutdown_type wip_operations.shutdown_type%type;
687: l_transaction_type NUMBER;
688: l_department_id wip_operations.department_id%type;
689: l_description wip_operations.description%type;

Line 686: l_shutdown_type wip_operations.shutdown_type%type;

682: l_shutdown_duration NUMBER;
683: l_err_code NUMBER;
684: l_err_msg VARCHAR2(1000);
685: l_operation_completed wip_operations.operation_completed%type;
686: l_shutdown_type wip_operations.shutdown_type%type;
687: l_transaction_type NUMBER;
688: l_department_id wip_operations.department_id%type;
689: l_description wip_operations.description%type;
690: l_quantity_completed wip_operations.quantity_completed%type;

Line 688: l_department_id wip_operations.department_id%type;

684: l_err_msg VARCHAR2(1000);
685: l_operation_completed wip_operations.operation_completed%type;
686: l_shutdown_type wip_operations.shutdown_type%type;
687: l_transaction_type NUMBER;
688: l_department_id wip_operations.department_id%type;
689: l_description wip_operations.description%type;
690: l_quantity_completed wip_operations.quantity_completed%type;
691: l_first_unit_start_date wip_operations.first_unit_start_date%type;
692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;

Line 689: l_description wip_operations.description%type;

685: l_operation_completed wip_operations.operation_completed%type;
686: l_shutdown_type wip_operations.shutdown_type%type;
687: l_transaction_type NUMBER;
688: l_department_id wip_operations.department_id%type;
689: l_description wip_operations.description%type;
690: l_quantity_completed wip_operations.quantity_completed%type;
691: l_first_unit_start_date wip_operations.first_unit_start_date%type;
692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;
693: l_created_by wip_operations.created_by%type;

Line 690: l_quantity_completed wip_operations.quantity_completed%type;

686: l_shutdown_type wip_operations.shutdown_type%type;
687: l_transaction_type NUMBER;
688: l_department_id wip_operations.department_id%type;
689: l_description wip_operations.description%type;
690: l_quantity_completed wip_operations.quantity_completed%type;
691: l_first_unit_start_date wip_operations.first_unit_start_date%type;
692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;
693: l_created_by wip_operations.created_by%type;
694: l_creation_date wip_operations.creation_date%type;

Line 691: l_first_unit_start_date wip_operations.first_unit_start_date%type;

687: l_transaction_type NUMBER;
688: l_department_id wip_operations.department_id%type;
689: l_description wip_operations.description%type;
690: l_quantity_completed wip_operations.quantity_completed%type;
691: l_first_unit_start_date wip_operations.first_unit_start_date%type;
692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;
693: l_created_by wip_operations.created_by%type;
694: l_creation_date wip_operations.creation_date%type;
695: l_last_updated_by wip_operations.last_updated_by%type;

Line 692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;

688: l_department_id wip_operations.department_id%type;
689: l_description wip_operations.description%type;
690: l_quantity_completed wip_operations.quantity_completed%type;
691: l_first_unit_start_date wip_operations.first_unit_start_date%type;
692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;
693: l_created_by wip_operations.created_by%type;
694: l_creation_date wip_operations.creation_date%type;
695: l_last_updated_by wip_operations.last_updated_by%type;
696: l_last_update_login wip_operations.last_update_login%type;

Line 693: l_created_by wip_operations.created_by%type;

689: l_description wip_operations.description%type;
690: l_quantity_completed wip_operations.quantity_completed%type;
691: l_first_unit_start_date wip_operations.first_unit_start_date%type;
692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;
693: l_created_by wip_operations.created_by%type;
694: l_creation_date wip_operations.creation_date%type;
695: l_last_updated_by wip_operations.last_updated_by%type;
696: l_last_update_login wip_operations.last_update_login%type;
697: l_last_update_date wip_operations.last_update_date%type;

Line 694: l_creation_date wip_operations.creation_date%type;

690: l_quantity_completed wip_operations.quantity_completed%type;
691: l_first_unit_start_date wip_operations.first_unit_start_date%type;
692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;
693: l_created_by wip_operations.created_by%type;
694: l_creation_date wip_operations.creation_date%type;
695: l_last_updated_by wip_operations.last_updated_by%type;
696: l_last_update_login wip_operations.last_update_login%type;
697: l_last_update_date wip_operations.last_update_date%type;
698:

Line 695: l_last_updated_by wip_operations.last_updated_by%type;

691: l_first_unit_start_date wip_operations.first_unit_start_date%type;
692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;
693: l_created_by wip_operations.created_by%type;
694: l_creation_date wip_operations.creation_date%type;
695: l_last_updated_by wip_operations.last_updated_by%type;
696: l_last_update_login wip_operations.last_update_login%type;
697: l_last_update_date wip_operations.last_update_date%type;
698:
699:

Line 696: l_last_update_login wip_operations.last_update_login%type;

692: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;
693: l_created_by wip_operations.created_by%type;
694: l_creation_date wip_operations.creation_date%type;
695: l_last_updated_by wip_operations.last_updated_by%type;
696: l_last_update_login wip_operations.last_update_login%type;
697: l_last_update_date wip_operations.last_update_date%type;
698:
699:
700: BEGIN

Line 697: l_last_update_date wip_operations.last_update_date%type;

693: l_created_by wip_operations.created_by%type;
694: l_creation_date wip_operations.creation_date%type;
695: l_last_updated_by wip_operations.last_updated_by%type;
696: l_last_update_login wip_operations.last_update_login%type;
697: l_last_update_date wip_operations.last_update_date%type;
698:
699:
700: BEGIN
701: SAVEPOINT Complete_Operation_PVT;

Line 753: wip_operations wo

749: l_last_updated_by,
750: l_last_update_login,
751: l_last_update_date
752: from
753: wip_operations wo
754: where
755: wip_entity_id = p_wip_entity_id and
756: operation_seq_num =p_operation_seq_num;
757:

Line 995: -- insert into eam_op_completion_txns, update wip_operations

991: p_attribute15 => p_attribute_rec.p_attribute15
992: );
993:
994: -- call eam_op_comp.op_comp to
995: -- insert into eam_op_completion_txns, update wip_operations
996:
997: if l_err_code = 1 then -- there was an error
998: x_return_status := FND_API.G_RET_STS_ERROR;
999: FND_MSG_PUB.Add;