APPS.DPP_COVEREDINVENTORY_PVT dependencies on DPP_INVENTORY_DETAILS_ALL

Line 551: TYPE inventory_details_id_tbl IS TABLE OF dpp_inventory_details_all.inventory_details_id%TYPE

547:
548: l_price_change_flag VARCHAR2(20);
549: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
550:
551: TYPE inventory_details_id_tbl IS TABLE OF dpp_inventory_details_all.inventory_details_id%TYPE
552: INDEX BY PLS_INTEGER;
553:
554: inventory_details_ids inventory_details_id_tbl;
555:

Line 725: dpp_inventory_details_all

721: inventory_details_id
722: BULK COLLECT INTO
723: inventory_details_ids
724: FROM
725: dpp_inventory_details_all
726: WHERE
727: org_id = l_inv_hdr_rec.org_id
728: AND transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;
729:

Line 735: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)

731: DELETE
732: FROM DPP_INVENTORY_DETAILS_ADJ_ALL
733: WHERE INVENTORY_DETAILS_ID = inventory_details_ids(indx);
734:
735: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
736: DELETE
737: FROM DPP_INVENTORY_DETAILS_ALL
738: WHERE org_id = l_inv_hdr_rec.org_id
739: AND transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;

Line 737: FROM DPP_INVENTORY_DETAILS_ALL

733: WHERE INVENTORY_DETAILS_ID = inventory_details_ids(indx);
734:
735: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
736: DELETE
737: FROM DPP_INVENTORY_DETAILS_ALL
738: WHERE org_id = l_inv_hdr_rec.org_id
739: AND transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;
740:
741: EXCEPTION

Line 761: INSERT INTO DPP_INVENTORY_DETAILS_ALL(

757: SELECT DPP_INVENTORY_DETAILS_SEQ.nextval
758: INTO l_inv_details_id
759: FROM DUAL;
760: l_flag := 'N';
761: INSERT INTO DPP_INVENTORY_DETAILS_ALL(
762: inventory_details_id,
763: transaction_line_id,
764: quantity,
765: uom,

Line 849: UPDATE DPP_INVENTORY_DETAILS_ALL

845: );
846:
847: END LOOP; --l_covered_inv_tbl(i).wh_line_tbl(j).rct_line_tbl.FIRST..
848: IF l_flag = 'Y' THEN
849: UPDATE DPP_INVENTORY_DETAILS_ALL
850: SET include_flag = 'Y',
851: object_version_number = object_version_number + 1,
852: last_update_date = l_sysdate,
853: last_updated_by = l_inv_hdr_rec.Last_Updated_By,