1449:
1450: PROCEDURE getOperationRecord
1451: (
1452: p_operation_Id IN NUMBER ,
1453: p_x_operation_rec IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.PRD_WORKOPERATION_REC,
1454: x_return_status OUT NOCOPY VARCHAR2
1455: )
1456:
1457: IS
1525: l_txn_group_id NUMBER;
1526: l_ctr NUMBER:=0;
1527: l_uom_code VARCHAR2(3);
1528: l_wo_status_code VARCHAR2(30);
1529: l_prd_operation_rec AHL_PRD_OPERATIONS_PVT.PRD_WORKOPERATION_REC;
1530: l_prd_operation_tbl AHL_PRD_OPERATIONS_PVT.PRD_OPERATION_TBL;
1531:
1532: Cursor GetWipid (C_WORK_ID Number)
1533: Is
1526: l_ctr NUMBER:=0;
1527: l_uom_code VARCHAR2(3);
1528: l_wo_status_code VARCHAR2(30);
1529: l_prd_operation_rec AHL_PRD_OPERATIONS_PVT.PRD_WORKOPERATION_REC;
1530: l_prd_operation_tbl AHL_PRD_OPERATIONS_PVT.PRD_OPERATION_TBL;
1531:
1532: Cursor GetWipid (C_WORK_ID Number)
1533: Is
1534: Select wip_entity_id, status_code
1729: END IF;
1730:
1731: IF l_prd_operation_tbl.count >0
1732: Then
1733: AHL_PRD_OPERATIONS_PVT.PROCESS_OPERATIONS
1734: (
1735: p_api_version =>1.0,
1736: p_init_msg_list =>FND_API.G_FALSE,
1737: p_commit =>l_commit,