9: TYPE plan_fun_privs_cache_tab_typ IS TABLE OF VARCHAR2(2000) INDEX BY LONG;
10: g_plan_fun_privs_cache_tab plan_fun_privs_cache_tab_typ;
11:
12:
13: FUNCTION evaluate_triggers (p_context_table in qa_ss_const.ctx_table,
14: p_txn_number IN NUMBER,
15: p_org_id IN NUMBER,
16: p_optimize_flag IN NUMBER,
17: p_mandatory_flag IN NUMBER DEFAULT NULL,
15: p_org_id IN NUMBER,
16: p_optimize_flag IN NUMBER,
17: p_mandatory_flag IN NUMBER DEFAULT NULL,
18: p_background_flag IN NUMBER DEFAULT NULL,
19: p_plans_table IN OUT NOCOPY qa_ss_const.num_table)
20: RETURN BOOLEAN IS
21:
22: -- The p_optimize_flag parameter is an optimization hint. A value 2 for
23: -- p_optimize_flag means optimize. As as soon as one plan apply we should
157: END evaluate_triggers;
158:
159:
160: FUNCTION check_plan_for_applicability (
161: p_context_table IN qa_ss_const.ctx_table,
162: p_txn_number IN NUMBER,
163: p_org_id IN NUMBER,
164: p_plan_id IN NUMBER)
165: RETURN VARCHAR2 IS
383: pk10 IN VARCHAR2, -- DEFAULT NULL
384: p_txn_name IN VARCHAR2) -- DEFAULT NULL)
385: RETURN VARCHAR2 IS
386:
387: l_context_table qa_ss_const.ctx_table;
388:
389: BEGIN
390: -- This function is called to figure out if a particular plan applies
391: -- to the transaction and the associated context. For EAM this is
407: end if;
408:
409: -- IF (p_txn_number = 31) THEN
410:
411: l_context_table(qa_ss_const.asset_group) := pk1;
412: l_context_table(qa_ss_const.asset_number) := pk2;
413: l_context_table(qa_ss_const.asset_activity) := pk3;
414: l_context_table(qa_ss_const.work_order) := pk4;
415: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
408:
409: -- IF (p_txn_number = 31) THEN
410:
411: l_context_table(qa_ss_const.asset_group) := pk1;
412: l_context_table(qa_ss_const.asset_number) := pk2;
413: l_context_table(qa_ss_const.asset_activity) := pk3;
414: l_context_table(qa_ss_const.work_order) := pk4;
415: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
416: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
409: -- IF (p_txn_number = 31) THEN
410:
411: l_context_table(qa_ss_const.asset_group) := pk1;
412: l_context_table(qa_ss_const.asset_number) := pk2;
413: l_context_table(qa_ss_const.asset_activity) := pk3;
414: l_context_table(qa_ss_const.work_order) := pk4;
415: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
416: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
417:
410:
411: l_context_table(qa_ss_const.asset_group) := pk1;
412: l_context_table(qa_ss_const.asset_number) := pk2;
413: l_context_table(qa_ss_const.asset_activity) := pk3;
414: l_context_table(qa_ss_const.work_order) := pk4;
415: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
416: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
417:
418: -- END IF;
411: l_context_table(qa_ss_const.asset_group) := pk1;
412: l_context_table(qa_ss_const.asset_number) := pk2;
413: l_context_table(qa_ss_const.asset_activity) := pk3;
414: l_context_table(qa_ss_const.work_order) := pk4;
415: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
416: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
417:
418: -- END IF;
419:
412: l_context_table(qa_ss_const.asset_number) := pk2;
413: l_context_table(qa_ss_const.asset_activity) := pk3;
414: l_context_table(qa_ss_const.work_order) := pk4;
415: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
416: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
417:
418: -- END IF;
419:
420: RETURN check_plan_for_applicability(l_context_table, p_txn_number,
595: pk10 IN VARCHAR2, -- DEFAULT NULL
596: p_txn_name IN VARCHAR2) -- DEFAULT NULL)
597: RETURN VARCHAR2 IS
598:
599: l_context_table qa_ss_const.ctx_table;
600: l_plans_table qa_ss_const.num_table;
601: result BOOLEAN;
602: return_value VARCHAR2(1) DEFAULT 'N';
603:
596: p_txn_name IN VARCHAR2) -- DEFAULT NULL)
597: RETURN VARCHAR2 IS
598:
599: l_context_table qa_ss_const.ctx_table;
600: l_plans_table qa_ss_const.num_table;
601: result BOOLEAN;
602: return_value VARCHAR2(1) DEFAULT 'N';
603:
604: BEGIN
609: -- Note that these will contain different values for different
610: -- transactions.
611:
612:
613: -- IF (p_txn_number = qa_ss_const.eam_work_order_completion_txn) THEN
614:
615: -- The following are the context elements for work order completions.
616: -- Ordered By char id
617: --
620: -- pk3 -> asset activity
621: -- pk4 -> work order number
622: -- pk5 -> step
623:
624: l_context_table(qa_ss_const.asset_group) := pk1;
625: l_context_table(qa_ss_const.asset_number) := pk2;
626: l_context_table(qa_ss_const.asset_activity) := pk3;
627: l_context_table(qa_ss_const.work_order) := pk4;
628: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
621: -- pk4 -> work order number
622: -- pk5 -> step
623:
624: l_context_table(qa_ss_const.asset_group) := pk1;
625: l_context_table(qa_ss_const.asset_number) := pk2;
626: l_context_table(qa_ss_const.asset_activity) := pk3;
627: l_context_table(qa_ss_const.work_order) := pk4;
628: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
629: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
622: -- pk5 -> step
623:
624: l_context_table(qa_ss_const.asset_group) := pk1;
625: l_context_table(qa_ss_const.asset_number) := pk2;
626: l_context_table(qa_ss_const.asset_activity) := pk3;
627: l_context_table(qa_ss_const.work_order) := pk4;
628: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
629: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
630:
623:
624: l_context_table(qa_ss_const.asset_group) := pk1;
625: l_context_table(qa_ss_const.asset_number) := pk2;
626: l_context_table(qa_ss_const.asset_activity) := pk3;
627: l_context_table(qa_ss_const.work_order) := pk4;
628: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
629: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
630:
631:
624: l_context_table(qa_ss_const.asset_group) := pk1;
625: l_context_table(qa_ss_const.asset_number) := pk2;
626: l_context_table(qa_ss_const.asset_activity) := pk3;
627: l_context_table(qa_ss_const.work_order) := pk4;
628: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
629: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
630:
631:
632:
625: l_context_table(qa_ss_const.asset_number) := pk2;
626: l_context_table(qa_ss_const.asset_activity) := pk3;
627: l_context_table(qa_ss_const.work_order) := pk4;
628: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
629: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
630:
631:
632:
633: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);
630:
631:
632:
633: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);
634: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
635: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
636: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
637: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
638: --dbms_output.put_line(l_context_table(qa_ss_const.step));
631:
632:
633: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);
634: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
635: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
636: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
637: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
638: --dbms_output.put_line(l_context_table(qa_ss_const.step));
639:
632:
633: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);
634: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
635: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
636: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
637: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
638: --dbms_output.put_line(l_context_table(qa_ss_const.step));
639:
640: result := evaluate_triggers (
633: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);
634: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
635: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
636: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
637: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
638: --dbms_output.put_line(l_context_table(qa_ss_const.step));
639:
640: result := evaluate_triggers (
641: p_context_table => l_context_table,
634: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
635: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
636: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
637: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
638: --dbms_output.put_line(l_context_table(qa_ss_const.step));
639:
640: result := evaluate_triggers (
641: p_context_table => l_context_table,
642: p_txn_number => p_txn_number,
678: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
679: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
680: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
681: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
682: l_context_table qa_ss_const.ctx_table;
683: l_plans_table qa_ss_const.num_table;
684: result BOOLEAN;
685: return_value VARCHAR2(1) DEFAULT 'N';
686: i NUMBER;
679: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
680: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
681: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
682: l_context_table qa_ss_const.ctx_table;
683: l_plans_table qa_ss_const.num_table;
684: result BOOLEAN;
685: return_value VARCHAR2(1) DEFAULT 'N';
686: i NUMBER;
687: l_plan_token VARCHAR2(30);
695: || ',pk3='|| pk3|| ', pk4='|| pk4|| ', pk5='|| pk5 || ', pk6='|| pk6|| ',p_txn_name='|| p_txn_name
696: || ',p_list_of_plans='|| p_list_of_plans || ',p_collection_id='|| p_collection_id
697: || ',p_wip_entity_id='|| p_wip_entity_id|| ')');
698: end if;
699: l_context_table(qa_ss_const.asset_group) := pk1;
700: l_context_table(qa_ss_const.asset_number) := pk2;
701: l_context_table(qa_ss_const.asset_activity) := pk3;
702: l_context_table(qa_ss_const.work_order) := pk4;
703: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
696: || ',p_list_of_plans='|| p_list_of_plans || ',p_collection_id='|| p_collection_id
697: || ',p_wip_entity_id='|| p_wip_entity_id|| ')');
698: end if;
699: l_context_table(qa_ss_const.asset_group) := pk1;
700: l_context_table(qa_ss_const.asset_number) := pk2;
701: l_context_table(qa_ss_const.asset_activity) := pk3;
702: l_context_table(qa_ss_const.work_order) := pk4;
703: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
704: l_context_table(qa_ss_const.asset_instance_number) := pk6;
697: || ',p_wip_entity_id='|| p_wip_entity_id|| ')');
698: end if;
699: l_context_table(qa_ss_const.asset_group) := pk1;
700: l_context_table(qa_ss_const.asset_number) := pk2;
701: l_context_table(qa_ss_const.asset_activity) := pk3;
702: l_context_table(qa_ss_const.work_order) := pk4;
703: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
704: l_context_table(qa_ss_const.asset_instance_number) := pk6;
705: --dgupta: End R12 EAM Integration. Bug 4345492
698: end if;
699: l_context_table(qa_ss_const.asset_group) := pk1;
700: l_context_table(qa_ss_const.asset_number) := pk2;
701: l_context_table(qa_ss_const.asset_activity) := pk3;
702: l_context_table(qa_ss_const.work_order) := pk4;
703: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
704: l_context_table(qa_ss_const.asset_instance_number) := pk6;
705: --dgupta: End R12 EAM Integration. Bug 4345492
706:
699: l_context_table(qa_ss_const.asset_group) := pk1;
700: l_context_table(qa_ss_const.asset_number) := pk2;
701: l_context_table(qa_ss_const.asset_activity) := pk3;
702: l_context_table(qa_ss_const.work_order) := pk4;
703: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
704: l_context_table(qa_ss_const.asset_instance_number) := pk6;
705: --dgupta: End R12 EAM Integration. Bug 4345492
706:
707: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
700: l_context_table(qa_ss_const.asset_number) := pk2;
701: l_context_table(qa_ss_const.asset_activity) := pk3;
702: l_context_table(qa_ss_const.work_order) := pk4;
703: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
704: l_context_table(qa_ss_const.asset_instance_number) := pk6;
705: --dgupta: End R12 EAM Integration. Bug 4345492
706:
707: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
708: 'Calling evaluate_triggers');
845: BEGIN
846: --bug 4995406
847: --Checking if the Txn is an EAM transaction
848: --ntungare Wed Feb 22 06:57:05 PST 2006
849: If p_txn_number in (qa_ss_const.eam_checkin_txn,
850: qa_ss_const.eam_checkout_txn,
851: qa_ss_const.eam_operation_txn,
852: qa_ss_const.eam_work_order_txn) THEN
853: -- CAll the procedure to process the result
846: --bug 4995406
847: --Checking if the Txn is an EAM transaction
848: --ntungare Wed Feb 22 06:57:05 PST 2006
849: If p_txn_number in (qa_ss_const.eam_checkin_txn,
850: qa_ss_const.eam_checkout_txn,
851: qa_ss_const.eam_operation_txn,
852: qa_ss_const.eam_work_order_txn) THEN
853: -- CAll the procedure to process the result
854: -- Collection for Background Plans for EAM Txn
847: --Checking if the Txn is an EAM transaction
848: --ntungare Wed Feb 22 06:57:05 PST 2006
849: If p_txn_number in (qa_ss_const.eam_checkin_txn,
850: qa_ss_const.eam_checkout_txn,
851: qa_ss_const.eam_operation_txn,
852: qa_ss_const.eam_work_order_txn) THEN
853: -- CAll the procedure to process the result
854: -- Collection for Background Plans for EAM Txn
855: -- ntungare Wed Feb 22 07:48:02 PST 2006
848: --ntungare Wed Feb 22 06:57:05 PST 2006
849: If p_txn_number in (qa_ss_const.eam_checkin_txn,
850: qa_ss_const.eam_checkout_txn,
851: qa_ss_const.eam_operation_txn,
852: qa_ss_const.eam_work_order_txn) THEN
853: -- CAll the procedure to process the result
854: -- Collection for Background Plans for EAM Txn
855: -- ntungare Wed Feb 22 07:48:02 PST 2006
856: qa_txn_grp.eam_post_background_results(p_txn_number => p_txn_number,
888:
889: BEGIN
890:
891: IF p_txn IN (
892: qa_ss_const.wip_move_txn,
893: qa_ss_const.wip_completion_txn,
894: qa_ss_const.flow_work_order_less_txn,
895: qa_ss_const.flow_line_op_txn,
896: qa_ss_const.osfm_move_txn) THEN
889: BEGIN
890:
891: IF p_txn IN (
892: qa_ss_const.wip_move_txn,
893: qa_ss_const.wip_completion_txn,
894: qa_ss_const.flow_work_order_less_txn,
895: qa_ss_const.flow_line_op_txn,
896: qa_ss_const.osfm_move_txn) THEN
897: RETURN fnd_api.g_true;
890:
891: IF p_txn IN (
892: qa_ss_const.wip_move_txn,
893: qa_ss_const.wip_completion_txn,
894: qa_ss_const.flow_work_order_less_txn,
895: qa_ss_const.flow_line_op_txn,
896: qa_ss_const.osfm_move_txn) THEN
897: RETURN fnd_api.g_true;
898: END IF;
891: IF p_txn IN (
892: qa_ss_const.wip_move_txn,
893: qa_ss_const.wip_completion_txn,
894: qa_ss_const.flow_work_order_less_txn,
895: qa_ss_const.flow_line_op_txn,
896: qa_ss_const.osfm_move_txn) THEN
897: RETURN fnd_api.g_true;
898: END IF;
899:
892: qa_ss_const.wip_move_txn,
893: qa_ss_const.wip_completion_txn,
894: qa_ss_const.flow_work_order_less_txn,
895: qa_ss_const.flow_line_op_txn,
896: qa_ss_const.osfm_move_txn) THEN
897: RETURN fnd_api.g_true;
898: END IF;
899:
900: RETURN fnd_api.g_false;
948: RETURN VARCHAR2 IS
949:
950: BEGIN
951:
952: IF p_txn IN (qa_ss_const.mob_move_txn,
953: qa_ss_const.mob_scrap_reject_txn,
954: qa_ss_const.mob_return_txn,
955: qa_ss_const.mob_completion_txn,
956: qa_ss_const.mob_wo_less_txn,
949:
950: BEGIN
951:
952: IF p_txn IN (qa_ss_const.mob_move_txn,
953: qa_ss_const.mob_scrap_reject_txn,
954: qa_ss_const.mob_return_txn,
955: qa_ss_const.mob_completion_txn,
956: qa_ss_const.mob_wo_less_txn,
957: qa_ss_const.mob_flow_txn,
950: BEGIN
951:
952: IF p_txn IN (qa_ss_const.mob_move_txn,
953: qa_ss_const.mob_scrap_reject_txn,
954: qa_ss_const.mob_return_txn,
955: qa_ss_const.mob_completion_txn,
956: qa_ss_const.mob_wo_less_txn,
957: qa_ss_const.mob_flow_txn,
958: qa_ss_const.mob_material_txn,
951:
952: IF p_txn IN (qa_ss_const.mob_move_txn,
953: qa_ss_const.mob_scrap_reject_txn,
954: qa_ss_const.mob_return_txn,
955: qa_ss_const.mob_completion_txn,
956: qa_ss_const.mob_wo_less_txn,
957: qa_ss_const.mob_flow_txn,
958: qa_ss_const.mob_material_txn,
959: qa_ss_const.mob_move_and_complete_txn,
952: IF p_txn IN (qa_ss_const.mob_move_txn,
953: qa_ss_const.mob_scrap_reject_txn,
954: qa_ss_const.mob_return_txn,
955: qa_ss_const.mob_completion_txn,
956: qa_ss_const.mob_wo_less_txn,
957: qa_ss_const.mob_flow_txn,
958: qa_ss_const.mob_material_txn,
959: qa_ss_const.mob_move_and_complete_txn,
960: qa_ss_const.mob_return_and_move_txn,
953: qa_ss_const.mob_scrap_reject_txn,
954: qa_ss_const.mob_return_txn,
955: qa_ss_const.mob_completion_txn,
956: qa_ss_const.mob_wo_less_txn,
957: qa_ss_const.mob_flow_txn,
958: qa_ss_const.mob_material_txn,
959: qa_ss_const.mob_move_and_complete_txn,
960: qa_ss_const.mob_return_and_move_txn,
961: qa_ss_const.mob_ser_move_txn,
954: qa_ss_const.mob_return_txn,
955: qa_ss_const.mob_completion_txn,
956: qa_ss_const.mob_wo_less_txn,
957: qa_ss_const.mob_flow_txn,
958: qa_ss_const.mob_material_txn,
959: qa_ss_const.mob_move_and_complete_txn,
960: qa_ss_const.mob_return_and_move_txn,
961: qa_ss_const.mob_ser_move_txn,
962: qa_ss_const.mob_ser_scrap_rej_txn,
955: qa_ss_const.mob_completion_txn,
956: qa_ss_const.mob_wo_less_txn,
957: qa_ss_const.mob_flow_txn,
958: qa_ss_const.mob_material_txn,
959: qa_ss_const.mob_move_and_complete_txn,
960: qa_ss_const.mob_return_and_move_txn,
961: qa_ss_const.mob_ser_move_txn,
962: qa_ss_const.mob_ser_scrap_rej_txn,
963: qa_ss_const.mob_ser_return_txn,
956: qa_ss_const.mob_wo_less_txn,
957: qa_ss_const.mob_flow_txn,
958: qa_ss_const.mob_material_txn,
959: qa_ss_const.mob_move_and_complete_txn,
960: qa_ss_const.mob_return_and_move_txn,
961: qa_ss_const.mob_ser_move_txn,
962: qa_ss_const.mob_ser_scrap_rej_txn,
963: qa_ss_const.mob_ser_return_txn,
964: qa_ss_const.mob_ser_completion_txn,
957: qa_ss_const.mob_flow_txn,
958: qa_ss_const.mob_material_txn,
959: qa_ss_const.mob_move_and_complete_txn,
960: qa_ss_const.mob_return_and_move_txn,
961: qa_ss_const.mob_ser_move_txn,
962: qa_ss_const.mob_ser_scrap_rej_txn,
963: qa_ss_const.mob_ser_return_txn,
964: qa_ss_const.mob_ser_completion_txn,
965: qa_ss_const.mob_ser_material_txn,
958: qa_ss_const.mob_material_txn,
959: qa_ss_const.mob_move_and_complete_txn,
960: qa_ss_const.mob_return_and_move_txn,
961: qa_ss_const.mob_ser_move_txn,
962: qa_ss_const.mob_ser_scrap_rej_txn,
963: qa_ss_const.mob_ser_return_txn,
964: qa_ss_const.mob_ser_completion_txn,
965: qa_ss_const.mob_ser_material_txn,
966: qa_ss_const.mob_ser_move_and_comp_txn,
959: qa_ss_const.mob_move_and_complete_txn,
960: qa_ss_const.mob_return_and_move_txn,
961: qa_ss_const.mob_ser_move_txn,
962: qa_ss_const.mob_ser_scrap_rej_txn,
963: qa_ss_const.mob_ser_return_txn,
964: qa_ss_const.mob_ser_completion_txn,
965: qa_ss_const.mob_ser_material_txn,
966: qa_ss_const.mob_ser_move_and_comp_txn,
967: qa_ss_const.mob_ser_return_and_move_txn,
960: qa_ss_const.mob_return_and_move_txn,
961: qa_ss_const.mob_ser_move_txn,
962: qa_ss_const.mob_ser_scrap_rej_txn,
963: qa_ss_const.mob_ser_return_txn,
964: qa_ss_const.mob_ser_completion_txn,
965: qa_ss_const.mob_ser_material_txn,
966: qa_ss_const.mob_ser_move_and_comp_txn,
967: qa_ss_const.mob_ser_return_and_move_txn,
968: qa_ss_const.mob_lpn_inspection_txn,
961: qa_ss_const.mob_ser_move_txn,
962: qa_ss_const.mob_ser_scrap_rej_txn,
963: qa_ss_const.mob_ser_return_txn,
964: qa_ss_const.mob_ser_completion_txn,
965: qa_ss_const.mob_ser_material_txn,
966: qa_ss_const.mob_ser_move_and_comp_txn,
967: qa_ss_const.mob_ser_return_and_move_txn,
968: qa_ss_const.mob_lpn_inspection_txn,
969: qa_ss_const.mob_recv_inspection_txn,
962: qa_ss_const.mob_ser_scrap_rej_txn,
963: qa_ss_const.mob_ser_return_txn,
964: qa_ss_const.mob_ser_completion_txn,
965: qa_ss_const.mob_ser_material_txn,
966: qa_ss_const.mob_ser_move_and_comp_txn,
967: qa_ss_const.mob_ser_return_and_move_txn,
968: qa_ss_const.mob_lpn_inspection_txn,
969: qa_ss_const.mob_recv_inspection_txn,
970: qa_ss_const.wms_lpn_based_txn) THEN
963: qa_ss_const.mob_ser_return_txn,
964: qa_ss_const.mob_ser_completion_txn,
965: qa_ss_const.mob_ser_material_txn,
966: qa_ss_const.mob_ser_move_and_comp_txn,
967: qa_ss_const.mob_ser_return_and_move_txn,
968: qa_ss_const.mob_lpn_inspection_txn,
969: qa_ss_const.mob_recv_inspection_txn,
970: qa_ss_const.wms_lpn_based_txn) THEN
971: RETURN fnd_api.g_true;
964: qa_ss_const.mob_ser_completion_txn,
965: qa_ss_const.mob_ser_material_txn,
966: qa_ss_const.mob_ser_move_and_comp_txn,
967: qa_ss_const.mob_ser_return_and_move_txn,
968: qa_ss_const.mob_lpn_inspection_txn,
969: qa_ss_const.mob_recv_inspection_txn,
970: qa_ss_const.wms_lpn_based_txn) THEN
971: RETURN fnd_api.g_true;
972: END IF;
965: qa_ss_const.mob_ser_material_txn,
966: qa_ss_const.mob_ser_move_and_comp_txn,
967: qa_ss_const.mob_ser_return_and_move_txn,
968: qa_ss_const.mob_lpn_inspection_txn,
969: qa_ss_const.mob_recv_inspection_txn,
970: qa_ss_const.wms_lpn_based_txn) THEN
971: RETURN fnd_api.g_true;
972: END IF;
973:
966: qa_ss_const.mob_ser_move_and_comp_txn,
967: qa_ss_const.mob_ser_return_and_move_txn,
968: qa_ss_const.mob_lpn_inspection_txn,
969: qa_ss_const.mob_recv_inspection_txn,
970: qa_ss_const.wms_lpn_based_txn) THEN
971: RETURN fnd_api.g_true;
972: END IF;
973:
974: RETURN fnd_api.g_false;