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_SS_LOV_API dependencies on QA_PLAN_ELEMENT_API

Line 487: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.po_number));

483:
484: IF ((p_plan_id is not null) AND (po_header_id is null)) THEN
485: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
486: fnd_message.set_token('DEPELEM',
487: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.po_number));
488: fnd_msg_pub.add();
489: END IF;
490:
491: x_lov_sql := 'SELECT to_char(release_num), QLTDATE.date_to_user(release_date) ' ||

Line 567: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);

563: l_project_id NUMBER ;
564:
565: BEGIN
566:
567: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);
568: IF (l_project_id is null) THEN
569: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
570: fnd_message.set_token('DEPELEM',
571: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.project_number));

Line 571: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.project_number));

567: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);
568: IF (l_project_id is null) THEN
569: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
570: fnd_message.set_token('DEPELEM',
571: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.project_number));
572: fnd_msg_pub.add();
573: END IF;
574:
575: x_lov_sql := 'select task_number, task_name

Line 593: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);

589:
590: l_project_id NUMBER;
591: BEGIN
592:
593: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);
594:
595: RETURN to_char(l_project_id);
596:
597: END get_task_number_bind_values;

Line 648: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.rma_number));

644: BEGIN
645: IF (p_rma_number is null) THEN
646: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
647: fnd_message.set_token('DEPELEM',
648: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.rma_number));
649: fnd_msg_pub.add();
650: END IF;
651:
652: x_lov_sql := 'select distinct to_char(oel.line_number),''RMA Number: '' ||

Line 696: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));

692: BEGIN
693: IF ((plan_id is not null) and (x_item_name is null)) THEN
694: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
695: fnd_message.set_token('DEPELEM',
696: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
697: fnd_msg_pub.add();
698: END IF;
699:
700: -- This procedure is used for both uom and component uom

Line 755: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));

751: BEGIN
752: IF ((plan_id is not null) AND (x_item_name is null)) THEN
753: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
754: fnd_message.set_token('DEPELEM',
755: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
756: fnd_msg_pub.add();
757: END IF;
758:
759: -- This procedure is used for both revision and component revision

Line 844: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));

840:
841: IF (p_item is null) THEN
842: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
843: fnd_message.set_token('DEPELEM',
844: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
845: fnd_msg_pub.add();
846: END IF;
847:
848: x_lov_sql := 'select lot_number, description

Line 888: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));

884: BEGIN
885: IF (p_comp_item is null) THEN
886: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
887: fnd_message.set_token('DEPELEM',
888: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
889: fnd_msg_pub.add();
890: END IF;
891:
892: x_lov_sql := 'select lot_number, description

Line 957: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));

953:
954: IF (p_item is null) THEN
955: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
956: fnd_message.set_token('DEPELEM',
957: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
958: fnd_msg_pub.add();
959: END IF;
960:
961: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);

Line 974: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.lot_number)

970: -- being used in forms. The reason is that if user selects a lot number
971: -- we expect the item to be lot controlled too. So serial lov is restricted
972: -- by lot number
973: j := 3;
974: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.lot_number)
975: AND p_lot_number is not NULL
976: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
977: x_lov_sql := x_lov_sql || ' AND msn.lot_number = :' || to_char(j) || ' ';
978: j := j+1;

Line 982: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.revision)

978: j := j+1;
979: END IF;
980: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
981: -- if revision is entered then restrict the serial lov with revision
982: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.revision)
983: AND p_revision is not NULL
984: AND is_item_revision_controlled(l_item_id, p_org_id)) THEN
985: x_lov_sql := x_lov_sql || ' AND msn.revision = :' || to_char(j) || ' ';
986: END IF;

Line 1012: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.lot_number)

1008:
1009: l_ret_string := to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_item_id);
1010:
1011:
1012: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.lot_number)
1013: AND p_lot_number is not NULL
1014: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1015: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_lot_number;
1016: END IF;

Line 1018: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.revision)

1014: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1015: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_lot_number;
1016: END IF;
1017:
1018: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.revision)
1019: AND p_revision is not NULL
1020: AND is_item_revision_controlled(l_item_id, p_org_id)) THEN
1021: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_revision;
1022: END IF;

Line 1046: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));

1042:
1043: IF (p_comp_item is null) THEN
1044: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1045: fnd_message.set_token('DEPELEM',
1046: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
1047: fnd_msg_pub.add();
1048: END IF;
1049:
1050: l_item_id := qa_flex_util.get_item_id(p_org_id, p_comp_item);

Line 1057: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.comp_lot_number)

1053: FROM mtl_serial_numbers_all_v msn
1054: WHERE msn.current_organization_id = :1 ' ||
1055: ' AND msn.inventory_item_id = :2 ';
1056: j := 3;
1057: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.comp_lot_number)
1058: AND p_comp_lot_number is not NULL
1059: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1060: x_lov_sql := x_lov_sql || ' AND msn.lot_number = :' || to_char(j) || ' ';
1061: j := j+1;

Line 1063: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.comp_revision)

1059: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1060: x_lov_sql := x_lov_sql || ' AND msn.lot_number = :' || to_char(j) || ' ';
1061: j := j+1;
1062: END IF;
1063: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.comp_revision)
1064: AND p_comp_revision is not NULL
1065: AND is_item_revision_controlled(l_item_id, p_org_id)) THEN
1066: x_lov_sql := x_lov_sql || ' AND msn.revision = :' || to_char(j) || ' ';
1067: END IF;

Line 1092: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.lot_number)

1088:
1089: l_ret_string := to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_item_id);
1090:
1091:
1092: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.lot_number)
1093: AND p_lot_number is not NULL
1094: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1095: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_lot_number;
1096: END IF;

Line 1098: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.revision)

1094: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1095: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_lot_number;
1096: END IF;
1097:
1098: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.revision)
1099: AND p_revision is not NULL
1100: AND is_item_revision_controlled(l_item_id, p_org_id)) THEN
1101: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_revision;
1102: END IF;

Line 1131: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.lot_number));

1127: /*
1128: IF (x_lot_number is null) THEN
1129: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1130: fnd_message.set_token('DEPELEM',
1131: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.lot_number));
1132: fnd_msg_pub.add();
1133: END IF;
1134:
1135: x_lov_sql := 'SELECT msn.serial_number, msn.current_status

Line 1199: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);

1195: l_asset_group_id NUMBER;
1196: l_ret_string VARCHAR2(1000);
1197:
1198: BEGIN
1199: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1200: l_ret_string := to_char(p_org_id);
1201: --RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id) ||
1202: -- g_bind_value_list_seperator || p_asset_number;
1203:

Line 1227: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));

1223: BEGIN
1224: IF ((plan_id is not null) AND (x_asset_group is null)) THEN
1225: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1226: fnd_message.set_token('DEPELEM',
1227: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));
1228: fnd_msg_pub.add();
1229: END IF;
1230:
1231: --dgupta: Start R12 EAM Integration. Bug 4345492

Line 1263: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);

1259: l_asset_group_id NUMBER;
1260: l_asset_instance_id NUMBER;
1261:
1262: BEGIN
1263: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1264: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1265:
1266: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id) ||
1267: g_bind_value_list_seperator || to_char(l_asset_instance_id);

Line 1264: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);

1260: l_asset_instance_id NUMBER;
1261:
1262: BEGIN
1263: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1264: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1265:
1266: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id) ||
1267: g_bind_value_list_seperator || to_char(l_asset_instance_id);
1268:

Line 1312: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.job_name));

1308: -- for job only.
1309: IF (plan_id is not null) AND (job_name is null) THEN
1310: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1311: fnd_message.set_token('DEPELEM',
1312: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.job_name));
1313: fnd_msg_pub.add();
1314: END IF;
1315:
1316: IF (production_line IS NOT NULL) THEN

Line 1317: x_line_id := qa_plan_element_api.get_production_line_id(org_id,

1313: fnd_msg_pub.add();
1314: END IF;
1315:
1316: IF (production_line IS NOT NULL) THEN
1317: x_line_id := qa_plan_element_api.get_production_line_id(org_id,
1318: production_line);
1319: END IF;
1320:
1321: -- x_wip_entity_id := qa_plan_element_api.get_job_id(org_id, job_name);

Line 1321: -- x_wip_entity_id := qa_plan_element_api.get_job_id(org_id, job_name);

1317: x_line_id := qa_plan_element_api.get_production_line_id(org_id,
1318: production_line);
1319: END IF;
1320:
1321: -- x_wip_entity_id := qa_plan_element_api.get_job_id(org_id, job_name);
1322:
1323: IF (x_line_id IS NULL) THEN
1324:
1325: -- anagarwa Thu Jan 16 19:02:01 PST 2003

Line 1371: l_line_id := qa_plan_element_api.get_production_line_id(p_org_id,

1367:
1368: l_line_id := NULL;
1369:
1370: IF (p_production_line IS NOT NULL OR p_production_line <> '') THEN
1371: l_line_id := qa_plan_element_api.get_production_line_id(p_org_id,
1372: p_production_line);
1373: END IF;
1374:
1375: l_wip_entity_id := qa_plan_element_api.get_job_id(p_org_id,p_job_name);

Line 1375: l_wip_entity_id := qa_plan_element_api.get_job_id(p_org_id,p_job_name);

1371: l_line_id := qa_plan_element_api.get_production_line_id(p_org_id,
1372: p_production_line);
1373: END IF;
1374:
1375: l_wip_entity_id := qa_plan_element_api.get_job_id(p_org_id,p_job_name);
1376:
1377: IF (l_line_id IS NULL) THEN
1378:
1379: RETURN to_char(l_wip_entity_id) || g_bind_value_list_seperator || to_char(p_org_id);

Line 1422: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number));

1418: -- in this method except for this dependency check.
1419: IF ((plan_id is not null) AND (po_header_id is null)) THEN
1420: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1421: fnd_message.set_token('DEPELEM',
1422: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number));
1423: fnd_msg_pub.add();
1424: END IF;
1425:
1426: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);

Line 1426: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);

1422: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number));
1423: fnd_msg_pub.add();
1424: END IF;
1425:
1426: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);
1427:
1428: -- Bug 3215866 ksoh Wed Oct 29 16:21:11 PST 2003
1429: -- fixed sql to make it return value instead of id.
1430: x_lov_sql := 'SELECT to_char(line_num), concatenated_segments

Line 1443: -- l_po_number_id := qa_plan_element_api.get_po_number_id(p_po_number);

1439: RETURN VARCHAR2 IS
1440:
1441: BEGIN
1442:
1443: -- l_po_number_id := qa_plan_element_api.get_po_number_id(p_po_number);
1444: RETURN p_po_header_id;
1445:
1446: END get_po_line_no_bind_values;
1447:

Line 1471: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||

1467: BEGIN
1468: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
1469: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1470: fnd_message.set_token('DEPELEM',
1471: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||
1472: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1473: fnd_msg_pub.add();
1474: END IF;
1475:

Line 1472: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));

1468: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
1469: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1470: fnd_message.set_token('DEPELEM',
1471: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||
1472: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1473: fnd_msg_pub.add();
1474: END IF;
1475:
1476: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);

Line 1476: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);

1472: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1473: fnd_msg_pub.add();
1474: END IF;
1475:
1476: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);
1477:
1478: -- Bug 3215866 ksoh Wed Oct 29 16:21:11 PST 2003
1479: -- added to_char to lov sql to make it compatible to
1480: -- char column when it is union with the kludge sql: select '1'.....

Line 1512: -- l_po_number_id := qa_plan_element_api.get_po_number_id(p_po_number);

1508:
1509:
1510: BEGIN
1511:
1512: -- l_po_number_id := qa_plan_element_api.get_po_number_id(p_po_number);
1513:
1514: RETURN to_char(p_po_line_num) || g_bind_value_list_seperator || p_po_header_id;
1515:
1516: END get_po_shipments_bind_values;

Line 1577: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));

1573:
1574: IF (p_item is null) THEN
1575: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1576: fnd_message.set_token('DEPELEM',
1577: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
1578: fnd_msg_pub.add();
1579: END IF;
1580:
1581: IF (p_item is not null) THEN

Line 1668: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));

1664: IF ((plan_id is not null) AND (p_asset_group is null)
1665: AND (p_asset_instance_number is null)) THEN
1666: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1667: fnd_message.set_token('DEPELEM',
1668: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));
1669: fnd_msg_pub.add();
1670: END IF;
1671:
1672: if (p_asset_number is null and p_asset_instance_number is null) then

Line 1746: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);

1742: l_asset_instance_id NUMBER DEFAULT NULL;
1743:
1744: BEGIN
1745: if (p_asset_number is null and p_asset_instance_number is null) then
1746: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1747: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id);
1748: else
1749: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1750: if (l_asset_instance_id is null) then

Line 1749: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);

1745: if (p_asset_number is null and p_asset_instance_number is null) then
1746: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1747: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id);
1748: else
1749: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1750: if (l_asset_instance_id is null) then
1751: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(l_asset_group_id, p_asset_number);
1752: end if;
1753: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_instance_id);

Line 1751: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(l_asset_group_id, p_asset_number);

1747: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id);
1748: else
1749: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1750: if (l_asset_instance_id is null) then
1751: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(l_asset_group_id, p_asset_number);
1752: end if;
1753: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_instance_id);
1754: end if;
1755: END get_asset_activity_bind_values;

Line 1829: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.subinventory));

1825: BEGIN
1826: IF ((plan_id is not null) AND (x_subinventory is null)) THEN
1827: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1828: fnd_message.set_token('DEPELEM',
1829: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.subinventory));
1830: fnd_msg_pub.add();
1831: END IF;
1832:
1833: -- anagarwa Thu May 13 14:56:49 PDT 2004

Line 2045: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);

2041: x_lov_sql OUT NOCOPY VARCHAR2) IS
2042:
2043: l_process_batch_id number;
2044: BEGIN
2045: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2046:
2047: IF (l_process_batch_id is null) THEN
2048: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2049: fnd_message.set_token('DEPELEM',

Line 2050: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)

2046:
2047: IF (l_process_batch_id is null) THEN
2048: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2049: fnd_message.set_token('DEPELEM',
2050: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2051: );
2052: fnd_msg_pub.add();
2053: END IF;
2054:

Line 2070: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);

2066: RETURN VARCHAR2 IS
2067:
2068: l_process_batch_id number;
2069: BEGIN
2070: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2071:
2072: IF (l_process_batch_id IS NULL) THEN
2073: RETURN NULL;
2074: END IF;

Line 2090: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);

2086:
2087: l_process_batch_id number;
2088: l_process_batchstep_id number;
2089: BEGIN
2090: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2091:
2092: IF (l_process_batch_id is null) THEN
2093: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2094: fnd_message.set_token('DEPELEM',

Line 2095: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)

2091:
2092: IF (l_process_batch_id is null) THEN
2093: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2094: fnd_message.set_token('DEPELEM',
2095: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2096: );
2097: fnd_msg_pub.add();
2098: END IF;
2099:

Line 2100: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2096: );
2097: fnd_msg_pub.add();
2098: END IF;
2099:
2100: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2101: (process_batchstep_num,L_PROCESS_BATCH_ID);
2102:
2103: IF (l_process_batchstep_id is null) THEN
2104: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

Line 2106: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)

2102:
2103: IF (l_process_batchstep_id is null) THEN
2104: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2105: fnd_message.set_token('DEPELEM',
2106: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2107: );
2108: fnd_msg_pub.add();
2109: END IF;
2110:

Line 2127: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);

2123:
2124: l_process_batch_id number;
2125: l_process_batchstep_id number;
2126: BEGIN
2127: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2128: IF (l_process_batch_id IS NULL) THEN
2129: RETURN NULL;
2130: END IF;
2131:

Line 2132: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2128: IF (l_process_batch_id IS NULL) THEN
2129: RETURN NULL;
2130: END IF;
2131:
2132: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2133: (process_batchstep_num,L_PROCESS_BATCH_ID);
2134: IF (l_process_batchstep_id IS NULL) THEN
2135: RETURN NULL;
2136: END IF;

Line 2155: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);

2151:
2152: l_process_batch_id number;
2153: l_process_batchstep_id number;
2154: BEGIN
2155: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2156:
2157: IF (l_process_batch_id is null) THEN
2158: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2159: fnd_message.set_token('DEPELEM',

Line 2160: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)

2156:
2157: IF (l_process_batch_id is null) THEN
2158: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2159: fnd_message.set_token('DEPELEM',
2160: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2161: );
2162: fnd_msg_pub.add();
2163: END IF;
2164:

Line 2165: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2161: );
2162: fnd_msg_pub.add();
2163: END IF;
2164:
2165: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2166: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2167:
2168: IF (l_process_batchstep_id is null) THEN
2169: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

Line 2171: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)

2167:
2168: IF (l_process_batchstep_id is null) THEN
2169: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2170: fnd_message.set_token('DEPELEM',
2171: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2172: );
2173: fnd_msg_pub.add();
2174: END IF;
2175:

Line 2193: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);

2189:
2190: l_process_batch_id number;
2191: l_process_batchstep_id number;
2192: BEGIN
2193: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2194: IF (l_process_batch_id IS NULL) THEN
2195: RETURN NULL;
2196: END IF;
2197:

Line 2198: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2194: IF (l_process_batch_id IS NULL) THEN
2195: RETURN NULL;
2196: END IF;
2197:
2198: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2199: (process_batchstep_num,L_PROCESS_BATCH_ID);
2200: IF (l_process_batchstep_id IS NULL) THEN
2201: RETURN NULL;
2202: END IF;

Line 2223: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);

2219: l_process_batch_id number;
2220: l_process_batchstep_id number;
2221: l_process_activity_id number;
2222: BEGIN
2223: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2224:
2225: IF (l_process_batch_id is null) THEN
2226: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2227: fnd_message.set_token('DEPELEM',

Line 2228: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)

2224:
2225: IF (l_process_batch_id is null) THEN
2226: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2227: fnd_message.set_token('DEPELEM',
2228: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2229: );
2230: fnd_msg_pub.add();
2231: END IF;
2232:

Line 2233: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2229: );
2230: fnd_msg_pub.add();
2231: END IF;
2232:
2233: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2234: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2235:
2236: IF (l_process_batchstep_id is null) THEN
2237: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

Line 2239: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)

2235:
2236: IF (l_process_batchstep_id is null) THEN
2237: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2238: fnd_message.set_token('DEPELEM',
2239: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2240: );
2241: fnd_msg_pub.add();
2242: END IF;
2243:

Line 2244: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID

2240: );
2241: fnd_msg_pub.add();
2242: END IF;
2243:
2244: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID
2245: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);
2246:
2247: IF (l_process_activity_id is null) THEN
2248: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

Line 2250: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_activity)

2246:
2247: IF (l_process_activity_id is null) THEN
2248: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2249: fnd_message.set_token('DEPELEM',
2250: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_activity)
2251: );
2252: fnd_msg_pub.add();
2253: END IF;
2254:

Line 2276: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);

2272: l_process_batch_id number;
2273: l_process_batchstep_id number;
2274: l_process_activity_id number;
2275: BEGIN
2276: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2277: IF (l_process_batch_id IS NULL) THEN
2278: RETURN NULL;
2279: END IF;
2280:

Line 2281: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2277: IF (l_process_batch_id IS NULL) THEN
2278: RETURN NULL;
2279: END IF;
2280:
2281: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2282: (process_batchstep_num,L_PROCESS_BATCH_ID);
2283: IF (l_process_batchstep_id IS NULL) THEN
2284: RETURN NULL;
2285: END IF;

Line 2287: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID

2283: IF (l_process_batchstep_id IS NULL) THEN
2284: RETURN NULL;
2285: END IF;
2286:
2287: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID
2288: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);
2289:
2290: IF (l_process_activity_id IS NULL) THEN
2291: RETURN NULL;

Line 2354: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.work_order));

2350: BEGIN
2351: IF ((plan_id is not null) AND (maintenance_work_order is null)) THEN
2352: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2353: fnd_message.set_token('DEPELEM',
2354: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.work_order));
2355: fnd_msg_pub.add();
2356: END IF;
2357: -- rkaza. 10/22/2003. 3209804.
2358: -- operation_seq_num should be made a varchar2 to be compatible with

Line 2362: x_wip_entity_id := qa_plan_element_api.get_job_id(org_id, maintenance_work_order);

2358: -- operation_seq_num should be made a varchar2 to be compatible with
2359: -- code and description in a dynamic lov.
2360: -- Also lov should not error out if wip_entity_id is null.
2361:
2362: x_wip_entity_id := qa_plan_element_api.get_job_id(org_id, maintenance_work_order);
2363:
2364: if x_wip_entity_id is not null then
2365: x_lov_sql := 'SELECT to_char(operation_seq_num), operation_code
2366: FROM wip_operations_all_v

Line 2389: l_wip_entity_id := qa_plan_element_api.get_job_id(p_org_id, p_maintenance_work_order);

2385: l_wip_entity_id NUMBER;
2386:
2387: BEGIN
2388:
2389: l_wip_entity_id := qa_plan_element_api.get_job_id(p_org_id, p_maintenance_work_order);
2390:
2391: if l_wip_entity_id is not null then
2392: RETURN to_char(l_wip_entity_id) || g_bind_value_list_seperator || to_char(p_org_id);
2393: end if;

Line 2483: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));

2479: /*
2480: IF ((plan_id is not null) AND (x_item_name is null)) THEN
2481: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2482: fnd_message.set_token('DEPELEM',
2483: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
2484: fnd_msg_pub.add();
2485: END IF;
2486:
2487: x_lov_sql := 'SELECT concatenated_segments, description