[Home] [Help]
1137: p_po_number VARCHAR2
1138: )
1139: IS
1140: SELECT ced.purchase_order_num
1141: FROM csd_product_transactions cpt, cs_estimate_details ced
1142: WHERE cpt.estimate_detail_id = ced.estimate_detail_id
1143: AND cpt.repair_line_id = p_repair_line_id
1144: AND ced.order_header_id = p_order_header_id
1145: AND ced.purchase_order_num = p_po_number;
1147: CURSOR cur_order_header (p_incident_id NUMBER)
1148: IS
1149: SELECT MAX (ced.order_header_id)
1150: FROM csd_repairs cr,
1151: csd_product_transactions cpt,
1152: cs_estimate_details ced
1153: WHERE cr.incident_id = p_incident_id
1154: AND cpt.repair_line_id = cr.repair_line_id
1155: AND ced.estimate_detail_id = cpt.estimate_detail_id
1727: );
1728: END IF;
1729:
1730: ---------------------------------------------------------------------------------12
1731: --Call CSD_PRODUCT_TRANSACTIONS_PKG.INSERT_ROW to add a product transaction record.
1732: --Update product_transaction_id in the Product_Txn_Rec.
1733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1734: THEN
1735: fnd_log.STRING (fnd_log.level_statement,
1737: 'Creating product txn rec ..'
1738: );
1739: END IF;
1740:
1741: csd_product_transactions_pkg.insert_row
1742: (px_product_transaction_id => p_product_txn_rec.product_transaction_id,
1743: p_repair_line_id => p_product_txn_rec.repair_line_id,
1744: p_estimate_detail_id => l_estimate_detail_id,
1745: p_action_type => p_product_txn_rec.action_type,
2016: || ']'
2017: );
2018: END IF;
2019:
2020: UPDATE csd_product_transactions
2021: SET prod_txn_status = l_prod_txn_status
2022: WHERE product_transaction_id = p_product_txn_rec.product_transaction_id;
2023:
2024: IF SQL%NOTFOUND