[Home] [Help]
1131: p_po_number VARCHAR2
1132: )
1133: IS
1134: SELECT ced.purchase_order_num
1135: FROM csd_product_transactions cpt, cs_estimate_details ced
1136: WHERE cpt.estimate_detail_id = ced.estimate_detail_id
1137: AND cpt.repair_line_id = p_repair_line_id
1138: AND ced.order_header_id = p_order_header_id
1139: AND ced.purchase_order_num = p_po_number;
1141: CURSOR cur_order_header (p_incident_id NUMBER)
1142: IS
1143: SELECT MAX (ced.order_header_id)
1144: FROM csd_repairs cr,
1145: csd_product_transactions cpt,
1146: cs_estimate_details ced
1147: WHERE cr.incident_id = p_incident_id
1148: AND cpt.repair_line_id = cr.repair_line_id
1149: AND ced.estimate_detail_id = cpt.estimate_detail_id
1721: );
1722: END IF;
1723:
1724: ---------------------------------------------------------------------------------12
1725: --Call CSD_PRODUCT_TRANSACTIONS_PKG.INSERT_ROW to add a product transaction record.
1726: --Update product_transaction_id in the Product_Txn_Rec.
1727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1728: THEN
1729: fnd_log.STRING (fnd_log.level_statement,
1731: 'Creating product txn rec ..'
1732: );
1733: END IF;
1734:
1735: csd_product_transactions_pkg.insert_row
1736: (px_product_transaction_id => p_product_txn_rec.product_transaction_id,
1737: p_repair_line_id => p_product_txn_rec.repair_line_id,
1738: p_estimate_detail_id => l_estimate_detail_id,
1739: p_action_type => p_product_txn_rec.action_type,
2010: || ']'
2011: );
2012: END IF;
2013:
2014: UPDATE csd_product_transactions
2015: SET prod_txn_status = l_prod_txn_status
2016: WHERE product_transaction_id = p_product_txn_rec.product_transaction_id;
2017:
2018: IF SQL%NOTFOUND