APPS.BOM_RTG_GLOBALS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 105

  SELECT approval_status_type
  INTO   l_approval_status_type
  FROM   eng_engineering_changes
  WHERE  change_notice = p_change_notice
    AND  organization_id = p_organization_id;

Line: 141

        UPDATE eng_engineering_changes
           SET approval_status_type = 1,
               approval_request_date = null,
               approval_date = null,
               last_update_date = SYSDATE,
               last_updated_by = FND_GLOBAL.USER_ID,
               last_update_login = FND_GLOBAL.LOGIN_ID
         WHERE organization_id = p_organization_id
           AND change_notice = p_change_notice;

Line: 153

        UPDATE eng_revised_items
           SET status_type = 1,
               last_update_date = SYSDATE,
               last_updated_by = FND_GLOBAL.USER_ID,
               last_update_login = FND_GLOBAL.LOGIN_ID
         WHERE organization_id = p_organization_id
           AND change_notice = p_change_notice
           AND status_type = 4;

Line: 193

        SELECT process_name
        INTO l_process_name
        FROM eng_change_type_processes
        WHERE change_order_type_id = p_change_order_type_id
           AND ( p_priority_code is NOT NULL
                  AND eng_change_priority_code = p_priority_code
                  AND organization_id = p_organization_id)
                OR
                (p_priority_code is NULL
                  AND eng_change_priority_code is NULL);

Line: 968

  SELECT effectivity_control
  FROM mtl_system_items
  WHERE inventory_item_id = p_inventory_item_id
  AND organization_id   = p_organization_id;

Line: 1023

  SELECT effectivity_control
  FROM mtl_system_items
  WHERE inventory_item_id = p_inventory_item_id
  AND organization_id   = p_organization_id;

Line: 1441

                        NOT IN ('CREATE', 'UPDATE', 'DELETE')
       )
   --    OR
   --    ( p_entity ='Bom_Rev' AND
   --       NVL(p_transaction_type, FND_API.G_MISS_CHAR)
   --                     NOT IN ('CREATE', 'UPDATE')
   --    )
    THEN
        IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
        THEN
            IF p_entity = 'Routing_Header'
            THEN
                Error_Handler.Add_Error_Token
                ( p_Message_Name       => 'BOM_RTG_TRANS_TYPE_INVALID'
                , p_Mesg_Token_Tbl     => l_Mesg_Token_Tbl
                , x_Mesg_Token_Tbl     => l_Mesg_Token_Tbl
                );

Line: 1555

*                 insert/update. But we need to differ this comparision
*                 till we process last network link. So we increment this
*                 counter as we process the records and then compare it
*                 with Netowkr table count
*****************************************************************************/
PROCEDURE Set_Osfm_NW_Count
          ( p_nw_count IN  NUMBER)
IS
BEGIN
        G_System_Information.Osfm_NW_Count := p_nw_count;

Line: 1656

	G_Temp_Op_Rec_Tbl.DELETE;

Line: 1675

	SELECT pending_from_ecn
	INTO l_pend_from_ecn
	FROM bom_operational_routings
	WHERE routing_sequence_id = p_routing_seq_id;