APPS.DPP_TRANSACTION_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 1549: -- Insert lines into dpp_transaction_lines_all table

1545: FND_FILE.PUT_LINE(FND_FILE.LOG,' Supplier Part Num'||p_txn_lines_tbl_type(i).supplier_part_num);
1546: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inventory Item ID'||p_txn_lines_tbl_type(i).inventory_item_id);
1547: END IF;
1548: dpp_utility_pvt.debug_message('Prior Price Create Lines:'||p_txn_lines_tbl_type(i).prior_price);
1549: -- Insert lines into dpp_transaction_lines_all table
1550: INSERT INTO dpp_transaction_lines_all(
1551: object_version_number
1552: , transaction_header_id
1553: , transaction_line_id

Line 1550: INSERT INTO dpp_transaction_lines_all(

1546: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inventory Item ID'||p_txn_lines_tbl_type(i).inventory_item_id);
1547: END IF;
1548: dpp_utility_pvt.debug_message('Prior Price Create Lines:'||p_txn_lines_tbl_type(i).prior_price);
1549: -- Insert lines into dpp_transaction_lines_all table
1550: INSERT INTO dpp_transaction_lines_all(
1551: object_version_number
1552: , transaction_header_id
1553: , transaction_line_id
1554: , supplier_part_num

Line 1832: UPDATE dpp_transaction_lines_all dtla

1828: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
1829: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
1830: END IF;
1831: --BUG 6806974
1832: UPDATE dpp_transaction_lines_all dtla
1833: SET dtla.approved_inventory = dtla.covered_inventory,
1834: dtla.object_version_number = dtla.object_version_number +1,
1835: dtla.last_updated_by = nvl(l_user_id,0),
1836: dtla.last_update_login = nvl(l_user_id,0),

Line 1878: UPDATE dpp_transaction_lines_all dtla

1874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1875: END;
1876:
1877: IF (l_price_change_flag = 'N') THEN -- Only Price Decrease
1878: UPDATE dpp_transaction_lines_all dtla
1879: SET dtla.claim_amount = dtla.approved_inventory * price_change,
1880: dtla.object_version_number = dtla.object_version_number +1,
1881: dtla.last_updated_by = nvl(l_user_id,0),
1882: dtla.last_update_login = nvl(l_user_id,0),

Line 1888: UPDATE dpp_transaction_lines_all dtla

1884: WHERE dtla.transaction_header_id = p_txn_header_rec_type.transaction_header_id
1885: AND dtla.transaction_line_id = l_line_tbl_type(i).transaction_line_id
1886: AND dtla.price_change > 0;
1887: ELSE -- Both Price Increase and Price Decrease
1888: UPDATE dpp_transaction_lines_all dtla
1889: SET dtla.claim_amount = dtla.approved_inventory * price_change,
1890: dtla.object_version_number = dtla.object_version_number +1,
1891: dtla.last_updated_by = nvl(l_user_id,0),
1892: dtla.last_update_login = nvl(l_user_id,0),

Line 1974: FROM dpp_transaction_lines_all dtla,

1970: --BUG 6806974
1971: IF p_txn_lines_tbl_type(i).inventory_item_id IS NOT NULL THEN
1972: SELECT dtla.supp_dist_claim_id
1973: INTO p_txn_lines_tbl_type(i).supp_dist_claim_id
1974: FROM dpp_transaction_lines_all dtla,
1975: ozf_claims_all oca
1976: WHERE dtla.transaction_header_id = p_txn_header_rec_type.transaction_header_id
1977: AND to_number(dtla.supp_dist_claim_id) = oca.claim_id
1978: AND (oca.claim_number = nvl(p_txn_header_rec_type.supp_dist_claim_number,oca.claim_number)

Line 2013: FROM dpp_transaction_lines_all dtla

2009: -- Check the transaction status if Approved, the lines are not updated.
2010: BEGIN
2011: SELECT dtla.supplier_approved_by
2012: INTO l_approved_by
2013: FROM dpp_transaction_lines_all dtla
2014: WHERE dtla.transaction_header_id = p_txn_lines_tbl_type(i).transaction_header_id
2015: AND dtla.inventory_item_id = p_txn_lines_tbl_type(i).inventory_item_id;
2016: EXCEPTION WHEN NO_DATA_FOUND THEN
2017: --l_approved_by := NULL;

Line 2029: UPDATE dpp_transaction_lines_all dtla

2025: || p_txn_lines_tbl_type(i).inventory_item_id ||'is already approved by '||
2026: l_approved_by);
2027: END IF;
2028: ELSE
2029: UPDATE dpp_transaction_lines_all dtla
2030: SET dtla.supplier_approved_by =p_txn_lines_tbl_type(i).supplier_approved_by,
2031: dtla.supplier_approval_date =TRUNC(p_txn_lines_tbl_type(i).supplier_approval_date),
2032: dtla.approved_inventory = p_txn_lines_tbl_type(i).approved_inventory,
2033: dtla.claim_amount= p_txn_lines_tbl_type(i).approved_inventory*price_change,

Line 2110: FROM dpp_transaction_lines_all dtla

2106: LOOP
2107: --Get the number of approved lines for the transaction
2108: SELECT count(dtla.supplier_approved_by)
2109: INTO l_count_approved_lines
2110: FROM dpp_transaction_lines_all dtla
2111: WHERE dtla.transaction_header_id = p_txn_header_rec_type.transaction_header_id
2112: AND dtla.supp_dist_claim_id = p_txn_lines_tbl_type(i).supp_dist_claim_id
2113: AND dtla.supplier_approved_by IS NOT NULL;
2114:

Line 2122: FROM dpp_transaction_lines_all dtla

2118: END IF;
2119: --Get the number of lines for the claim
2120: SELECT count(transaction_line_id)
2121: INTO l_count_lines
2122: FROM dpp_transaction_lines_all dtla
2123: WHERE transaction_header_id = p_txn_header_rec_type.transaction_header_id
2124: AND dtla.supp_dist_claim_id = p_txn_lines_tbl_type(i).supp_dist_claim_id;
2125:
2126: IF DPP_DEBUG_HIGH_ON THEN