APPS.QA_SAMPLING_PKG dependencies on QA_INSP_COLLECTIONS_TEMP

Line 458: from qa_insp_collections_temp

454: x_msg_data VARCHAR2(240);
455:
456: CURSOR lot_info_cur IS
457: select lot_size, lot_result, total_rejected_qty
458: from qa_insp_collections_temp
459: where collection_id = p_collection_id;
460:
461: CURSOR lot_insp_cur IS
462: select sum(insp_qty) AS total_insp_qty

Line 1088: update qa_insp_collections_temp

1084: and plan_id = plan_rec.plan_id;
1085:
1086: l_sampling_flag := 'Y'; --even if one sampling found
1087: --also update the temp table flag
1088: update qa_insp_collections_temp
1089: set sampling_flag = 'Y'
1090: where collection_id = p_collection_id;
1091:
1092: p_sampling_flag := 'Y'; --set out parameter

Line 1319: from qa_insp_collections_temp

1315:
1316: cursor sampling_flag_cur
1317: is
1318: select sampling_flag
1319: from qa_insp_collections_temp
1320: where collection_id = p_collection_id;
1321:
1322: cursor rej_cur
1323: is

Line 1489: from qa_insp_collections_temp

1485:
1486: cursor sampling_flag_cur
1487: is
1488: select sampling_flag
1489: from qa_insp_collections_temp
1490: where collection_id = p_collection_id;
1491:
1492: cursor plan_result_cur
1493: is

Line 1523: update qa_insp_collections_temp

1519: else
1520: result := 'ACCEPT';
1521: end if;--end inner if
1522:
1523: update qa_insp_collections_temp
1524: set lot_result = result
1525: where collection_id = p_collection_id;
1526: end if;
1527: lot_insp_result := result; --set the out variable

Line 1534: update qa_insp_collections_temp

1530: open total_rej_cur;
1531: fetch total_rej_cur into total_number_rej;
1532: close total_rej_cur;
1533:
1534: update qa_insp_collections_temp
1535: set total_rejected_qty = total_number_rej
1536: where collection_id = p_collection_id;
1537:
1538: null;

Line 1543: --From the qa_insp_collections_temp table find out the lotsize, lotresult

1539: end;
1540:
1541: --
1542: --This procedure is a wrapper to call the RCV API to perform accept or reject
1543: --From the qa_insp_collections_temp table find out the lotsize, lotresult
1544: --based on that call the RCV API to perform the action
1545: --this procedure called from qainspb.pls (the qainspb.pls has a wrapper)
1546: --the qainspb.pls wrapper is called from client side QLTRES.pld
1547: --

Line 1577: from qa_insp_collections_temp

1573:
1574: cursor lot_info_cur
1575: is
1576: select lot_size, lot_result,total_rejected_qty
1577: from qa_insp_collections_temp
1578: where collection_id = p_collection_id;
1579:
1580: -- Added the below cursor and variable for RCV/WMS Merge.
1581: -- Bug 3096256. kabalakr Fri Aug 29 09:06:28 PDT 2003.

Line 1796: from qa_insp_collections_temp

1792:
1793: cursor sampling_flag_cur
1794: is
1795: select sampling_flag
1796: from qa_insp_collections_temp
1797: where collection_id = p_collection_id;
1798:
1799: begin
1800: open sampling_flag_cur;

Line 1911: FROM qa_insp_collections_temp

1907: l_item_id NUMBER;
1908:
1909: CURSOR lot_rej_cur IS
1910: SELECT total_rejected_qty, lot_size
1911: FROM qa_insp_collections_temp
1912: WHERE collection_id = p_collection_id;
1913:
1914: BEGIN
1915: