APPS.QA_SKIPLOT_RES_ENGINE dependencies on QA_INSP_COLLECTIONS_TEMP

Line 674: update qa_insp_collections_temp

670: p_collection_id in number) is
671:
672: begin
673:
674: update qa_insp_collections_temp
675: set skiplot_flag = 'Y'
676: where collection_id = p_collection_id;
677:
678: end set_skiplot_flag;

Line 739: -- set skip lot flag in qa_insp_collections_temp table.

735:
736: BEGIN
737:
738: --
739: -- set skip lot flag in qa_insp_collections_temp table.
740: --
741: set_skiplot_flag (p_collection_id);
742:
743:

Line 1327: from qa_insp_collections_temp

1323: where shipment_line_id = x_shl_id;
1324:
1325: cursor sampling_result (x_coll_id number) is
1326: select sampling_flag, lot_result
1327: from qa_insp_collections_temp
1328: where collection_id = x_coll_id;
1329:
1330: sampling_flag varchar2(1);
1331:

Line 1680: from qa_insp_collections_temp

1676: p_collection_id IN NUMBER) RETURN VARCHAR2 IS
1677:
1678: cursor skiplot_flag (x_coll_id number) is
1679: select skiplot_flag
1680: from qa_insp_collections_temp
1681: where collection_id = x_coll_id;
1682:
1683: x_skiplot_flag varchar2(1) := null;
1684:

Line 1706: update qa_insp_collections_temp

1702: p_skiplot_flag IN VARCHAR2) IS
1703:
1704: BEGIN
1705:
1706: update qa_insp_collections_temp
1707: set skiplot_flag = decode(p_skiplot_flag, 'T', 'Y','Y', 'Y', 'N')
1708: where collection_id = p_collection_id;
1709:
1710: END SET_SKIPLOT_FLAG;