APPS.AHL_PRD_MRSHL_PVT dependencies on AHL_PRD_MB_UC_DETAILS

Line 1533: DELETE ahl_prd_mb_uc_details;

1529: p_item_instance_id => p_item_instance_id,
1530: p_visit_id => p_visit_id,
1531: x_inst_mrshl_details_tbl => x_mrshl_details_tbl);
1532: END IF;
1533: DELETE ahl_prd_mb_uc_details;
1534:
1535: IF x_mrshl_details_tbl.FIRST IS NOT NULL THEN
1536: FOR i IN x_mrshl_details_tbl.FIRST..x_mrshl_details_tbl.LAST LOOP
1537: INSERT INTO ahl_prd_mb_uc_details

Line 1537: INSERT INTO ahl_prd_mb_uc_details

1533: DELETE ahl_prd_mb_uc_details;
1534:
1535: IF x_mrshl_details_tbl.FIRST IS NOT NULL THEN
1536: FOR i IN x_mrshl_details_tbl.FIRST..x_mrshl_details_tbl.LAST LOOP
1537: INSERT INTO ahl_prd_mb_uc_details
1538: (
1539: Unit_Header_id,
1540: Unit_Name,
1541: --Path_position_id,

Line 1671: Select * FROM ahl_prd_mb_uc_details

1667: AND C.inventory_item_id = M.inventory_item_id
1668: AND C.inv_master_organization_id = M.organization_id;
1669:
1670: /*CURSOR get_all_details(c_unit_header_id IN NUMBER) IS
1671: Select * FROM ahl_prd_mb_uc_details
1672: WHERE UNIT_HEADER_ID = c_unit_header_id;*/
1673:
1674: CURSOR get_pos_dtls_csr(c_mc_relationship_id IN NUMBER,
1675: c_instance_id IN NUMBER) IS