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 481: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.sales_order));

477:
478: IF (p_so_number is null) THEN
479: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
480: fnd_message.set_token('DEPELEM',
481: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.sales_order));
482: fnd_msg_pub.add();
483: END IF;
484:
485: x_lov_sql := 'select distinct to_char(oel.line_number) ,''Sales Order: '' ||

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

522:
523: IF ((p_plan_id is not null) AND (po_header_id is null)) THEN
524: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
525: fnd_message.set_token('DEPELEM',
526: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.po_number));
527: fnd_msg_pub.add();
528: END IF;
529:
530: x_lov_sql := 'SELECT to_char(release_num), QLTDATE.date_to_user(release_date) ' ||

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

546: BEGIN
547: IF ((plan_id is not null) AND (po_number is null)) THEN
548: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
549: fnd_message.set_token('DEPELEM',
550: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number));
551: fnd_msg_pub.add();
552: END IF;
553:
554: x_lov_sql := 'SELECT DISTINCT to_char(pr.release_num) release_number,

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

655: l_project_id NUMBER ;
656:
657: BEGIN
658:
659: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);
660: IF (l_project_id is null) THEN
661: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
662: fnd_message.set_token('DEPELEM',
663: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.project_number));

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

659: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);
660: IF (l_project_id is null) THEN
661: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
662: fnd_message.set_token('DEPELEM',
663: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.project_number));
664: fnd_msg_pub.add();
665: END IF;
666:
667: x_lov_sql := 'select task_number, task_name

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

681:
682: l_project_id NUMBER;
683: BEGIN
684:
685: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);
686:
687: RETURN to_char(l_project_id);
688:
689: END get_task_number_bind_values;

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

736: BEGIN
737: IF (p_rma_number is null) THEN
738: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
739: fnd_message.set_token('DEPELEM',
740: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.rma_number));
741: fnd_msg_pub.add();
742: END IF;
743:
744: x_lov_sql := 'select distinct to_char(oel.line_number),''RMA Number: '' ||

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

784: BEGIN
785: IF ((plan_id is not null) and (x_item_name is null)) THEN
786: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
787: fnd_message.set_token('DEPELEM',
788: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
789: fnd_msg_pub.add();
790: END IF;
791:
792: -- This procedure is used for both uom and component uom

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

843: BEGIN
844: IF ((plan_id is not null) AND (x_item_name is null)) THEN
845: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
846: fnd_message.set_token('DEPELEM',
847: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
848: fnd_msg_pub.add();
849: END IF;
850:
851: -- This procedure is used for both revision and component revision

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

932:
933: IF (p_item is null) THEN
934: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
935: fnd_message.set_token('DEPELEM',
936: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
937: fnd_msg_pub.add();
938: END IF;
939:
940: x_lov_sql := 'select lot_number, description

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

976: BEGIN
977: IF (p_comp_item is null) THEN
978: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
979: fnd_message.set_token('DEPELEM',
980: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
981: fnd_msg_pub.add();
982: END IF;
983:
984: x_lov_sql := 'select lot_number, description

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

1045:
1046: IF (p_item is null) THEN
1047: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1048: fnd_message.set_token('DEPELEM',
1049: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
1050: fnd_msg_pub.add();
1051: END IF;
1052:
1053: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);

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

1062: -- being used in forms. The reason is that if user selects a lot number
1063: -- we expect the item to be lot controlled too. So serial lov is restricted
1064: -- by lot number
1065: j := 3;
1066: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.lot_number)
1067: AND p_lot_number is not NULL
1068: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1069: x_lov_sql := x_lov_sql || ' AND msn.lot_number = :' || to_char(j) || ' ';
1070: j := j+1;

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

1070: j := j+1;
1071: END IF;
1072: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
1073: -- if revision is entered then restrict the serial lov with revision
1074: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.revision)
1075: AND p_revision is not NULL
1076: AND is_item_revision_controlled(l_item_id, p_org_id)) THEN
1077: x_lov_sql := x_lov_sql || ' AND msn.revision = :' || to_char(j) || ' ';
1078: END IF;

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

1100:
1101: l_ret_string := to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_item_id);
1102:
1103:
1104: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.lot_number)
1105: AND p_lot_number is not NULL
1106: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1107: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_lot_number;
1108: END IF;

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

1106: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1107: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_lot_number;
1108: END IF;
1109:
1110: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.revision)
1111: AND p_revision is not NULL
1112: AND is_item_revision_controlled(l_item_id, p_org_id)) THEN
1113: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_revision;
1114: END IF;

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

1134:
1135: IF (p_comp_item is null) THEN
1136: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1137: fnd_message.set_token('DEPELEM',
1138: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
1139: fnd_msg_pub.add();
1140: END IF;
1141:
1142: l_item_id := qa_flex_util.get_item_id(p_org_id, p_comp_item);

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

1145: FROM mtl_serial_numbers_all_v msn
1146: WHERE msn.current_organization_id = :1 ' ||
1147: ' AND msn.inventory_item_id = :2 ';
1148: j := 3;
1149: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.comp_lot_number)
1150: AND p_comp_lot_number is not NULL
1151: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1152: x_lov_sql := x_lov_sql || ' AND msn.lot_number = :' || to_char(j) || ' ';
1153: j := j+1;

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

1151: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1152: x_lov_sql := x_lov_sql || ' AND msn.lot_number = :' || to_char(j) || ' ';
1153: j := j+1;
1154: END IF;
1155: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.comp_revision)
1156: AND p_comp_revision is not NULL
1157: AND is_item_revision_controlled(l_item_id, p_org_id)) THEN
1158: x_lov_sql := x_lov_sql || ' AND msn.revision = :' || to_char(j) || ' ';
1159: END IF;

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

1180:
1181: l_ret_string := to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_item_id);
1182:
1183:
1184: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.lot_number)
1185: AND p_lot_number is not NULL
1186: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1187: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_lot_number;
1188: END IF;

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

1186: AND is_item_lot_controlled(l_item_id, p_org_id)) THEN
1187: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_lot_number;
1188: END IF;
1189:
1190: IF (qa_plan_element_api.element_in_plan(p_plan_id, qa_ss_const.revision)
1191: AND p_revision is not NULL
1192: AND is_item_revision_controlled(l_item_id, p_org_id)) THEN
1193: l_ret_string := l_ret_string || g_bind_value_list_seperator || p_revision;
1194: END IF;

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

1219: /*
1220: IF (x_lot_number is null) THEN
1221: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1222: fnd_message.set_token('DEPELEM',
1223: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.lot_number));
1224: fnd_msg_pub.add();
1225: END IF;
1226:
1227: x_lov_sql := 'SELECT msn.serial_number, msn.current_status

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

1287: l_asset_group_id NUMBER;
1288: l_ret_string VARCHAR2(1000);
1289:
1290: BEGIN
1291: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1292: l_ret_string := to_char(p_org_id);
1293: --RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id) ||
1294: -- g_bind_value_list_seperator || p_asset_number;
1295:

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

1315: BEGIN
1316: IF ((plan_id is not null) AND (x_asset_group is null)) THEN
1317: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1318: fnd_message.set_token('DEPELEM',
1319: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));
1320: fnd_msg_pub.add();
1321: END IF;
1322:
1323: --dgupta: Start R12 EAM Integration. Bug 4345492

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

1351: l_asset_group_id NUMBER;
1352: l_asset_instance_id NUMBER;
1353:
1354: BEGIN
1355: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1356: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1357:
1358: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id) ||
1359: g_bind_value_list_seperator || to_char(l_asset_instance_id);

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

1352: l_asset_instance_id NUMBER;
1353:
1354: BEGIN
1355: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1356: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1357:
1358: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id) ||
1359: g_bind_value_list_seperator || to_char(l_asset_instance_id);
1360:

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

1400: -- for job only.
1401: IF (plan_id is not null) AND (job_name is null) THEN
1402: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1403: fnd_message.set_token('DEPELEM',
1404: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.job_name));
1405: fnd_msg_pub.add();
1406: END IF;
1407:
1408: IF (production_line IS NOT NULL) THEN

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

1405: fnd_msg_pub.add();
1406: END IF;
1407:
1408: IF (production_line IS NOT NULL) THEN
1409: x_line_id := qa_plan_element_api.get_production_line_id(org_id,
1410: production_line);
1411: END IF;
1412:
1413: -- x_wip_entity_id := qa_plan_element_api.get_job_id(org_id, job_name);

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

1409: x_line_id := qa_plan_element_api.get_production_line_id(org_id,
1410: production_line);
1411: END IF;
1412:
1413: -- x_wip_entity_id := qa_plan_element_api.get_job_id(org_id, job_name);
1414:
1415: IF (x_line_id IS NULL) THEN
1416:
1417: -- anagarwa Thu Jan 16 19:02:01 PST 2003

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

1459:
1460: l_line_id := NULL;
1461:
1462: IF (p_production_line IS NOT NULL OR p_production_line <> '') THEN
1463: l_line_id := qa_plan_element_api.get_production_line_id(p_org_id,
1464: p_production_line);
1465: END IF;
1466:
1467: l_wip_entity_id := qa_plan_element_api.get_job_id(p_org_id,p_job_name);

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

1463: l_line_id := qa_plan_element_api.get_production_line_id(p_org_id,
1464: p_production_line);
1465: END IF;
1466:
1467: l_wip_entity_id := qa_plan_element_api.get_job_id(p_org_id,p_job_name);
1468:
1469: IF (l_line_id IS NULL) THEN
1470:
1471: RETURN to_char(l_wip_entity_id) || g_bind_value_list_seperator || to_char(p_org_id);

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

1510: -- in this method except for this dependency check.
1511: IF ((plan_id is not null) AND (po_header_id is null)) THEN
1512: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1513: fnd_message.set_token('DEPELEM',
1514: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number));
1515: fnd_msg_pub.add();
1516: END IF;
1517:
1518: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);

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

1514: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number));
1515: fnd_msg_pub.add();
1516: END IF;
1517:
1518: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);
1519:
1520: -- Bug 3215866 ksoh Wed Oct 29 16:21:11 PST 2003
1521: -- fixed sql to make it return value instead of id.
1522: x_lov_sql := 'SELECT to_char(line_num), concatenated_segments

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

1531: RETURN VARCHAR2 IS
1532:
1533: BEGIN
1534:
1535: -- l_po_number_id := qa_plan_element_api.get_po_number_id(p_po_number);
1536: RETURN p_po_header_id;
1537:
1538: END get_po_line_no_bind_values;
1539:

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

1563: BEGIN
1564: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
1565: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1566: fnd_message.set_token('DEPELEM',
1567: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||
1568: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1569: fnd_msg_pub.add();
1570: END IF;
1571:

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

1564: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
1565: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1566: fnd_message.set_token('DEPELEM',
1567: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||
1568: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1569: fnd_msg_pub.add();
1570: END IF;
1571:
1572: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);

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

1568: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1569: fnd_msg_pub.add();
1570: END IF;
1571:
1572: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);
1573:
1574: -- Bug 3215866 ksoh Wed Oct 29 16:21:11 PST 2003
1575: -- added to_char to lov sql to make it compatible to
1576: -- char column when it is union with the kludge sql: select '1'.....

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

1609:
1610:
1611: BEGIN
1612:
1613: -- l_po_number_id := qa_plan_element_api.get_po_number_id(p_po_number);
1614:
1615: RETURN to_char(p_po_line_num) || g_bind_value_list_seperator || p_po_header_id;
1616:
1617: END get_po_shipments_bind_values;

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

1640: BEGIN
1641: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
1642: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1643: fnd_message.set_token('DEPELEM',
1644: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||
1645: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1646: fnd_msg_pub.add();
1647: END IF;
1648:

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

1641: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
1642: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1643: fnd_message.set_token('DEPELEM',
1644: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||
1645: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1646: fnd_msg_pub.add();
1647: END IF;
1648:
1649: x_lov_sql := 'select to_char(shipment_num) shipment_number,shipment_type

Line 1670: l_po_rel_id := qa_plan_element_api.get_po_release_number_id(p_po_release_num, po_header_id);

1666: l_po_rel_id NUMBER;
1667:
1668: BEGIN
1669:
1670: l_po_rel_id := qa_plan_element_api.get_po_release_number_id(p_po_release_num, po_header_id);
1671:
1672: RETURN to_char(p_po_line_num) || g_bind_value_list_seperator || po_header_id || g_bind_value_list_seperator || to_char(l_po_rel_id);
1673:
1674: END get_po_shipments_bind_values;

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

1745:
1746: l_line_id NUMBER;
1747: BEGIN
1748: IF (p_production_line IS NOT NULL OR p_production_line <> '') THEN
1749: l_line_id := qa_plan_element_api.get_production_line_id(p_org_id,
1750: p_production_line);
1751:
1752: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(p_org_id) ||
1753: g_bind_value_list_seperator || to_char(l_line_id) || g_bind_value_list_seperator ||

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

1767:
1768: IF (p_item is null) THEN
1769: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1770: fnd_message.set_token('DEPELEM',
1771: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
1772: fnd_msg_pub.add();
1773: END IF;
1774:
1775: IF (p_item is not null) THEN

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

1858: IF ((plan_id is not null) AND (p_asset_group is null)
1859: AND (p_asset_instance_number is null)) THEN
1860: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1861: fnd_message.set_token('DEPELEM',
1862: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));
1863: fnd_msg_pub.add();
1864: END IF;
1865:
1866: if (p_asset_number is null and p_asset_instance_number is null) then

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

1936: l_asset_instance_id NUMBER DEFAULT NULL;
1937:
1938: BEGIN
1939: if (p_asset_number is null and p_asset_instance_number is null) then
1940: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1941: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id);
1942: else
1943: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1944: if (l_asset_instance_id is null) then

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

1939: if (p_asset_number is null and p_asset_instance_number is null) then
1940: l_asset_group_id := qa_plan_element_api.get_asset_group_id(p_org_id, p_asset_group);
1941: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id);
1942: else
1943: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1944: if (l_asset_instance_id is null) then
1945: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(l_asset_group_id, p_asset_number);
1946: end if;
1947: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_instance_id);

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

1941: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_group_id);
1942: else
1943: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(p_asset_instance_number);
1944: if (l_asset_instance_id is null) then
1945: l_asset_instance_id := qa_plan_element_api.get_asset_instance_id(l_asset_group_id, p_asset_number);
1946: end if;
1947: RETURN to_char(p_org_id) || g_bind_value_list_seperator || to_char(l_asset_instance_id);
1948: end if;
1949: END get_asset_activity_bind_values;

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

2019: BEGIN
2020: IF ((plan_id is not null) AND (x_subinventory is null)) THEN
2021: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2022: fnd_message.set_token('DEPELEM',
2023: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.subinventory));
2024: fnd_msg_pub.add();
2025: END IF;
2026:
2027: -- anagarwa Thu May 13 14:56:49 PDT 2004

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

2097: BEGIN
2098: IF (p_item is null) THEN
2099: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2100: fnd_message.set_token('DEPELEM',
2101: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
2102: fnd_msg_pub.add();
2103: END IF;
2104:
2105: x_lov_sql := 'SELECT cii.instance_number, cii.serial_number

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

2148: BEGIN
2149: IF (p_item is null) THEN
2150: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2151: fnd_message.set_token('DEPELEM',
2152: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
2153: fnd_msg_pub.add();
2154: END IF;
2155:
2156: x_lov_sql := 'SELECT cii.serial_number, msik.concatenated_segments

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

2338: x_lov_sql OUT NOCOPY VARCHAR2) IS
2339:
2340: l_process_batch_id number;
2341: BEGIN
2342: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2343:
2344: IF (l_process_batch_id is null) THEN
2345: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2346: fnd_message.set_token('DEPELEM',

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

2343:
2344: IF (l_process_batch_id is null) THEN
2345: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2346: fnd_message.set_token('DEPELEM',
2347: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2348: );
2349: fnd_msg_pub.add();
2350: END IF;
2351:

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

2363: RETURN VARCHAR2 IS
2364:
2365: l_process_batch_id number;
2366: BEGIN
2367: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2368:
2369: IF (l_process_batch_id IS NULL) THEN
2370: RETURN NULL;
2371: END IF;

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

2383:
2384: l_process_batch_id number;
2385: l_process_batchstep_id number;
2386: BEGIN
2387: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2388:
2389: IF (l_process_batch_id is null) THEN
2390: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2391: fnd_message.set_token('DEPELEM',

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

2388:
2389: IF (l_process_batch_id is null) THEN
2390: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2391: fnd_message.set_token('DEPELEM',
2392: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2393: );
2394: fnd_msg_pub.add();
2395: END IF;
2396:

Line 2397: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2393: );
2394: fnd_msg_pub.add();
2395: END IF;
2396:
2397: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2398: (process_batchstep_num,L_PROCESS_BATCH_ID);
2399:
2400: IF (l_process_batchstep_id is null) THEN
2401: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

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

2399:
2400: IF (l_process_batchstep_id is null) THEN
2401: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2402: fnd_message.set_token('DEPELEM',
2403: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2404: );
2405: fnd_msg_pub.add();
2406: END IF;
2407:

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

2420:
2421: l_process_batch_id number;
2422: l_process_batchstep_id number;
2423: BEGIN
2424: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2425: IF (l_process_batch_id IS NULL) THEN
2426: RETURN NULL;
2427: END IF;
2428:

Line 2429: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2425: IF (l_process_batch_id IS NULL) THEN
2426: RETURN NULL;
2427: END IF;
2428:
2429: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2430: (process_batchstep_num,L_PROCESS_BATCH_ID);
2431: IF (l_process_batchstep_id IS NULL) THEN
2432: RETURN NULL;
2433: END IF;

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

2448:
2449: l_process_batch_id number;
2450: l_process_batchstep_id number;
2451: BEGIN
2452: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2453:
2454: IF (l_process_batch_id is null) THEN
2455: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2456: fnd_message.set_token('DEPELEM',

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

2453:
2454: IF (l_process_batch_id is null) THEN
2455: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2456: fnd_message.set_token('DEPELEM',
2457: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2458: );
2459: fnd_msg_pub.add();
2460: END IF;
2461:

Line 2462: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2458: );
2459: fnd_msg_pub.add();
2460: END IF;
2461:
2462: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2463: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2464:
2465: IF (l_process_batchstep_id is null) THEN
2466: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

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

2464:
2465: IF (l_process_batchstep_id is null) THEN
2466: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2467: fnd_message.set_token('DEPELEM',
2468: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2469: );
2470: fnd_msg_pub.add();
2471: END IF;
2472:

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

2486:
2487: l_process_batch_id number;
2488: l_process_batchstep_id number;
2489: BEGIN
2490: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2491: IF (l_process_batch_id IS NULL) THEN
2492: RETURN NULL;
2493: END IF;
2494:

Line 2495: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2491: IF (l_process_batch_id IS NULL) THEN
2492: RETURN NULL;
2493: END IF;
2494:
2495: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2496: (process_batchstep_num,L_PROCESS_BATCH_ID);
2497: IF (l_process_batchstep_id IS NULL) THEN
2498: RETURN NULL;
2499: END IF;

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

2516: l_process_batch_id number;
2517: l_process_batchstep_id number;
2518: l_process_activity_id number;
2519: BEGIN
2520: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2521:
2522: IF (l_process_batch_id is null) THEN
2523: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2524: fnd_message.set_token('DEPELEM',

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

2521:
2522: IF (l_process_batch_id is null) THEN
2523: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2524: fnd_message.set_token('DEPELEM',
2525: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2526: );
2527: fnd_msg_pub.add();
2528: END IF;
2529:

Line 2530: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2526: );
2527: fnd_msg_pub.add();
2528: END IF;
2529:
2530: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2531: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2532:
2533: IF (l_process_batchstep_id is null) THEN
2534: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

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

2532:
2533: IF (l_process_batchstep_id is null) THEN
2534: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2535: fnd_message.set_token('DEPELEM',
2536: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2537: );
2538: fnd_msg_pub.add();
2539: END IF;
2540:

Line 2541: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID

2537: );
2538: fnd_msg_pub.add();
2539: END IF;
2540:
2541: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID
2542: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);
2543:
2544: IF (l_process_activity_id is null) THEN
2545: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

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

2543:
2544: IF (l_process_activity_id is null) THEN
2545: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2546: fnd_message.set_token('DEPELEM',
2547: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_activity)
2548: );
2549: fnd_msg_pub.add();
2550: END IF;
2551:

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

2569: l_process_batch_id number;
2570: l_process_batchstep_id number;
2571: l_process_activity_id number;
2572: BEGIN
2573: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2574: IF (l_process_batch_id IS NULL) THEN
2575: RETURN NULL;
2576: END IF;
2577:

Line 2578: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID

2574: IF (l_process_batch_id IS NULL) THEN
2575: RETURN NULL;
2576: END IF;
2577:
2578: l_process_batchstep_id := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2579: (process_batchstep_num,L_PROCESS_BATCH_ID);
2580: IF (l_process_batchstep_id IS NULL) THEN
2581: RETURN NULL;
2582: END IF;

Line 2584: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID

2580: IF (l_process_batchstep_id IS NULL) THEN
2581: RETURN NULL;
2582: END IF;
2583:
2584: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID
2585: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);
2586:
2587: IF (l_process_activity_id IS NULL) THEN
2588: RETURN NULL;

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

2647: BEGIN
2648: IF ((plan_id is not null) AND (maintenance_work_order is null)) THEN
2649: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2650: fnd_message.set_token('DEPELEM',
2651: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.work_order));
2652: fnd_msg_pub.add();
2653: END IF;
2654: -- rkaza. 10/22/2003. 3209804.
2655: -- operation_seq_num should be made a varchar2 to be compatible with

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

2655: -- operation_seq_num should be made a varchar2 to be compatible with
2656: -- code and description in a dynamic lov.
2657: -- Also lov should not error out if wip_entity_id is null.
2658:
2659: x_wip_entity_id := qa_plan_element_api.get_job_id(org_id, maintenance_work_order);
2660:
2661: if x_wip_entity_id is not null then
2662: x_lov_sql := 'SELECT to_char(operation_seq_num), operation_code
2663: FROM wip_operations_all_v

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

2682: l_wip_entity_id NUMBER;
2683:
2684: BEGIN
2685:
2686: l_wip_entity_id := qa_plan_element_api.get_job_id(p_org_id, p_maintenance_work_order);
2687:
2688: if l_wip_entity_id is not null then
2689: RETURN to_char(l_wip_entity_id) || g_bind_value_list_seperator || to_char(p_org_id);
2690: end if;

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

2776: /*
2777: IF ((plan_id is not null) AND (x_item_name is null)) THEN
2778: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2779: fnd_message.set_token('DEPELEM',
2780: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
2781: fnd_msg_pub.add();
2782: END IF;
2783:
2784: x_lov_sql := 'SELECT concatenated_segments, description