APPS.QA_SKIPLOT_RES_ENGINE dependencies on QA_SKIPLOT_LOT_PLANS

Line 1089: from qa_skiplot_lot_plans

1085: p_reinsp_flag IN VARCHAR2 DEFAULT NULL) IS
1086:
1087: cursor lotPlans (x_insp_lot_id number) is
1088: select *
1089: from qa_skiplot_lot_plans
1090: where insp_lot_id = x_insp_lot_id;
1091:
1092: cursor lotPlans2 (x_shl_id number) is
1093: select *

Line 1094: from qa_skiplot_lot_plans

1090: where insp_lot_id = x_insp_lot_id;
1091:
1092: cursor lotPlans2 (x_shl_id number) is
1093: select *
1094: from qa_skiplot_lot_plans
1095: where shipment_line_id = x_shl_id;
1096:
1097: res_col varchar2(30);
1098: result varchar2(100);

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

1189:
1190: --
1191: -- update lot plans table
1192: --
1193: sql_str := 'update qa_skiplot_lot_plans set ' ||
1194: 'plan_insp_status = ''INSPECTED'', ' ||
1195: 'plan_insp_result = :1, ' ||
1196: 'inspected_qty = :2 ,' ||
1197: 'accepted_qty = :3, ' ||

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

1253: --
1254: -- update lot plans table
1255: -- if plan was rejected before, keep the result
1256: --
1257: sql_str := 'update qa_skiplot_lot_plans set ' ||
1258: 'plan_insp_status = ''INSPECTED'', ' ||
1259: 'plan_insp_result = :1, ' ||
1260: 'inspected_qty = :2 ,' ||
1261: 'accepted_qty = :3, ' ||

Line 1317: from qa_skiplot_lot_plans

1313: lot_plans lotPlanTable;
1314:
1315: cursor lotPlans (x_insp_lot_id number) is
1316: select *
1317: from qa_skiplot_lot_plans
1318: where insp_lot_id = x_insp_lot_id;
1319:
1320: cursor lotPlans2 (x_shl_id number) is
1321: select *

Line 1322: from qa_skiplot_lot_plans

1318: where insp_lot_id = x_insp_lot_id;
1319:
1320: cursor lotPlans2 (x_shl_id number) is
1321: select *
1322: from qa_skiplot_lot_plans
1323: where shipment_line_id = x_shl_id;
1324:
1325: cursor sampling_result (x_coll_id number) is
1326: select sampling_flag, lot_result

Line 1721: from qa_skiplot_lot_plans

1717: p_lot_qty in number) return number is
1718:
1719: cursor rej_qty(x_coll_id number) is
1720: select sum(rejected_qty)
1721: from qa_skiplot_lot_plans
1722: where collection_id = x_coll_id;
1723:
1724: x_rej_qty number;
1725: