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 687: l_operation_completed wip_operations.operation_completed%type;

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

Line 688: l_shutdown_type wip_operations.shutdown_type%type;

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

Line 690: l_department_id wip_operations.department_id%type;

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

Line 691: l_description wip_operations.description%type;

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

Line 692: l_quantity_completed wip_operations.quantity_completed%type;

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

Line 693: l_first_unit_start_date wip_operations.first_unit_start_date%type;

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

Line 694: l_last_unit_completion_date wip_operations.last_unit_completion_date%type;

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

Line 695: l_created_by wip_operations.created_by%type;

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

Line 696: l_creation_date wip_operations.creation_date%type;

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

Line 697: l_last_updated_by wip_operations.last_updated_by%type;

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

Line 698: l_last_update_login wip_operations.last_update_login%type;

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

Line 699: l_last_update_date wip_operations.last_update_date%type;

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

Line 755: wip_operations wo

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

Line 997: -- insert into eam_op_completion_txns, update wip_operations

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