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_SS_CONST

Line 120: i := mod(plan_id * qa_ss_const.max_elements + element_id,

116: -- a mirror copy of that in qltelemb. Can this one be
117: -- removed?
118: --
119:
120: i := mod(plan_id * qa_ss_const.max_elements + element_id,
121: 2147483647);
122:
123: LOOP
124: IF NOT x_qa_plan_chars_array.EXISTS(i) THEN

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

Line 3065: IF (char_id = qa_ss_const.department) THEN

3061: -- we should clear stack so that errors are not shown over and over again.
3062: fnd_msg_pub.Initialize();
3063: fnd_msg_pub.reset();
3064:
3065: IF (char_id = qa_ss_const.department) THEN
3066: get_department_lov(org_id, value, l_lov_sql);
3067:
3068: ELSIF (char_id = qa_ss_const.job_name) THEN
3069: get_job_lov(org_id, value, l_lov_sql);

Line 3068: ELSIF (char_id = qa_ss_const.job_name) THEN

3064:
3065: IF (char_id = qa_ss_const.department) THEN
3066: get_department_lov(org_id, value, l_lov_sql);
3067:
3068: ELSIF (char_id = qa_ss_const.job_name) THEN
3069: get_job_lov(org_id, value, l_lov_sql);
3070:
3071: ELSIF (char_id = qa_ss_const.work_order) THEN
3072: get_work_order_lov(org_id, value, l_lov_sql);

Line 3071: ELSIF (char_id = qa_ss_const.work_order) THEN

3067:
3068: ELSIF (char_id = qa_ss_const.job_name) THEN
3069: get_job_lov(org_id, value, l_lov_sql);
3070:
3071: ELSIF (char_id = qa_ss_const.work_order) THEN
3072: get_work_order_lov(org_id, value, l_lov_sql);
3073:
3074: ELSIF (char_id = qa_ss_const.production_line) THEN
3075: get_production_lov(org_id, value, l_lov_sql);

Line 3074: ELSIF (char_id = qa_ss_const.production_line) THEN

3070:
3071: ELSIF (char_id = qa_ss_const.work_order) THEN
3072: get_work_order_lov(org_id, value, l_lov_sql);
3073:
3074: ELSIF (char_id = qa_ss_const.production_line) THEN
3075: get_production_lov(org_id, value, l_lov_sql);
3076:
3077: ELSIF (char_id = qa_ss_const.resource_code) THEN
3078: get_resource_code_lov(org_id, value, l_lov_sql);

Line 3077: ELSIF (char_id = qa_ss_const.resource_code) THEN

3073:
3074: ELSIF (char_id = qa_ss_const.production_line) THEN
3075: get_production_lov(org_id, value, l_lov_sql);
3076:
3077: ELSIF (char_id = qa_ss_const.resource_code) THEN
3078: get_resource_code_lov(org_id, value, l_lov_sql);
3079:
3080: ELSIF (char_id = qa_ss_const.vendor_name) THEN
3081: get_supplier_lov(value, l_lov_sql);

Line 3080: ELSIF (char_id = qa_ss_const.vendor_name) THEN

3076:
3077: ELSIF (char_id = qa_ss_const.resource_code) THEN
3078: get_resource_code_lov(org_id, value, l_lov_sql);
3079:
3080: ELSIF (char_id = qa_ss_const.vendor_name) THEN
3081: get_supplier_lov(value, l_lov_sql);
3082:
3083: ELSIF (char_id = qa_ss_const.po_number) THEN
3084: get_po_number_lov(value, l_lov_sql);

Line 3083: ELSIF (char_id = qa_ss_const.po_number) THEN

3079:
3080: ELSIF (char_id = qa_ss_const.vendor_name) THEN
3081: get_supplier_lov(value, l_lov_sql);
3082:
3083: ELSIF (char_id = qa_ss_const.po_number) THEN
3084: get_po_number_lov(value, l_lov_sql);
3085:
3086: ELSIF (char_id = qa_ss_const.customer_name) THEN
3087: get_customer_lov(value, l_lov_sql);

Line 3086: ELSIF (char_id = qa_ss_const.customer_name) THEN

3082:
3083: ELSIF (char_id = qa_ss_const.po_number) THEN
3084: get_po_number_lov(value, l_lov_sql);
3085:
3086: ELSIF (char_id = qa_ss_const.customer_name) THEN
3087: get_customer_lov(value, l_lov_sql);
3088:
3089: ELSIF (char_id = qa_ss_const.sales_order) THEN
3090: get_so_number_lov(value, l_lov_sql);

Line 3089: ELSIF (char_id = qa_ss_const.sales_order) THEN

3085:
3086: ELSIF (char_id = qa_ss_const.customer_name) THEN
3087: get_customer_lov(value, l_lov_sql);
3088:
3089: ELSIF (char_id = qa_ss_const.sales_order) THEN
3090: get_so_number_lov(value, l_lov_sql);
3091:
3092: ELSIF (char_id = qa_ss_const.order_line) THEN
3093: -- Bug 7716875.Added sales Order as dependent.The depen1 here

Line 3092: ELSIF (char_id = qa_ss_const.order_line) THEN

3088:
3089: ELSIF (char_id = qa_ss_const.sales_order) THEN
3090: get_so_number_lov(value, l_lov_sql);
3091:
3092: ELSIF (char_id = qa_ss_const.order_line) THEN
3093: -- Bug 7716875.Added sales Order as dependent.The depen1 here
3094: -- will be passed as SO Number.pdube Mon Apr 13 03:25:19 PDT 2009
3095: -- get_so_line_number_lov(value, l_lov_sql);
3096: get_so_line_number_lov(plan_id, depen1, value, l_lov_sql);

Line 3098: ELSIF (char_id = qa_ss_const.po_release_num) THEN

3094: -- will be passed as SO Number.pdube Mon Apr 13 03:25:19 PDT 2009
3095: -- get_so_line_number_lov(value, l_lov_sql);
3096: get_so_line_number_lov(plan_id, depen1, value, l_lov_sql);
3097:
3098: ELSIF (char_id = qa_ss_const.po_release_num) THEN
3099: --
3100: -- Bug 5003511. R12 Performance bug. SQLID: 15008630
3101: -- Release number is dependent on PO Number.
3102: -- Call new overloaded method.

Line 3112: ELSIF (char_id = qa_ss_const.project_number) THEN

3108: -- skolluku.
3109: get_po_release_number_lov(plan_id, depen1, depen2, value, l_lov_sql);
3110:
3111:
3112: ELSIF (char_id = qa_ss_const.project_number) THEN
3113: get_project_number_lov(value, l_lov_sql);
3114:
3115: ELSIF (char_id = qa_ss_const.task_number) THEN
3116: -- anagarwa Thu Jan 29 15:04:26 PST 2004

Line 3115: ELSIF (char_id = qa_ss_const.task_number) THEN

3111:
3112: ELSIF (char_id = qa_ss_const.project_number) THEN
3113: get_project_number_lov(value, l_lov_sql);
3114:
3115: ELSIF (char_id = qa_ss_const.task_number) THEN
3116: -- anagarwa Thu Jan 29 15:04:26 PST 2004
3117: -- Bug 3404863 : task lov should be dependent upon project so now we
3118: -- pass project number as parent element value.
3119: get_task_number_lov(plan_id, depen1, value, l_lov_sql);

Line 3121: ELSIF (char_id = qa_ss_const.rma_number) THEN

3117: -- Bug 3404863 : task lov should be dependent upon project so now we
3118: -- pass project number as parent element value.
3119: get_task_number_lov(plan_id, depen1, value, l_lov_sql);
3120:
3121: ELSIF (char_id = qa_ss_const.rma_number) THEN
3122: get_rma_number_lov(value, l_lov_sql);
3123:
3124: ELSIF (char_id = qa_ss_const.uom) THEN
3125: -- get_uom_lov(org_id, item_name, value, l_lov_sql);

Line 3124: ELSIF (char_id = qa_ss_const.uom) THEN

3120:
3121: ELSIF (char_id = qa_ss_const.rma_number) THEN
3122: get_rma_number_lov(value, l_lov_sql);
3123:
3124: ELSIF (char_id = qa_ss_const.uom) THEN
3125: -- get_uom_lov(org_id, item_name, value, l_lov_sql);
3126: get_uom_lov(plan_id, org_id, depen1, value, l_lov_sql);
3127:
3128: -- anagarwa Mon Feb 24 17:08:57 PST 2003

Line 3131: ELSIF (char_id = qa_ss_const.revision OR

3127:
3128: -- anagarwa Mon Feb 24 17:08:57 PST 2003
3129: -- Bug 2808693
3130: -- adding support for comp_revision
3131: ELSIF (char_id = qa_ss_const.revision OR
3132: char_id = qa_ss_const.comp_revision) THEN
3133: -- get_revision_lov(org_id, item_name, value, l_lov_sql);
3134: get_revision_lov(plan_id, org_id, depen1, value, l_lov_sql);
3135:

Line 3132: char_id = qa_ss_const.comp_revision) THEN

3128: -- anagarwa Mon Feb 24 17:08:57 PST 2003
3129: -- Bug 2808693
3130: -- adding support for comp_revision
3131: ELSIF (char_id = qa_ss_const.revision OR
3132: char_id = qa_ss_const.comp_revision) THEN
3133: -- get_revision_lov(org_id, item_name, value, l_lov_sql);
3134: get_revision_lov(plan_id, org_id, depen1, value, l_lov_sql);
3135:
3136: ELSIF (char_id = qa_ss_const.subinventory) THEN

Line 3136: ELSIF (char_id = qa_ss_const.subinventory) THEN

3132: char_id = qa_ss_const.comp_revision) THEN
3133: -- get_revision_lov(org_id, item_name, value, l_lov_sql);
3134: get_revision_lov(plan_id, org_id, depen1, value, l_lov_sql);
3135:
3136: ELSIF (char_id = qa_ss_const.subinventory) THEN
3137: get_subinventory_lov(org_id, value, l_lov_sql);
3138:
3139: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
3140: -- bug 3830258 incorrect LOVs in QWB

Line 3142: ELSIF (char_id = qa_ss_const.lot_number) THEN

3138:
3139: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
3140: -- bug 3830258 incorrect LOVs in QWB
3141: -- synced up the lot and serial number lov with forms
3142: ELSIF (char_id = qa_ss_const.lot_number) THEN
3143: -- get_lot_number_lov(transaction_id, value, l_lov_sql);
3144: -- get_lot_number_lov(depen3, value, l_lov_sql);
3145: get_lot_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
3146:

Line 3147: ELSIF (char_id = qa_ss_const.serial_number) THEN

3143: -- get_lot_number_lov(transaction_id, value, l_lov_sql);
3144: -- get_lot_number_lov(depen3, value, l_lov_sql);
3145: get_lot_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
3146:
3147: ELSIF (char_id = qa_ss_const.serial_number) THEN
3148: -- get_serial_number_lov(transaction_id, lot_number, value, l_lov_sql);
3149: -- get_serial_number_lov(plan_id, depen3, depen1, value, l_lov_sql);
3150: get_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);
3151:

Line 3153: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN

3149: -- get_serial_number_lov(plan_id, depen3, depen1, value, l_lov_sql);
3150: get_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);
3151:
3152: -- dgupta: Start R12 EAM Integration. Bug 4345492
3153: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN
3154: get_asset_instance_number_lov(plan_id, org_id, depen1,depen2,value, l_lov_sql);
3155: --dgupta: End R12 EAM Integration. Bug 4345492
3156:
3157: ELSIF (char_id = qa_ss_const.asset_number) THEN

Line 3157: ELSIF (char_id = qa_ss_const.asset_number) THEN

3153: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN
3154: get_asset_instance_number_lov(plan_id, org_id, depen1,depen2,value, l_lov_sql);
3155: --dgupta: End R12 EAM Integration. Bug 4345492
3156:
3157: ELSIF (char_id = qa_ss_const.asset_number) THEN
3158: -- get_asset_number_lov(org_id, depen1, value, l_lov_sql);
3159: get_asset_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
3160:
3161: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR

Line 3161: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR

3157: ELSIF (char_id = qa_ss_const.asset_number) THEN
3158: -- get_asset_number_lov(org_id, depen1, value, l_lov_sql);
3159: get_asset_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
3160:
3161: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
3162: (char_id = qa_ss_const.to_op_seq_num) THEN
3163: -- get_op_seq_number_lov(org_id, value, job_name, production_line,
3164: -- l_lov_sql);
3165: get_op_seq_number_lov(plan_id, org_id, value, depen1, depen2, l_lov_sql);

Line 3162: (char_id = qa_ss_const.to_op_seq_num) THEN

3158: -- get_asset_number_lov(org_id, depen1, value, l_lov_sql);
3159: get_asset_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
3160:
3161: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
3162: (char_id = qa_ss_const.to_op_seq_num) THEN
3163: -- get_op_seq_number_lov(org_id, value, job_name, production_line,
3164: -- l_lov_sql);
3165: get_op_seq_number_lov(plan_id, org_id, value, depen1, depen2, l_lov_sql);
3166:

Line 3167: ELSIF (char_id = qa_ss_const.po_line_num) THEN

3163: -- get_op_seq_number_lov(org_id, value, job_name, production_line,
3164: -- l_lov_sql);
3165: get_op_seq_number_lov(plan_id, org_id, value, depen1, depen2, l_lov_sql);
3166:
3167: ELSIF (char_id = qa_ss_const.po_line_num) THEN
3168: -- get_po_line_number_lov(po_number, value, l_lov_sql);
3169: get_po_line_number_lov(plan_id, depen1, value, l_lov_sql);
3170:
3171: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN

Line 3171: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN

3167: ELSIF (char_id = qa_ss_const.po_line_num) THEN
3168: -- get_po_line_number_lov(po_number, value, l_lov_sql);
3169: get_po_line_number_lov(plan_id, depen1, value, l_lov_sql);
3170:
3171: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN
3172: -- Bug 9817478. If PO Release Num is present call the new proc.
3173: -- Else use the existing one.
3174: IF (depen3 IS NOT NULL) THEN
3175: get_po_shipments_lov(plan_id, depen1, depen2, depen3, value, l_lov_sql);

Line 3180: ELSIF (char_id = qa_ss_const.receipt_num) THEN

3176: ELSE
3177: -- get_po_shipments_lov(po_line_number, po_number, value, l_lov_sql);
3178: get_po_shipments_lov(plan_id, depen1, depen2, value, l_lov_sql);
3179: END IF;
3180: ELSIF (char_id = qa_ss_const.receipt_num) THEN
3181: get_receipt_num_lov(value, l_lov_sql);
3182:
3183: ELSIF (char_id = qa_ss_const.item) THEN
3184: --

Line 3183: ELSIF (char_id = qa_ss_const.item) THEN

3179: END IF;
3180: ELSIF (char_id = qa_ss_const.receipt_num) THEN
3181: get_receipt_num_lov(value, l_lov_sql);
3182:
3183: ELSIF (char_id = qa_ss_const.item) THEN
3184: --
3185: -- bug 7197055
3186: -- Added depen1 (prod line) for item.
3187: -- skolluku

Line 3192: ELSIF (char_id = qa_ss_const.comp_item) THEN

3188: --
3189: get_item_lov(org_id, value, depen1, l_lov_sql);
3190:
3191: -- rkaza. 12/15/2003. bug 3280307. Added lov for comp item
3192: ELSIF (char_id = qa_ss_const.comp_item) THEN
3193: get_comp_item_lov(plan_id, org_id, depen1, value, l_lov_sql);
3194:
3195: ELSIF (char_id = qa_ss_const.asset_group) THEN
3196: get_asset_group_lov(org_id, value, l_lov_sql);

Line 3195: ELSIF (char_id = qa_ss_const.asset_group) THEN

3191: -- rkaza. 12/15/2003. bug 3280307. Added lov for comp item
3192: ELSIF (char_id = qa_ss_const.comp_item) THEN
3193: get_comp_item_lov(plan_id, org_id, depen1, value, l_lov_sql);
3194:
3195: ELSIF (char_id = qa_ss_const.asset_group) THEN
3196: get_asset_group_lov(org_id, value, l_lov_sql);
3197:
3198: ELSIF (char_id = qa_ss_const.asset_activity) THEN
3199: -- get_asset_activity_lov(org_id, depen1, depen2, value, l_lov_sql);

Line 3198: ELSIF (char_id = qa_ss_const.asset_activity) THEN

3194:
3195: ELSIF (char_id = qa_ss_const.asset_group) THEN
3196: get_asset_group_lov(org_id, value, l_lov_sql);
3197:
3198: ELSIF (char_id = qa_ss_const.asset_activity) THEN
3199: -- get_asset_activity_lov(org_id, depen1, depen2, value, l_lov_sql);
3200: get_asset_activity_lov(plan_id, org_id, depen1, depen2, value, l_lov_sql);
3201:
3202: -- added the following to include new hardcoded element followup activity

Line 3205: ELSIF (char_id = qa_ss_const.followup_activity) THEN

3201:
3202: -- added the following to include new hardcoded element followup activity
3203: -- saugupta
3204:
3205: ELSIF (char_id = qa_ss_const.followup_activity) THEN
3206: -- get_followup_activity_lov(org_id, depen1, depen2, value, l_lov_sql);
3207: get_followup_activity_lov(plan_id, org_id, depen1, depen2, value, l_lov_sql);
3208:
3209: ELSIF (char_id = qa_ss_const.xfr_license_plate_number) THEN

Line 3209: ELSIF (char_id = qa_ss_const.xfr_license_plate_number) THEN

3205: ELSIF (char_id = qa_ss_const.followup_activity) THEN
3206: -- get_followup_activity_lov(org_id, depen1, depen2, value, l_lov_sql);
3207: get_followup_activity_lov(plan_id, org_id, depen1, depen2, value, l_lov_sql);
3208:
3209: ELSIF (char_id = qa_ss_const.xfr_license_plate_number) THEN
3210: get_xfr_lpn_lov(value, l_lov_sql);
3211:
3212: ELSIF (char_id = qa_ss_const.locator) THEN
3213: -- get_locator_lov(org_id, depen1, value, l_lov_sql);

Line 3212: ELSIF (char_id = qa_ss_const.locator) THEN

3208:
3209: ELSIF (char_id = qa_ss_const.xfr_license_plate_number) THEN
3210: get_xfr_lpn_lov(value, l_lov_sql);
3211:
3212: ELSIF (char_id = qa_ss_const.locator) THEN
3213: -- get_locator_lov(org_id, depen1, value, l_lov_sql);
3214: get_locator_lov(plan_id, org_id, depen1, value, l_lov_sql);
3215:
3216: ELSIF (char_id = qa_ss_const.party_name) THEN

Line 3216: ELSIF (char_id = qa_ss_const.party_name) THEN

3212: ELSIF (char_id = qa_ss_const.locator) THEN
3213: -- get_locator_lov(org_id, depen1, value, l_lov_sql);
3214: get_locator_lov(plan_id, org_id, depen1, value, l_lov_sql);
3215:
3216: ELSIF (char_id = qa_ss_const.party_name) THEN
3217: get_party_lov(value, l_lov_sql);
3218:
3219: ELSIF (char_id = qa_ss_const.item_instance) THEN
3220: --

Line 3219: ELSIF (char_id = qa_ss_const.item_instance) THEN

3215:
3216: ELSIF (char_id = qa_ss_const.party_name) THEN
3217: get_party_lov(value, l_lov_sql);
3218:
3219: ELSIF (char_id = qa_ss_const.item_instance) THEN
3220: --
3221: -- Bug 9032151
3222: -- Modified the below procedure to include the value
3223: -- for item on which item instance is dependent.

Line 3233: ELSIF (char_id = qa_ss_const.item_instance_serial) THEN

3229: -- Bug 9359442
3230: -- Added lov for item instance serial based on item.
3231: -- skolluku
3232: --
3233: ELSIF (char_id = qa_ss_const.item_instance_serial) THEN
3234: get_item_instance_serial_lov(plan_id, depen1, value, l_lov_sql);
3235:
3236: ELSIF (char_id = qa_ss_const.service_request) THEN
3237: get_service_request_lov(value, l_lov_sql);

Line 3236: ELSIF (char_id = qa_ss_const.service_request) THEN

3232: --
3233: ELSIF (char_id = qa_ss_const.item_instance_serial) THEN
3234: get_item_instance_serial_lov(plan_id, depen1, value, l_lov_sql);
3235:
3236: ELSIF (char_id = qa_ss_const.service_request) THEN
3237: get_service_request_lov(value, l_lov_sql);
3238:
3239: ELSIF (char_id = qa_ss_const.maintenance_requirement) THEN
3240: get_maintenance_req_lov(value, l_lov_sql);

Line 3239: ELSIF (char_id = qa_ss_const.maintenance_requirement) THEN

3235:
3236: ELSIF (char_id = qa_ss_const.service_request) THEN
3237: get_service_request_lov(value, l_lov_sql);
3238:
3239: ELSIF (char_id = qa_ss_const.maintenance_requirement) THEN
3240: get_maintenance_req_lov(value, l_lov_sql);
3241:
3242: ELSIF (char_id = qa_ss_const.rework_job) THEN
3243: get_rework_job_lov(org_id, value, l_lov_sql);

Line 3242: ELSIF (char_id = qa_ss_const.rework_job) THEN

3238:
3239: ELSIF (char_id = qa_ss_const.maintenance_requirement) THEN
3240: get_maintenance_req_lov(value, l_lov_sql);
3241:
3242: ELSIF (char_id = qa_ss_const.rework_job) THEN
3243: get_rework_job_lov(org_id, value, l_lov_sql);
3244:
3245: ELSIF (char_id = qa_ss_const.counter_name) THEN
3246: get_counter_name_lov(value, l_lov_sql);

Line 3245: ELSIF (char_id = qa_ss_const.counter_name) THEN

3241:
3242: ELSIF (char_id = qa_ss_const.rework_job) THEN
3243: get_rework_job_lov(org_id, value, l_lov_sql);
3244:
3245: ELSIF (char_id = qa_ss_const.counter_name) THEN
3246: get_counter_name_lov(value, l_lov_sql);
3247:
3248: -- anagarwa Mon Feb 2 16:27:56 PST 2004
3249: -- Bug 3415693

Line 3258: ELSIF (char_id = qa_ss_const.disposition_source) THEN

3254: -- to appear on selfservice
3255: -- For maintenance sake we should remove corresponding get lov functions
3256: -- too as they serve no purpose other than making this file bulkier.
3257: /*
3258: ELSIF (char_id = qa_ss_const.disposition_source) THEN
3259: get_disposition_source_lov(value, l_lov_sql);
3260:
3261: ELSIF (char_id = qa_ss_const.disposition_action) THEN
3262: get_disposition_action_lov(value, l_lov_sql);

Line 3261: ELSIF (char_id = qa_ss_const.disposition_action) THEN

3257: /*
3258: ELSIF (char_id = qa_ss_const.disposition_source) THEN
3259: get_disposition_source_lov(value, l_lov_sql);
3260:
3261: ELSIF (char_id = qa_ss_const.disposition_action) THEN
3262: get_disposition_action_lov(value, l_lov_sql);
3263:
3264: ELSIF (char_id = qa_ss_const.disposition) THEN
3265: get_disposition_lov(value, l_lov_sql);

Line 3264: ELSIF (char_id = qa_ss_const.disposition) THEN

3260:
3261: ELSIF (char_id = qa_ss_const.disposition_action) THEN
3262: get_disposition_action_lov(value, l_lov_sql);
3263:
3264: ELSIF (char_id = qa_ss_const.disposition) THEN
3265: get_disposition_lov(value, l_lov_sql);
3266:
3267: ELSIF (char_id = qa_ss_const.disposition_status) THEN
3268: get_disposition_status_lov(value, l_lov_sql);

Line 3267: ELSIF (char_id = qa_ss_const.disposition_status) THEN

3263:
3264: ELSIF (char_id = qa_ss_const.disposition) THEN
3265: get_disposition_lov(value, l_lov_sql);
3266:
3267: ELSIF (char_id = qa_ss_const.disposition_status) THEN
3268: get_disposition_status_lov(value, l_lov_sql);
3269:
3270: */
3271: --

Line 3277: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN

3273: -- To support the element Maintenance Op Seq Number
3274: -- to be used along with Maintenance Workorder
3275: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
3276: --
3277: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN
3278: -- get_maintenance_op_seq_lov(org_id, value, depen1, l_lov_sql);
3279: get_maintenance_op_seq_lov(plan_id, org_id, value, depen1, l_lov_sql);
3280: --
3281: -- End of inclusions for Bug 2588213

Line 3288: ELSIF (char_id = qa_ss_const.bill_reference) THEN

3284: -- Start of inclusions for NCM Hardcode Elements.
3285: -- suramasw Thu Oct 31 10:48:59 PST 2002.
3286: -- Bug 2449067.
3287:
3288: ELSIF (char_id = qa_ss_const.bill_reference) THEN
3289: get_bill_reference_lov(org_id, value, l_lov_sql);
3290:
3291: ELSIF (char_id = qa_ss_const.routing_reference) THEN
3292: get_routing_reference_lov(org_id, value, l_lov_sql);

Line 3291: ELSIF (char_id = qa_ss_const.routing_reference) THEN

3287:
3288: ELSIF (char_id = qa_ss_const.bill_reference) THEN
3289: get_bill_reference_lov(org_id, value, l_lov_sql);
3290:
3291: ELSIF (char_id = qa_ss_const.routing_reference) THEN
3292: get_routing_reference_lov(org_id, value, l_lov_sql);
3293:
3294: ELSIF (char_id = qa_ss_const.to_subinventory) THEN
3295: get_to_subinventory_lov(org_id, value, l_lov_sql);

Line 3294: ELSIF (char_id = qa_ss_const.to_subinventory) THEN

3290:
3291: ELSIF (char_id = qa_ss_const.routing_reference) THEN
3292: get_routing_reference_lov(org_id, value, l_lov_sql);
3293:
3294: ELSIF (char_id = qa_ss_const.to_subinventory) THEN
3295: get_to_subinventory_lov(org_id, value, l_lov_sql);
3296:
3297: ELSIF (char_id = qa_ss_const.to_locator) THEN
3298: -- get_to_locator_lov(org_id, depen1, value, l_lov_sql);

Line 3297: ELSIF (char_id = qa_ss_const.to_locator) THEN

3293:
3294: ELSIF (char_id = qa_ss_const.to_subinventory) THEN
3295: get_to_subinventory_lov(org_id, value, l_lov_sql);
3296:
3297: ELSIF (char_id = qa_ss_const.to_locator) THEN
3298: -- get_to_locator_lov(org_id, depen1, value, l_lov_sql);
3299: get_to_locator_lov(plan_id, org_id, depen1, value, l_lov_sql);
3300:
3301: ELSIF (char_id = qa_ss_const.lot_status) THEN

Line 3301: ELSIF (char_id = qa_ss_const.lot_status) THEN

3297: ELSIF (char_id = qa_ss_const.to_locator) THEN
3298: -- get_to_locator_lov(org_id, depen1, value, l_lov_sql);
3299: get_to_locator_lov(plan_id, org_id, depen1, value, l_lov_sql);
3300:
3301: ELSIF (char_id = qa_ss_const.lot_status) THEN
3302: get_lot_status_lov(value, l_lov_sql);
3303:
3304: ELSIF (char_id = qa_ss_const.serial_status) THEN
3305: -- Bug 7588754. Added additional bind parameters

Line 3304: ELSIF (char_id = qa_ss_const.serial_status) THEN

3300:
3301: ELSIF (char_id = qa_ss_const.lot_status) THEN
3302: get_lot_status_lov(value, l_lov_sql);
3303:
3304: ELSIF (char_id = qa_ss_const.serial_status) THEN
3305: -- Bug 7588754. Added additional bind parameters
3306: -- pdube Wed Apr 15 07:37:25 PDT 2009
3307: -- get_serial_status_lov(value, l_lov_sql);
3308: get_serial_status_lov(value,depen1,depen2, l_lov_sql);

Line 3310: ELSIF (char_id = qa_ss_const.nonconformance_source) THEN

3306: -- pdube Wed Apr 15 07:37:25 PDT 2009
3307: -- get_serial_status_lov(value, l_lov_sql);
3308: get_serial_status_lov(value,depen1,depen2, l_lov_sql);
3309:
3310: ELSIF (char_id = qa_ss_const.nonconformance_source) THEN
3311: get_nonconformance_source_lov(value, l_lov_sql);
3312:
3313: ELSIF (char_id = qa_ss_const.nonconform_severity) THEN
3314: get_nonconform_severity_lov(value, l_lov_sql);

Line 3313: ELSIF (char_id = qa_ss_const.nonconform_severity) THEN

3309:
3310: ELSIF (char_id = qa_ss_const.nonconformance_source) THEN
3311: get_nonconformance_source_lov(value, l_lov_sql);
3312:
3313: ELSIF (char_id = qa_ss_const.nonconform_severity) THEN
3314: get_nonconform_severity_lov(value, l_lov_sql);
3315:
3316: ELSIF (char_id = qa_ss_const.nonconform_priority) THEN
3317: get_nonconform_priority_lov(value, l_lov_sql);

Line 3316: ELSIF (char_id = qa_ss_const.nonconform_priority) THEN

3312:
3313: ELSIF (char_id = qa_ss_const.nonconform_severity) THEN
3314: get_nonconform_severity_lov(value, l_lov_sql);
3315:
3316: ELSIF (char_id = qa_ss_const.nonconform_priority) THEN
3317: get_nonconform_priority_lov(value, l_lov_sql);
3318:
3319: ELSIF (char_id = qa_ss_const.nonconformance_type) THEN
3320: get_nonconformance_type_lov(value, l_lov_sql);

Line 3319: ELSIF (char_id = qa_ss_const.nonconformance_type) THEN

3315:
3316: ELSIF (char_id = qa_ss_const.nonconform_priority) THEN
3317: get_nonconform_priority_lov(value, l_lov_sql);
3318:
3319: ELSIF (char_id = qa_ss_const.nonconformance_type) THEN
3320: get_nonconformance_type_lov(value, l_lov_sql);
3321:
3322: ELSIF (char_id = qa_ss_const.nonconformance_status) THEN
3323: get_nonconformance_status_lov(value, l_lov_sql);

Line 3322: ELSIF (char_id = qa_ss_const.nonconformance_status) THEN

3318:
3319: ELSIF (char_id = qa_ss_const.nonconformance_type) THEN
3320: get_nonconformance_type_lov(value, l_lov_sql);
3321:
3322: ELSIF (char_id = qa_ss_const.nonconformance_status) THEN
3323: get_nonconformance_status_lov(value, l_lov_sql);
3324:
3325: --anagarwa Wed Jan 15 13:51:41 PST 2003
3326: -- Bug 2751198

Line 3330: ELSIF (char_id = qa_ss_const.contract_number) THEN

3326: -- Bug 2751198
3327: -- support needed for contract number, contract line number and
3328: -- deliverable number
3329:
3330: ELSIF (char_id = qa_ss_const.contract_number) THEN
3331: get_contract_lov(value, l_lov_sql);
3332:
3333: ELSIF (char_id = qa_ss_const.contract_line_number) THEN
3334: get_contract_line_lov(value, l_lov_sql);

Line 3333: ELSIF (char_id = qa_ss_const.contract_line_number) THEN

3329:
3330: ELSIF (char_id = qa_ss_const.contract_number) THEN
3331: get_contract_lov(value, l_lov_sql);
3332:
3333: ELSIF (char_id = qa_ss_const.contract_line_number) THEN
3334: get_contract_line_lov(value, l_lov_sql);
3335:
3336: ELSIF (char_id = qa_ss_const.deliverable_number) THEN
3337: get_deliverable_lov(value, l_lov_sql);

Line 3336: ELSIF (char_id = qa_ss_const.deliverable_number) THEN

3332:
3333: ELSIF (char_id = qa_ss_const.contract_line_number) THEN
3334: get_contract_line_lov(value, l_lov_sql);
3335:
3336: ELSIF (char_id = qa_ss_const.deliverable_number) THEN
3337: get_deliverable_lov(value, l_lov_sql);
3338:
3339: -- End of inclusions for NCM Hardcode Elements.
3340:

Line 3344: ELSIF (char_id = qa_ss_const.request_source) THEN

3340:
3341: --anagarwa Fri Nov 15 13:03:35 PST 2002
3342: --Following added for new CAR lov's
3343:
3344: ELSIF (char_id = qa_ss_const.request_source) THEN
3345: get_request_source_lov(value, l_lov_sql);
3346:
3347: ELSIF (char_id = qa_ss_const.request_priority) THEN
3348: get_request_priority_lov(value, l_lov_sql);

Line 3347: ELSIF (char_id = qa_ss_const.request_priority) THEN

3343:
3344: ELSIF (char_id = qa_ss_const.request_source) THEN
3345: get_request_source_lov(value, l_lov_sql);
3346:
3347: ELSIF (char_id = qa_ss_const.request_priority) THEN
3348: get_request_priority_lov(value, l_lov_sql);
3349:
3350: ELSIF (char_id = qa_ss_const.request_severity) THEN
3351: get_request_severity_lov(value, l_lov_sql);

Line 3350: ELSIF (char_id = qa_ss_const.request_severity) THEN

3346:
3347: ELSIF (char_id = qa_ss_const.request_priority) THEN
3348: get_request_priority_lov(value, l_lov_sql);
3349:
3350: ELSIF (char_id = qa_ss_const.request_severity) THEN
3351: get_request_severity_lov(value, l_lov_sql);
3352:
3353: ELSIF (char_id = qa_ss_const.request_status) THEN
3354: get_request_status_lov(value, l_lov_sql);

Line 3353: ELSIF (char_id = qa_ss_const.request_status) THEN

3349:
3350: ELSIF (char_id = qa_ss_const.request_severity) THEN
3351: get_request_severity_lov(value, l_lov_sql);
3352:
3353: ELSIF (char_id = qa_ss_const.request_status) THEN
3354: get_request_status_lov(value, l_lov_sql);
3355:
3356: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
3357: -- bug 3830258 incorrect LOVs in QWB

Line 3360: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN

3356: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
3357: -- bug 3830258 incorrect LOVs in QWB
3358: -- synced up the component lot number and component serial number
3359: -- lov with forms
3360: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
3361: get_comp_lot_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
3362:
3363: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3364: get_comp_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);

Line 3363: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN

3359: -- lov with forms
3360: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
3361: get_comp_lot_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
3362:
3363: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3364: get_comp_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);
3365:
3366: -- End of inclusions for CAR Hardcode Elements.
3367: /* R12 DR Integration. Bug 4345489 Start */

Line 3368: ELSIF (char_id = qa_ss_const.repair_order_number) THEN

3364: get_comp_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);
3365:
3366: -- End of inclusions for CAR Hardcode Elements.
3367: /* R12 DR Integration. Bug 4345489 Start */
3368: ELSIF (char_id = qa_ss_const.repair_order_number) THEN
3369: get_repair_order_lov(value, l_lov_sql);
3370:
3371: ELSIF (char_id = qa_ss_const.jtf_task_number) THEN
3372: get_jtf_task_lov(value, l_lov_sql);

Line 3371: ELSIF (char_id = qa_ss_const.jtf_task_number) THEN

3367: /* R12 DR Integration. Bug 4345489 Start */
3368: ELSIF (char_id = qa_ss_const.repair_order_number) THEN
3369: get_repair_order_lov(value, l_lov_sql);
3370:
3371: ELSIF (char_id = qa_ss_const.jtf_task_number) THEN
3372: get_jtf_task_lov(value, l_lov_sql);
3373: /* R12 DR Integration. Bug 4345489 End */
3374:
3375: -- R12 OPM Deviations. Bug 4345503 Start

Line 3376: ELSIF (char_id = qa_ss_const.process_batch_num) THEN

3372: get_jtf_task_lov(value, l_lov_sql);
3373: /* R12 DR Integration. Bug 4345489 End */
3374:
3375: -- R12 OPM Deviations. Bug 4345503 Start
3376: ELSIF (char_id = qa_ss_const.process_batch_num) THEN
3377: get_process_batch_num_lov(org_id,value,l_lov_sql);
3378:
3379: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3380: get_process_batchstep_num_lov

Line 3379: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN

3375: -- R12 OPM Deviations. Bug 4345503 Start
3376: ELSIF (char_id = qa_ss_const.process_batch_num) THEN
3377: get_process_batch_num_lov(org_id,value,l_lov_sql);
3378:
3379: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3380: get_process_batchstep_num_lov
3381: (org_id,plan_id,depen1,value, l_lov_sql);
3382:
3383: ELSIF (char_id = qa_ss_const.process_operation) THEN

Line 3383: ELSIF (char_id = qa_ss_const.process_operation) THEN

3379: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3380: get_process_batchstep_num_lov
3381: (org_id,plan_id,depen1,value, l_lov_sql);
3382:
3383: ELSIF (char_id = qa_ss_const.process_operation) THEN
3384: get_process_operation_lov
3385: (org_id,plan_id,depen1, depen2,value, l_lov_sql);
3386:
3387: ELSIF (char_id = qa_ss_const.process_activity) THEN

Line 3387: ELSIF (char_id = qa_ss_const.process_activity) THEN

3383: ELSIF (char_id = qa_ss_const.process_operation) THEN
3384: get_process_operation_lov
3385: (org_id,plan_id,depen1, depen2,value, l_lov_sql);
3386:
3387: ELSIF (char_id = qa_ss_const.process_activity) THEN
3388: get_process_activity_lov
3389: (org_id,plan_id,depen1, depen2,value, l_lov_sql);
3390:
3391: ELSIF (char_id = qa_ss_const.process_resource) THEN

Line 3391: ELSIF (char_id = qa_ss_const.process_resource) THEN

3387: ELSIF (char_id = qa_ss_const.process_activity) THEN
3388: get_process_activity_lov
3389: (org_id,plan_id,depen1, depen2,value, l_lov_sql);
3390:
3391: ELSIF (char_id = qa_ss_const.process_resource) THEN
3392: get_process_resource_lov
3393: (org_id,plan_id,depen1, depen2, depen3, value, l_lov_sql);
3394:
3395: ELSIF (char_id = qa_ss_const.process_parameter) THEN

Line 3395: ELSIF (char_id = qa_ss_const.process_parameter) THEN

3391: ELSIF (char_id = qa_ss_const.process_resource) THEN
3392: get_process_resource_lov
3393: (org_id,plan_id,depen1, depen2, depen3, value, l_lov_sql);
3394:
3395: ELSIF (char_id = qa_ss_const.process_parameter) THEN
3396: get_process_parameter_lov
3397: (org_id,plan_id,depen1, value, l_lov_sql);
3398:
3399: -- R12 OPM Deviations. Bug 4345503 End

Line 3406: ELSIF (char_id = qa_ss_const.rma_line_num) THEN

3402: -- Bug 6161802
3403: -- Obtain rma line number lov with rma number as a bind variable.
3404: -- skolluku Mon Jul 16 22:08:16 PDT 2007
3405: --
3406: ELSIF (char_id = qa_ss_const.rma_line_num) THEN
3407: get_rma_line_num_lov(plan_id, depen1, value, l_lov_sql);
3408:
3409: ELSE
3410: get_plan_element_lov (plan_id, char_id, org_id, user_id, l_lov_sql);

Line 3442: IF char_id IN ( qa_ss_const.department,

3438: -- Commented out item, because a new method to fetch its bind values
3439: -- been created.
3440: -- skolluku
3441: --
3442: IF char_id IN ( qa_ss_const.department,
3443: qa_ss_const.job_name,
3444: qa_ss_const.work_order,
3445: qa_ss_const.production_line,
3446: qa_ss_const.resource_code,

Line 3443: qa_ss_const.job_name,

3439: -- been created.
3440: -- skolluku
3441: --
3442: IF char_id IN ( qa_ss_const.department,
3443: qa_ss_const.job_name,
3444: qa_ss_const.work_order,
3445: qa_ss_const.production_line,
3446: qa_ss_const.resource_code,
3447: -- qa_ss_const.uom,

Line 3444: qa_ss_const.work_order,

3440: -- skolluku
3441: --
3442: IF char_id IN ( qa_ss_const.department,
3443: qa_ss_const.job_name,
3444: qa_ss_const.work_order,
3445: qa_ss_const.production_line,
3446: qa_ss_const.resource_code,
3447: -- qa_ss_const.uom,
3448: qa_ss_const.subinventory,

Line 3445: qa_ss_const.production_line,

3441: --
3442: IF char_id IN ( qa_ss_const.department,
3443: qa_ss_const.job_name,
3444: qa_ss_const.work_order,
3445: qa_ss_const.production_line,
3446: qa_ss_const.resource_code,
3447: -- qa_ss_const.uom,
3448: qa_ss_const.subinventory,
3449: -- qa_ss_const.item,

Line 3446: qa_ss_const.resource_code,

3442: IF char_id IN ( qa_ss_const.department,
3443: qa_ss_const.job_name,
3444: qa_ss_const.work_order,
3445: qa_ss_const.production_line,
3446: qa_ss_const.resource_code,
3447: -- qa_ss_const.uom,
3448: qa_ss_const.subinventory,
3449: -- qa_ss_const.item,
3450: qa_ss_const.asset_group,

Line 3447: -- qa_ss_const.uom,

3443: qa_ss_const.job_name,
3444: qa_ss_const.work_order,
3445: qa_ss_const.production_line,
3446: qa_ss_const.resource_code,
3447: -- qa_ss_const.uom,
3448: qa_ss_const.subinventory,
3449: -- qa_ss_const.item,
3450: qa_ss_const.asset_group,
3451: qa_ss_const.rework_job,

Line 3448: qa_ss_const.subinventory,

3444: qa_ss_const.work_order,
3445: qa_ss_const.production_line,
3446: qa_ss_const.resource_code,
3447: -- qa_ss_const.uom,
3448: qa_ss_const.subinventory,
3449: -- qa_ss_const.item,
3450: qa_ss_const.asset_group,
3451: qa_ss_const.rework_job,
3452: qa_ss_const.bill_reference,

Line 3449: -- qa_ss_const.item,

3445: qa_ss_const.production_line,
3446: qa_ss_const.resource_code,
3447: -- qa_ss_const.uom,
3448: qa_ss_const.subinventory,
3449: -- qa_ss_const.item,
3450: qa_ss_const.asset_group,
3451: qa_ss_const.rework_job,
3452: qa_ss_const.bill_reference,
3453: qa_ss_const.routing_reference,

Line 3450: qa_ss_const.asset_group,

3446: qa_ss_const.resource_code,
3447: -- qa_ss_const.uom,
3448: qa_ss_const.subinventory,
3449: -- qa_ss_const.item,
3450: qa_ss_const.asset_group,
3451: qa_ss_const.rework_job,
3452: qa_ss_const.bill_reference,
3453: qa_ss_const.routing_reference,
3454: -- R12 OPM Deviations. Bug 4345503 Start

Line 3451: qa_ss_const.rework_job,

3447: -- qa_ss_const.uom,
3448: qa_ss_const.subinventory,
3449: -- qa_ss_const.item,
3450: qa_ss_const.asset_group,
3451: qa_ss_const.rework_job,
3452: qa_ss_const.bill_reference,
3453: qa_ss_const.routing_reference,
3454: -- R12 OPM Deviations. Bug 4345503 Start
3455: qa_ss_const.process_batch_num,

Line 3452: qa_ss_const.bill_reference,

3448: qa_ss_const.subinventory,
3449: -- qa_ss_const.item,
3450: qa_ss_const.asset_group,
3451: qa_ss_const.rework_job,
3452: qa_ss_const.bill_reference,
3453: qa_ss_const.routing_reference,
3454: -- R12 OPM Deviations. Bug 4345503 Start
3455: qa_ss_const.process_batch_num,
3456: -- R12 OPM Deviations. Bug 4345503 End

Line 3453: qa_ss_const.routing_reference,

3449: -- qa_ss_const.item,
3450: qa_ss_const.asset_group,
3451: qa_ss_const.rework_job,
3452: qa_ss_const.bill_reference,
3453: qa_ss_const.routing_reference,
3454: -- R12 OPM Deviations. Bug 4345503 Start
3455: qa_ss_const.process_batch_num,
3456: -- R12 OPM Deviations. Bug 4345503 End
3457: qa_ss_const.to_subinventory ) THEN

Line 3455: qa_ss_const.process_batch_num,

3451: qa_ss_const.rework_job,
3452: qa_ss_const.bill_reference,
3453: qa_ss_const.routing_reference,
3454: -- R12 OPM Deviations. Bug 4345503 Start
3455: qa_ss_const.process_batch_num,
3456: -- R12 OPM Deviations. Bug 4345503 End
3457: qa_ss_const.to_subinventory ) THEN
3458:
3459: RETURN to_char(org_id);

Line 3457: qa_ss_const.to_subinventory ) THEN

3453: qa_ss_const.routing_reference,
3454: -- R12 OPM Deviations. Bug 4345503 Start
3455: qa_ss_const.process_batch_num,
3456: -- R12 OPM Deviations. Bug 4345503 End
3457: qa_ss_const.to_subinventory ) THEN
3458:
3459: RETURN to_char(org_id);
3460:
3461: END IF;

Line 3465: IF char_id IN ( qa_ss_const.nonconformance_source,

3461: END IF;
3462:
3463: -- Collection elements based on QA_LOOKUPS.
3464:
3465: IF char_id IN ( qa_ss_const.nonconformance_source,
3466: qa_ss_const.nonconform_severity,
3467: qa_ss_const.nonconform_priority,
3468: qa_ss_const.nonconformance_status,
3469: qa_ss_const.nonconformance_type,

Line 3466: qa_ss_const.nonconform_severity,

3462:
3463: -- Collection elements based on QA_LOOKUPS.
3464:
3465: IF char_id IN ( qa_ss_const.nonconformance_source,
3466: qa_ss_const.nonconform_severity,
3467: qa_ss_const.nonconform_priority,
3468: qa_ss_const.nonconformance_status,
3469: qa_ss_const.nonconformance_type,
3470: qa_ss_const.request_source,

Line 3467: qa_ss_const.nonconform_priority,

3463: -- Collection elements based on QA_LOOKUPS.
3464:
3465: IF char_id IN ( qa_ss_const.nonconformance_source,
3466: qa_ss_const.nonconform_severity,
3467: qa_ss_const.nonconform_priority,
3468: qa_ss_const.nonconformance_status,
3469: qa_ss_const.nonconformance_type,
3470: qa_ss_const.request_source,
3471: qa_ss_const.request_priority,

Line 3468: qa_ss_const.nonconformance_status,

3464:
3465: IF char_id IN ( qa_ss_const.nonconformance_source,
3466: qa_ss_const.nonconform_severity,
3467: qa_ss_const.nonconform_priority,
3468: qa_ss_const.nonconformance_status,
3469: qa_ss_const.nonconformance_type,
3470: qa_ss_const.request_source,
3471: qa_ss_const.request_priority,
3472: qa_ss_const.request_severity,

Line 3469: qa_ss_const.nonconformance_type,

3465: IF char_id IN ( qa_ss_const.nonconformance_source,
3466: qa_ss_const.nonconform_severity,
3467: qa_ss_const.nonconform_priority,
3468: qa_ss_const.nonconformance_status,
3469: qa_ss_const.nonconformance_type,
3470: qa_ss_const.request_source,
3471: qa_ss_const.request_priority,
3472: qa_ss_const.request_severity,
3473: qa_ss_const.request_status ) THEN

Line 3470: qa_ss_const.request_source,

3466: qa_ss_const.nonconform_severity,
3467: qa_ss_const.nonconform_priority,
3468: qa_ss_const.nonconformance_status,
3469: qa_ss_const.nonconformance_type,
3470: qa_ss_const.request_source,
3471: qa_ss_const.request_priority,
3472: qa_ss_const.request_severity,
3473: qa_ss_const.request_status ) THEN
3474:

Line 3471: qa_ss_const.request_priority,

3467: qa_ss_const.nonconform_priority,
3468: qa_ss_const.nonconformance_status,
3469: qa_ss_const.nonconformance_type,
3470: qa_ss_const.request_source,
3471: qa_ss_const.request_priority,
3472: qa_ss_const.request_severity,
3473: qa_ss_const.request_status ) THEN
3474:
3475: RETURN to_char(char_id);

Line 3472: qa_ss_const.request_severity,

3468: qa_ss_const.nonconformance_status,
3469: qa_ss_const.nonconformance_type,
3470: qa_ss_const.request_source,
3471: qa_ss_const.request_priority,
3472: qa_ss_const.request_severity,
3473: qa_ss_const.request_status ) THEN
3474:
3475: RETURN to_char(char_id);
3476:

Line 3473: qa_ss_const.request_status ) THEN

3469: qa_ss_const.nonconformance_type,
3470: qa_ss_const.request_source,
3471: qa_ss_const.request_priority,
3472: qa_ss_const.request_severity,
3473: qa_ss_const.request_status ) THEN
3474:
3475: RETURN to_char(char_id);
3476:
3477: END IF;

Line 3481: IF char_id = qa_ss_const.task_number THEN

3477: END IF;
3478:
3479: -- Other dependent elements.
3480:
3481: IF char_id = qa_ss_const.task_number THEN
3482: RETURN get_task_number_bind_values(depen1);
3483:
3484: ELSIF (char_id = qa_ss_const.revision OR
3485: char_id = qa_ss_const.comp_revision) THEN

Line 3484: ELSIF (char_id = qa_ss_const.revision OR

3480:
3481: IF char_id = qa_ss_const.task_number THEN
3482: RETURN get_task_number_bind_values(depen1);
3483:
3484: ELSIF (char_id = qa_ss_const.revision OR
3485: char_id = qa_ss_const.comp_revision) THEN
3486: RETURN get_revision_bind_values(org_id, depen1);
3487:
3488: -- Bug 5005707. Adding item as a filtering criteria

Line 3485: char_id = qa_ss_const.comp_revision) THEN

3481: IF char_id = qa_ss_const.task_number THEN
3482: RETURN get_task_number_bind_values(depen1);
3483:
3484: ELSIF (char_id = qa_ss_const.revision OR
3485: char_id = qa_ss_const.comp_revision) THEN
3486: RETURN get_revision_bind_values(org_id, depen1);
3487:
3488: -- Bug 5005707. Adding item as a filtering criteria
3489: -- for item uom to improve performance.

Line 3492: ELSIF (char_id = qa_ss_const.uom) THEN

3488: -- Bug 5005707. Adding item as a filtering criteria
3489: -- for item uom to improve performance.
3490: -- Removed the same from the above if condition
3491: -- saugupta Mon, 10 Jul 2006 21:47:17 -0700 PDT
3492: ELSIF (char_id = qa_ss_const.uom) THEN
3493: RETURN get_uom_bind_values(p_org_id => org_id, p_item_name => depen1);
3494:
3495: ELSIF (char_id = qa_ss_const.lot_number) THEN
3496: RETURN get_lot_number_bind_values(org_id, depen1);

Line 3495: ELSIF (char_id = qa_ss_const.lot_number) THEN

3491: -- saugupta Mon, 10 Jul 2006 21:47:17 -0700 PDT
3492: ELSIF (char_id = qa_ss_const.uom) THEN
3493: RETURN get_uom_bind_values(p_org_id => org_id, p_item_name => depen1);
3494:
3495: ELSIF (char_id = qa_ss_const.lot_number) THEN
3496: RETURN get_lot_number_bind_values(org_id, depen1);
3497:
3498: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
3499: RETURN get_comp_lot_bind_values(org_id, depen1);

Line 3498: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN

3494:
3495: ELSIF (char_id = qa_ss_const.lot_number) THEN
3496: RETURN get_lot_number_bind_values(org_id, depen1);
3497:
3498: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
3499: RETURN get_comp_lot_bind_values(org_id, depen1);
3500:
3501: ELSIF (char_id = qa_ss_const.serial_number) THEN
3502: RETURN get_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);

Line 3501: ELSIF (char_id = qa_ss_const.serial_number) THEN

3497:
3498: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
3499: RETURN get_comp_lot_bind_values(org_id, depen1);
3500:
3501: ELSIF (char_id = qa_ss_const.serial_number) THEN
3502: RETURN get_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);
3503:
3504: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3505: RETURN get_comp_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);

Line 3504: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN

3500:
3501: ELSIF (char_id = qa_ss_const.serial_number) THEN
3502: RETURN get_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);
3503:
3504: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3505: RETURN get_comp_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);
3506:
3507: -- dgupta: Start R12 EAM Integration. Bug 4345492
3508: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN

Line 3508: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN

3504: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3505: RETURN get_comp_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);
3506:
3507: -- dgupta: Start R12 EAM Integration. Bug 4345492
3508: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN
3509: RETURN get_asset_inst_num_bind_values(org_id, depen1, depen2);
3510:
3511: ELSIF (char_id = qa_ss_const.asset_number) THEN
3512: RETURN get_asset_number_bind_values(org_id, depen1, depen2);

Line 3511: ELSIF (char_id = qa_ss_const.asset_number) THEN

3507: -- dgupta: Start R12 EAM Integration. Bug 4345492
3508: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN
3509: RETURN get_asset_inst_num_bind_values(org_id, depen1, depen2);
3510:
3511: ELSIF (char_id = qa_ss_const.asset_number) THEN
3512: RETURN get_asset_number_bind_values(org_id, depen1, depen2);
3513: --dgupta: End R12 EAM Integration. Bug 4345492
3514:
3515: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR

Line 3515: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR

3511: ELSIF (char_id = qa_ss_const.asset_number) THEN
3512: RETURN get_asset_number_bind_values(org_id, depen1, depen2);
3513: --dgupta: End R12 EAM Integration. Bug 4345492
3514:
3515: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
3516: (char_id = qa_ss_const.to_op_seq_num) THEN
3517: RETURN get_op_seq_no_bind_values(plan_id, org_id, depen1, depen2);
3518:
3519: ELSIF (char_id = qa_ss_const.po_line_num) THEN

Line 3516: (char_id = qa_ss_const.to_op_seq_num) THEN

3512: RETURN get_asset_number_bind_values(org_id, depen1, depen2);
3513: --dgupta: End R12 EAM Integration. Bug 4345492
3514:
3515: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
3516: (char_id = qa_ss_const.to_op_seq_num) THEN
3517: RETURN get_op_seq_no_bind_values(plan_id, org_id, depen1, depen2);
3518:
3519: ELSIF (char_id = qa_ss_const.po_line_num) THEN
3520: RETURN get_po_line_no_bind_values(depen1);

Line 3519: ELSIF (char_id = qa_ss_const.po_line_num) THEN

3515: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
3516: (char_id = qa_ss_const.to_op_seq_num) THEN
3517: RETURN get_op_seq_no_bind_values(plan_id, org_id, depen1, depen2);
3518:
3519: ELSIF (char_id = qa_ss_const.po_line_num) THEN
3520: RETURN get_po_line_no_bind_values(depen1);
3521:
3522: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN
3523: -- Bug 9817478. If PO Release Num is present, use the new proc.

Line 3522: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN

3518:
3519: ELSIF (char_id = qa_ss_const.po_line_num) THEN
3520: RETURN get_po_line_no_bind_values(depen1);
3521:
3522: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN
3523: -- Bug 9817478. If PO Release Num is present, use the new proc.
3524: -- Else use the existing.
3525: IF (depen3 IS NOT NULL) THEN
3526: RETURN get_po_shipments_bind_values (depen1, depen2, depen3);

Line 3530: ELSIF (char_id = qa_ss_const.comp_item) THEN

3526: RETURN get_po_shipments_bind_values (depen1, depen2, depen3);
3527: ELSE
3528: RETURN get_po_shipments_bind_values (depen1, depen2);
3529: END IF;
3530: ELSIF (char_id = qa_ss_const.comp_item) THEN
3531: RETURN get_comp_item_bind_values (org_id, depen1);
3532:
3533: -- dgupta: Start R12 EAM Integration. Bug 4345492
3534: ELSIF (char_id = qa_ss_const.asset_activity) THEN

Line 3534: ELSIF (char_id = qa_ss_const.asset_activity) THEN

3530: ELSIF (char_id = qa_ss_const.comp_item) THEN
3531: RETURN get_comp_item_bind_values (org_id, depen1);
3532:
3533: -- dgupta: Start R12 EAM Integration. Bug 4345492
3534: ELSIF (char_id = qa_ss_const.asset_activity) THEN
3535: RETURN get_asset_activity_bind_values (org_id, depen1, depen2, depen3);
3536:
3537: ELSIF (char_id = qa_ss_const.followup_activity) THEN
3538: RETURN get_followup_act_bind_values(org_id, depen1, depen2, depen3);

Line 3537: ELSIF (char_id = qa_ss_const.followup_activity) THEN

3533: -- dgupta: Start R12 EAM Integration. Bug 4345492
3534: ELSIF (char_id = qa_ss_const.asset_activity) THEN
3535: RETURN get_asset_activity_bind_values (org_id, depen1, depen2, depen3);
3536:
3537: ELSIF (char_id = qa_ss_const.followup_activity) THEN
3538: RETURN get_followup_act_bind_values(org_id, depen1, depen2, depen3);
3539: --dgupta: End R12 EAM Integration. Bug 4345492
3540:
3541: ELSIF (char_id = qa_ss_const.locator) OR

Line 3541: ELSIF (char_id = qa_ss_const.locator) OR

3537: ELSIF (char_id = qa_ss_const.followup_activity) THEN
3538: RETURN get_followup_act_bind_values(org_id, depen1, depen2, depen3);
3539: --dgupta: End R12 EAM Integration. Bug 4345492
3540:
3541: ELSIF (char_id = qa_ss_const.locator) OR
3542: (char_id = qa_ss_const.to_locator) THEN
3543: RETURN get_locator_bind_values(org_id, depen1);
3544:
3545: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN

Line 3542: (char_id = qa_ss_const.to_locator) THEN

3538: RETURN get_followup_act_bind_values(org_id, depen1, depen2, depen3);
3539: --dgupta: End R12 EAM Integration. Bug 4345492
3540:
3541: ELSIF (char_id = qa_ss_const.locator) OR
3542: (char_id = qa_ss_const.to_locator) THEN
3543: RETURN get_locator_bind_values(org_id, depen1);
3544:
3545: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN
3546: RETURN get_maint_op_seq_bind_values(org_id, depen1);

Line 3545: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN

3541: ELSIF (char_id = qa_ss_const.locator) OR
3542: (char_id = qa_ss_const.to_locator) THEN
3543: RETURN get_locator_bind_values(org_id, depen1);
3544:
3545: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN
3546: RETURN get_maint_op_seq_bind_values(org_id, depen1);
3547:
3548: -- R12 OPM Deviations. Bug 4345503 Start
3549: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN

Line 3549: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN

3545: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN
3546: RETURN get_maint_op_seq_bind_values(org_id, depen1);
3547:
3548: -- R12 OPM Deviations. Bug 4345503 Start
3549: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3550: RETURN GET_PROCESS_STEP_BIND_VALUE(org_id, depen1);
3551:
3552: ELSIF (char_id = qa_ss_const.process_operation) THEN
3553: RETURN GET_PROCESS_OPRN_BIND_VALUE(org_id, depen1, depen2);

Line 3552: ELSIF (char_id = qa_ss_const.process_operation) THEN

3548: -- R12 OPM Deviations. Bug 4345503 Start
3549: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3550: RETURN GET_PROCESS_STEP_BIND_VALUE(org_id, depen1);
3551:
3552: ELSIF (char_id = qa_ss_const.process_operation) THEN
3553: RETURN GET_PROCESS_OPRN_BIND_VALUE(org_id, depen1, depen2);
3554:
3555: ELSIF (char_id = qa_ss_const.process_activity) THEN
3556: RETURN GET_PROCESS_ACT_BIND_VALUE(org_id, depen1, depen2);

Line 3555: ELSIF (char_id = qa_ss_const.process_activity) THEN

3551:
3552: ELSIF (char_id = qa_ss_const.process_operation) THEN
3553: RETURN GET_PROCESS_OPRN_BIND_VALUE(org_id, depen1, depen2);
3554:
3555: ELSIF (char_id = qa_ss_const.process_activity) THEN
3556: RETURN GET_PROCESS_ACT_BIND_VALUE(org_id, depen1, depen2);
3557:
3558: ELSIF (char_id = qa_ss_const.process_resource) THEN
3559: RETURN GET_PROCESS_RSR_BIND_VALUE(org_id, depen1, depen2, depen3);

Line 3558: ELSIF (char_id = qa_ss_const.process_resource) THEN

3554:
3555: ELSIF (char_id = qa_ss_const.process_activity) THEN
3556: RETURN GET_PROCESS_ACT_BIND_VALUE(org_id, depen1, depen2);
3557:
3558: ELSIF (char_id = qa_ss_const.process_resource) THEN
3559: RETURN GET_PROCESS_RSR_BIND_VALUE(org_id, depen1, depen2, depen3);
3560:
3561: ELSIF (char_id = qa_ss_const.process_parameter) THEN
3562: RETURN GET_PROCESS_PARAM_BIND_VALUE(org_id, depen1);

Line 3561: ELSIF (char_id = qa_ss_const.process_parameter) THEN

3557:
3558: ELSIF (char_id = qa_ss_const.process_resource) THEN
3559: RETURN GET_PROCESS_RSR_BIND_VALUE(org_id, depen1, depen2, depen3);
3560:
3561: ELSIF (char_id = qa_ss_const.process_parameter) THEN
3562: RETURN GET_PROCESS_PARAM_BIND_VALUE(org_id, depen1);
3563: -- R12 OPM Deviations. Bug 4345503 End
3564:
3565: ELSIF (char_id = qa_ss_const.po_release_num) THEN

Line 3565: ELSIF (char_id = qa_ss_const.po_release_num) THEN

3561: ELSIF (char_id = qa_ss_const.process_parameter) THEN
3562: RETURN GET_PROCESS_PARAM_BIND_VALUE(org_id, depen1);
3563: -- R12 OPM Deviations. Bug 4345503 End
3564:
3565: ELSIF (char_id = qa_ss_const.po_release_num) THEN
3566: --
3567: -- Bug 5003511. R12 Performance bug. SQLID: 15008630
3568: -- Release number is dependent on PO Number.
3569: -- Call new method for bind values.

Line 3580: ELSIF (char_id = qa_ss_const.rma_line_num) THEN

3576: -- Bug 6161802
3577: -- Return rma number as a bind variable for rma line number lov
3578: -- skolluku Mon Jul 16 22:08:16 PDT 2007
3579: --
3580: ELSIF (char_id = qa_ss_const.rma_line_num) THEN
3581: RETURN get_rma_line_num_bind_values(depen1);
3582:
3583: -- Bug 7716875.Return SO Number as bind variable for
3584: -- SO Line Number.pdube Mon Apr 13 03:25:19 PDT 2009

Line 3585: ELSIF (char_id = qa_ss_const.order_line) THEN

3581: RETURN get_rma_line_num_bind_values(depen1);
3582:
3583: -- Bug 7716875.Return SO Number as bind variable for
3584: -- SO Line Number.pdube Mon Apr 13 03:25:19 PDT 2009
3585: ELSIF (char_id = qa_ss_const.order_line) THEN
3586: RETURN get_so_line_num_bind_values(depen1);
3587:
3588: -- Bug 7588754.Added org_id,item and srl number as binds
3589: ELSIF (char_id = qa_ss_const.serial_status) THEN

Line 3589: ELSIF (char_id = qa_ss_const.serial_status) THEN

3585: ELSIF (char_id = qa_ss_const.order_line) THEN
3586: RETURN get_so_line_num_bind_values(depen1);
3587:
3588: -- Bug 7588754.Added org_id,item and srl number as binds
3589: ELSIF (char_id = qa_ss_const.serial_status) THEN
3590: RETURN get_serial_status_bind_values(org_id,depen1,depen2);
3591: --
3592: -- bug 7197055
3593: -- Fetch bind values for item.

Line 3596: ELSIF (char_id = qa_ss_const.item) THEN

3592: -- bug 7197055
3593: -- Fetch bind values for item.
3594: -- skolluku
3595: --
3596: ELSIF (char_id = qa_ss_const.item) THEN
3597: RETURN get_item_bind_values(org_id,depen1);
3598: --
3599: -- Bug 9032151
3600: -- Return item as a bind variable for item instance lov

Line 3603: ELSIF (char_id = qa_ss_const.item_instance) THEN

3599: -- Bug 9032151
3600: -- Return item as a bind variable for item instance lov
3601: -- skolluku
3602: --
3603: ELSIF (char_id = qa_ss_const.item_instance) THEN
3604: RETURN get_item_instance_bind_values(org_id, depen1);
3605: --
3606: -- Bug 9359442
3607: -- Return item as a bind variable for item instance serial lov

Line 3610: ELSIF (char_id = qa_ss_const.item_instance_serial) THEN

3606: -- Bug 9359442
3607: -- Return item as a bind variable for item instance serial lov
3608: -- skolluku
3609: --
3610: ELSIF (char_id = qa_ss_const.item_instance_serial) THEN
3611: RETURN get_item_inst_ser_bind_values(org_id, depen1);
3612: ELSE
3613:
3614: -- Will handle qa_plan_char_value_lookups.