eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSD_LOGISTICS_UTIL dependencies on CSD_PRODUCT_TRANSACTIONS

Line 2112: FROM CSD_PRODUCT_TRANSACTIONS

2108: book_sales_order_flag,
2109: release_sales_order_flag,
2110: ship_sales_order_flag,
2111: object_version_number
2112: FROM CSD_PRODUCT_TRANSACTIONS
2113: WHERE product_transaction_id = p_prod_txn_id;
2114:
2115: x_prodtxn_db_attr Csd_Logistics_Util.PRODTXN_DB_ATTR_REC;
2116:

Line 2205: -- Validate the prod_txn_id if it exists in csd_product_transactions

2201:
2202: l_repair_line_id := p_product_txn_rec.repair_line_id;
2203: l_est_detail_id := p_product_txn_rec.estimate_detail_id;
2204:
2205: -- Validate the prod_txn_id if it exists in csd_product_transactions
2206: IF NOT
2207: (Csd_Process_Util.Validate_prod_txn_id(p_prod_txn_id => p_product_txn_rec.product_transaction_id))
2208: THEN
2209: RAISE Fnd_Api.G_EXC_ERROR;

Line 2519: Debug('Call csd_product_transactions_pkg.update_row to update the prod txn',

2515: END IF;
2516:
2517: END IF;
2518:
2519: Debug('Call csd_product_transactions_pkg.update_row to update the prod txn',
2520: l_mod_name,
2521: C_STATEMENT_LEVEL);
2522:
2523: Debug('estimate_details_id =['||l_est_detail_id||']',

Line 2528: Csd_Product_Transactions_Pkg.UPDATE_ROW(p_PRODUCT_TRANSACTION_ID => p_product_txn_rec.PRODUCT_TRANSACTION_ID,

2524: l_mod_name,
2525: C_STATEMENT_LEVEL);
2526:
2527:
2528: Csd_Product_Transactions_Pkg.UPDATE_ROW(p_PRODUCT_TRANSACTION_ID => p_product_txn_rec.PRODUCT_TRANSACTION_ID,
2529: p_REPAIR_LINE_ID => l_REPAIR_LINE_ID,
2530: p_ESTIMATE_DETAIL_ID => l_est_detail_id,
2531: p_ACTION_TYPE => p_product_txn_rec.ACTION_TYPE,
2532: p_ACTION_CODE => p_product_txn_rec.ACTION_CODE,

Line 2795: UPDATE CSD_PRODUCT_TRANSACTIONS

2791: p_product_txn_rec.PRODUCT_TRANSACTION_ID,
2792: l_mod_name,
2793: 1);
2794:
2795: UPDATE CSD_PRODUCT_TRANSACTIONS
2796: SET prod_txn_status = 'SUBMITTED',
2797: interface_to_om_flag = 'Y'
2798: WHERE product_transaction_id =
2799: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3186: -- UPDATE csd_product_transactions

3182: Debug('Update the prod txn status to BOOKED',
3183: l_mod_name,
3184: 1);
3185:
3186: -- UPDATE csd_product_transactions
3187: -- SET prod_txn_status = 'BOOKED',
3188: -- book_sales_order_flag = 'Y'
3189: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3190: -- IF SQL%NOTFOUND then

Line 3222: -- UPDATE csd_product_transactions

3218: Debug('Update the prod txn status to BOOKED',
3219: l_mod_name,
3220: 1);
3221:
3222: -- UPDATE csd_product_transactions
3223: -- SET prod_txn_status = 'BOOKED',
3224: -- book_sales_order_flag = 'Y'
3225: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3226: -- IF SQL%NOTFOUND then

Line 3617: UPDATE CSD_PRODUCT_TRANSACTIONS

3613:
3614: IF (p_product_txn_rec.ACTION_TYPE IN
3615: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY')) -- swai: 5931926 12.0.2
3616: THEN
3617: UPDATE CSD_PRODUCT_TRANSACTIONS
3618: SET prod_txn_status = 'RELEASED',
3619: release_sales_order_flag = 'Y'
3620: WHERE product_transaction_id =
3621: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3710: CSD_PRODUCT_TRANSACTIONS c

3706: px_order_rec.serial_number,
3707: px_order_rec.shipped_quantity
3708: FROM oe_order_lines_all a,
3709: cs_estimate_details b,
3710: CSD_PRODUCT_TRANSACTIONS c
3711: WHERE a.line_id = b.order_line_id
3712: AND b.estimate_detail_id = c.estimate_detail_id
3713: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
3714: EXCEPTION

Line 3803: UPDATE CSD_PRODUCT_TRANSACTIONS

3799:
3800: IF (p_product_txn_rec.ACTION_TYPE IN
3801: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY')) -- swai: 5931926 12.0.2
3802: THEN
3803: UPDATE CSD_PRODUCT_TRANSACTIONS
3804: SET prod_txn_status = 'SHIPPED',
3805: ship_sales_order_flag = 'Y'
3806: WHERE product_transaction_id =
3807: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3839: UPDATE CSD_PRODUCT_TRANSACTIONS

3835:
3836: IF (p_product_txn_rec.ACTION_TYPE IN
3837: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY')) -- swai: 5931926 12.0.2
3838: THEN
3839: UPDATE CSD_PRODUCT_TRANSACTIONS
3840: SET prod_txn_status = 'SHIPPED',
3841: ship_sales_order_flag = 'Y'
3842: WHERE product_transaction_id =
3843: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3875: UPDATE CSD_PRODUCT_TRANSACTIONS

3871:
3872: IF (p_product_txn_rec.ACTION_TYPE IN
3873: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY')) -- swai: 5931926 12.0.2
3874: THEN
3875: UPDATE CSD_PRODUCT_TRANSACTIONS
3876: SET prod_txn_status = 'BOOKED',
3877: book_sales_order_flag = 'Y'
3878: WHERE product_transaction_id =
3879: p_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 4054: UPDATE CSD_PRODUCT_TRANSACTIONS

4050: END IF;
4051:
4052: --Update the product transactions table with the cancelled status.
4053: --
4054: UPDATE CSD_PRODUCT_TRANSACTIONS
4055: SET prod_txn_status = 'CANCELLED',
4056: LAST_UPDATE_DATE = SYSDATE,
4057: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4058: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,