APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_WO_OPERATIONS_TXNS

Line 1808: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id

1804: END IF;
1805: --
1806: END IF; --Material id g_miss_num
1807: --
1808: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
1809: FROM DUAL;
1810: --
1811: IF G_DEBUG='Y' THEN
1812: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

Line 2095: FROM ahl_wo_operations_txns

2091: SELECT inventory_item_id,
2092: schedule_material_id,
2093: date_required,
2094: required_quantity
2095: FROM ahl_wo_operations_txns
2096: WHERE wo_operation_txn_id = c_wo_trans_id;
2097: --
2098: --Check for status Released or Unreleased
2099: CURSOR Check_wo_status_cur(c_workorder_id IN NUMBER)

Line 2110: FROM ahl_wo_operations_txns

2106: --Get wo transaction id
2107: CURSOR Get_wo_transaction_id(c_sch_material_id IN NUMBER)
2108: IS
2109: SELECT max(wo_operation_txn_id)
2110: FROM ahl_wo_operations_txns
2111: WHERE schedule_material_id = c_sch_material_id;
2112:
2113: -- rroy
2114: -- ACL Changes

Line 2400: --Call transaction log to create record ahl_wo_operations_txns

2396: END IF;
2397: -- Assign workorder operation id if null
2398: p_x_req_material_tbl(i).workorder_operation_id := l_req_material_rec.workorder_operation_id;
2399: --
2400: --Call transaction log to create record ahl_wo_operations_txns
2401: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
2402: FROM DUAL;
2403: --
2404: IF G_DEBUG='Y' THEN

Line 2401: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id

2397: -- Assign workorder operation id if null
2398: p_x_req_material_tbl(i).workorder_operation_id := l_req_material_rec.workorder_operation_id;
2399: --
2400: --Call transaction log to create record ahl_wo_operations_txns
2401: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
2402: FROM DUAL;
2403: --
2404: IF G_DEBUG='Y' THEN
2405: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

Line 3812: INSERT INTO AHL_WO_OPERATIONS_TXNS

3808: p_attribute15 IN VARCHAR2 := NULL)
3809: IS
3810: BEGIN
3811: --
3812: INSERT INTO AHL_WO_OPERATIONS_TXNS
3813: ( wo_operation_txn_id ,
3814: object_version_number ,
3815: last_update_date ,
3816: last_updated_by ,