DBA Data[Home] [Help]

APPS.QA_WEB_TXN_API dependencies on QA_SS_CONST

Line 13: FUNCTION evaluate_triggers (p_context_table in qa_ss_const.ctx_table,

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,

Line 19: p_plans_table IN OUT NOCOPY qa_ss_const.num_table)

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

Line 161: p_context_table IN qa_ss_const.ctx_table,

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

Line 387: l_context_table qa_ss_const.ctx_table;

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

Line 411: l_context_table(qa_ss_const.asset_group) := pk1;

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;

Line 412: l_context_table(qa_ss_const.asset_number) := pk2;

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

Line 413: l_context_table(qa_ss_const.asset_activity) := pk3;

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:

Line 414: l_context_table(qa_ss_const.work_order) := pk4;

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;

Line 415: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;

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:

Line 416: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492

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,

Line 599: l_context_table qa_ss_const.ctx_table;

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:

Line 600: l_plans_table qa_ss_const.num_table;

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

Line 613: -- IF (p_txn_number = qa_ss_const.eam_work_order_completion_txn) THEN

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

Line 624: l_context_table(qa_ss_const.asset_group) := pk1;

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;

Line 625: l_context_table(qa_ss_const.asset_number) := pk2;

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

Line 626: l_context_table(qa_ss_const.asset_activity) := pk3;

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:

Line 627: l_context_table(qa_ss_const.work_order) := pk4;

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:

Line 628: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;

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:

Line 629: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492

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

Line 634: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));

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

Line 635: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));

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:

Line 636: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));

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 (

Line 637: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));

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,

Line 638: --dbms_output.put_line(l_context_table(qa_ss_const.step));

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,

Line 682: l_context_table qa_ss_const.ctx_table;

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;

Line 683: l_plans_table qa_ss_const.num_table;

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

Line 699: l_context_table(qa_ss_const.asset_group) := pk1;

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;

Line 700: l_context_table(qa_ss_const.asset_number) := pk2;

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;

Line 701: l_context_table(qa_ss_const.asset_activity) := pk3;

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

Line 702: l_context_table(qa_ss_const.work_order) := pk4;

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:

Line 703: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;

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,

Line 704: l_context_table(qa_ss_const.asset_instance_number) := pk6;

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');

Line 849: If p_txn_number in (qa_ss_const.eam_checkin_txn,

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

Line 850: qa_ss_const.eam_checkout_txn,

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

Line 851: qa_ss_const.eam_operation_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

Line 852: qa_ss_const.eam_work_order_txn) THEN

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,

Line 892: qa_ss_const.wip_move_txn,

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

Line 893: qa_ss_const.wip_completion_txn,

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;

Line 894: qa_ss_const.flow_work_order_less_txn,

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;

Line 895: qa_ss_const.flow_line_op_txn,

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:

Line 896: qa_ss_const.osfm_move_txn) THEN

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;

Line 952: IF p_txn IN (qa_ss_const.mob_move_txn,

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,

Line 953: qa_ss_const.mob_scrap_reject_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,

Line 954: qa_ss_const.mob_return_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,

Line 955: qa_ss_const.mob_completion_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,

Line 956: qa_ss_const.mob_wo_less_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,

Line 957: qa_ss_const.mob_flow_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,

Line 958: qa_ss_const.mob_material_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,

Line 959: qa_ss_const.mob_move_and_complete_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,

Line 960: qa_ss_const.mob_return_and_move_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,

Line 961: qa_ss_const.mob_ser_move_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,

Line 962: qa_ss_const.mob_ser_scrap_rej_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,

Line 963: qa_ss_const.mob_ser_return_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,

Line 964: qa_ss_const.mob_ser_completion_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,

Line 965: qa_ss_const.mob_ser_material_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,

Line 966: qa_ss_const.mob_ser_move_and_comp_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

Line 967: qa_ss_const.mob_ser_return_and_move_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
971: RETURN fnd_api.g_true;

Line 968: qa_ss_const.mob_lpn_inspection_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;
972: END IF;

Line 969: qa_ss_const.mob_recv_inspection_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;
973:

Line 970: qa_ss_const.wms_lpn_based_txn) THEN

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;