APPS.QA_PLAN_ELEMENT_API dependencies on QA_FLEX_UTIL

Line 3253: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

3249:
3250: -- After Single Scan LOV
3251: wild := value;
3252:
3253: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3254:
3255: sql_string := 'SELECT uom_code, description
3256: FROM mtl_item_uoms_view
3257: WHERE inventory_item_id = :1

Line 3288: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

3284:
3285: -- After Single Scan LOV
3286: wild := value;
3287:
3288: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3289:
3290: -- Bug 3595553. Modified the below query to join with msi to fetch
3291: -- revisions only if the item is revision controlled. All the items
3292: -- will have a base revision by default. But we want this sql to

Line 3328: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

3324:
3325: -- After Single Scan LOV
3326: wild := value;
3327:
3328: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3329:
3330: sql_string := 'select lot_number, description
3331: from mtl_lot_numbers
3332: where inventory_item_id = :1

Line 3355: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

3351: BEGIN
3352:
3353: wild := value;
3354:
3355: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3356:
3357: -- Undoing Bug 3364660. Not needed after sync up with Bug 3773298
3358: -- l_trans_string := fnd_message.get_string('QA','QA_MOBILE_SERIAL_LOV_TXT');
3359: --

Line 4141: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

4137:
4138: -- After Single Scan LOV
4139: wild := value;
4140:
4141: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
4142:
4143: -- Added the organization_id condition in the following select statement.
4144: -- Bug 2686970. suramasw Wed Nov 27 04:45:34 PST 2002.
4145:

Line 4204: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

4200:
4201: -- After Single Scan LOV
4202: wild := value;
4203:
4204: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
4205:
4206: sql_string := 'SELECT mms.status_code, mms.description
4207: FROM mtl_serial_numbers msn, mtl_material_statuses mms
4208: WHERE msn.inventory_item_id = :1

Line 4492: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

4488:
4489: BEGIN
4490:
4491: IF p_item_name IS NOT NULL THEN
4492: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
4493: END IF;
4494:
4495: IF p_job_name IS NOT NULL THEN
4496: l_job_id := get_job_id(p_org_id, p_job_name);

Line 4879: x_item_name := QA_FLEX_UTIL.item(l_org_id, l_item_id);

4875: OPEN c;
4876: FETCH c INTO l_org_id, l_item_id;
4877: CLOSE c;
4878:
4879: x_item_name := QA_FLEX_UTIL.item(l_org_id, l_item_id);
4880:
4881: END get_item_name;
4882:
4883: