eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_SAMPLING_PKG dependencies on QA_INSP_PLANS_TEMP

Line 815: -- qa_insp_plans_temp is being updated 3 times and this procedure

811:
812:
813:
814: -- following procedure is written to avoid code duplication.
815: -- qa_insp_plans_temp is being updated 3 times and this procedure
816: -- consolidates the code.
817: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
818: procedure update_qa_insp_plans_temp(p_sample_size number,
819: p_c_num number,

Line 818: procedure update_qa_insp_plans_temp(p_sample_size number,

814: -- following procedure is written to avoid code duplication.
815: -- qa_insp_plans_temp is being updated 3 times and this procedure
816: -- consolidates the code.
817: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
818: procedure update_qa_insp_plans_temp(p_sample_size number,
819: p_c_num number,
820: p_rej_num number,
821: p_aql number,
822: p_coll_id number,

Line 827: update qa_insp_plans_temp

823: p_plan_id number)
824: is
825:
826: begin
827: update qa_insp_plans_temp
828: set sample_size = p_sample_size,
829: c_number = p_c_num,
830: rejection_number = p_rej_num,
831: aql = p_aql

Line 835: end ; -- update_qa_insp_plans_temp

831: aql = p_aql
832: where collection_id = p_coll_id
833: and plan_id = p_plan_id;
834:
835: end ; -- update_qa_insp_plans_temp
836:
837: --
838: -- local function
839: --

Line 1015: from qa_insp_plans_temp qipt

1011:
1012: cursor plan_cur
1013: is
1014: select plan_id
1015: from qa_insp_plans_temp qipt
1016: where collection_id = p_collection_id;
1017:
1018: --
1019: -- removed the rownum = 1 statement from this cursor

Line 1080: update qa_insp_plans_temp

1076: close criteria_cur;
1077:
1078: if (l_sampling_plan_id <> -1) --means sampling plan present
1079: then
1080: update qa_insp_plans_temp
1081: set sampling_plan_id = l_sampling_plan_id,
1082: sampling_criteria_id = l_criteria_id
1083: where collection_id = p_collection_id
1084: and plan_id = plan_rec.plan_id;

Line 1094: update qa_insp_plans_temp

1090: where collection_id = p_collection_id;
1091:
1092: p_sampling_flag := 'Y'; --set out parameter
1093: else
1094: update qa_insp_plans_temp
1095: set sampling_plan_id = -1,
1096: sampling_criteria_id = -1
1097: where collection_id = p_collection_id
1098: and plan_id = plan_rec.plan_id;

Line 1181: -- replace update stmt by calling proc update_qa_insp_plans_temp

1177: l_c_num := 0;
1178: l_rej_num := 1;
1179: l_aql := null;
1180:
1181: -- replace update stmt by calling proc update_qa_insp_plans_temp
1182: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1183: update_qa_insp_plans_temp(l_sample_size, l_c_num, l_rej_num,
1184: l_aql, p_collection_id,
1185: p_collection_plan_id);

Line 1183: update_qa_insp_plans_temp(l_sample_size, l_c_num, l_rej_num,

1179: l_aql := null;
1180:
1181: -- replace update stmt by calling proc update_qa_insp_plans_temp
1182: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1183: update_qa_insp_plans_temp(l_sample_size, l_c_num, l_rej_num,
1184: l_aql, p_collection_id,
1185: p_collection_plan_id);
1186:
1187: /*

Line 1188: update qa_insp_plans_temp

1184: l_aql, p_collection_id,
1185: p_collection_plan_id);
1186:
1187: /*
1188: update qa_insp_plans_temp
1189: set sample_size = l_sample_size,
1190: c_number = l_c_num,
1191: rejection_number = l_rej_num,
1192: aql = l_aql

Line 1217: -- replace update stmt by calling proc update_qa_insp_plans_temp

1213: -- bhsankar Tue Jul 3 03:40:41 PDT 2007
1214: --
1215: l_sample_size := least(l_sample_size, p_lot_size);
1216:
1217: -- replace update stmt by calling proc update_qa_insp_plans_temp
1218: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1219: update_qa_insp_plans_temp(l_sample_size, l_c_num,
1220: l_rej_num, null, p_collection_id,
1221: p_collection_plan_id);

Line 1219: update_qa_insp_plans_temp(l_sample_size, l_c_num,

1215: l_sample_size := least(l_sample_size, p_lot_size);
1216:
1217: -- replace update stmt by calling proc update_qa_insp_plans_temp
1218: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1219: update_qa_insp_plans_temp(l_sample_size, l_c_num,
1220: l_rej_num, null, p_collection_id,
1221: p_collection_plan_id);
1222: /*
1223: update qa_insp_plans_temp

Line 1223: update qa_insp_plans_temp

1219: update_qa_insp_plans_temp(l_sample_size, l_c_num,
1220: l_rej_num, null, p_collection_id,
1221: p_collection_plan_id);
1222: /*
1223: update qa_insp_plans_temp
1224: set sample_size = l_sample_size,
1225: c_number = l_c_num,
1226: rejection_number = l_rej_num,
1227: aql = null -- no aql for custom sampling

Line 1253: -- replace update stmt by calling proc update_qa_insp_plans_temp

1249: -- reference bug 2331892
1250: --
1251: l_sample_size := least(l_sample_size, p_lot_size);
1252:
1253: -- replace update stmt by calling proc update_qa_insp_plans_temp
1254: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1255: update_qa_insp_plans_temp(l_sample_size, l_c_num,
1256: l_rej_num, l_aql, p_collection_id,
1257: p_collection_plan_id);

Line 1255: update_qa_insp_plans_temp(l_sample_size, l_c_num,

1251: l_sample_size := least(l_sample_size, p_lot_size);
1252:
1253: -- replace update stmt by calling proc update_qa_insp_plans_temp
1254: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1255: update_qa_insp_plans_temp(l_sample_size, l_c_num,
1256: l_rej_num, l_aql, p_collection_id,
1257: p_collection_plan_id);
1258: /*
1259: update qa_insp_plans_temp

Line 1259: update qa_insp_plans_temp

1255: update_qa_insp_plans_temp(l_sample_size, l_c_num,
1256: l_rej_num, l_aql, p_collection_id,
1257: p_collection_plan_id);
1258: /*
1259: update qa_insp_plans_temp
1260: set sample_size = l_sample_size,
1261: c_number = l_c_num,
1262: rejection_number = l_rej_num,
1263: aql = l_aql

Line 1326: from qa_insp_plans_temp

1322: cursor rej_cur
1323: is
1324: select c_number, rejection_number,
1325: sampling_plan_id, sampling_criteria_id
1326: from qa_insp_plans_temp
1327: where collection_id = p_collection_id
1328: and plan_id = p_coll_plan_id;
1329:
1330: cursor sampling_std_code_cur (x_sampling_plan_id number)

Line 1427: update qa_insp_plans_temp

1423:
1424: reject_qty := nvl(reject_qty, 0);
1425:
1426: --set the total qty rejected for this collection plan
1427: update qa_insp_plans_temp
1428: set plan_rejected_qty = reject_qty
1429: where collection_id = p_collection_id
1430: and plan_id = p_coll_plan_id;
1431:

Line 1459: update qa_insp_plans_temp

1455: result := 'FUZZY';
1456: end if;
1457: end if;
1458:
1459: update qa_insp_plans_temp
1460: set plan_insp_result = result
1461: where collection_id = p_collection_id
1462: and plan_id = p_coll_plan_id;
1463:

Line 1495: from qa_insp_plans_temp

1491:
1492: cursor plan_result_cur
1493: is
1494: select count(*) AS rejected_plans
1495: from qa_insp_plans_temp
1496: where collection_id = p_collection_id
1497: and plan_insp_result = 'REJECT';
1498:
1499: cursor total_rej_cur

Line 1502: from qa_insp_plans_temp

1498:
1499: cursor total_rej_cur
1500: is
1501: select sum(plan_rejected_qty) AS total_rej_qty
1502: from qa_insp_plans_temp
1503: where collection_id = p_collection_id;
1504:
1505: begin
1506: open sampling_flag_cur;

Line 1586: from qa_insp_plans_temp

1582:
1583: cursor plan_count_cur
1584: is
1585: select count(*) AS insp_plans
1586: from qa_insp_plans_temp
1587: where collection_id = p_collection_id;
1588:
1589: l_plan_count NUMBER;
1590:

Line 1610: -- Check the no of plan involved from qa_insp_plans_temp.

1606: -- This procedure supports unit wise inspection at lpn, lot and
1607: -- Serial levels.
1608: -- Bug 3096256. kabalakr Fri Aug 29 09:06:28 PDT 2003
1609:
1610: -- Check the no of plan involved from qa_insp_plans_temp.
1611: open plan_count_cur;
1612: fetch plan_count_cur into l_plan_count;
1613: close plan_count_cur;
1614:

Line 2123: from qa_insp_plans_temp

2119: l_plan_id NUMBER;
2120:
2121: CURSOR plan_cur IS
2122: select plan_id
2123: from qa_insp_plans_temp
2124: where collection_id = p_collection_id;
2125:
2126:
2127: BEGIN