3024:
3025: Debug('NEW ESTIMATE DETAIL ID =' || x_estimate_detail_id,
3026: l_mod_name,
3027: 1);
3028: Debug('Call csd_product_transactions_pkg.insert_row to insert prod txns',
3029: l_mod_name,
3030: 1);
3031:
3032: -- Note (TTRV) at this point I would like to derive values for the new columns, every column is not
3034: -- they need not be filled at the time of creation of product transaction record. Some of the columns
3035: -- are updated by update programs.
3036: -- Please come back and verify that for repair types, Exchange, Advance Exchange, Replacement
3037: -- non-source columns are picked from UI. These comments are added by saupadhy TTRV
3038: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,
3039: p_REPAIR_LINE_ID => x_product_txn_rec.REPAIR_LINE_ID,
3040: p_ESTIMATE_DETAIL_ID => x_estimate_detail_id,
3041: p_ACTION_TYPE => x_product_txn_rec.ACTION_TYPE,
3042: p_ACTION_CODE => x_product_txn_rec.ACTION_CODE,
4537: x_product_txn_rec.currency_code := l_curr_code;
4538: x_product_txn_rec.line_category_code := l_line_category_code;
4539: x_estimate_detail_id := x_product_txn_rec.estimate_detail_id;
4540:
4541: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.insert_row to insert prod txns');
4542:
4543: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,
4544: p_REPAIR_LINE_ID => x_product_txn_rec.REPAIR_LINE_ID,
4545: p_ESTIMATE_DETAIL_ID => x_estimate_detail_id,
4539: x_estimate_detail_id := x_product_txn_rec.estimate_detail_id;
4540:
4541: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.insert_row to insert prod txns');
4542:
4543: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,
4544: p_REPAIR_LINE_ID => x_product_txn_rec.REPAIR_LINE_ID,
4545: p_ESTIMATE_DETAIL_ID => x_estimate_detail_id,
4546: p_ACTION_TYPE => x_product_txn_rec.ACTION_TYPE,
4547: p_ACTION_CODE => x_product_txn_rec.ACTION_CODE,
5169: END IF;
5170:
5171: IF (g_debug > 0)
5172: THEN
5173: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');
5174: END IF;
5175:
5176: Csd_Product_Transactions_Pkg.Delete_Row(p_PRODUCT_TRANSACTION_ID => p_product_txn_id);
5177: END IF; --end of delete
5172: THEN
5173: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');
5174: END IF;
5175:
5176: Csd_Product_Transactions_Pkg.Delete_Row(p_PRODUCT_TRANSACTION_ID => p_product_txn_id);
5177: END IF; --end of delete
5178:
5179: -- Api body ends here
5180: