APPS.DPP_TRANSACTION_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 1754: -- Insert lines into dpp_transaction_lines_all table

1750: FND_FILE.PUT_LINE(FND_FILE.LOG,' Supplier Part Num'||p_txn_lines_tbl_type(i).supplier_part_num);
1751: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inventory Item ID'||p_txn_lines_tbl_type(i).inventory_item_id);
1752: END IF;
1753: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Prior Price Create Lines:'||p_txn_lines_tbl_type(i).prior_price);
1754: -- Insert lines into dpp_transaction_lines_all table
1755: INSERT INTO dpp_transaction_lines_all(
1756: object_version_number
1757: , transaction_header_id
1758: , transaction_line_id

Line 1755: INSERT INTO dpp_transaction_lines_all(

1751: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inventory Item ID'||p_txn_lines_tbl_type(i).inventory_item_id);
1752: END IF;
1753: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Prior Price Create Lines:'||p_txn_lines_tbl_type(i).prior_price);
1754: -- Insert lines into dpp_transaction_lines_all table
1755: INSERT INTO dpp_transaction_lines_all(
1756: object_version_number
1757: , transaction_header_id
1758: , transaction_line_id
1759: , supplier_part_num

Line 2041: UPDATE dpp_transaction_lines_all dtla

2037: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
2038: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
2039: END IF;
2040: --BUG 6806974
2041: UPDATE dpp_transaction_lines_all dtla
2042: SET dtla.approved_inventory = dtla.covered_inventory,
2043: dtla.object_version_number = dtla.object_version_number +1,
2044: dtla.last_updated_by = nvl(l_user_id,0),
2045: dtla.last_update_login = nvl(l_user_id,0),

Line 2087: UPDATE dpp_transaction_lines_all dtla

2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END;
2085:
2086: IF (l_price_change_flag = 'N') THEN -- Only Price Decrease
2087: UPDATE dpp_transaction_lines_all dtla
2088: SET dtla.claim_amount = dtla.approved_inventory * price_change,
2089: dtla.object_version_number = dtla.object_version_number +1,
2090: dtla.last_updated_by = nvl(l_user_id,0),
2091: dtla.last_update_login = nvl(l_user_id,0),

Line 2097: UPDATE dpp_transaction_lines_all dtla

2093: WHERE dtla.transaction_header_id = p_txn_header_rec_type.transaction_header_id
2094: AND dtla.transaction_line_id = l_line_tbl_type(i).transaction_line_id
2095: AND dtla.price_change > 0;
2096: ELSE -- Both Price Increase and Price Decrease
2097: UPDATE dpp_transaction_lines_all dtla
2098: SET dtla.claim_amount = dtla.approved_inventory * price_change,
2099: dtla.object_version_number = dtla.object_version_number +1,
2100: dtla.last_updated_by = nvl(l_user_id,0),
2101: dtla.last_update_login = nvl(l_user_id,0),

Line 2183: FROM dpp_transaction_lines_all dtla,

2179: --BUG 6806974
2180: IF p_txn_lines_tbl_type(i).inventory_item_id IS NOT NULL THEN
2181: SELECT dtla.supp_dist_claim_id
2182: INTO p_txn_lines_tbl_type(i).supp_dist_claim_id
2183: FROM dpp_transaction_lines_all dtla,
2184: ozf_claims_all oca
2185: WHERE dtla.transaction_header_id = p_txn_header_rec_type.transaction_header_id
2186: AND to_number(dtla.supp_dist_claim_id) = oca.claim_id
2187: AND (oca.claim_number = nvl(p_txn_header_rec_type.supp_dist_claim_number,oca.claim_number)

Line 2222: FROM dpp_transaction_lines_all dtla

2218: -- Check the transaction status if Approved, the lines are not updated.
2219: BEGIN
2220: SELECT dtla.supplier_approved_by
2221: INTO l_approved_by
2222: FROM dpp_transaction_lines_all dtla
2223: WHERE dtla.transaction_header_id = p_txn_lines_tbl_type(i).transaction_header_id
2224: AND dtla.inventory_item_id = p_txn_lines_tbl_type(i).inventory_item_id;
2225: EXCEPTION WHEN NO_DATA_FOUND THEN
2226: --l_approved_by := NULL;

Line 2238: UPDATE dpp_transaction_lines_all dtla

2234: || p_txn_lines_tbl_type(i).inventory_item_id ||'is already approved by '||
2235: l_approved_by);
2236: END IF;
2237: ELSE
2238: UPDATE dpp_transaction_lines_all dtla
2239: SET dtla.supplier_approved_by =p_txn_lines_tbl_type(i).supplier_approved_by,
2240: dtla.supplier_approval_date =TRUNC(p_txn_lines_tbl_type(i).supplier_approval_date),
2241: dtla.approved_inventory = p_txn_lines_tbl_type(i).approved_inventory,
2242: dtla.claim_amount= p_txn_lines_tbl_type(i).approved_inventory*price_change,

Line 2319: FROM dpp_transaction_lines_all dtla

2315: LOOP
2316: --Get the number of approved lines for the transaction
2317: SELECT count(dtla.supplier_approved_by)
2318: INTO l_count_approved_lines
2319: FROM dpp_transaction_lines_all dtla
2320: WHERE dtla.transaction_header_id = p_txn_header_rec_type.transaction_header_id
2321: AND dtla.supp_dist_claim_id = p_txn_lines_tbl_type(i).supp_dist_claim_id
2322: AND dtla.supplier_approved_by IS NOT NULL;
2323:

Line 2331: FROM dpp_transaction_lines_all dtla

2327: END IF;
2328: --Get the number of lines for the claim
2329: SELECT count(transaction_line_id)
2330: INTO l_count_lines
2331: FROM dpp_transaction_lines_all dtla
2332: WHERE transaction_header_id = p_txn_header_rec_type.transaction_header_id
2333: AND dtla.supp_dist_claim_id = p_txn_lines_tbl_type(i).supp_dist_claim_id;
2334:
2335: IF DPP_DEBUG_HIGH_ON THEN