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.GMI_MOVE_ORDER_HEADER_UTIL SQL Statements

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

Line: 38


/*  (odab) Deleted procedures :
   Procedure Clear_Dependent_Attr
   Procedure Apply_Attribute_Changes
   Function Get_Values
   Function Get_Ids
*/

/*   Function Complete_Record  */

FUNCTION Complete_Record
(   p_mo_hdr_rec                    IN  GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
,   p_old_mo_hdr_rec                IN  GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
IS
l_mo_hdr_rec                  GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;

Line: 147


    IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_mo_hdr_rec.last_updated_by := p_old_mo_hdr_rec.last_updated_by;

Line: 151


    IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_mo_hdr_rec.last_update_date := p_old_mo_hdr_rec.last_update_date;

Line: 155


    IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_mo_hdr_rec.last_update_login := p_old_mo_hdr_rec.last_update_login;

Line: 171


    IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_mo_hdr_rec.program_update_date := p_old_mo_hdr_rec.program_update_date;

Line: 312


    IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_mo_hdr_rec.last_updated_by := NULL;

Line: 316


    IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_mo_hdr_rec.last_update_date := NULL;

Line: 320


    IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_mo_hdr_rec.last_update_login := NULL;

Line: 336


    IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_mo_hdr_rec.program_update_date := NULL;

Line: 376


/*   Procedure Update_Row  */

PROCEDURE Update_Row
(   p_mo_hdr_rec                    IN  GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
)
IS
BEGIN

    UPDATE  IC_TXN_REQUEST_HEADERS
    SET     ATTRIBUTE1                     = p_mo_hdr_rec.attribute1
    ,       ATTRIBUTE10                    = p_mo_hdr_rec.attribute10
    ,       ATTRIBUTE11                    = p_mo_hdr_rec.attribute11
    ,       ATTRIBUTE12                    = p_mo_hdr_rec.attribute12
    ,       ATTRIBUTE13                    = p_mo_hdr_rec.attribute13
    ,       ATTRIBUTE14                    = p_mo_hdr_rec.attribute14
    ,       ATTRIBUTE15                    = p_mo_hdr_rec.attribute15
    ,       ATTRIBUTE2                     = p_mo_hdr_rec.attribute2
    ,       ATTRIBUTE3                     = p_mo_hdr_rec.attribute3
    ,       ATTRIBUTE4                     = p_mo_hdr_rec.attribute4
    ,       ATTRIBUTE5                     = p_mo_hdr_rec.attribute5
    ,       ATTRIBUTE6                     = p_mo_hdr_rec.attribute6
    ,       ATTRIBUTE7                     = p_mo_hdr_rec.attribute7
    ,       ATTRIBUTE8                     = p_mo_hdr_rec.attribute8
    ,       ATTRIBUTE9                     = p_mo_hdr_rec.attribute9
    ,       ATTRIBUTE_CATEGORY             = p_mo_hdr_rec.attribute_category
    ,       CREATED_BY                     = p_mo_hdr_rec.created_by
    ,       CREATION_DATE                  = p_mo_hdr_rec.creation_date
    ,       DATE_REQUIRED                  = p_mo_hdr_rec.date_required
    ,       DESCRIPTION                    = p_mo_hdr_rec.description
    ,       FROM_SUBINVENTORY_CODE         = p_mo_hdr_rec.from_subinventory_code
    ,       HEADER_ID                      = p_mo_hdr_rec.header_id
    ,       HEADER_STATUS                  = p_mo_hdr_rec.header_status
    ,       LAST_UPDATED_BY                = p_mo_hdr_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_mo_hdr_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_mo_hdr_rec.last_update_login
    ,       ORGANIZATION_ID                = p_mo_hdr_rec.organization_id
    ,       PROGRAM_APPLICATION_ID         = p_mo_hdr_rec.program_application_id
    ,       PROGRAM_ID                     = p_mo_hdr_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_mo_hdr_rec.program_update_date
    ,       REQUEST_ID                     = p_mo_hdr_rec.request_id
    ,       REQUEST_NUMBER                 = p_mo_hdr_rec.request_number
    ,       STATUS_DATE                    = p_mo_hdr_rec.status_date
    ,       TO_ACCOUNT_ID                  = p_mo_hdr_rec.to_account_id
    ,       TO_SUBINVENTORY_CODE           = p_mo_hdr_rec.to_subinventory_code
    ,       MOVE_ORDER_TYPE                = p_mo_hdr_rec.move_order_type
    ,	    TRANSACTION_TYPE_ID		   = p_mo_hdr_rec.transaction_type_id
    ,       SHIP_TO_LOCATION_ID            = p_mo_hdr_rec.ship_to_location_id
    WHERE   HEADER_ID = p_mo_hdr_rec.header_id
    ;

Line: 434


            ,   'Update_Row'
            );

Line: 440


END Update_Row;

Line: 443


/*   Procedure Insert_Row  */

PROCEDURE Insert_Row
(   p_mo_hdr_rec                    IN  GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
)
IS
BEGIN

gmi_reservation_util.println('In insert_row in GMIUMOHB.pls');

Line: 455


    INSERT  INTO IC_TXN_REQUEST_HEADERS
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DATE_REQUIRED
    ,       DESCRIPTION
    ,       FROM_SUBINVENTORY_CODE
    ,       HEADER_ID
    ,       HEADER_STATUS
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       REQUEST_NUMBER
    ,       STATUS_DATE
    ,       TO_ACCOUNT_ID
    ,       TO_SUBINVENTORY_CODE
    ,       MOVE_ORDER_TYPE
    , 	    TRANSACTION_TYPE_ID
    , 	    GROUPING_RULE_ID
    ,       SHIP_TO_LOCATION_ID
    )
    VALUES
    (       p_mo_hdr_rec.attribute1
    ,       p_mo_hdr_rec.attribute10
    ,       p_mo_hdr_rec.attribute11
    ,       p_mo_hdr_rec.attribute12
    ,       p_mo_hdr_rec.attribute13
    ,       p_mo_hdr_rec.attribute14
    ,       p_mo_hdr_rec.attribute15
    ,       p_mo_hdr_rec.attribute2
    ,       p_mo_hdr_rec.attribute3
    ,       p_mo_hdr_rec.attribute4
    ,       p_mo_hdr_rec.attribute5
    ,       p_mo_hdr_rec.attribute6
    ,       p_mo_hdr_rec.attribute7
    ,       p_mo_hdr_rec.attribute8
    ,       p_mo_hdr_rec.attribute9
    ,       p_mo_hdr_rec.attribute_category
    ,       p_mo_hdr_rec.created_by
    ,       p_mo_hdr_rec.creation_date
    ,       p_mo_hdr_rec.date_required
    ,       p_mo_hdr_rec.description
    ,       p_mo_hdr_rec.from_subinventory_code
    ,       p_mo_hdr_rec.header_id
    ,       p_mo_hdr_rec.header_status
    ,       p_mo_hdr_rec.last_updated_by
    ,       p_mo_hdr_rec.last_update_date
    ,       p_mo_hdr_rec.last_update_login
    ,       p_mo_hdr_rec.organization_id
    ,       p_mo_hdr_rec.program_application_id
    ,       p_mo_hdr_rec.program_id
    ,       p_mo_hdr_rec.program_update_date
    ,       p_mo_hdr_rec.request_id
    ,       p_mo_hdr_rec.request_number
    ,       p_mo_hdr_rec.status_date
    ,       p_mo_hdr_rec.to_account_id
    ,       p_mo_hdr_rec.to_subinventory_code
    ,       p_mo_hdr_rec.move_order_type
    ,	    p_mo_hdr_rec.transaction_type_id
    ,	    p_mo_hdr_rec.grouping_rule_id
    ,       p_mo_hdr_rec.ship_to_location_id
    );

Line: 543


    WSH_Util_Core.PrintLn('Error In Insert');

Line: 544


    gmi_reservation_util.println('ERROR in INSERT');

Line: 552


            ,   'Insert_Row'
            );

Line: 558


END Insert_Row;

Line: 560


/*   Procedure Delete_Row   */

PROCEDURE Delete_Row
(   p_header_id                     IN  NUMBER
)
IS
BEGIN

    DELETE  FROM IC_TXN_REQUEST_HEADERS
    WHERE   HEADER_ID = p_header_id
    ;

Line: 580


            ,   'Delete_Row'
            );

Line: 586


END Delete_Row;

Line: 589


/*   Procedure Update_Row_Status  */

PROCEDURE Update_Row_Status
(   p_header_id              IN  Number,
    p_status                 IN  Number
)
IS
l_mo_hdr_rec        GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;

Line: 601


                l_mo_hdr_rec.last_update_date := SYSDATE;

Line: 602


                l_mo_hdr_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 603


                l_mo_hdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 605


        /*         INV_Trohdr_Util.Update_Row(l_mo_hdr_rec);   */

Line: 616


            ,   'Update_Row_Status'
            );

Line: 622


END Update_Row_Status;

Line: 633


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DATE_REQUIRED
    ,       DESCRIPTION
    ,       FROM_SUBINVENTORY_CODE
    ,       HEADER_ID
    ,       HEADER_STATUS
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       REQUEST_NUMBER
    ,       STATUS_DATE
    ,       TO_ACCOUNT_ID
    ,       TO_SUBINVENTORY_CODE
    ,       MOVE_ORDER_TYPE
    ,       TRANSACTION_TYPE_ID
    , 	    GROUPING_RULE_ID
    ,       SHIP_TO_LOCATION_ID
    INTO    l_mo_hdr_rec.attribute1
    ,       l_mo_hdr_rec.attribute10
    ,       l_mo_hdr_rec.attribute11
    ,       l_mo_hdr_rec.attribute12
    ,       l_mo_hdr_rec.attribute13
    ,       l_mo_hdr_rec.attribute14
    ,       l_mo_hdr_rec.attribute15
    ,       l_mo_hdr_rec.attribute2
    ,       l_mo_hdr_rec.attribute3
    ,       l_mo_hdr_rec.attribute4
    ,       l_mo_hdr_rec.attribute5
    ,       l_mo_hdr_rec.attribute6
    ,       l_mo_hdr_rec.attribute7
    ,       l_mo_hdr_rec.attribute8
    ,       l_mo_hdr_rec.attribute9
    ,       l_mo_hdr_rec.attribute_category
    ,       l_mo_hdr_rec.created_by
    ,       l_mo_hdr_rec.creation_date
    ,       l_mo_hdr_rec.date_required
    ,       l_mo_hdr_rec.description
    ,       l_mo_hdr_rec.from_subinventory_code
    ,       l_mo_hdr_rec.header_id
    ,       l_mo_hdr_rec.header_status
    ,       l_mo_hdr_rec.last_updated_by
    ,       l_mo_hdr_rec.last_update_date
    ,       l_mo_hdr_rec.last_update_login
    ,       l_mo_hdr_rec.organization_id
    ,       l_mo_hdr_rec.program_application_id
    ,       l_mo_hdr_rec.program_id
    ,       l_mo_hdr_rec.program_update_date
    ,       l_mo_hdr_rec.request_id
    ,       l_mo_hdr_rec.request_number
    ,       l_mo_hdr_rec.status_date
    ,       l_mo_hdr_rec.to_account_id
    ,       l_mo_hdr_rec.to_subinventory_code
    ,       l_mo_hdr_rec.move_order_type
    ,       l_mo_hdr_rec.transaction_type_id
    ,	    l_mo_hdr_rec.grouping_rule_id
    ,       l_mo_hdr_rec.ship_to_location_id
    FROM    IC_TXN_REQUEST_HEADERS
    WHERE   HEADER_ID = p_header_id
    ;

Line: 743


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DATE_REQUIRED
    ,       DESCRIPTION
    ,       FROM_SUBINVENTORY_CODE
    ,       HEADER_ID
    ,       HEADER_STATUS
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       REQUEST_NUMBER
    ,       STATUS_DATE
    ,       TO_ACCOUNT_ID
    ,       TO_SUBINVENTORY_CODE
    ,       MOVE_ORDER_TYPE
    ,       TRANSACTION_TYPE_ID
    , 	    grouping_rule_id
    ,       SHIP_TO_LOCATION_ID
    INTO    l_mo_hdr_rec.attribute1
    ,       l_mo_hdr_rec.attribute10
    ,       l_mo_hdr_rec.attribute11
    ,       l_mo_hdr_rec.attribute12
    ,       l_mo_hdr_rec.attribute13
    ,       l_mo_hdr_rec.attribute14
    ,       l_mo_hdr_rec.attribute15
    ,       l_mo_hdr_rec.attribute2
    ,       l_mo_hdr_rec.attribute3
    ,       l_mo_hdr_rec.attribute4
    ,       l_mo_hdr_rec.attribute5
    ,       l_mo_hdr_rec.attribute6
    ,       l_mo_hdr_rec.attribute7
    ,       l_mo_hdr_rec.attribute8
    ,       l_mo_hdr_rec.attribute9
    ,       l_mo_hdr_rec.attribute_category
    ,       l_mo_hdr_rec.created_by
    ,       l_mo_hdr_rec.creation_date
    ,       l_mo_hdr_rec.date_required
    ,       l_mo_hdr_rec.description
    ,       l_mo_hdr_rec.from_subinventory_code
    ,       l_mo_hdr_rec.header_id
    ,       l_mo_hdr_rec.header_status
    ,       l_mo_hdr_rec.last_updated_by
    ,       l_mo_hdr_rec.last_update_date
    ,       l_mo_hdr_rec.last_update_login
    ,       l_mo_hdr_rec.organization_id
    ,       l_mo_hdr_rec.program_application_id
    ,       l_mo_hdr_rec.program_id
    ,       l_mo_hdr_rec.program_update_date
    ,       l_mo_hdr_rec.request_id
    ,       l_mo_hdr_rec.request_number
    ,       l_mo_hdr_rec.status_date
    ,       l_mo_hdr_rec.to_account_id
    ,       l_mo_hdr_rec.to_subinventory_code
    ,       l_mo_hdr_rec.move_order_type
    ,       l_mo_hdr_rec.transaction_type_id
    ,	    l_mo_hdr_rec.grouping_rule_id
    ,       l_mo_hdr_rec.ship_to_location_id
    FROM    IC_TXN_REQUEST_HEADERS
    WHERE   HEADER_ID = p_mo_hdr_rec.header_id
        FOR UPDATE NOWAIT;

Line: 873


    AND INV_GLOBALS.Equal(p_mo_hdr_rec.last_updated_by,
                         l_mo_hdr_rec.last_updated_by)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.last_update_date,
                         l_mo_hdr_rec.last_update_date)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.last_update_login,
                         l_mo_hdr_rec.last_update_login)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.organization_id,
                         l_mo_hdr_rec.organization_id)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.program_application_id,
                         l_mo_hdr_rec.program_application_id)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.program_id,
                         l_mo_hdr_rec.program_id)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.program_update_date,
                         l_mo_hdr_rec.program_update_date)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.request_id,
                         l_mo_hdr_rec.request_id)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.request_number,
                         l_mo_hdr_rec.request_number)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.status_date,
                         l_mo_hdr_rec.status_date)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.to_account_id,
                         l_mo_hdr_rec.to_account_id)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.to_subinventory_code,
                         l_mo_hdr_rec.to_subinventory_code)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.move_order_type,
                         l_mo_hdr_rec.move_order_type)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.transaction_type_id,
                         l_mo_hdr_rec.transaction_type_id)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.grouping_rule_id,
                         l_mo_hdr_rec.grouping_rule_id)
    AND INV_GLOBALS.Equal(p_mo_hdr_rec.ship_to_location_id,
                         l_mo_hdr_rec.ship_to_location_id)
    THEN

        /*   Row has not changed. Set out parameter.   */

        x_mo_hdr_rec                   := l_mo_hdr_rec;

Line: 943


            FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_DELETED');