[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF l_Res_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_Res_rec.last_updated_by := NULL;
IF l_Res_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
l_Res_rec.last_updated_by_name := NULL;
IF l_Res_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_Res_rec.last_update_date := NULL;
IF l_Res_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_Res_rec.last_update_login := NULL;
IF l_Res_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_Res_rec.program_update_date := NULL;
PROCEDURE Update_Row
( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
)
IS
BEGIN
UPDATE WIP_COST_TXN_INTERFACE
SET ACCT_PERIOD_ID = p_Res_rec.acct_period_id
, ACTIVITY_ID = p_Res_rec.activity_id
, ACTIVITY_NAME = p_Res_rec.activity_name
, ACTUAL_RESOURCE_RATE = p_Res_rec.actual_resource_rate
, ATTRIBUTE1 = p_Res_rec.attribute1
, ATTRIBUTE10 = p_Res_rec.attribute10
, ATTRIBUTE11 = p_Res_rec.attribute11
, ATTRIBUTE12 = p_Res_rec.attribute12
, ATTRIBUTE13 = p_Res_rec.attribute13
, ATTRIBUTE14 = p_Res_rec.attribute14
, ATTRIBUTE15 = p_Res_rec.attribute15
, ATTRIBUTE2 = p_Res_rec.attribute2
, ATTRIBUTE3 = p_Res_rec.attribute3
, ATTRIBUTE4 = p_Res_rec.attribute4
, ATTRIBUTE5 = p_Res_rec.attribute5
, ATTRIBUTE6 = p_Res_rec.attribute6
, ATTRIBUTE7 = p_Res_rec.attribute7
, ATTRIBUTE8 = p_Res_rec.attribute8
, ATTRIBUTE9 = p_Res_rec.attribute9
, ATTRIBUTE_CATEGORY = p_Res_rec.attribute_category
, AUTOCHARGE_TYPE = p_Res_rec.autocharge_type
, BASIS_TYPE = p_Res_rec.basis_type
, COMPLETION_TRANSACTION_ID = p_Res_rec.completion_transaction_id
, CREATED_BY = p_Res_rec.created_by
, CREATED_BY_NAME = p_Res_rec.created_by_name
, CREATION_DATE = p_Res_rec.creation_date
, CURRENCY_ACTUAL_RESOURCE_RATE = p_Res_rec.currency_actual_rsc_rate
, CURRENCY_CODE = p_Res_rec.currency_code
, CURRENCY_CONVERSION_DATE = p_Res_rec.currency_conversion_date
, CURRENCY_CONVERSION_RATE = p_Res_rec.currency_conversion_rate
, CURRENCY_CONVERSION_TYPE = p_Res_rec.currency_conversion_type
, DEPARTMENT_CODE = p_Res_rec.department_code
, DEPARTMENT_ID = p_Res_rec.department_id
, EMPLOYEE_ID = p_Res_rec.employee_id
, EMPLOYEE_NUM = p_Res_rec.employee_num
, ENTITY_TYPE = p_Res_rec.entity_type
, GROUP_ID = p_Res_rec.group_id
, LAST_UPDATED_BY = p_Res_rec.last_updated_by
, LAST_UPDATED_BY_NAME = p_Res_rec.last_updated_by_name
, LAST_UPDATE_DATE = p_Res_rec.last_update_date
, LAST_UPDATE_LOGIN = p_Res_rec.last_update_login
, LINE_CODE = p_Res_rec.line_code
, LINE_ID = p_Res_rec.line_id
, MOVE_TRANSACTION_ID = p_Res_rec.move_transaction_id
, OPERATION_SEQ_NUM = p_Res_rec.operation_seq_num
, ORGANIZATION_CODE = p_Res_rec.organization_code
, ORGANIZATION_ID = p_Res_rec.organization_id
, PO_HEADER_ID = p_Res_rec.po_header_id
, PO_LINE_ID = p_Res_rec.po_line_id
, PRIMARY_ITEM_ID = p_Res_rec.primary_item_id
, PRIMARY_QUANTITY = p_Res_rec.primary_quantity
, PRIMARY_UOM = p_Res_rec.primary_uom
, PRIMARY_UOM_CLASS = p_Res_rec.primary_uom_class
, PROCESS_PHASE = p_Res_rec.process_phase
, PROCESS_STATUS = p_Res_rec.process_status
, PROGRAM_APPLICATION_ID = p_Res_rec.program_application_id
, PROGRAM_ID = p_Res_rec.program_id
, PROGRAM_UPDATE_DATE = p_Res_rec.program_update_date
, PROJECT_ID = p_Res_rec.project_id
, RCV_TRANSACTION_ID = p_Res_rec.rcv_transaction_id
, REASON_ID = p_Res_rec.reason_id
, REASON_NAME = p_Res_rec.reason_name
, RECEIVING_ACCOUNT_ID = p_Res_rec.receiving_account_id
, REFERENCE = p_Res_rec.reference
, REPETITIVE_SCHEDULE_ID = p_Res_rec.repetitive_schedule_id
, REQUEST_ID = p_Res_rec.request_id
, RESOURCE_CODE = p_Res_rec.resource_code
, RESOURCE_ID = p_Res_rec.resource_id
, RESOURCE_SEQ_NUM = p_Res_rec.resource_seq_num
, RESOURCE_TYPE = p_Res_rec.resource_type
, SOURCE_CODE = p_Res_rec.source_code
, SOURCE_LINE_ID = p_Res_rec.source_line_id
, STANDARD_RATE_FLAG = p_Res_rec.standard_rate_flag
, TASK_ID = p_Res_rec.task_id
, TRANSACTION_DATE = p_Res_rec.transaction_date
, TRANSACTION_ID = p_Res_rec.transaction_id
, TRANSACTION_QUANTITY = p_Res_rec.transaction_quantity
, TRANSACTION_TYPE = p_Res_rec.transaction_type
, TRANSACTION_UOM = p_Res_rec.transaction_uom
, USAGE_RATE_OR_AMOUNT = p_Res_rec.usage_rate_or_amount
, WIP_ENTITY_ID = p_Res_rec.wip_entity_id
/* Fix for bug 3427769. Removed WIP_ENTITY_NAME from update statement.
, WIP_ENTITY_NAME = p_Res_rec.wip_entity_name
*/
WHERE PO_HEADER_ID = p_Res_rec.po_header_id
;
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
)
IS
BEGIN
INSERT INTO WIP_COST_TXN_INTERFACE
( ACCT_PERIOD_ID
, ACTIVITY_ID
, ACTIVITY_NAME
, ACTUAL_RESOURCE_RATE
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, AUTOCHARGE_TYPE
, BASIS_TYPE
, COMPLETION_TRANSACTION_ID
, CREATED_BY
, CREATED_BY_NAME
, CREATION_DATE
, CURRENCY_ACTUAL_RESOURCE_RATE
, CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, DEPARTMENT_CODE
, DEPARTMENT_ID
, EMPLOYEE_ID
, EMPLOYEE_NUM
, ENTITY_TYPE
, GROUP_ID
, LAST_UPDATED_BY
, LAST_UPDATED_BY_NAME
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_CODE
, LINE_ID
, MOVE_TRANSACTION_ID
, OPERATION_SEQ_NUM
, ORGANIZATION_CODE
, ORGANIZATION_ID
, PO_HEADER_ID
, PO_LINE_ID
, PRIMARY_ITEM_ID
, PRIMARY_QUANTITY
, PRIMARY_UOM
, PRIMARY_UOM_CLASS
, PROCESS_PHASE
, PROCESS_STATUS
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, RCV_TRANSACTION_ID
, REASON_ID
, REASON_NAME
, RECEIVING_ACCOUNT_ID
, REFERENCE
, REPETITIVE_SCHEDULE_ID
, REQUEST_ID
, RESOURCE_CODE
, RESOURCE_ID
, RESOURCE_SEQ_NUM
, RESOURCE_TYPE
, SOURCE_CODE
, SOURCE_LINE_ID
, STANDARD_RATE_FLAG
, TASK_ID
, TRANSACTION_DATE
, TRANSACTION_ID
, TRANSACTION_QUANTITY
, TRANSACTION_TYPE
, TRANSACTION_UOM
, USAGE_RATE_OR_AMOUNT
, WIP_ENTITY_ID
/* Fix for bug 3427769. Removed WIP_ENTITY_NAME from insert statement.
, WIP_ENTITY_NAME
*/
)
VALUES
( p_Res_rec.acct_period_id
, p_Res_rec.activity_id
, p_Res_rec.activity_name
, p_Res_rec.actual_resource_rate
, p_Res_rec.attribute1
, p_Res_rec.attribute10
, p_Res_rec.attribute11
, p_Res_rec.attribute12
, p_Res_rec.attribute13
, p_Res_rec.attribute14
, p_Res_rec.attribute15
, p_Res_rec.attribute2
, p_Res_rec.attribute3
, p_Res_rec.attribute4
, p_Res_rec.attribute5
, p_Res_rec.attribute6
, p_Res_rec.attribute7
, p_Res_rec.attribute8
, p_Res_rec.attribute9
, p_Res_rec.attribute_category
, p_Res_rec.autocharge_type
, p_Res_rec.basis_type
, p_Res_rec.completion_transaction_id
, p_Res_rec.created_by
, p_Res_rec.created_by_name
, p_Res_rec.creation_date
, p_Res_rec.currency_actual_rsc_rate
, p_Res_rec.currency_code
, p_Res_rec.currency_conversion_date
, p_Res_rec.currency_conversion_rate
, p_Res_rec.currency_conversion_type
, p_Res_rec.department_code
, p_Res_rec.department_id
, p_Res_rec.employee_id
, p_Res_rec.employee_num
, p_Res_rec.entity_type
, p_Res_rec.group_id
, p_Res_rec.last_updated_by
, p_Res_rec.last_updated_by_name
, p_Res_rec.last_update_date
, p_Res_rec.last_update_login
, p_Res_rec.line_code
, p_Res_rec.line_id
, p_Res_rec.move_transaction_id
, p_Res_rec.operation_seq_num
, p_Res_rec.organization_code
, p_Res_rec.organization_id
, p_Res_rec.po_header_id
, p_Res_rec.po_line_id
, p_Res_rec.primary_item_id
, p_Res_rec.primary_quantity
, p_Res_rec.primary_uom
, p_Res_rec.primary_uom_class
, p_Res_rec.process_phase
, p_Res_rec.process_status
, p_Res_rec.program_application_id
, p_Res_rec.program_id
, p_Res_rec.program_update_date
, p_Res_rec.project_id
, p_Res_rec.rcv_transaction_id
, p_Res_rec.reason_id
, p_Res_rec.reason_name
, p_Res_rec.receiving_account_id
, p_Res_rec.reference
, p_Res_rec.repetitive_schedule_id
, p_Res_rec.request_id
, p_Res_rec.resource_code
, p_Res_rec.resource_id
, p_Res_rec.resource_seq_num
, p_Res_rec.resource_type
, p_Res_rec.source_code
, p_Res_rec.source_line_id
, p_Res_rec.standard_rate_flag
, p_Res_rec.task_id
, p_Res_rec.transaction_date
, p_Res_rec.transaction_id
, p_Res_rec.transaction_quantity
, p_Res_rec.transaction_type
, p_Res_rec.transaction_uom
, p_Res_rec.usage_rate_or_amount
, p_Res_rec.wip_entity_id
/* Fix for bug 3427769. Removed WIP_ENTITY_NAME from insert statement.
, p_Res_rec.wip_entity_name
*/
);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_po_header_id IN NUMBER
)
IS
BEGIN
DELETE FROM WIP_COST_TXN_INTERFACE
WHERE PO_HEADER_ID = p_po_header_id
;
, 'Delete_Row'
);
END Delete_Row;
SELECT ACCT_PERIOD_ID
, ACTIVITY_ID
, ACTIVITY_NAME
, ACTUAL_RESOURCE_RATE
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, AUTOCHARGE_TYPE
, BASIS_TYPE
, COMPLETION_TRANSACTION_ID
, CREATED_BY
, CREATED_BY_NAME
, CREATION_DATE
, CURRENCY_ACTUAL_RESOURCE_RATE
, CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, DEPARTMENT_CODE
, DEPARTMENT_ID
, EMPLOYEE_ID
, EMPLOYEE_NUM
, ENTITY_TYPE
, GROUP_ID
, LAST_UPDATED_BY
, LAST_UPDATED_BY_NAME
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_CODE
, LINE_ID
, MOVE_TRANSACTION_ID
, OPERATION_SEQ_NUM
, ORGANIZATION_CODE
, ORGANIZATION_ID
, PO_HEADER_ID
, PO_LINE_ID
, PRIMARY_ITEM_ID
, PRIMARY_QUANTITY
, PRIMARY_UOM
, PRIMARY_UOM_CLASS
, PROCESS_PHASE
, PROCESS_STATUS
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, RCV_TRANSACTION_ID
, REASON_ID
, REASON_NAME
, RECEIVING_ACCOUNT_ID
, REFERENCE
, REPETITIVE_SCHEDULE_ID
, REQUEST_ID
, RESOURCE_CODE
, RESOURCE_ID
, RESOURCE_SEQ_NUM
, RESOURCE_TYPE
, SOURCE_CODE
, SOURCE_LINE_ID
, STANDARD_RATE_FLAG
, TASK_ID
, TRANSACTION_DATE
, TRANSACTION_ID
, TRANSACTION_QUANTITY
, TRANSACTION_TYPE
, TRANSACTION_UOM
, USAGE_RATE_OR_AMOUNT
, WIP_ENTITY_ID
, WIP_ENTITY_NAME
FROM WIP_COST_TXN_INTERFACE
WHERE ( PO_HEADER_ID = nvl(p_po_header_id,FND_API.G_MISS_NUM)
);
l_Res_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
l_Res_rec.last_updated_by_name := l_implicit_rec.LAST_UPDATED_BY_NAME;
l_Res_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
l_Res_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
l_Res_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;
SELECT ACCT_PERIOD_ID
, ACTIVITY_ID
, ACTIVITY_NAME
, ACTUAL_RESOURCE_RATE
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, AUTOCHARGE_TYPE
, BASIS_TYPE
, COMPLETION_TRANSACTION_ID
, CREATED_BY
, CREATED_BY_NAME
, CREATION_DATE
, CURRENCY_ACTUAL_RESOURCE_RATE
, CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, DEPARTMENT_CODE
, DEPARTMENT_ID
, EMPLOYEE_ID
, EMPLOYEE_NUM
, ENTITY_TYPE
, GROUP_ID
, LAST_UPDATED_BY
, LAST_UPDATED_BY_NAME
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_CODE
, LINE_ID
, MOVE_TRANSACTION_ID
, OPERATION_SEQ_NUM
, ORGANIZATION_CODE
, ORGANIZATION_ID
, PO_HEADER_ID
, PO_LINE_ID
, PRIMARY_ITEM_ID
, PRIMARY_QUANTITY
, PRIMARY_UOM
, PRIMARY_UOM_CLASS
, PROCESS_PHASE
, PROCESS_STATUS
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, RCV_TRANSACTION_ID
, REASON_ID
, REASON_NAME
, RECEIVING_ACCOUNT_ID
, REFERENCE
, REPETITIVE_SCHEDULE_ID
, REQUEST_ID
, RESOURCE_CODE
, RESOURCE_ID
, RESOURCE_SEQ_NUM
, RESOURCE_TYPE
, SOURCE_CODE
, SOURCE_LINE_ID
, STANDARD_RATE_FLAG
, TASK_ID
, TRANSACTION_DATE
, TRANSACTION_ID
, TRANSACTION_QUANTITY
, TRANSACTION_TYPE
, TRANSACTION_UOM
, USAGE_RATE_OR_AMOUNT
, WIP_ENTITY_ID
, WIP_ENTITY_NAME
INTO l_Res_rec.acct_period_id
, l_Res_rec.activity_id
, l_Res_rec.activity_name
, l_Res_rec.actual_resource_rate
, l_Res_rec.attribute1
, l_Res_rec.attribute10
, l_Res_rec.attribute11
, l_Res_rec.attribute12
, l_Res_rec.attribute13
, l_Res_rec.attribute14
, l_Res_rec.attribute15
, l_Res_rec.attribute2
, l_Res_rec.attribute3
, l_Res_rec.attribute4
, l_Res_rec.attribute5
, l_Res_rec.attribute6
, l_Res_rec.attribute7
, l_Res_rec.attribute8
, l_Res_rec.attribute9
, l_Res_rec.attribute_category
, l_Res_rec.autocharge_type
, l_Res_rec.basis_type
, l_Res_rec.completion_transaction_id
, l_Res_rec.created_by
, l_Res_rec.created_by_name
, l_Res_rec.creation_date
, l_Res_rec.currency_actual_rsc_rate
, l_Res_rec.currency_code
, l_Res_rec.currency_conversion_date
, l_Res_rec.currency_conversion_rate
, l_Res_rec.currency_conversion_type
, l_Res_rec.department_code
, l_Res_rec.department_id
, l_Res_rec.employee_id
, l_Res_rec.employee_num
, l_Res_rec.entity_type
, l_Res_rec.group_id
, l_Res_rec.last_updated_by
, l_Res_rec.last_updated_by_name
, l_Res_rec.last_update_date
, l_Res_rec.last_update_login
, l_Res_rec.line_code
, l_Res_rec.line_id
, l_Res_rec.move_transaction_id
, l_Res_rec.operation_seq_num
, l_Res_rec.organization_code
, l_Res_rec.organization_id
, l_Res_rec.po_header_id
, l_Res_rec.po_line_id
, l_Res_rec.primary_item_id
, l_Res_rec.primary_quantity
, l_Res_rec.primary_uom
, l_Res_rec.primary_uom_class
, l_Res_rec.process_phase
, l_Res_rec.process_status
, l_Res_rec.program_application_id
, l_Res_rec.program_id
, l_Res_rec.program_update_date
, l_Res_rec.project_id
, l_Res_rec.rcv_transaction_id
, l_Res_rec.reason_id
, l_Res_rec.reason_name
, l_Res_rec.receiving_account_id
, l_Res_rec.reference
, l_Res_rec.repetitive_schedule_id
, l_Res_rec.request_id
, l_Res_rec.resource_code
, l_Res_rec.resource_id
, l_Res_rec.resource_seq_num
, l_Res_rec.resource_type
, l_Res_rec.source_code
, l_Res_rec.source_line_id
, l_Res_rec.standard_rate_flag
, l_Res_rec.task_id
, l_Res_rec.transaction_date
, l_Res_rec.transaction_id
, l_Res_rec.transaction_quantity
, l_Res_rec.transaction_type
, l_Res_rec.transaction_uom
, l_Res_rec.usage_rate_or_amount
, l_Res_rec.wip_entity_id
, l_Res_rec.wip_entity_name
FROM WIP_COST_TXN_INTERFACE
WHERE PO_HEADER_ID = p_Res_rec.po_header_id
FOR UPDATE NOWAIT;
AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by,
l_Res_rec.last_updated_by)
AND WIP_GLOBALS.Equal(p_Res_rec.last_updated_by_name,
l_Res_rec.last_updated_by_name)
AND WIP_GLOBALS.Equal(p_Res_rec.last_update_date,
l_Res_rec.last_update_date)
AND WIP_GLOBALS.Equal(p_Res_rec.last_update_login,
l_Res_rec.last_update_login)
AND WIP_GLOBALS.Equal(p_Res_rec.line_code,
l_Res_rec.line_code)
AND WIP_GLOBALS.Equal(p_Res_rec.line_id,
l_Res_rec.line_id)
AND WIP_GLOBALS.Equal(p_Res_rec.move_transaction_id,
l_Res_rec.move_transaction_id)
AND WIP_GLOBALS.Equal(p_Res_rec.operation_seq_num,
l_Res_rec.operation_seq_num)
AND WIP_GLOBALS.Equal(p_Res_rec.organization_code,
l_Res_rec.organization_code)
AND WIP_GLOBALS.Equal(p_Res_rec.organization_id,
l_Res_rec.organization_id)
AND WIP_GLOBALS.Equal(p_Res_rec.po_header_id,
l_Res_rec.po_header_id)
AND WIP_GLOBALS.Equal(p_Res_rec.po_line_id,
l_Res_rec.po_line_id)
AND WIP_GLOBALS.Equal(p_Res_rec.primary_item_id,
l_Res_rec.primary_item_id)
AND WIP_GLOBALS.Equal(p_Res_rec.primary_quantity,
l_Res_rec.primary_quantity)
AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom,
l_Res_rec.primary_uom)
AND WIP_GLOBALS.Equal(p_Res_rec.primary_uom_class,
l_Res_rec.primary_uom_class)
AND WIP_GLOBALS.Equal(p_Res_rec.process_phase,
l_Res_rec.process_phase)
AND WIP_GLOBALS.Equal(p_Res_rec.process_status,
l_Res_rec.process_status)
AND WIP_GLOBALS.Equal(p_Res_rec.program_application_id,
l_Res_rec.program_application_id)
AND WIP_GLOBALS.Equal(p_Res_rec.program_id,
l_Res_rec.program_id)
AND WIP_GLOBALS.Equal(p_Res_rec.program_update_date,
l_Res_rec.program_update_date)
AND WIP_GLOBALS.Equal(p_Res_rec.project_id,
l_Res_rec.project_id)
AND WIP_GLOBALS.Equal(p_Res_rec.rcv_transaction_id,
l_Res_rec.rcv_transaction_id)
AND WIP_GLOBALS.Equal(p_Res_rec.reason_id,
l_Res_rec.reason_id)
AND WIP_GLOBALS.Equal(p_Res_rec.reason_name,
l_Res_rec.reason_name)
AND WIP_GLOBALS.Equal(p_Res_rec.receiving_account_id,
l_Res_rec.receiving_account_id)
AND WIP_GLOBALS.Equal(p_Res_rec.reference,
l_Res_rec.reference)
AND WIP_GLOBALS.Equal(p_Res_rec.repetitive_schedule_id,
l_Res_rec.repetitive_schedule_id)
AND WIP_GLOBALS.Equal(p_Res_rec.request_id,
l_Res_rec.request_id)
AND WIP_GLOBALS.Equal(p_Res_rec.resource_code,
l_Res_rec.resource_code)
AND WIP_GLOBALS.Equal(p_Res_rec.resource_id,
l_Res_rec.resource_id)
AND WIP_GLOBALS.Equal(p_Res_rec.resource_seq_num,
l_Res_rec.resource_seq_num)
AND WIP_GLOBALS.Equal(p_Res_rec.resource_type,
l_Res_rec.resource_type)
AND WIP_GLOBALS.Equal(p_Res_rec.source_code,
l_Res_rec.source_code)
AND WIP_GLOBALS.Equal(p_Res_rec.source_line_id,
l_Res_rec.source_line_id)
AND WIP_GLOBALS.Equal(p_Res_rec.standard_rate_flag,
l_Res_rec.standard_rate_flag)
AND WIP_GLOBALS.Equal(p_Res_rec.task_id,
l_Res_rec.task_id)
AND WIP_GLOBALS.Equal(p_Res_rec.transaction_date,
l_Res_rec.transaction_date)
AND WIP_GLOBALS.Equal(p_Res_rec.transaction_id,
l_Res_rec.transaction_id)
AND WIP_GLOBALS.Equal(p_Res_rec.transaction_quantity,
l_Res_rec.transaction_quantity)
AND WIP_GLOBALS.Equal(p_Res_rec.transaction_type,
l_Res_rec.transaction_type)
AND WIP_GLOBALS.Equal(p_Res_rec.transaction_uom,
l_Res_rec.transaction_uom)
AND WIP_GLOBALS.Equal(p_Res_rec.usage_rate_or_amount,
l_Res_rec.usage_rate_or_amount)
AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_id,
l_Res_rec.wip_entity_id)
AND WIP_GLOBALS.Equal(p_Res_rec.wip_entity_name,
l_Res_rec.wip_entity_name)
THEN
-- Row has not changed. Set out parameter.
x_Res_rec := l_Res_rec;
FND_MESSAGE.SET_NAME('WIP','WIP_LOCK_ROW_DELETED');