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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2733: -- we should clear stack so that errors are not shown over and over again.
2734: fnd_msg_pub.Initialize();
2735: fnd_msg_pub.reset();
2736:
2737: IF (char_id = qa_ss_const.department) THEN
2738: get_department_lov(org_id, value, l_lov_sql);
2739:
2740: ELSIF (char_id = qa_ss_const.job_name) THEN
2741: get_job_lov(org_id, value, l_lov_sql);

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

2736:
2737: IF (char_id = qa_ss_const.department) THEN
2738: get_department_lov(org_id, value, l_lov_sql);
2739:
2740: ELSIF (char_id = qa_ss_const.job_name) THEN
2741: get_job_lov(org_id, value, l_lov_sql);
2742:
2743: ELSIF (char_id = qa_ss_const.work_order) THEN
2744: get_work_order_lov(org_id, value, l_lov_sql);

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

2739:
2740: ELSIF (char_id = qa_ss_const.job_name) THEN
2741: get_job_lov(org_id, value, l_lov_sql);
2742:
2743: ELSIF (char_id = qa_ss_const.work_order) THEN
2744: get_work_order_lov(org_id, value, l_lov_sql);
2745:
2746: ELSIF (char_id = qa_ss_const.production_line) THEN
2747: get_production_lov(org_id, value, l_lov_sql);

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

2742:
2743: ELSIF (char_id = qa_ss_const.work_order) THEN
2744: get_work_order_lov(org_id, value, l_lov_sql);
2745:
2746: ELSIF (char_id = qa_ss_const.production_line) THEN
2747: get_production_lov(org_id, value, l_lov_sql);
2748:
2749: ELSIF (char_id = qa_ss_const.resource_code) THEN
2750: get_resource_code_lov(org_id, value, l_lov_sql);

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

2745:
2746: ELSIF (char_id = qa_ss_const.production_line) THEN
2747: get_production_lov(org_id, value, l_lov_sql);
2748:
2749: ELSIF (char_id = qa_ss_const.resource_code) THEN
2750: get_resource_code_lov(org_id, value, l_lov_sql);
2751:
2752: ELSIF (char_id = qa_ss_const.vendor_name) THEN
2753: get_supplier_lov(value, l_lov_sql);

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

2748:
2749: ELSIF (char_id = qa_ss_const.resource_code) THEN
2750: get_resource_code_lov(org_id, value, l_lov_sql);
2751:
2752: ELSIF (char_id = qa_ss_const.vendor_name) THEN
2753: get_supplier_lov(value, l_lov_sql);
2754:
2755: ELSIF (char_id = qa_ss_const.po_number) THEN
2756: get_po_number_lov(value, l_lov_sql);

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

2751:
2752: ELSIF (char_id = qa_ss_const.vendor_name) THEN
2753: get_supplier_lov(value, l_lov_sql);
2754:
2755: ELSIF (char_id = qa_ss_const.po_number) THEN
2756: get_po_number_lov(value, l_lov_sql);
2757:
2758: ELSIF (char_id = qa_ss_const.customer_name) THEN
2759: get_customer_lov(value, l_lov_sql);

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

2754:
2755: ELSIF (char_id = qa_ss_const.po_number) THEN
2756: get_po_number_lov(value, l_lov_sql);
2757:
2758: ELSIF (char_id = qa_ss_const.customer_name) THEN
2759: get_customer_lov(value, l_lov_sql);
2760:
2761: ELSIF (char_id = qa_ss_const.sales_order) THEN
2762: get_so_number_lov(value, l_lov_sql);

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

2757:
2758: ELSIF (char_id = qa_ss_const.customer_name) THEN
2759: get_customer_lov(value, l_lov_sql);
2760:
2761: ELSIF (char_id = qa_ss_const.sales_order) THEN
2762: get_so_number_lov(value, l_lov_sql);
2763:
2764: ELSIF (char_id = qa_ss_const.order_line) THEN
2765: get_so_line_number_lov(value, l_lov_sql);

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

2760:
2761: ELSIF (char_id = qa_ss_const.sales_order) THEN
2762: get_so_number_lov(value, l_lov_sql);
2763:
2764: ELSIF (char_id = qa_ss_const.order_line) THEN
2765: get_so_line_number_lov(value, l_lov_sql);
2766:
2767: ELSIF (char_id = qa_ss_const.po_release_num) THEN
2768: --

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

2763:
2764: ELSIF (char_id = qa_ss_const.order_line) THEN
2765: get_so_line_number_lov(value, l_lov_sql);
2766:
2767: ELSIF (char_id = qa_ss_const.po_release_num) THEN
2768: --
2769: -- Bug 5003511. R12 Performance bug. SQLID: 15008630
2770: -- Release number is dependent on PO Number.
2771: -- Call new overloaded method.

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

2772: -- srhariha. Wed Feb 8 02:10:26 PST 2006.
2773: --
2774: get_po_release_number_lov(plan_id,depen1,value, l_lov_sql);
2775:
2776: ELSIF (char_id = qa_ss_const.project_number) THEN
2777: get_project_number_lov(value, l_lov_sql);
2778:
2779: ELSIF (char_id = qa_ss_const.task_number) THEN
2780: -- anagarwa Thu Jan 29 15:04:26 PST 2004

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

2775:
2776: ELSIF (char_id = qa_ss_const.project_number) THEN
2777: get_project_number_lov(value, l_lov_sql);
2778:
2779: ELSIF (char_id = qa_ss_const.task_number) THEN
2780: -- anagarwa Thu Jan 29 15:04:26 PST 2004
2781: -- Bug 3404863 : task lov should be dependent upon project so now we
2782: -- pass project number as parent element value.
2783: get_task_number_lov(plan_id, depen1, value, l_lov_sql);

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

2781: -- Bug 3404863 : task lov should be dependent upon project so now we
2782: -- pass project number as parent element value.
2783: get_task_number_lov(plan_id, depen1, value, l_lov_sql);
2784:
2785: ELSIF (char_id = qa_ss_const.rma_number) THEN
2786: get_rma_number_lov(value, l_lov_sql);
2787:
2788: ELSIF (char_id = qa_ss_const.uom) THEN
2789: -- get_uom_lov(org_id, item_name, value, l_lov_sql);

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

2784:
2785: ELSIF (char_id = qa_ss_const.rma_number) THEN
2786: get_rma_number_lov(value, l_lov_sql);
2787:
2788: ELSIF (char_id = qa_ss_const.uom) THEN
2789: -- get_uom_lov(org_id, item_name, value, l_lov_sql);
2790: get_uom_lov(plan_id, org_id, depen1, value, l_lov_sql);
2791:
2792: -- anagarwa Mon Feb 24 17:08:57 PST 2003

Line 2795: ELSIF (char_id = qa_ss_const.revision OR

2791:
2792: -- anagarwa Mon Feb 24 17:08:57 PST 2003
2793: -- Bug 2808693
2794: -- adding support for comp_revision
2795: ELSIF (char_id = qa_ss_const.revision OR
2796: char_id = qa_ss_const.comp_revision) THEN
2797: -- get_revision_lov(org_id, item_name, value, l_lov_sql);
2798: get_revision_lov(plan_id, org_id, depen1, value, l_lov_sql);
2799:

Line 2796: char_id = qa_ss_const.comp_revision) THEN

2792: -- anagarwa Mon Feb 24 17:08:57 PST 2003
2793: -- Bug 2808693
2794: -- adding support for comp_revision
2795: ELSIF (char_id = qa_ss_const.revision OR
2796: char_id = qa_ss_const.comp_revision) THEN
2797: -- get_revision_lov(org_id, item_name, value, l_lov_sql);
2798: get_revision_lov(plan_id, org_id, depen1, value, l_lov_sql);
2799:
2800: ELSIF (char_id = qa_ss_const.subinventory) THEN

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

2796: char_id = qa_ss_const.comp_revision) THEN
2797: -- get_revision_lov(org_id, item_name, value, l_lov_sql);
2798: get_revision_lov(plan_id, org_id, depen1, value, l_lov_sql);
2799:
2800: ELSIF (char_id = qa_ss_const.subinventory) THEN
2801: get_subinventory_lov(org_id, value, l_lov_sql);
2802:
2803: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
2804: -- bug 3830258 incorrect LOVs in QWB

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

2802:
2803: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
2804: -- bug 3830258 incorrect LOVs in QWB
2805: -- synced up the lot and serial number lov with forms
2806: ELSIF (char_id = qa_ss_const.lot_number) THEN
2807: -- get_lot_number_lov(transaction_id, value, l_lov_sql);
2808: -- get_lot_number_lov(depen3, value, l_lov_sql);
2809: get_lot_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
2810:

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

2807: -- get_lot_number_lov(transaction_id, value, l_lov_sql);
2808: -- get_lot_number_lov(depen3, value, l_lov_sql);
2809: get_lot_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
2810:
2811: ELSIF (char_id = qa_ss_const.serial_number) THEN
2812: -- get_serial_number_lov(transaction_id, lot_number, value, l_lov_sql);
2813: -- get_serial_number_lov(plan_id, depen3, depen1, value, l_lov_sql);
2814: get_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);
2815:

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

2813: -- get_serial_number_lov(plan_id, depen3, depen1, value, l_lov_sql);
2814: get_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);
2815:
2816: -- dgupta: Start R12 EAM Integration. Bug 4345492
2817: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN
2818: get_asset_instance_number_lov(plan_id, org_id, depen1,depen2,value, l_lov_sql);
2819: --dgupta: End R12 EAM Integration. Bug 4345492
2820:
2821: ELSIF (char_id = qa_ss_const.asset_number) THEN

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

2817: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN
2818: get_asset_instance_number_lov(plan_id, org_id, depen1,depen2,value, l_lov_sql);
2819: --dgupta: End R12 EAM Integration. Bug 4345492
2820:
2821: ELSIF (char_id = qa_ss_const.asset_number) THEN
2822: -- get_asset_number_lov(org_id, depen1, value, l_lov_sql);
2823: get_asset_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
2824:
2825: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR

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

2821: ELSIF (char_id = qa_ss_const.asset_number) THEN
2822: -- get_asset_number_lov(org_id, depen1, value, l_lov_sql);
2823: get_asset_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
2824:
2825: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
2826: (char_id = qa_ss_const.to_op_seq_num) THEN
2827: -- get_op_seq_number_lov(org_id, value, job_name, production_line,
2828: -- l_lov_sql);
2829: get_op_seq_number_lov(plan_id, org_id, value, depen1, depen2, l_lov_sql);

Line 2826: (char_id = qa_ss_const.to_op_seq_num) THEN

2822: -- get_asset_number_lov(org_id, depen1, value, l_lov_sql);
2823: get_asset_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
2824:
2825: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
2826: (char_id = qa_ss_const.to_op_seq_num) THEN
2827: -- get_op_seq_number_lov(org_id, value, job_name, production_line,
2828: -- l_lov_sql);
2829: get_op_seq_number_lov(plan_id, org_id, value, depen1, depen2, l_lov_sql);
2830:

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

2827: -- get_op_seq_number_lov(org_id, value, job_name, production_line,
2828: -- l_lov_sql);
2829: get_op_seq_number_lov(plan_id, org_id, value, depen1, depen2, l_lov_sql);
2830:
2831: ELSIF (char_id = qa_ss_const.po_line_num) THEN
2832: -- get_po_line_number_lov(po_number, value, l_lov_sql);
2833: get_po_line_number_lov(plan_id, depen1, value, l_lov_sql);
2834:
2835: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN

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

2831: ELSIF (char_id = qa_ss_const.po_line_num) THEN
2832: -- get_po_line_number_lov(po_number, value, l_lov_sql);
2833: get_po_line_number_lov(plan_id, depen1, value, l_lov_sql);
2834:
2835: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN
2836: -- get_po_shipments_lov(po_line_number, po_number, value, l_lov_sql);
2837: get_po_shipments_lov(plan_id, depen1, depen2, value, l_lov_sql);
2838:
2839: ELSIF (char_id = qa_ss_const.receipt_num) THEN

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

2835: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN
2836: -- get_po_shipments_lov(po_line_number, po_number, value, l_lov_sql);
2837: get_po_shipments_lov(plan_id, depen1, depen2, value, l_lov_sql);
2838:
2839: ELSIF (char_id = qa_ss_const.receipt_num) THEN
2840: get_receipt_num_lov(value, l_lov_sql);
2841:
2842: ELSIF (char_id = qa_ss_const.item) THEN
2843: get_item_lov(org_id, value, l_lov_sql);

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

2838:
2839: ELSIF (char_id = qa_ss_const.receipt_num) THEN
2840: get_receipt_num_lov(value, l_lov_sql);
2841:
2842: ELSIF (char_id = qa_ss_const.item) THEN
2843: get_item_lov(org_id, value, l_lov_sql);
2844:
2845: -- rkaza. 12/15/2003. bug 3280307. Added lov for comp item
2846: ELSIF (char_id = qa_ss_const.comp_item) THEN

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

2842: ELSIF (char_id = qa_ss_const.item) THEN
2843: get_item_lov(org_id, value, l_lov_sql);
2844:
2845: -- rkaza. 12/15/2003. bug 3280307. Added lov for comp item
2846: ELSIF (char_id = qa_ss_const.comp_item) THEN
2847: get_comp_item_lov(plan_id, org_id, depen1, value, l_lov_sql);
2848:
2849: ELSIF (char_id = qa_ss_const.asset_group) THEN
2850: get_asset_group_lov(org_id, value, l_lov_sql);

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

2845: -- rkaza. 12/15/2003. bug 3280307. Added lov for comp item
2846: ELSIF (char_id = qa_ss_const.comp_item) THEN
2847: get_comp_item_lov(plan_id, org_id, depen1, value, l_lov_sql);
2848:
2849: ELSIF (char_id = qa_ss_const.asset_group) THEN
2850: get_asset_group_lov(org_id, value, l_lov_sql);
2851:
2852: ELSIF (char_id = qa_ss_const.asset_activity) THEN
2853: -- get_asset_activity_lov(org_id, depen1, depen2, value, l_lov_sql);

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

2848:
2849: ELSIF (char_id = qa_ss_const.asset_group) THEN
2850: get_asset_group_lov(org_id, value, l_lov_sql);
2851:
2852: ELSIF (char_id = qa_ss_const.asset_activity) THEN
2853: -- get_asset_activity_lov(org_id, depen1, depen2, value, l_lov_sql);
2854: get_asset_activity_lov(plan_id, org_id, depen1, depen2, value, l_lov_sql);
2855:
2856: -- added the following to include new hardcoded element followup activity

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

2855:
2856: -- added the following to include new hardcoded element followup activity
2857: -- saugupta
2858:
2859: ELSIF (char_id = qa_ss_const.followup_activity) THEN
2860: -- get_followup_activity_lov(org_id, depen1, depen2, value, l_lov_sql);
2861: get_followup_activity_lov(plan_id, org_id, depen1, depen2, value, l_lov_sql);
2862:
2863: ELSIF (char_id = qa_ss_const.xfr_license_plate_number) THEN

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

2859: ELSIF (char_id = qa_ss_const.followup_activity) THEN
2860: -- get_followup_activity_lov(org_id, depen1, depen2, value, l_lov_sql);
2861: get_followup_activity_lov(plan_id, org_id, depen1, depen2, value, l_lov_sql);
2862:
2863: ELSIF (char_id = qa_ss_const.xfr_license_plate_number) THEN
2864: get_xfr_lpn_lov(value, l_lov_sql);
2865:
2866: ELSIF (char_id = qa_ss_const.locator) THEN
2867: -- get_locator_lov(org_id, depen1, value, l_lov_sql);

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

2862:
2863: ELSIF (char_id = qa_ss_const.xfr_license_plate_number) THEN
2864: get_xfr_lpn_lov(value, l_lov_sql);
2865:
2866: ELSIF (char_id = qa_ss_const.locator) THEN
2867: -- get_locator_lov(org_id, depen1, value, l_lov_sql);
2868: get_locator_lov(plan_id, org_id, depen1, value, l_lov_sql);
2869:
2870: ELSIF (char_id = qa_ss_const.party_name) THEN

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

2866: ELSIF (char_id = qa_ss_const.locator) THEN
2867: -- get_locator_lov(org_id, depen1, value, l_lov_sql);
2868: get_locator_lov(plan_id, org_id, depen1, value, l_lov_sql);
2869:
2870: ELSIF (char_id = qa_ss_const.party_name) THEN
2871: get_party_lov(value, l_lov_sql);
2872:
2873: ELSIF (char_id = qa_ss_const.item_instance) THEN
2874: get_item_instance_lov(value, l_lov_sql);

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

2869:
2870: ELSIF (char_id = qa_ss_const.party_name) THEN
2871: get_party_lov(value, l_lov_sql);
2872:
2873: ELSIF (char_id = qa_ss_const.item_instance) THEN
2874: get_item_instance_lov(value, l_lov_sql);
2875:
2876: ELSIF (char_id = qa_ss_const.service_request) THEN
2877: get_service_request_lov(value, l_lov_sql);

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

2872:
2873: ELSIF (char_id = qa_ss_const.item_instance) THEN
2874: get_item_instance_lov(value, l_lov_sql);
2875:
2876: ELSIF (char_id = qa_ss_const.service_request) THEN
2877: get_service_request_lov(value, l_lov_sql);
2878:
2879: ELSIF (char_id = qa_ss_const.maintenance_requirement) THEN
2880: get_maintenance_req_lov(value, l_lov_sql);

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

2875:
2876: ELSIF (char_id = qa_ss_const.service_request) THEN
2877: get_service_request_lov(value, l_lov_sql);
2878:
2879: ELSIF (char_id = qa_ss_const.maintenance_requirement) THEN
2880: get_maintenance_req_lov(value, l_lov_sql);
2881:
2882: ELSIF (char_id = qa_ss_const.rework_job) THEN
2883: get_rework_job_lov(org_id, value, l_lov_sql);

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

2878:
2879: ELSIF (char_id = qa_ss_const.maintenance_requirement) THEN
2880: get_maintenance_req_lov(value, l_lov_sql);
2881:
2882: ELSIF (char_id = qa_ss_const.rework_job) THEN
2883: get_rework_job_lov(org_id, value, l_lov_sql);
2884:
2885: ELSIF (char_id = qa_ss_const.counter_name) THEN
2886: get_counter_name_lov(value, l_lov_sql);

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

2881:
2882: ELSIF (char_id = qa_ss_const.rework_job) THEN
2883: get_rework_job_lov(org_id, value, l_lov_sql);
2884:
2885: ELSIF (char_id = qa_ss_const.counter_name) THEN
2886: get_counter_name_lov(value, l_lov_sql);
2887:
2888: -- anagarwa Mon Feb 2 16:27:56 PST 2004
2889: -- Bug 3415693

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

2894: -- to appear on selfservice
2895: -- For maintenance sake we should remove corresponding get lov functions
2896: -- too as they serve no purpose other than making this file bulkier.
2897: /*
2898: ELSIF (char_id = qa_ss_const.disposition_source) THEN
2899: get_disposition_source_lov(value, l_lov_sql);
2900:
2901: ELSIF (char_id = qa_ss_const.disposition_action) THEN
2902: get_disposition_action_lov(value, l_lov_sql);

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

2897: /*
2898: ELSIF (char_id = qa_ss_const.disposition_source) THEN
2899: get_disposition_source_lov(value, l_lov_sql);
2900:
2901: ELSIF (char_id = qa_ss_const.disposition_action) THEN
2902: get_disposition_action_lov(value, l_lov_sql);
2903:
2904: ELSIF (char_id = qa_ss_const.disposition) THEN
2905: get_disposition_lov(value, l_lov_sql);

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

2900:
2901: ELSIF (char_id = qa_ss_const.disposition_action) THEN
2902: get_disposition_action_lov(value, l_lov_sql);
2903:
2904: ELSIF (char_id = qa_ss_const.disposition) THEN
2905: get_disposition_lov(value, l_lov_sql);
2906:
2907: ELSIF (char_id = qa_ss_const.disposition_status) THEN
2908: get_disposition_status_lov(value, l_lov_sql);

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

2903:
2904: ELSIF (char_id = qa_ss_const.disposition) THEN
2905: get_disposition_lov(value, l_lov_sql);
2906:
2907: ELSIF (char_id = qa_ss_const.disposition_status) THEN
2908: get_disposition_status_lov(value, l_lov_sql);
2909:
2910: */
2911: --

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

2913: -- To support the element Maintenance Op Seq Number
2914: -- to be used along with Maintenance Workorder
2915: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
2916: --
2917: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN
2918: -- get_maintenance_op_seq_lov(org_id, value, depen1, l_lov_sql);
2919: get_maintenance_op_seq_lov(plan_id, org_id, value, depen1, l_lov_sql);
2920: --
2921: -- End of inclusions for Bug 2588213

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

2924: -- Start of inclusions for NCM Hardcode Elements.
2925: -- suramasw Thu Oct 31 10:48:59 PST 2002.
2926: -- Bug 2449067.
2927:
2928: ELSIF (char_id = qa_ss_const.bill_reference) THEN
2929: get_bill_reference_lov(org_id, value, l_lov_sql);
2930:
2931: ELSIF (char_id = qa_ss_const.routing_reference) THEN
2932: get_routing_reference_lov(org_id, value, l_lov_sql);

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

2927:
2928: ELSIF (char_id = qa_ss_const.bill_reference) THEN
2929: get_bill_reference_lov(org_id, value, l_lov_sql);
2930:
2931: ELSIF (char_id = qa_ss_const.routing_reference) THEN
2932: get_routing_reference_lov(org_id, value, l_lov_sql);
2933:
2934: ELSIF (char_id = qa_ss_const.to_subinventory) THEN
2935: get_to_subinventory_lov(org_id, value, l_lov_sql);

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

2930:
2931: ELSIF (char_id = qa_ss_const.routing_reference) THEN
2932: get_routing_reference_lov(org_id, value, l_lov_sql);
2933:
2934: ELSIF (char_id = qa_ss_const.to_subinventory) THEN
2935: get_to_subinventory_lov(org_id, value, l_lov_sql);
2936:
2937: ELSIF (char_id = qa_ss_const.to_locator) THEN
2938: -- get_to_locator_lov(org_id, depen1, value, l_lov_sql);

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

2933:
2934: ELSIF (char_id = qa_ss_const.to_subinventory) THEN
2935: get_to_subinventory_lov(org_id, value, l_lov_sql);
2936:
2937: ELSIF (char_id = qa_ss_const.to_locator) THEN
2938: -- get_to_locator_lov(org_id, depen1, value, l_lov_sql);
2939: get_to_locator_lov(plan_id, org_id, depen1, value, l_lov_sql);
2940:
2941: ELSIF (char_id = qa_ss_const.lot_status) THEN

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

2937: ELSIF (char_id = qa_ss_const.to_locator) THEN
2938: -- get_to_locator_lov(org_id, depen1, value, l_lov_sql);
2939: get_to_locator_lov(plan_id, org_id, depen1, value, l_lov_sql);
2940:
2941: ELSIF (char_id = qa_ss_const.lot_status) THEN
2942: get_lot_status_lov(value, l_lov_sql);
2943:
2944: ELSIF (char_id = qa_ss_const.serial_status) THEN
2945: get_serial_status_lov(value, l_lov_sql);

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

2940:
2941: ELSIF (char_id = qa_ss_const.lot_status) THEN
2942: get_lot_status_lov(value, l_lov_sql);
2943:
2944: ELSIF (char_id = qa_ss_const.serial_status) THEN
2945: get_serial_status_lov(value, l_lov_sql);
2946:
2947: ELSIF (char_id = qa_ss_const.nonconformance_source) THEN
2948: get_nonconformance_source_lov(value, l_lov_sql);

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

2943:
2944: ELSIF (char_id = qa_ss_const.serial_status) THEN
2945: get_serial_status_lov(value, l_lov_sql);
2946:
2947: ELSIF (char_id = qa_ss_const.nonconformance_source) THEN
2948: get_nonconformance_source_lov(value, l_lov_sql);
2949:
2950: ELSIF (char_id = qa_ss_const.nonconform_severity) THEN
2951: get_nonconform_severity_lov(value, l_lov_sql);

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

2946:
2947: ELSIF (char_id = qa_ss_const.nonconformance_source) THEN
2948: get_nonconformance_source_lov(value, l_lov_sql);
2949:
2950: ELSIF (char_id = qa_ss_const.nonconform_severity) THEN
2951: get_nonconform_severity_lov(value, l_lov_sql);
2952:
2953: ELSIF (char_id = qa_ss_const.nonconform_priority) THEN
2954: get_nonconform_priority_lov(value, l_lov_sql);

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

2949:
2950: ELSIF (char_id = qa_ss_const.nonconform_severity) THEN
2951: get_nonconform_severity_lov(value, l_lov_sql);
2952:
2953: ELSIF (char_id = qa_ss_const.nonconform_priority) THEN
2954: get_nonconform_priority_lov(value, l_lov_sql);
2955:
2956: ELSIF (char_id = qa_ss_const.nonconformance_type) THEN
2957: get_nonconformance_type_lov(value, l_lov_sql);

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

2952:
2953: ELSIF (char_id = qa_ss_const.nonconform_priority) THEN
2954: get_nonconform_priority_lov(value, l_lov_sql);
2955:
2956: ELSIF (char_id = qa_ss_const.nonconformance_type) THEN
2957: get_nonconformance_type_lov(value, l_lov_sql);
2958:
2959: ELSIF (char_id = qa_ss_const.nonconformance_status) THEN
2960: get_nonconformance_status_lov(value, l_lov_sql);

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

2955:
2956: ELSIF (char_id = qa_ss_const.nonconformance_type) THEN
2957: get_nonconformance_type_lov(value, l_lov_sql);
2958:
2959: ELSIF (char_id = qa_ss_const.nonconformance_status) THEN
2960: get_nonconformance_status_lov(value, l_lov_sql);
2961:
2962: --anagarwa Wed Jan 15 13:51:41 PST 2003
2963: -- Bug 2751198

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

2963: -- Bug 2751198
2964: -- support needed for contract number, contract line number and
2965: -- deliverable number
2966:
2967: ELSIF (char_id = qa_ss_const.contract_number) THEN
2968: get_contract_lov(value, l_lov_sql);
2969:
2970: ELSIF (char_id = qa_ss_const.contract_line_number) THEN
2971: get_contract_line_lov(value, l_lov_sql);

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

2966:
2967: ELSIF (char_id = qa_ss_const.contract_number) THEN
2968: get_contract_lov(value, l_lov_sql);
2969:
2970: ELSIF (char_id = qa_ss_const.contract_line_number) THEN
2971: get_contract_line_lov(value, l_lov_sql);
2972:
2973: ELSIF (char_id = qa_ss_const.deliverable_number) THEN
2974: get_deliverable_lov(value, l_lov_sql);

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

2969:
2970: ELSIF (char_id = qa_ss_const.contract_line_number) THEN
2971: get_contract_line_lov(value, l_lov_sql);
2972:
2973: ELSIF (char_id = qa_ss_const.deliverable_number) THEN
2974: get_deliverable_lov(value, l_lov_sql);
2975:
2976: -- End of inclusions for NCM Hardcode Elements.
2977:

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

2977:
2978: --anagarwa Fri Nov 15 13:03:35 PST 2002
2979: --Following added for new CAR lov's
2980:
2981: ELSIF (char_id = qa_ss_const.request_source) THEN
2982: get_request_source_lov(value, l_lov_sql);
2983:
2984: ELSIF (char_id = qa_ss_const.request_priority) THEN
2985: get_request_priority_lov(value, l_lov_sql);

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

2980:
2981: ELSIF (char_id = qa_ss_const.request_source) THEN
2982: get_request_source_lov(value, l_lov_sql);
2983:
2984: ELSIF (char_id = qa_ss_const.request_priority) THEN
2985: get_request_priority_lov(value, l_lov_sql);
2986:
2987: ELSIF (char_id = qa_ss_const.request_severity) THEN
2988: get_request_severity_lov(value, l_lov_sql);

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

2983:
2984: ELSIF (char_id = qa_ss_const.request_priority) THEN
2985: get_request_priority_lov(value, l_lov_sql);
2986:
2987: ELSIF (char_id = qa_ss_const.request_severity) THEN
2988: get_request_severity_lov(value, l_lov_sql);
2989:
2990: ELSIF (char_id = qa_ss_const.request_status) THEN
2991: get_request_status_lov(value, l_lov_sql);

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

2986:
2987: ELSIF (char_id = qa_ss_const.request_severity) THEN
2988: get_request_severity_lov(value, l_lov_sql);
2989:
2990: ELSIF (char_id = qa_ss_const.request_status) THEN
2991: get_request_status_lov(value, l_lov_sql);
2992:
2993: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
2994: -- bug 3830258 incorrect LOVs in QWB

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

2993: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
2994: -- bug 3830258 incorrect LOVs in QWB
2995: -- synced up the component lot number and component serial number
2996: -- lov with forms
2997: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
2998: get_comp_lot_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
2999:
3000: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3001: get_comp_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);

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

2996: -- lov with forms
2997: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
2998: get_comp_lot_number_lov(plan_id, org_id, depen1, value, l_lov_sql);
2999:
3000: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3001: get_comp_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);
3002:
3003: -- End of inclusions for CAR Hardcode Elements.
3004: /* R12 DR Integration. Bug 4345489 Start */

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

3001: get_comp_serial_number_lov(plan_id, org_id, depen2, depen3, depen1, value, l_lov_sql);
3002:
3003: -- End of inclusions for CAR Hardcode Elements.
3004: /* R12 DR Integration. Bug 4345489 Start */
3005: ELSIF (char_id = qa_ss_const.repair_order_number) THEN
3006: get_repair_order_lov(value, l_lov_sql);
3007:
3008: ELSIF (char_id = qa_ss_const.jtf_task_number) THEN
3009: get_jtf_task_lov(value, l_lov_sql);

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

3004: /* R12 DR Integration. Bug 4345489 Start */
3005: ELSIF (char_id = qa_ss_const.repair_order_number) THEN
3006: get_repair_order_lov(value, l_lov_sql);
3007:
3008: ELSIF (char_id = qa_ss_const.jtf_task_number) THEN
3009: get_jtf_task_lov(value, l_lov_sql);
3010: /* R12 DR Integration. Bug 4345489 End */
3011:
3012: -- R12 OPM Deviations. Bug 4345503 Start

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

3009: get_jtf_task_lov(value, l_lov_sql);
3010: /* R12 DR Integration. Bug 4345489 End */
3011:
3012: -- R12 OPM Deviations. Bug 4345503 Start
3013: ELSIF (char_id = qa_ss_const.process_batch_num) THEN
3014: get_process_batch_num_lov(org_id,value,l_lov_sql);
3015:
3016: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3017: get_process_batchstep_num_lov

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

3012: -- R12 OPM Deviations. Bug 4345503 Start
3013: ELSIF (char_id = qa_ss_const.process_batch_num) THEN
3014: get_process_batch_num_lov(org_id,value,l_lov_sql);
3015:
3016: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3017: get_process_batchstep_num_lov
3018: (org_id,plan_id,depen1,value, l_lov_sql);
3019:
3020: ELSIF (char_id = qa_ss_const.process_operation) THEN

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

3016: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3017: get_process_batchstep_num_lov
3018: (org_id,plan_id,depen1,value, l_lov_sql);
3019:
3020: ELSIF (char_id = qa_ss_const.process_operation) THEN
3021: get_process_operation_lov
3022: (org_id,plan_id,depen1, depen2,value, l_lov_sql);
3023:
3024: ELSIF (char_id = qa_ss_const.process_activity) THEN

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

3020: ELSIF (char_id = qa_ss_const.process_operation) THEN
3021: get_process_operation_lov
3022: (org_id,plan_id,depen1, depen2,value, l_lov_sql);
3023:
3024: ELSIF (char_id = qa_ss_const.process_activity) THEN
3025: get_process_activity_lov
3026: (org_id,plan_id,depen1, depen2,value, l_lov_sql);
3027:
3028: ELSIF (char_id = qa_ss_const.process_resource) THEN

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

3024: ELSIF (char_id = qa_ss_const.process_activity) THEN
3025: get_process_activity_lov
3026: (org_id,plan_id,depen1, depen2,value, l_lov_sql);
3027:
3028: ELSIF (char_id = qa_ss_const.process_resource) THEN
3029: get_process_resource_lov
3030: (org_id,plan_id,depen1, depen2, depen3, value, l_lov_sql);
3031:
3032: ELSIF (char_id = qa_ss_const.process_parameter) THEN

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

3028: ELSIF (char_id = qa_ss_const.process_resource) THEN
3029: get_process_resource_lov
3030: (org_id,plan_id,depen1, depen2, depen3, value, l_lov_sql);
3031:
3032: ELSIF (char_id = qa_ss_const.process_parameter) THEN
3033: get_process_parameter_lov
3034: (org_id,plan_id,depen1, value, l_lov_sql);
3035:
3036: -- R12 OPM Deviations. Bug 4345503 End

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

3039: -- Bug 6161802
3040: -- Obtain rma line number lov with rma number as a bind variable.
3041: -- skolluku Mon Jul 16 22:08:16 PDT 2007
3042: --
3043: ELSIF (char_id = qa_ss_const.rma_line_num) THEN
3044: get_rma_line_num_lov(plan_id, depen1, value, l_lov_sql);
3045:
3046: ELSE
3047: get_plan_element_lov (plan_id, char_id, org_id, user_id, l_lov_sql);

Line 3074: IF char_id IN ( qa_ss_const.department,

3070:
3071:
3072: -- Collection elements dependent only on ORG_ID.
3073:
3074: IF char_id IN ( qa_ss_const.department,
3075: qa_ss_const.job_name,
3076: qa_ss_const.work_order,
3077: qa_ss_const.production_line,
3078: qa_ss_const.resource_code,

Line 3075: qa_ss_const.job_name,

3071:
3072: -- Collection elements dependent only on ORG_ID.
3073:
3074: IF char_id IN ( qa_ss_const.department,
3075: qa_ss_const.job_name,
3076: qa_ss_const.work_order,
3077: qa_ss_const.production_line,
3078: qa_ss_const.resource_code,
3079: -- qa_ss_const.uom,

Line 3076: qa_ss_const.work_order,

3072: -- Collection elements dependent only on ORG_ID.
3073:
3074: IF char_id IN ( qa_ss_const.department,
3075: qa_ss_const.job_name,
3076: qa_ss_const.work_order,
3077: qa_ss_const.production_line,
3078: qa_ss_const.resource_code,
3079: -- qa_ss_const.uom,
3080: qa_ss_const.subinventory,

Line 3077: qa_ss_const.production_line,

3073:
3074: IF char_id IN ( qa_ss_const.department,
3075: qa_ss_const.job_name,
3076: qa_ss_const.work_order,
3077: qa_ss_const.production_line,
3078: qa_ss_const.resource_code,
3079: -- qa_ss_const.uom,
3080: qa_ss_const.subinventory,
3081: qa_ss_const.item,

Line 3078: qa_ss_const.resource_code,

3074: IF char_id IN ( qa_ss_const.department,
3075: qa_ss_const.job_name,
3076: qa_ss_const.work_order,
3077: qa_ss_const.production_line,
3078: qa_ss_const.resource_code,
3079: -- qa_ss_const.uom,
3080: qa_ss_const.subinventory,
3081: qa_ss_const.item,
3082: qa_ss_const.asset_group,

Line 3079: -- qa_ss_const.uom,

3075: qa_ss_const.job_name,
3076: qa_ss_const.work_order,
3077: qa_ss_const.production_line,
3078: qa_ss_const.resource_code,
3079: -- qa_ss_const.uom,
3080: qa_ss_const.subinventory,
3081: qa_ss_const.item,
3082: qa_ss_const.asset_group,
3083: qa_ss_const.rework_job,

Line 3080: qa_ss_const.subinventory,

3076: qa_ss_const.work_order,
3077: qa_ss_const.production_line,
3078: qa_ss_const.resource_code,
3079: -- qa_ss_const.uom,
3080: qa_ss_const.subinventory,
3081: qa_ss_const.item,
3082: qa_ss_const.asset_group,
3083: qa_ss_const.rework_job,
3084: qa_ss_const.bill_reference,

Line 3081: qa_ss_const.item,

3077: qa_ss_const.production_line,
3078: qa_ss_const.resource_code,
3079: -- qa_ss_const.uom,
3080: qa_ss_const.subinventory,
3081: qa_ss_const.item,
3082: qa_ss_const.asset_group,
3083: qa_ss_const.rework_job,
3084: qa_ss_const.bill_reference,
3085: qa_ss_const.routing_reference,

Line 3082: qa_ss_const.asset_group,

3078: qa_ss_const.resource_code,
3079: -- qa_ss_const.uom,
3080: qa_ss_const.subinventory,
3081: qa_ss_const.item,
3082: qa_ss_const.asset_group,
3083: qa_ss_const.rework_job,
3084: qa_ss_const.bill_reference,
3085: qa_ss_const.routing_reference,
3086: -- R12 OPM Deviations. Bug 4345503 Start

Line 3083: qa_ss_const.rework_job,

3079: -- qa_ss_const.uom,
3080: qa_ss_const.subinventory,
3081: qa_ss_const.item,
3082: qa_ss_const.asset_group,
3083: qa_ss_const.rework_job,
3084: qa_ss_const.bill_reference,
3085: qa_ss_const.routing_reference,
3086: -- R12 OPM Deviations. Bug 4345503 Start
3087: qa_ss_const.process_batch_num,

Line 3084: qa_ss_const.bill_reference,

3080: qa_ss_const.subinventory,
3081: qa_ss_const.item,
3082: qa_ss_const.asset_group,
3083: qa_ss_const.rework_job,
3084: qa_ss_const.bill_reference,
3085: qa_ss_const.routing_reference,
3086: -- R12 OPM Deviations. Bug 4345503 Start
3087: qa_ss_const.process_batch_num,
3088: -- R12 OPM Deviations. Bug 4345503 End

Line 3085: qa_ss_const.routing_reference,

3081: qa_ss_const.item,
3082: qa_ss_const.asset_group,
3083: qa_ss_const.rework_job,
3084: qa_ss_const.bill_reference,
3085: qa_ss_const.routing_reference,
3086: -- R12 OPM Deviations. Bug 4345503 Start
3087: qa_ss_const.process_batch_num,
3088: -- R12 OPM Deviations. Bug 4345503 End
3089: qa_ss_const.to_subinventory ) THEN

Line 3087: qa_ss_const.process_batch_num,

3083: qa_ss_const.rework_job,
3084: qa_ss_const.bill_reference,
3085: qa_ss_const.routing_reference,
3086: -- R12 OPM Deviations. Bug 4345503 Start
3087: qa_ss_const.process_batch_num,
3088: -- R12 OPM Deviations. Bug 4345503 End
3089: qa_ss_const.to_subinventory ) THEN
3090:
3091: RETURN to_char(org_id);

Line 3089: qa_ss_const.to_subinventory ) THEN

3085: qa_ss_const.routing_reference,
3086: -- R12 OPM Deviations. Bug 4345503 Start
3087: qa_ss_const.process_batch_num,
3088: -- R12 OPM Deviations. Bug 4345503 End
3089: qa_ss_const.to_subinventory ) THEN
3090:
3091: RETURN to_char(org_id);
3092:
3093: END IF;

Line 3097: IF char_id IN ( qa_ss_const.nonconformance_source,

3093: END IF;
3094:
3095: -- Collection elements based on QA_LOOKUPS.
3096:
3097: IF char_id IN ( qa_ss_const.nonconformance_source,
3098: qa_ss_const.nonconform_severity,
3099: qa_ss_const.nonconform_priority,
3100: qa_ss_const.nonconformance_status,
3101: qa_ss_const.nonconformance_type,

Line 3098: qa_ss_const.nonconform_severity,

3094:
3095: -- Collection elements based on QA_LOOKUPS.
3096:
3097: IF char_id IN ( qa_ss_const.nonconformance_source,
3098: qa_ss_const.nonconform_severity,
3099: qa_ss_const.nonconform_priority,
3100: qa_ss_const.nonconformance_status,
3101: qa_ss_const.nonconformance_type,
3102: qa_ss_const.request_source,

Line 3099: qa_ss_const.nonconform_priority,

3095: -- Collection elements based on QA_LOOKUPS.
3096:
3097: IF char_id IN ( qa_ss_const.nonconformance_source,
3098: qa_ss_const.nonconform_severity,
3099: qa_ss_const.nonconform_priority,
3100: qa_ss_const.nonconformance_status,
3101: qa_ss_const.nonconformance_type,
3102: qa_ss_const.request_source,
3103: qa_ss_const.request_priority,

Line 3100: qa_ss_const.nonconformance_status,

3096:
3097: IF char_id IN ( qa_ss_const.nonconformance_source,
3098: qa_ss_const.nonconform_severity,
3099: qa_ss_const.nonconform_priority,
3100: qa_ss_const.nonconformance_status,
3101: qa_ss_const.nonconformance_type,
3102: qa_ss_const.request_source,
3103: qa_ss_const.request_priority,
3104: qa_ss_const.request_severity,

Line 3101: qa_ss_const.nonconformance_type,

3097: IF char_id IN ( qa_ss_const.nonconformance_source,
3098: qa_ss_const.nonconform_severity,
3099: qa_ss_const.nonconform_priority,
3100: qa_ss_const.nonconformance_status,
3101: qa_ss_const.nonconformance_type,
3102: qa_ss_const.request_source,
3103: qa_ss_const.request_priority,
3104: qa_ss_const.request_severity,
3105: qa_ss_const.request_status ) THEN

Line 3102: qa_ss_const.request_source,

3098: qa_ss_const.nonconform_severity,
3099: qa_ss_const.nonconform_priority,
3100: qa_ss_const.nonconformance_status,
3101: qa_ss_const.nonconformance_type,
3102: qa_ss_const.request_source,
3103: qa_ss_const.request_priority,
3104: qa_ss_const.request_severity,
3105: qa_ss_const.request_status ) THEN
3106:

Line 3103: qa_ss_const.request_priority,

3099: qa_ss_const.nonconform_priority,
3100: qa_ss_const.nonconformance_status,
3101: qa_ss_const.nonconformance_type,
3102: qa_ss_const.request_source,
3103: qa_ss_const.request_priority,
3104: qa_ss_const.request_severity,
3105: qa_ss_const.request_status ) THEN
3106:
3107: RETURN to_char(char_id);

Line 3104: qa_ss_const.request_severity,

3100: qa_ss_const.nonconformance_status,
3101: qa_ss_const.nonconformance_type,
3102: qa_ss_const.request_source,
3103: qa_ss_const.request_priority,
3104: qa_ss_const.request_severity,
3105: qa_ss_const.request_status ) THEN
3106:
3107: RETURN to_char(char_id);
3108:

Line 3105: qa_ss_const.request_status ) THEN

3101: qa_ss_const.nonconformance_type,
3102: qa_ss_const.request_source,
3103: qa_ss_const.request_priority,
3104: qa_ss_const.request_severity,
3105: qa_ss_const.request_status ) THEN
3106:
3107: RETURN to_char(char_id);
3108:
3109: END IF;

Line 3113: IF char_id = qa_ss_const.task_number THEN

3109: END IF;
3110:
3111: -- Other dependent elements.
3112:
3113: IF char_id = qa_ss_const.task_number THEN
3114: RETURN get_task_number_bind_values(depen1);
3115:
3116: ELSIF (char_id = qa_ss_const.revision OR
3117: char_id = qa_ss_const.comp_revision) THEN

Line 3116: ELSIF (char_id = qa_ss_const.revision OR

3112:
3113: IF char_id = qa_ss_const.task_number THEN
3114: RETURN get_task_number_bind_values(depen1);
3115:
3116: ELSIF (char_id = qa_ss_const.revision OR
3117: char_id = qa_ss_const.comp_revision) THEN
3118: RETURN get_revision_bind_values(org_id, depen1);
3119:
3120: -- Bug 5005707. Adding item as a filtering criteria

Line 3117: char_id = qa_ss_const.comp_revision) THEN

3113: IF char_id = qa_ss_const.task_number THEN
3114: RETURN get_task_number_bind_values(depen1);
3115:
3116: ELSIF (char_id = qa_ss_const.revision OR
3117: char_id = qa_ss_const.comp_revision) THEN
3118: RETURN get_revision_bind_values(org_id, depen1);
3119:
3120: -- Bug 5005707. Adding item as a filtering criteria
3121: -- for item uom to improve performance.

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

3120: -- Bug 5005707. Adding item as a filtering criteria
3121: -- for item uom to improve performance.
3122: -- Removed the same from the above if condition
3123: -- saugupta Mon, 10 Jul 2006 21:47:17 -0700 PDT
3124: ELSIF (char_id = qa_ss_const.uom) THEN
3125: RETURN get_uom_bind_values(p_org_id => org_id, p_item_name => depen1);
3126:
3127: ELSIF (char_id = qa_ss_const.lot_number) THEN
3128: RETURN get_lot_number_bind_values(org_id, depen1);

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

3123: -- saugupta Mon, 10 Jul 2006 21:47:17 -0700 PDT
3124: ELSIF (char_id = qa_ss_const.uom) THEN
3125: RETURN get_uom_bind_values(p_org_id => org_id, p_item_name => depen1);
3126:
3127: ELSIF (char_id = qa_ss_const.lot_number) THEN
3128: RETURN get_lot_number_bind_values(org_id, depen1);
3129:
3130: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
3131: RETURN get_comp_lot_bind_values(org_id, depen1);

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

3126:
3127: ELSIF (char_id = qa_ss_const.lot_number) THEN
3128: RETURN get_lot_number_bind_values(org_id, depen1);
3129:
3130: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
3131: RETURN get_comp_lot_bind_values(org_id, depen1);
3132:
3133: ELSIF (char_id = qa_ss_const.serial_number) THEN
3134: RETURN get_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);

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

3129:
3130: ELSIF (char_id = qa_ss_const.comp_lot_number) THEN
3131: RETURN get_comp_lot_bind_values(org_id, depen1);
3132:
3133: ELSIF (char_id = qa_ss_const.serial_number) THEN
3134: RETURN get_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);
3135:
3136: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3137: RETURN get_comp_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);

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

3132:
3133: ELSIF (char_id = qa_ss_const.serial_number) THEN
3134: RETURN get_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);
3135:
3136: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3137: RETURN get_comp_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);
3138:
3139: -- dgupta: Start R12 EAM Integration. Bug 4345492
3140: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN

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

3136: ELSIF (char_id = qa_ss_const.comp_serial_number) THEN
3137: RETURN get_comp_serial_no_bind_values(plan_id, org_id, depen2, depen3, depen1);
3138:
3139: -- dgupta: Start R12 EAM Integration. Bug 4345492
3140: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN
3141: RETURN get_asset_inst_num_bind_values(org_id, depen1, depen2);
3142:
3143: ELSIF (char_id = qa_ss_const.asset_number) THEN
3144: RETURN get_asset_number_bind_values(org_id, depen1, depen2);

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

3139: -- dgupta: Start R12 EAM Integration. Bug 4345492
3140: ELSIF (char_id = qa_ss_const.asset_instance_number) THEN
3141: RETURN get_asset_inst_num_bind_values(org_id, depen1, depen2);
3142:
3143: ELSIF (char_id = qa_ss_const.asset_number) THEN
3144: RETURN get_asset_number_bind_values(org_id, depen1, depen2);
3145: --dgupta: End R12 EAM Integration. Bug 4345492
3146:
3147: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR

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

3143: ELSIF (char_id = qa_ss_const.asset_number) THEN
3144: RETURN get_asset_number_bind_values(org_id, depen1, depen2);
3145: --dgupta: End R12 EAM Integration. Bug 4345492
3146:
3147: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
3148: (char_id = qa_ss_const.to_op_seq_num) THEN
3149: RETURN get_op_seq_no_bind_values(plan_id, org_id, depen1, depen2);
3150:
3151: ELSIF (char_id = qa_ss_const.po_line_num) THEN

Line 3148: (char_id = qa_ss_const.to_op_seq_num) THEN

3144: RETURN get_asset_number_bind_values(org_id, depen1, depen2);
3145: --dgupta: End R12 EAM Integration. Bug 4345492
3146:
3147: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
3148: (char_id = qa_ss_const.to_op_seq_num) THEN
3149: RETURN get_op_seq_no_bind_values(plan_id, org_id, depen1, depen2);
3150:
3151: ELSIF (char_id = qa_ss_const.po_line_num) THEN
3152: RETURN get_po_line_no_bind_values(depen1);

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

3147: ELSIF (char_id = qa_ss_const.from_op_seq_num) OR
3148: (char_id = qa_ss_const.to_op_seq_num) THEN
3149: RETURN get_op_seq_no_bind_values(plan_id, org_id, depen1, depen2);
3150:
3151: ELSIF (char_id = qa_ss_const.po_line_num) THEN
3152: RETURN get_po_line_no_bind_values(depen1);
3153:
3154: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN
3155: RETURN get_po_shipments_bind_values (depen1, depen2);

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

3150:
3151: ELSIF (char_id = qa_ss_const.po_line_num) THEN
3152: RETURN get_po_line_no_bind_values(depen1);
3153:
3154: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN
3155: RETURN get_po_shipments_bind_values (depen1, depen2);
3156:
3157: ELSIF (char_id = qa_ss_const.comp_item) THEN
3158: RETURN get_comp_item_bind_values (org_id, depen1);

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

3153:
3154: ELSIF (char_id = qa_ss_const.po_shipment_num) THEN
3155: RETURN get_po_shipments_bind_values (depen1, depen2);
3156:
3157: ELSIF (char_id = qa_ss_const.comp_item) THEN
3158: RETURN get_comp_item_bind_values (org_id, depen1);
3159:
3160: -- dgupta: Start R12 EAM Integration. Bug 4345492
3161: ELSIF (char_id = qa_ss_const.asset_activity) THEN

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

3157: ELSIF (char_id = qa_ss_const.comp_item) THEN
3158: RETURN get_comp_item_bind_values (org_id, depen1);
3159:
3160: -- dgupta: Start R12 EAM Integration. Bug 4345492
3161: ELSIF (char_id = qa_ss_const.asset_activity) THEN
3162: RETURN get_asset_activity_bind_values (org_id, depen1, depen2, depen3);
3163:
3164: ELSIF (char_id = qa_ss_const.followup_activity) THEN
3165: RETURN get_followup_act_bind_values(org_id, depen1, depen2, depen3);

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

3160: -- dgupta: Start R12 EAM Integration. Bug 4345492
3161: ELSIF (char_id = qa_ss_const.asset_activity) THEN
3162: RETURN get_asset_activity_bind_values (org_id, depen1, depen2, depen3);
3163:
3164: ELSIF (char_id = qa_ss_const.followup_activity) THEN
3165: RETURN get_followup_act_bind_values(org_id, depen1, depen2, depen3);
3166: --dgupta: End R12 EAM Integration. Bug 4345492
3167:
3168: ELSIF (char_id = qa_ss_const.locator) OR

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

3164: ELSIF (char_id = qa_ss_const.followup_activity) THEN
3165: RETURN get_followup_act_bind_values(org_id, depen1, depen2, depen3);
3166: --dgupta: End R12 EAM Integration. Bug 4345492
3167:
3168: ELSIF (char_id = qa_ss_const.locator) OR
3169: (char_id = qa_ss_const.to_locator) THEN
3170: RETURN get_locator_bind_values(org_id, depen1);
3171:
3172: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN

Line 3169: (char_id = qa_ss_const.to_locator) THEN

3165: RETURN get_followup_act_bind_values(org_id, depen1, depen2, depen3);
3166: --dgupta: End R12 EAM Integration. Bug 4345492
3167:
3168: ELSIF (char_id = qa_ss_const.locator) OR
3169: (char_id = qa_ss_const.to_locator) THEN
3170: RETURN get_locator_bind_values(org_id, depen1);
3171:
3172: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN
3173: RETURN get_maint_op_seq_bind_values(org_id, depen1);

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

3168: ELSIF (char_id = qa_ss_const.locator) OR
3169: (char_id = qa_ss_const.to_locator) THEN
3170: RETURN get_locator_bind_values(org_id, depen1);
3171:
3172: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN
3173: RETURN get_maint_op_seq_bind_values(org_id, depen1);
3174:
3175: -- R12 OPM Deviations. Bug 4345503 Start
3176: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN

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

3172: ELSIF (char_id = qa_ss_const.maintenance_op_seq) THEN
3173: RETURN get_maint_op_seq_bind_values(org_id, depen1);
3174:
3175: -- R12 OPM Deviations. Bug 4345503 Start
3176: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3177: RETURN GET_PROCESS_STEP_BIND_VALUE(org_id, depen1);
3178:
3179: ELSIF (char_id = qa_ss_const.process_operation) THEN
3180: RETURN GET_PROCESS_OPRN_BIND_VALUE(org_id, depen1, depen2);

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

3175: -- R12 OPM Deviations. Bug 4345503 Start
3176: ELSIF (char_id = qa_ss_const.process_batchstep_num) THEN
3177: RETURN GET_PROCESS_STEP_BIND_VALUE(org_id, depen1);
3178:
3179: ELSIF (char_id = qa_ss_const.process_operation) THEN
3180: RETURN GET_PROCESS_OPRN_BIND_VALUE(org_id, depen1, depen2);
3181:
3182: ELSIF (char_id = qa_ss_const.process_activity) THEN
3183: RETURN GET_PROCESS_ACT_BIND_VALUE(org_id, depen1, depen2);

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

3178:
3179: ELSIF (char_id = qa_ss_const.process_operation) THEN
3180: RETURN GET_PROCESS_OPRN_BIND_VALUE(org_id, depen1, depen2);
3181:
3182: ELSIF (char_id = qa_ss_const.process_activity) THEN
3183: RETURN GET_PROCESS_ACT_BIND_VALUE(org_id, depen1, depen2);
3184:
3185: ELSIF (char_id = qa_ss_const.process_resource) THEN
3186: RETURN GET_PROCESS_RSR_BIND_VALUE(org_id, depen1, depen2, depen3);

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

3181:
3182: ELSIF (char_id = qa_ss_const.process_activity) THEN
3183: RETURN GET_PROCESS_ACT_BIND_VALUE(org_id, depen1, depen2);
3184:
3185: ELSIF (char_id = qa_ss_const.process_resource) THEN
3186: RETURN GET_PROCESS_RSR_BIND_VALUE(org_id, depen1, depen2, depen3);
3187:
3188: ELSIF (char_id = qa_ss_const.process_parameter) THEN
3189: RETURN GET_PROCESS_PARAM_BIND_VALUE(org_id, depen1);

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

3184:
3185: ELSIF (char_id = qa_ss_const.process_resource) THEN
3186: RETURN GET_PROCESS_RSR_BIND_VALUE(org_id, depen1, depen2, depen3);
3187:
3188: ELSIF (char_id = qa_ss_const.process_parameter) THEN
3189: RETURN GET_PROCESS_PARAM_BIND_VALUE(org_id, depen1);
3190: -- R12 OPM Deviations. Bug 4345503 End
3191:
3192: ELSIF (char_id = qa_ss_const.po_release_num) THEN

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

3188: ELSIF (char_id = qa_ss_const.process_parameter) THEN
3189: RETURN GET_PROCESS_PARAM_BIND_VALUE(org_id, depen1);
3190: -- R12 OPM Deviations. Bug 4345503 End
3191:
3192: ELSIF (char_id = qa_ss_const.po_release_num) THEN
3193: --
3194: -- Bug 5003511. R12 Performance bug. SQLID: 15008630
3195: -- Release number is dependent on PO Number.
3196: -- Call new method for bind values.

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

3201: -- Bug 6161802
3202: -- Return rma number as a bind variable for rma line number lov
3203: -- skolluku Mon Jul 16 22:08:16 PDT 2007
3204: --
3205: ELSIF (char_id = qa_ss_const.rma_line_num) THEN
3206: RETURN get_rma_line_num_bind_values(depen1);
3207:
3208: ELSE
3209: