APPS.DPP_COVEREDINVENTORY_PVT dependencies on DPP_INVENTORY_DETAILS_ALL

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

552: l_flag VARCHAR2(1);
553: l_days_out NUMBER;
554: l_sysdate DATE := SYSDATE;
555:
556: TYPE inventory_details_id_tbl IS TABLE OF dpp_inventory_details_all.inventory_details_id%TYPE
557: INDEX BY PLS_INTEGER;
558:
559: inventory_details_ids inventory_details_id_tbl;
560:

Line 670: dpp_inventory_details_all

666: inventory_details_id
667: BULK COLLECT INTO
668: inventory_details_ids
669: FROM
670: dpp_inventory_details_all
671: WHERE
672: org_id = l_inv_hdr_rec.org_id
673: AND transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;
674:

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

676: DELETE
677: FROM DPP_INVENTORY_DETAILS_ADJ_ALL
678: WHERE INVENTORY_DETAILS_ID = inventory_details_ids(indx);
679:
680: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
681: DELETE
682: FROM DPP_INVENTORY_DETAILS_ALL
683: WHERE org_id = l_inv_hdr_rec.org_id
684: AND transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;

Line 682: FROM DPP_INVENTORY_DETAILS_ALL

678: WHERE INVENTORY_DETAILS_ID = inventory_details_ids(indx);
679:
680: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
681: DELETE
682: FROM DPP_INVENTORY_DETAILS_ALL
683: WHERE org_id = l_inv_hdr_rec.org_id
684: AND transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;
685:
686: EXCEPTION

Line 706: INSERT INTO DPP_INVENTORY_DETAILS_ALL(

702: SELECT DPP_INVENTORY_DETAILS_SEQ.nextval
703: INTO l_inv_details_id
704: FROM DUAL;
705: l_flag := 'N';
706: INSERT INTO DPP_INVENTORY_DETAILS_ALL(
707: inventory_details_id,
708: transaction_line_id,
709: quantity,
710: uom,

Line 792: UPDATE DPP_INVENTORY_DETAILS_ALL

788: );
789:
790: END LOOP; --l_covered_inv_tbl(i).wh_line_tbl(j).rct_line_tbl.FIRST..
791: IF l_flag = 'Y' THEN
792: UPDATE DPP_INVENTORY_DETAILS_ALL
793: SET include_flag = 'Y',
794: object_version_number = object_version_number + 1,
795: last_update_date = l_sysdate,
796: last_updated_by = l_inv_hdr_rec.Last_Updated_By,