DBA Data[Home] [Help]

APPS.QA_WEB_TXN_API dependencies on QA_SS_CONST

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

2: /* $Header: qlttxnwb.plb 120.7 2006/02/23 06:05:09 ntungare noship $ */
3:
4: g_module_name CONSTANT VARCHAR2(60):= 'qa.plsql.qa_web_txn_api';
5:
6: FUNCTION evaluate_triggers (p_context_table in qa_ss_const.ctx_table,
7: p_txn_number IN NUMBER,
8: p_org_id IN NUMBER,
9: p_optimize_flag IN NUMBER,
10: p_mandatory_flag IN NUMBER DEFAULT NULL,

Line 12: p_plans_table IN OUT NOCOPY qa_ss_const.num_table)

8: p_org_id IN NUMBER,
9: p_optimize_flag IN NUMBER,
10: p_mandatory_flag IN NUMBER DEFAULT NULL,
11: p_background_flag IN NUMBER DEFAULT NULL,
12: p_plans_table IN OUT NOCOPY qa_ss_const.num_table)
13: RETURN BOOLEAN IS
14:
15: -- The p_optimize_flag parameter is an optimization hint. A value 2 for
16: -- p_optimize_flag means optimize. As as soon as one plan apply we should

Line 154: p_context_table IN qa_ss_const.ctx_table,

150: END evaluate_triggers;
151:
152:
153: FUNCTION check_plan_for_applicability (
154: p_context_table IN qa_ss_const.ctx_table,
155: p_txn_number IN NUMBER,
156: p_org_id IN NUMBER,
157: p_plan_id IN NUMBER)
158: RETURN VARCHAR2 IS

Line 380: l_context_table qa_ss_const.ctx_table;

376: pk10 IN VARCHAR2, -- DEFAULT NULL
377: p_txn_name IN VARCHAR2) -- DEFAULT NULL)
378: RETURN VARCHAR2 IS
379:
380: l_context_table qa_ss_const.ctx_table;
381:
382: BEGIN
383: -- This function is called to figure out if a particular plan applies
384: -- to the transaction and the associated context. For EAM this is

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

400: end if;
401:
402: -- IF (p_txn_number = 31) THEN
403:
404: l_context_table(qa_ss_const.asset_group) := pk1;
405: l_context_table(qa_ss_const.asset_number) := pk2;
406: l_context_table(qa_ss_const.asset_activity) := pk3;
407: l_context_table(qa_ss_const.work_order) := pk4;
408: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;

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

401:
402: -- IF (p_txn_number = 31) THEN
403:
404: l_context_table(qa_ss_const.asset_group) := pk1;
405: l_context_table(qa_ss_const.asset_number) := pk2;
406: l_context_table(qa_ss_const.asset_activity) := pk3;
407: l_context_table(qa_ss_const.work_order) := pk4;
408: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
409: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492

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

402: -- IF (p_txn_number = 31) THEN
403:
404: l_context_table(qa_ss_const.asset_group) := pk1;
405: l_context_table(qa_ss_const.asset_number) := pk2;
406: l_context_table(qa_ss_const.asset_activity) := pk3;
407: l_context_table(qa_ss_const.work_order) := pk4;
408: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
409: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
410:

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

403:
404: l_context_table(qa_ss_const.asset_group) := pk1;
405: l_context_table(qa_ss_const.asset_number) := pk2;
406: l_context_table(qa_ss_const.asset_activity) := pk3;
407: l_context_table(qa_ss_const.work_order) := pk4;
408: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
409: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
410:
411: -- END IF;

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

404: l_context_table(qa_ss_const.asset_group) := pk1;
405: l_context_table(qa_ss_const.asset_number) := pk2;
406: l_context_table(qa_ss_const.asset_activity) := pk3;
407: l_context_table(qa_ss_const.work_order) := pk4;
408: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
409: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
410:
411: -- END IF;
412:

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

405: l_context_table(qa_ss_const.asset_number) := pk2;
406: l_context_table(qa_ss_const.asset_activity) := pk3;
407: l_context_table(qa_ss_const.work_order) := pk4;
408: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
409: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
410:
411: -- END IF;
412:
413: RETURN check_plan_for_applicability(l_context_table, p_txn_number,

Line 579: l_context_table qa_ss_const.ctx_table;

575: pk10 IN VARCHAR2, -- DEFAULT NULL
576: p_txn_name IN VARCHAR2) -- DEFAULT NULL)
577: RETURN VARCHAR2 IS
578:
579: l_context_table qa_ss_const.ctx_table;
580: l_plans_table qa_ss_const.num_table;
581: result BOOLEAN;
582: return_value VARCHAR2(1) DEFAULT 'N';
583:

Line 580: l_plans_table qa_ss_const.num_table;

576: p_txn_name IN VARCHAR2) -- DEFAULT NULL)
577: RETURN VARCHAR2 IS
578:
579: l_context_table qa_ss_const.ctx_table;
580: l_plans_table qa_ss_const.num_table;
581: result BOOLEAN;
582: return_value VARCHAR2(1) DEFAULT 'N';
583:
584: BEGIN

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

589: -- Note that these will contain different values for different
590: -- transactions.
591:
592:
593: -- IF (p_txn_number = qa_ss_const.eam_work_order_completion_txn) THEN
594:
595: -- The following are the context elements for work order completions.
596: -- Ordered By char id
597: --

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

600: -- pk3 -> asset activity
601: -- pk4 -> work order number
602: -- pk5 -> step
603:
604: l_context_table(qa_ss_const.asset_group) := pk1;
605: l_context_table(qa_ss_const.asset_number) := pk2;
606: l_context_table(qa_ss_const.asset_activity) := pk3;
607: l_context_table(qa_ss_const.work_order) := pk4;
608: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;

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

601: -- pk4 -> work order number
602: -- pk5 -> step
603:
604: l_context_table(qa_ss_const.asset_group) := pk1;
605: l_context_table(qa_ss_const.asset_number) := pk2;
606: l_context_table(qa_ss_const.asset_activity) := pk3;
607: l_context_table(qa_ss_const.work_order) := pk4;
608: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
609: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492

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

602: -- pk5 -> step
603:
604: l_context_table(qa_ss_const.asset_group) := pk1;
605: l_context_table(qa_ss_const.asset_number) := pk2;
606: l_context_table(qa_ss_const.asset_activity) := pk3;
607: l_context_table(qa_ss_const.work_order) := pk4;
608: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
609: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
610:

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

603:
604: l_context_table(qa_ss_const.asset_group) := pk1;
605: l_context_table(qa_ss_const.asset_number) := pk2;
606: l_context_table(qa_ss_const.asset_activity) := pk3;
607: l_context_table(qa_ss_const.work_order) := pk4;
608: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
609: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
610:
611:

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

604: l_context_table(qa_ss_const.asset_group) := pk1;
605: l_context_table(qa_ss_const.asset_number) := pk2;
606: l_context_table(qa_ss_const.asset_activity) := pk3;
607: l_context_table(qa_ss_const.work_order) := pk4;
608: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
609: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
610:
611:
612:

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

605: l_context_table(qa_ss_const.asset_number) := pk2;
606: l_context_table(qa_ss_const.asset_activity) := pk3;
607: l_context_table(qa_ss_const.work_order) := pk4;
608: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
609: l_context_table(qa_ss_const.asset_instance_number) := pk6; --dgupta: R12 EAM Integration. Bug 4345492
610:
611:
612:
613: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);

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

610:
611:
612:
613: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);
614: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
615: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
616: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
617: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
618: --dbms_output.put_line(l_context_table(qa_ss_const.step));

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

611:
612:
613: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);
614: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
615: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
616: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
617: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
618: --dbms_output.put_line(l_context_table(qa_ss_const.step));
619:

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

612:
613: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);
614: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
615: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
616: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
617: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
618: --dbms_output.put_line(l_context_table(qa_ss_const.step));
619:
620: result := evaluate_triggers (

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

613: --dbms_output.put_line(p_txn_number || ' ' || p_organization_id);
614: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
615: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
616: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
617: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
618: --dbms_output.put_line(l_context_table(qa_ss_const.step));
619:
620: result := evaluate_triggers (
621: p_context_table => l_context_table,

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

614: --dbms_output.put_line(l_context_table(qa_ss_const.asset_group));
615: --dbms_output.put_line(l_context_table(qa_ss_const.asset_number));
616: --dbms_output.put_line(l_context_table(qa_ss_const.asset_activity));
617: --dbms_output.put_line(l_context_table(qa_ss_const.work_order));
618: --dbms_output.put_line(l_context_table(qa_ss_const.step));
619:
620: result := evaluate_triggers (
621: p_context_table => l_context_table,
622: p_txn_number => p_txn_number,

Line 662: l_context_table qa_ss_const.ctx_table;

658: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
659: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
660: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
661: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
662: l_context_table qa_ss_const.ctx_table;
663: l_plans_table qa_ss_const.num_table;
664: result BOOLEAN;
665: return_value VARCHAR2(1) DEFAULT 'N';
666: i NUMBER;

Line 663: l_plans_table qa_ss_const.num_table;

659: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
660: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
661: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
662: l_context_table qa_ss_const.ctx_table;
663: l_plans_table qa_ss_const.num_table;
664: result BOOLEAN;
665: return_value VARCHAR2(1) DEFAULT 'N';
666: i NUMBER;
667: l_plan_token VARCHAR2(30);

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

675: || ',pk3='|| pk3|| ', pk4='|| pk4|| ', pk5='|| pk5 || ', pk6='|| pk6|| ',p_txn_name='|| p_txn_name
676: || ',p_list_of_plans='|| p_list_of_plans || ',p_collection_id='|| p_collection_id
677: || ',p_wip_entity_id='|| p_wip_entity_id|| ')');
678: end if;
679: l_context_table(qa_ss_const.asset_group) := pk1;
680: l_context_table(qa_ss_const.asset_number) := pk2;
681: l_context_table(qa_ss_const.asset_activity) := pk3;
682: l_context_table(qa_ss_const.work_order) := pk4;
683: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;

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

676: || ',p_list_of_plans='|| p_list_of_plans || ',p_collection_id='|| p_collection_id
677: || ',p_wip_entity_id='|| p_wip_entity_id|| ')');
678: end if;
679: l_context_table(qa_ss_const.asset_group) := pk1;
680: l_context_table(qa_ss_const.asset_number) := pk2;
681: l_context_table(qa_ss_const.asset_activity) := pk3;
682: l_context_table(qa_ss_const.work_order) := pk4;
683: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
684: l_context_table(qa_ss_const.asset_instance_number) := pk6;

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

677: || ',p_wip_entity_id='|| p_wip_entity_id|| ')');
678: end if;
679: l_context_table(qa_ss_const.asset_group) := pk1;
680: l_context_table(qa_ss_const.asset_number) := pk2;
681: l_context_table(qa_ss_const.asset_activity) := pk3;
682: l_context_table(qa_ss_const.work_order) := pk4;
683: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
684: l_context_table(qa_ss_const.asset_instance_number) := pk6;
685: --dgupta: End R12 EAM Integration. Bug 4345492

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

678: end if;
679: l_context_table(qa_ss_const.asset_group) := pk1;
680: l_context_table(qa_ss_const.asset_number) := pk2;
681: l_context_table(qa_ss_const.asset_activity) := pk3;
682: l_context_table(qa_ss_const.work_order) := pk4;
683: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
684: l_context_table(qa_ss_const.asset_instance_number) := pk6;
685: --dgupta: End R12 EAM Integration. Bug 4345492
686:

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

679: l_context_table(qa_ss_const.asset_group) := pk1;
680: l_context_table(qa_ss_const.asset_number) := pk2;
681: l_context_table(qa_ss_const.asset_activity) := pk3;
682: l_context_table(qa_ss_const.work_order) := pk4;
683: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
684: l_context_table(qa_ss_const.asset_instance_number) := pk6;
685: --dgupta: End R12 EAM Integration. Bug 4345492
686:
687: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

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

680: l_context_table(qa_ss_const.asset_number) := pk2;
681: l_context_table(qa_ss_const.asset_activity) := pk3;
682: l_context_table(qa_ss_const.work_order) := pk4;
683: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
684: l_context_table(qa_ss_const.asset_instance_number) := pk6;
685: --dgupta: End R12 EAM Integration. Bug 4345492
686:
687: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
688: 'Calling evaluate_triggers');

Line 822: If p_txn_number in (qa_ss_const.eam_checkin_txn,

818: BEGIN
819: --bug 4995406
820: --Checking if the Txn is an EAM transaction
821: --ntungare Wed Feb 22 06:57:05 PST 2006
822: If p_txn_number in (qa_ss_const.eam_checkin_txn,
823: qa_ss_const.eam_checkout_txn,
824: qa_ss_const.eam_operation_txn,
825: qa_ss_const.eam_work_order_txn) THEN
826: -- CAll the procedure to process the result

Line 823: qa_ss_const.eam_checkout_txn,

819: --bug 4995406
820: --Checking if the Txn is an EAM transaction
821: --ntungare Wed Feb 22 06:57:05 PST 2006
822: If p_txn_number in (qa_ss_const.eam_checkin_txn,
823: qa_ss_const.eam_checkout_txn,
824: qa_ss_const.eam_operation_txn,
825: qa_ss_const.eam_work_order_txn) THEN
826: -- CAll the procedure to process the result
827: -- Collection for Background Plans for EAM Txn

Line 824: qa_ss_const.eam_operation_txn,

820: --Checking if the Txn is an EAM transaction
821: --ntungare Wed Feb 22 06:57:05 PST 2006
822: If p_txn_number in (qa_ss_const.eam_checkin_txn,
823: qa_ss_const.eam_checkout_txn,
824: qa_ss_const.eam_operation_txn,
825: qa_ss_const.eam_work_order_txn) THEN
826: -- CAll the procedure to process the result
827: -- Collection for Background Plans for EAM Txn
828: -- ntungare Wed Feb 22 07:48:02 PST 2006

Line 825: qa_ss_const.eam_work_order_txn) THEN

821: --ntungare Wed Feb 22 06:57:05 PST 2006
822: If p_txn_number in (qa_ss_const.eam_checkin_txn,
823: qa_ss_const.eam_checkout_txn,
824: qa_ss_const.eam_operation_txn,
825: qa_ss_const.eam_work_order_txn) THEN
826: -- CAll the procedure to process the result
827: -- Collection for Background Plans for EAM Txn
828: -- ntungare Wed Feb 22 07:48:02 PST 2006
829: qa_txn_grp.eam_post_background_results(p_txn_number => p_txn_number,

Line 865: qa_ss_const.wip_move_txn,

861:
862: BEGIN
863:
864: IF p_txn IN (
865: qa_ss_const.wip_move_txn,
866: qa_ss_const.wip_completion_txn,
867: qa_ss_const.flow_work_order_less_txn,
868: qa_ss_const.flow_line_op_txn,
869: qa_ss_const.osfm_move_txn) THEN

Line 866: qa_ss_const.wip_completion_txn,

862: BEGIN
863:
864: IF p_txn IN (
865: qa_ss_const.wip_move_txn,
866: qa_ss_const.wip_completion_txn,
867: qa_ss_const.flow_work_order_less_txn,
868: qa_ss_const.flow_line_op_txn,
869: qa_ss_const.osfm_move_txn) THEN
870: RETURN fnd_api.g_true;

Line 867: qa_ss_const.flow_work_order_less_txn,

863:
864: IF p_txn IN (
865: qa_ss_const.wip_move_txn,
866: qa_ss_const.wip_completion_txn,
867: qa_ss_const.flow_work_order_less_txn,
868: qa_ss_const.flow_line_op_txn,
869: qa_ss_const.osfm_move_txn) THEN
870: RETURN fnd_api.g_true;
871: END IF;

Line 868: qa_ss_const.flow_line_op_txn,

864: IF p_txn IN (
865: qa_ss_const.wip_move_txn,
866: qa_ss_const.wip_completion_txn,
867: qa_ss_const.flow_work_order_less_txn,
868: qa_ss_const.flow_line_op_txn,
869: qa_ss_const.osfm_move_txn) THEN
870: RETURN fnd_api.g_true;
871: END IF;
872:

Line 869: qa_ss_const.osfm_move_txn) THEN

865: qa_ss_const.wip_move_txn,
866: qa_ss_const.wip_completion_txn,
867: qa_ss_const.flow_work_order_less_txn,
868: qa_ss_const.flow_line_op_txn,
869: qa_ss_const.osfm_move_txn) THEN
870: RETURN fnd_api.g_true;
871: END IF;
872:
873: RETURN fnd_api.g_false;

Line 925: IF p_txn IN (qa_ss_const.mob_move_txn,

921: RETURN VARCHAR2 IS
922:
923: BEGIN
924:
925: IF p_txn IN (qa_ss_const.mob_move_txn,
926: qa_ss_const.mob_scrap_reject_txn,
927: qa_ss_const.mob_return_txn,
928: qa_ss_const.mob_completion_txn,
929: qa_ss_const.mob_wo_less_txn,

Line 926: qa_ss_const.mob_scrap_reject_txn,

922:
923: BEGIN
924:
925: IF p_txn IN (qa_ss_const.mob_move_txn,
926: qa_ss_const.mob_scrap_reject_txn,
927: qa_ss_const.mob_return_txn,
928: qa_ss_const.mob_completion_txn,
929: qa_ss_const.mob_wo_less_txn,
930: qa_ss_const.mob_flow_txn,

Line 927: qa_ss_const.mob_return_txn,

923: BEGIN
924:
925: IF p_txn IN (qa_ss_const.mob_move_txn,
926: qa_ss_const.mob_scrap_reject_txn,
927: qa_ss_const.mob_return_txn,
928: qa_ss_const.mob_completion_txn,
929: qa_ss_const.mob_wo_less_txn,
930: qa_ss_const.mob_flow_txn,
931: qa_ss_const.mob_material_txn,

Line 928: qa_ss_const.mob_completion_txn,

924:
925: IF p_txn IN (qa_ss_const.mob_move_txn,
926: qa_ss_const.mob_scrap_reject_txn,
927: qa_ss_const.mob_return_txn,
928: qa_ss_const.mob_completion_txn,
929: qa_ss_const.mob_wo_less_txn,
930: qa_ss_const.mob_flow_txn,
931: qa_ss_const.mob_material_txn,
932: qa_ss_const.mob_move_and_complete_txn,

Line 929: qa_ss_const.mob_wo_less_txn,

925: IF p_txn IN (qa_ss_const.mob_move_txn,
926: qa_ss_const.mob_scrap_reject_txn,
927: qa_ss_const.mob_return_txn,
928: qa_ss_const.mob_completion_txn,
929: qa_ss_const.mob_wo_less_txn,
930: qa_ss_const.mob_flow_txn,
931: qa_ss_const.mob_material_txn,
932: qa_ss_const.mob_move_and_complete_txn,
933: qa_ss_const.mob_return_and_move_txn,

Line 930: qa_ss_const.mob_flow_txn,

926: qa_ss_const.mob_scrap_reject_txn,
927: qa_ss_const.mob_return_txn,
928: qa_ss_const.mob_completion_txn,
929: qa_ss_const.mob_wo_less_txn,
930: qa_ss_const.mob_flow_txn,
931: qa_ss_const.mob_material_txn,
932: qa_ss_const.mob_move_and_complete_txn,
933: qa_ss_const.mob_return_and_move_txn,
934: qa_ss_const.mob_ser_move_txn,

Line 931: qa_ss_const.mob_material_txn,

927: qa_ss_const.mob_return_txn,
928: qa_ss_const.mob_completion_txn,
929: qa_ss_const.mob_wo_less_txn,
930: qa_ss_const.mob_flow_txn,
931: qa_ss_const.mob_material_txn,
932: qa_ss_const.mob_move_and_complete_txn,
933: qa_ss_const.mob_return_and_move_txn,
934: qa_ss_const.mob_ser_move_txn,
935: qa_ss_const.mob_ser_scrap_rej_txn,

Line 932: qa_ss_const.mob_move_and_complete_txn,

928: qa_ss_const.mob_completion_txn,
929: qa_ss_const.mob_wo_less_txn,
930: qa_ss_const.mob_flow_txn,
931: qa_ss_const.mob_material_txn,
932: qa_ss_const.mob_move_and_complete_txn,
933: qa_ss_const.mob_return_and_move_txn,
934: qa_ss_const.mob_ser_move_txn,
935: qa_ss_const.mob_ser_scrap_rej_txn,
936: qa_ss_const.mob_ser_return_txn,

Line 933: qa_ss_const.mob_return_and_move_txn,

929: qa_ss_const.mob_wo_less_txn,
930: qa_ss_const.mob_flow_txn,
931: qa_ss_const.mob_material_txn,
932: qa_ss_const.mob_move_and_complete_txn,
933: qa_ss_const.mob_return_and_move_txn,
934: qa_ss_const.mob_ser_move_txn,
935: qa_ss_const.mob_ser_scrap_rej_txn,
936: qa_ss_const.mob_ser_return_txn,
937: qa_ss_const.mob_ser_completion_txn,

Line 934: qa_ss_const.mob_ser_move_txn,

930: qa_ss_const.mob_flow_txn,
931: qa_ss_const.mob_material_txn,
932: qa_ss_const.mob_move_and_complete_txn,
933: qa_ss_const.mob_return_and_move_txn,
934: qa_ss_const.mob_ser_move_txn,
935: qa_ss_const.mob_ser_scrap_rej_txn,
936: qa_ss_const.mob_ser_return_txn,
937: qa_ss_const.mob_ser_completion_txn,
938: qa_ss_const.mob_ser_material_txn,

Line 935: qa_ss_const.mob_ser_scrap_rej_txn,

931: qa_ss_const.mob_material_txn,
932: qa_ss_const.mob_move_and_complete_txn,
933: qa_ss_const.mob_return_and_move_txn,
934: qa_ss_const.mob_ser_move_txn,
935: qa_ss_const.mob_ser_scrap_rej_txn,
936: qa_ss_const.mob_ser_return_txn,
937: qa_ss_const.mob_ser_completion_txn,
938: qa_ss_const.mob_ser_material_txn,
939: qa_ss_const.mob_ser_move_and_comp_txn,

Line 936: qa_ss_const.mob_ser_return_txn,

932: qa_ss_const.mob_move_and_complete_txn,
933: qa_ss_const.mob_return_and_move_txn,
934: qa_ss_const.mob_ser_move_txn,
935: qa_ss_const.mob_ser_scrap_rej_txn,
936: qa_ss_const.mob_ser_return_txn,
937: qa_ss_const.mob_ser_completion_txn,
938: qa_ss_const.mob_ser_material_txn,
939: qa_ss_const.mob_ser_move_and_comp_txn,
940: qa_ss_const.mob_ser_return_and_move_txn,

Line 937: qa_ss_const.mob_ser_completion_txn,

933: qa_ss_const.mob_return_and_move_txn,
934: qa_ss_const.mob_ser_move_txn,
935: qa_ss_const.mob_ser_scrap_rej_txn,
936: qa_ss_const.mob_ser_return_txn,
937: qa_ss_const.mob_ser_completion_txn,
938: qa_ss_const.mob_ser_material_txn,
939: qa_ss_const.mob_ser_move_and_comp_txn,
940: qa_ss_const.mob_ser_return_and_move_txn,
941: qa_ss_const.mob_lpn_inspection_txn,

Line 938: qa_ss_const.mob_ser_material_txn,

934: qa_ss_const.mob_ser_move_txn,
935: qa_ss_const.mob_ser_scrap_rej_txn,
936: qa_ss_const.mob_ser_return_txn,
937: qa_ss_const.mob_ser_completion_txn,
938: qa_ss_const.mob_ser_material_txn,
939: qa_ss_const.mob_ser_move_and_comp_txn,
940: qa_ss_const.mob_ser_return_and_move_txn,
941: qa_ss_const.mob_lpn_inspection_txn,
942: qa_ss_const.mob_recv_inspection_txn,

Line 939: qa_ss_const.mob_ser_move_and_comp_txn,

935: qa_ss_const.mob_ser_scrap_rej_txn,
936: qa_ss_const.mob_ser_return_txn,
937: qa_ss_const.mob_ser_completion_txn,
938: qa_ss_const.mob_ser_material_txn,
939: qa_ss_const.mob_ser_move_and_comp_txn,
940: qa_ss_const.mob_ser_return_and_move_txn,
941: qa_ss_const.mob_lpn_inspection_txn,
942: qa_ss_const.mob_recv_inspection_txn,
943: qa_ss_const.wms_lpn_based_txn) THEN

Line 940: qa_ss_const.mob_ser_return_and_move_txn,

936: qa_ss_const.mob_ser_return_txn,
937: qa_ss_const.mob_ser_completion_txn,
938: qa_ss_const.mob_ser_material_txn,
939: qa_ss_const.mob_ser_move_and_comp_txn,
940: qa_ss_const.mob_ser_return_and_move_txn,
941: qa_ss_const.mob_lpn_inspection_txn,
942: qa_ss_const.mob_recv_inspection_txn,
943: qa_ss_const.wms_lpn_based_txn) THEN
944: RETURN fnd_api.g_true;

Line 941: qa_ss_const.mob_lpn_inspection_txn,

937: qa_ss_const.mob_ser_completion_txn,
938: qa_ss_const.mob_ser_material_txn,
939: qa_ss_const.mob_ser_move_and_comp_txn,
940: qa_ss_const.mob_ser_return_and_move_txn,
941: qa_ss_const.mob_lpn_inspection_txn,
942: qa_ss_const.mob_recv_inspection_txn,
943: qa_ss_const.wms_lpn_based_txn) THEN
944: RETURN fnd_api.g_true;
945: END IF;

Line 942: qa_ss_const.mob_recv_inspection_txn,

938: qa_ss_const.mob_ser_material_txn,
939: qa_ss_const.mob_ser_move_and_comp_txn,
940: qa_ss_const.mob_ser_return_and_move_txn,
941: qa_ss_const.mob_lpn_inspection_txn,
942: qa_ss_const.mob_recv_inspection_txn,
943: qa_ss_const.wms_lpn_based_txn) THEN
944: RETURN fnd_api.g_true;
945: END IF;
946:

Line 943: qa_ss_const.wms_lpn_based_txn) THEN

939: qa_ss_const.mob_ser_move_and_comp_txn,
940: qa_ss_const.mob_ser_return_and_move_txn,
941: qa_ss_const.mob_lpn_inspection_txn,
942: qa_ss_const.mob_recv_inspection_txn,
943: qa_ss_const.wms_lpn_based_txn) THEN
944: RETURN fnd_api.g_true;
945: END IF;
946:
947: RETURN fnd_api.g_false;