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.MSC_ATP_PVT dependencies on FND_PROFILE

Line 25: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');

21:
22: -- This is the main procedure called for Scheduling
23: -- Change name to Schedule
24:
25: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
26:
27: -- dsting
28: -- For multilevel models, the override flag for the input record is reset to null
29: -- after the first level.

Line 348: MSC_ATP_PVT.G_RES_CONSUME := NVL(FND_PROFILE.value('MSC_ATP_RES_CONSUME'), 'Y');

344: MSC_ATP_PVT.G_ATP_ITEM_PRESENT_IN_SET := 'N';
345: -- initialize API return status to success
346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347:
348: MSC_ATP_PVT.G_RES_CONSUME := NVL(FND_PROFILE.value('MSC_ATP_RES_CONSUME'), 'Y');
349: IF PG_DEBUG in ('Y', 'C') THEN
350: msc_sch_wb.atp_debug('Schedule: ' || 'G_RES_CONSUME = '||MSC_ATP_PVT.G_RES_CONSUME);
351: END IF;
352:

Line 485: lv_assign_set_id := FND_PROFILE.value('MSC_ATP_ASSIGN_SET');

481: -- This is done to support region level sourcing as
482: -- only assignment set on APS can be used.
483:
484: -- lv_assign_set_id := NULL; -- User new local variable
485: lv_assign_set_id := FND_PROFILE.value('MSC_ATP_ASSIGN_SET');
486: END IF;
487:
488: IF PG_DEBUG in ('Y', 'C') THEN
489: msc_sch_wb.atp_debug('Schedule: ' || 'after converting the assign set id');

Line 758: -- l_complete_scatp := NVL(FND_PROFILE.value('MRP_COMPLETE_SCATP'), 'N');

754: msc_sch_wb.atp_debug('Schedule: Stmt = '||l_stmt);
755: END IF;
756:
757: -- cchen: disable complete scatp for now
758: -- l_complete_scatp := NVL(FND_PROFILE.value('MRP_COMPLETE_SCATP'), 'N');
759: -- l_complete_scatp := 'Y';
760: -- msc_sch_wb.atp_debug('l_complete_scatp = '||l_complete_scatp);
761:
762: -- we may need to loop through every supply source until we succeed

Line 1396: MSC_ATP_PVT.G_SUMMARY_FLAG := NVL(FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N');

1392: END IF;
1393: MSC_ATP_PVT.G_SUMMARY_FLAG := 'N';
1394: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 THEN
1395: --- we re-read this summary profile option because it might get changed with plan
1396: MSC_ATP_PVT.G_SUMMARY_FLAG := NVL(FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N');
1397: END IF;
1398: IF PG_DEBUG in ('Y', 'C') THEN
1399: msc_sch_wb.atp_debug('Schedule: ' || 'MSC_ATP_PVT.G_SUMMARY_FLAG := ' || MSC_ATP_PVT.G_SUMMARY_FLAG);
1400: END IF;

Line 2602: --L_MOVE_PAST_DUE_TO_SYSDATE := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); -- Bug 5584634/5618929

2598: RAISE FND_API.G_EXC_ERROR;
2599: END IF;
2600:
2601: --bug 3322846: Move past due ship date to the first working day after sysdate
2602: --L_MOVE_PAST_DUE_TO_SYSDATE := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); -- Bug 5584634/5618929
2603: L_MOVE_PAST_DUE_TO_SYSDATE := MSC_ATP_PVT.G_MOV_PAST_DUE_SYSDATE_PROF;--6316476
2604: IF PG_DEBUG in ('Y', 'C') THEN
2605: msc_sch_wb.atp_debug('Schedule: ' || 'MOVE_PAST_DUE_TO_SYS_DATE :'|| L_MOVE_PAST_DUE_TO_SYSDATE);
2606: END IF;

Line 4115: --L_MOVE_PAST_DUE_TO_SYSDATE := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); -- Bug 5584634/5618929

4111: msc_sch_wb.atp_debug('ship_date: ' || l_atp_table.ship_date(i));
4112: msc_sch_wb.atp_debug('arrival_date: ' || l_atp_table.arrival_date(i));
4113: END IF;
4114: --bug3439591 start
4115: --L_MOVE_PAST_DUE_TO_SYSDATE := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); -- Bug 5584634/5618929
4116: L_MOVE_PAST_DUE_TO_SYSDATE := MSC_ATP_PVT.G_MOV_PAST_DUE_SYSDATE_PROF;--6316476
4117: IF PG_DEBUG in ('Y', 'C') THEN
4118: msc_sch_wb.atp_debug('Schedule: ' || 'MOVE_PAST_DUE_TO_SYS_DATE :'|| L_MOVE_PAST_DUE_TO_SYSDATE);
4119: END IF;

Line 7487: l_enforce_model_lt := NVL(FND_PROFILE.VALUE('MSC_ENFORCE_MODEL_LT'), 'Y');

7483: msc_sch_wb.atp_debug('ATP_Check: ' || 'MSC_ATP_PVT.G_PTF_DATE := ' || MSC_ATP_PVT.G_PTF_DATE);
7484: END IF;
7485:
7486: --s_cto_rearch: bug 3169831 : Honor lead time only when profile option is turned on
7487: l_enforce_model_lt := NVL(FND_PROFILE.VALUE('MSC_ENFORCE_MODEL_LT'), 'Y');
7488:
7489: IF PG_DEBUG in ('Y', 'C') THEN
7490: msc_sch_wb.atp_debug('l_enforce_model_lt := ' || l_enforce_model_lt);
7491: END IF;

Line 14933: l_coproducts_flag := FND_Profile.value('MSC_PLAN_COPRODUCTS');

14929: IF PG_DEBUG in ('Y', 'C') THEN
14930: msc_sch_wb.atp_debug('ATP_Check: ' || 'OSFM Coproducts Backward');
14931: END IF;
14932: --- OSFM Changes: update coproduct supply
14933: l_coproducts_flag := FND_Profile.value('MSC_PLAN_COPRODUCTS');
14934: IF PG_DEBUG in ('Y', 'C') THEN
14935: msc_sch_wb.atp_debug('ATP_Check: ' || 'msc_plan_coproducts = ' || l_coproducts_flag);
14936: END IF;
14937: --- set the sumary flag back to summary flag for p_plan_id

Line 15490: l_coproducts_flag := FND_Profile.value('MSC_PLAN_COPRODUCTS');

15486: END IF;
15487: --- reset the sumamry flag back to summary flag corresponding to p_plan_id
15488: MSC_ATP_PVT.G_SUMMARY_FLAG := l_summary_flag;
15489: --- OSFM Changes: update coproduct supply
15490: l_coproducts_flag := FND_Profile.value('MSC_PLAN_COPRODUCTS');
15491: IF PG_DEBUG in ('Y', 'C') THEN
15492: msc_sch_wb.atp_debug('ATP_Check: ' || 'msc_plan_coproducts = ' || l_coproducts_flag);
15493: END IF;
15494: IF ((l_atp_comp_flag = 'C') OR

Line 17185: l_atp_progess_bar varchar2(1) := nvl(fnd_profile.value('MRP_ATP_PROGRESS_BAR'),'Y'); --7419485

17181: l_feeder_count NUMBER;
17182: l_consume_so_profile_value NUMBER;
17183:
17184:
17185: l_atp_progess_bar varchar2(1) := nvl(fnd_profile.value('MRP_ATP_PROGRESS_BAR'),'Y'); --7419485
17186: BEGIN
17187:
17188: IF PG_DEBUG in ('Y', 'C') THEN
17189: msc_sch_wb.atp_debug('***** Begin Call_Schedule Procedure *****');

Line 17193: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;

17189: msc_sch_wb.atp_debug('***** Begin Call_Schedule Procedure *****');
17190: END IF;
17191:
17192: -- Initialize global variables to work in a connection pooling env
17193: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
17194: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
17195: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
17196: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
17197: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);

Line 17194: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');

17190: END IF;
17191:
17192: -- Initialize global variables to work in a connection pooling env
17193: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
17194: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
17195: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
17196: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
17197: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
17198:

Line 17195: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

17191:
17192: -- Initialize global variables to work in a connection pooling env
17193: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
17194: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
17195: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
17196: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
17197: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
17198:
17199: --bug 3625348: reset global variable

Line 17196: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);

17192: -- Initialize global variables to work in a connection pooling env
17193: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
17194: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
17195: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
17196: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
17197: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
17198:
17199: --bug 3625348: reset global variable
17200: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;

Line 17197: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);

17193: G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
17194: G_SUB_COMP := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
17195: G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
17196: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
17197: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
17198:
17199: --bug 3625348: reset global variable
17200: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
17201: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;

Line 17285: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);

17281: --alloc_pp
17282: IF MSC_ATP_PVT.G_INV_CTP = 4 AND MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y' AND
17283: MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 THEN
17284:
17285: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
17286: IF PG_DEBUG in ('Y', 'C') THEN
17287: msc_sch_wb.atp_debug('Call_Schedule: ' || 'G_ALLOCATION_METHOD := ' || MSC_ATP_PVT.G_ALLOCATION_METHOD);
17288: END IF;
17289: END IF;

Line 17691: l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'), NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO)); --5564082

17687: msc_sch_wb.atp_debug('Call_Schedule: ' || 'OE Flag (Before ISO check) : '||l_atp_input_table.OE_flag(m));
17688: END IF;
17689: --Bug 4279623 4333596
17690: IF l_atp_input_table.oe_flag(m) = 'Y' and MSC_ATP_PVT.G_INV_CTP = 4 THEN
17691: l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'), NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO)); --5564082
17692: --l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO);
17693: IF PG_DEBUG in ('Y', 'C') THEN
17694: msc_sch_wb.atp_debug('Before get_plan_info_call:l_consume_so_profile_value ' || l_consume_so_profile_value);
17695: msc_sch_wb.atp_debug('Before get_plan_info_call:MSC_CONSUME_INT_SALES_ORDERS ' || l_consume_so_profile_value);

Line 17692: --l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO);

17688: END IF;
17689: --Bug 4279623 4333596
17690: IF l_atp_input_table.oe_flag(m) = 'Y' and MSC_ATP_PVT.G_INV_CTP = 4 THEN
17691: l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'), NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO)); --5564082
17692: --l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO);
17693: IF PG_DEBUG in ('Y', 'C') THEN
17694: msc_sch_wb.atp_debug('Before get_plan_info_call:l_consume_so_profile_value ' || l_consume_so_profile_value);
17695: msc_sch_wb.atp_debug('Before get_plan_info_call:MSC_CONSUME_INT_SALES_ORDERS ' || l_consume_so_profile_value);
17696: msc_sch_wb.atp_debug('New profile: '||FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS')); --5564082

Line 17696: msc_sch_wb.atp_debug('New profile: '||FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS')); --5564082

17692: --l_consume_so_profile_value := NVL(FND_PROFILE.VALUE('MSC_CONSUME_INT_SALES_ORDERS'), NO);
17693: IF PG_DEBUG in ('Y', 'C') THEN
17694: msc_sch_wb.atp_debug('Before get_plan_info_call:l_consume_so_profile_value ' || l_consume_so_profile_value);
17695: msc_sch_wb.atp_debug('Before get_plan_info_call:MSC_CONSUME_INT_SALES_ORDERS ' || l_consume_so_profile_value);
17696: msc_sch_wb.atp_debug('New profile: '||FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS')); --5564082
17697: END IF;
17698: IF l_consume_so_profile_value = CHECK_ORG_IN_PLAN THEN
17699: MSC_ATP_PROC.get_plan_info(p_instance_id,
17700: l_atp_input_table.inventory_item_id(m),

Line 17780: END IF; -- nvl(fnd_profile.value('msc_consume_int_sales_orders'), '2') = 3

17776: IF PG_DEBUG in ('Y', 'C') THEN
17777: msc_sch_wb.atp_debug('Profile value is set to CHECK ATP. We need to do ATP always.');
17778: END IF;
17779:
17780: END IF; -- nvl(fnd_profile.value('msc_consume_int_sales_orders'), '2') = 3
17781: END IF; -- l_atp_input_table.oe_flag(1) = 'y' and msc_atp_pvt.g_inv_ctp = 4
17782: --Bug 4279623 4333596
17783: msc_sch_wb.atp_debug('l_atp_input_table.oe_flag(m) = '||l_atp_input_table.oe_flag(m)); --5564082
17784: IF l_atp_input_table.OE_flag(m) = 'Y' AND MSC_ATP_PVT.G_INV_CTP = 4 THEN

Line 18603: NVL(fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW'), 'N'));

18599:
18600: /* rajjain 02/27/2003 Bug 2824700 Begin
18601: * Restructured Exception/WF Notification code */
18602: l_wf_profile := NVL(G_ATP_WORKFLOW,
18603: NVL(fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW'), 'N'));
18604: IF PG_DEBUG in ('Y', 'C') THEN
18605: msc_sch_wb.atp_debug('Call_Schedule: ' || 'WF Profile:' || l_wf_profile);
18606: END IF;
18607:

Line 18982: FND_PROFILE.put('MSC_ATP_DEBUG', p_atp_debug_flag);

18978:
18979: x_return_status := FND_API.G_RET_STS_SUCCESS;
18980: --bug3940999 setting debug mode explicitly so the messages can be printed
18981: IF p_atp_debug_flag IS NOT NULL THEN
18982: FND_PROFILE.put('MSC_ATP_DEBUG', p_atp_debug_flag);
18983: PG_DEBUG := p_atp_debug_flag;
18984: END IF;
18985: IF PG_DEBUG in ('Y', 'C') THEN
18986: --ATP Debug Workflow

Line 19094: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 2 ));

19090:
19091: IF l_profile_name(j) = 'MSC_ALLOCATION_METHOD' THEN
19092:
19093: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(l_profile_value(j), 2 );
19094: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 2 ));
19095:
19096: ELSIF l_profile_name(j) = 'MSC_ALLOCATED_ATP' THEN
19097:
19098: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(l_profile_value(j), 'N');

Line 19099: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 'N'));

19095:
19096: ELSIF l_profile_name(j) = 'MSC_ALLOCATED_ATP' THEN
19097:
19098: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(l_profile_value(j), 'N');
19099: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 'N'));
19100:
19101: ELSIF l_profile_name(j) = 'MSC_CLASS_HIERARCHY' THEN
19102:
19103: MSC_ATP_PVT.G_HIERARCHY_PROFILE := NVL(l_profile_value(j), 2 );

Line 19104: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 2 ));

19100:
19101: ELSIF l_profile_name(j) = 'MSC_CLASS_HIERARCHY' THEN
19102:
19103: MSC_ATP_PVT.G_HIERARCHY_PROFILE := NVL(l_profile_value(j), 2 );
19104: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 2 ));
19105:
19106: ELSIF l_profile_name(j) = 'MSC_ALLOCATED_ATP_WORKFLOW' THEN
19107:
19108: G_ATP_WORKFLOW := l_profile_value(j);

Line 19109: FND_PROFILE.put(l_profile_name(j) , l_profile_value(j));

19105:
19106: ELSIF l_profile_name(j) = 'MSC_ALLOCATED_ATP_WORKFLOW' THEN
19107:
19108: G_ATP_WORKFLOW := l_profile_value(j);
19109: FND_PROFILE.put(l_profile_name(j) , l_profile_value(j));
19110:
19111: ELSIF l_profile_name(j) = 'INV_CTP' THEN
19112:
19113: MSC_ATP_PVT.G_INV_CTP_SOURCE := NVL(l_profile_value(j), 0 );

Line 19123: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 'N'));

19119: --optional_fw
19120: ELSIF l_profile_name(j) = 'MSC_ENHANCED_FORWARD_ATP' THEN
19121:
19122: MSC_ATP_PVT.G_FORWARD_ATP := NVL(l_profile_value(j), 'N');
19123: FND_PROFILE.put(l_profile_name(j) , NVL(l_profile_value(j), 'N'));
19124:
19125: ELSIF l_profile_name(j) = 'MSC_MOVE_PAST_DUE_TO_SYSDATE' THEN --6316476
19126:
19127: MSC_ATP_PVT.G_MOV_PAST_DUE_SYSDATE_PROF := NVL(l_profile_value(j), 'Y'); --6316476

Line 19145: FND_PROFILE.put('MSC_ATP_DEBUG', p_atp_debug_flag);

19141: --bug3940999 end honor profile options passed from the source
19142:
19143: /* --bug3940999 set above
19144: IF p_atp_debug_flag IS NOT NULL THEN
19145: FND_PROFILE.put('MSC_ATP_DEBUG', p_atp_debug_flag);
19146: PG_DEBUG := p_atp_debug_flag;
19147: END IF;
19148:
19149: msc_sch_wb.set_session_id(p_session_id);

Line 19156: FND_PROFILE.put('MSC_ALLOCATED_ATP_WORKFLOW', p_atp_workflow);

19152: END IF;
19153:
19154: -- Fixed as part of Fix for Bug 3444096, need to set profile value as it is queried again in msc_wf_alloc_atp.start_mscatp_wf
19155: IF p_atp_workflow IS NOT NULL THEN
19156: FND_PROFILE.put('MSC_ALLOCATED_ATP_WORKFLOW', p_atp_workflow);
19157: G_ATP_WORKFLOW := p_atp_workflow;
19158: END IF;
19159:
19160: -- Bug 2387242 : krajan