APPS.QA_SKIPLOT_RES_ENGINE dependencies on QA_INSP_COLLECTIONS_TEMP

Line 656: update qa_insp_collections_temp

652: p_collection_id in number) is
653:
654: begin
655:
656: update qa_insp_collections_temp
657: set skiplot_flag = 'Y'
658: where collection_id = p_collection_id;
659:
660: end set_skiplot_flag;

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

712:
713: BEGIN
714:
715: --
716: -- set skip lot flag in qa_insp_collections_temp table.
717: --
718: set_skiplot_flag (p_collection_id);
719:
720:

Line 1239: from qa_insp_collections_temp

1235: where shipment_line_id = x_shl_id;
1236:
1237: cursor sampling_result (x_coll_id number) is
1238: select sampling_flag, lot_result
1239: from qa_insp_collections_temp
1240: where collection_id = x_coll_id;
1241:
1242: sampling_flag varchar2(1);
1243:

Line 1519: from qa_insp_collections_temp

1515: p_collection_id IN NUMBER) RETURN VARCHAR2 IS
1516:
1517: cursor skiplot_flag (x_coll_id number) is
1518: select skiplot_flag
1519: from qa_insp_collections_temp
1520: where collection_id = x_coll_id;
1521:
1522: x_skiplot_flag varchar2(1) := null;
1523:

Line 1545: update qa_insp_collections_temp

1541: p_skiplot_flag IN VARCHAR2) IS
1542:
1543: BEGIN
1544:
1545: update qa_insp_collections_temp
1546: set skiplot_flag = decode(p_skiplot_flag, 'T', 'Y','Y', 'Y', 'N')
1547: where collection_id = p_collection_id;
1548:
1549: END SET_SKIPLOT_FLAG;