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 1149: update qa_insp_collections_temp

1145: and plan_id = plan_rec.plan_id;
1146:
1147: l_sampling_flag := 'Y'; --even if one sampling found
1148: --also update the temp table flag
1149: update qa_insp_collections_temp
1150: set sampling_flag = 'Y'
1151: where collection_id = p_collection_id;
1152:
1153: p_sampling_flag := 'Y'; --set out parameter

Line 1380: from qa_insp_collections_temp

1376:
1377: cursor sampling_flag_cur
1378: is
1379: select sampling_flag
1380: from qa_insp_collections_temp
1381: where collection_id = p_collection_id;
1382:
1383: cursor rej_cur
1384: is

Line 1550: from qa_insp_collections_temp

1546:
1547: cursor sampling_flag_cur
1548: is
1549: select sampling_flag
1550: from qa_insp_collections_temp
1551: where collection_id = p_collection_id;
1552:
1553: cursor plan_result_cur
1554: is

Line 1584: update qa_insp_collections_temp

1580: else
1581: result := 'ACCEPT';
1582: end if;--end inner if
1583:
1584: update qa_insp_collections_temp
1585: set lot_result = result
1586: where collection_id = p_collection_id;
1587: end if;
1588: lot_insp_result := result; --set the out variable

Line 1595: update qa_insp_collections_temp

1591: open total_rej_cur;
1592: fetch total_rej_cur into total_number_rej;
1593: close total_rej_cur;
1594:
1595: update qa_insp_collections_temp
1596: set total_rejected_qty = total_number_rej
1597: where collection_id = p_collection_id;
1598:
1599: null;

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

1600: end;
1601:
1602: --
1603: --This procedure is a wrapper to call the RCV API to perform accept or reject
1604: --From the qa_insp_collections_temp table find out the lotsize, lotresult
1605: --based on that call the RCV API to perform the action
1606: --this procedure called from qainspb.pls (the qainspb.pls has a wrapper)
1607: --the qainspb.pls wrapper is called from client side QLTRES.pld
1608: --

Line 1638: from qa_insp_collections_temp

1634:
1635: cursor lot_info_cur
1636: is
1637: select lot_size, lot_result,total_rejected_qty
1638: from qa_insp_collections_temp
1639: where collection_id = p_collection_id;
1640:
1641: -- Added the below cursor and variable for RCV/WMS Merge.
1642: -- Bug 3096256. kabalakr Fri Aug 29 09:06:28 PDT 2003.

Line 1873: from qa_insp_collections_temp

1869:
1870: cursor sampling_flag_cur
1871: is
1872: select sampling_flag
1873: from qa_insp_collections_temp
1874: where collection_id = p_collection_id;
1875:
1876: begin
1877: open sampling_flag_cur;

Line 1988: FROM qa_insp_collections_temp

1984: l_item_id NUMBER;
1985:
1986: CURSOR lot_rej_cur IS
1987: SELECT total_rejected_qty, lot_size
1988: FROM qa_insp_collections_temp
1989: WHERE collection_id = p_collection_id;
1990:
1991: BEGIN
1992: