APPS.QA_SKIPLOT_RES_ENGINE dependencies on QA_SKIPLOT_LOT_PLANS

Line 1009: from qa_skiplot_lot_plans

1005: p_reinsp_flag IN VARCHAR2 DEFAULT NULL) IS
1006:
1007: cursor lotPlans (x_insp_lot_id number) is
1008: select *
1009: from qa_skiplot_lot_plans
1010: where insp_lot_id = x_insp_lot_id;
1011:
1012: cursor lotPlans2 (x_shl_id number) is
1013: select *

Line 1014: from qa_skiplot_lot_plans

1010: where insp_lot_id = x_insp_lot_id;
1011:
1012: cursor lotPlans2 (x_shl_id number) is
1013: select *
1014: from qa_skiplot_lot_plans
1015: where shipment_line_id = x_shl_id;
1016:
1017: res_col varchar2(30);
1018: result varchar2(100);

Line 1113: sql_str := 'update qa_skiplot_lot_plans set ' ||

1109:
1110: --
1111: -- update lot plans table
1112: --
1113: sql_str := 'update qa_skiplot_lot_plans set ' ||
1114: 'plan_insp_status = ''INSPECTED'', ' ||
1115: 'plan_insp_result = :1, ' ||
1116: 'inspected_qty = :2 ,' ||
1117: 'accepted_qty = :3, ' ||

Line 1177: sql_str := 'update qa_skiplot_lot_plans set ' ||

1173: --
1174: -- update lot plans table
1175: -- if plan was rejected before, keep the result
1176: --
1177: sql_str := 'update qa_skiplot_lot_plans set ' ||
1178: 'plan_insp_status = ''INSPECTED'', ' ||
1179: 'plan_insp_result = :1, ' ||
1180: 'inspected_qty = :2 ,' ||
1181: 'accepted_qty = :3, ' ||

Line 1229: from qa_skiplot_lot_plans

1225: lot_plans lotPlanTable;
1226:
1227: cursor lotPlans (x_insp_lot_id number) is
1228: select *
1229: from qa_skiplot_lot_plans
1230: where insp_lot_id = x_insp_lot_id;
1231:
1232: cursor lotPlans2 (x_shl_id number) is
1233: select *

Line 1234: from qa_skiplot_lot_plans

1230: where insp_lot_id = x_insp_lot_id;
1231:
1232: cursor lotPlans2 (x_shl_id number) is
1233: select *
1234: from qa_skiplot_lot_plans
1235: where shipment_line_id = x_shl_id;
1236:
1237: cursor sampling_result (x_coll_id number) is
1238: select sampling_flag, lot_result

Line 1560: from qa_skiplot_lot_plans

1556: p_lot_qty in number) return number is
1557:
1558: cursor rej_qty(x_coll_id number) is
1559: select sum(rejected_qty)
1560: from qa_skiplot_lot_plans
1561: where collection_id = x_coll_id;
1562:
1563: x_rej_qty number;
1564: