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.QP_DELAYED_REQUESTS_PVT dependencies on QP_DELAYED_REQUESTS_UTIL

Line 188: QP_DELAYED_REQUESTS_UTIL.CHECK_FOR_DUPLICATE_QUALIFIERS(l_return_status,l_entity_Id);

184: IF l_request_type = 'DUPLICATE_QUALIFIERS'
185: THEN
186:
187: --dbms_output.put_line('calling qualifier dup');
188: QP_DELAYED_REQUESTS_UTIL.CHECK_FOR_DUPLICATE_QUALIFIERS(l_return_status,l_entity_Id);
189:
190:
191: END IF;
192:

Line 204: QP_DELAYED_REQUESTS_UTIL.CHECK_DUPLICATE_MODIFIER_LINES

200: IF l_request_type = 'DUPLICATE_MODIFIER_LINES'
201: THEN
202:
203: --dbms_output.put_line('calling Modifier Line dup');
204: QP_DELAYED_REQUESTS_UTIL.CHECK_DUPLICATE_MODIFIER_LINES
205: ( p_Start_Date_Active => fnd_date.canonical_to_date(l_request_rec.param2) --2752265
206: , p_End_Date_Active => fnd_date.canonical_to_date(l_request_rec.param3) --2752265
207: , p_List_Line_ID => l_entity_id
208: , p_List_Header_ID => l_request_rec.param1

Line 229: QP_DELAYED_REQUESTS_UTIL.CHECK_DUPLICATE_LIST_LINES

225: IF l_request_type = 'DUPLICATE_LIST_LINES'
226: THEN
227:
228: --dbms_output.put_line('calling qualifier dup');
229: QP_DELAYED_REQUESTS_UTIL.CHECK_DUPLICATE_LIST_LINES
230: ( p_Start_Date_Active => fnd_date.canonical_to_date(l_request_rec.param2) --2739511
231: , p_End_Date_Active => fnd_date.canonical_to_date(l_request_rec.param3) --2739511
232: , p_Revision => l_request_rec.param4
233: , p_List_Line_ID => l_entity_id

Line 253: QP_DELAYED_REQUESTS_UTIL.maintain_list_header_phases

249: IF l_request_type = 'MAINTAIN_LIST_HEADER_PHASES'
250: THEN
251:
252: --dbms_output.put_line('calling qualifier dup');
253: QP_DELAYED_REQUESTS_UTIL.maintain_list_header_phases
254: (p_List_Header_ID => l_request_rec.param1
255: , x_return_status => l_return_status);
256:
257: END IF;

Line 270: QP_DELAYED_REQUESTS_UTIL.validate_lines_for_child

266: IF l_request_type = 'VALIDATE_LINES_FOR_CHILD'
267: THEN
268:
269: --dbms_output.put_line('calling qualifier dup');
270: QP_DELAYED_REQUESTS_UTIL.validate_lines_for_child
271: ( p_List_Line_ID => l_entity_id
272: ,p_list_line_type_code =>l_request_rec.param1
273: , x_return_status => l_return_status);
274:

Line 287: QP_DELAYED_REQUESTS_UTIL.Check_Mult_Price_Break_Attrs(

283:
284: IF l_request_type = QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS
285: THEN
286: oe_debug_pub.add('Processing check_mult_price_break_attrs');
287: QP_DELAYED_REQUESTS_UTIL.Check_Mult_Price_Break_Attrs(
288: p_parent_list_line_id => l_request_rec.param1,
289: x_return_status => l_return_status);
290: END IF;
291:

Line 302: QP_DELAYED_REQUESTS_UTIL.Check_Mixed_Qual_Seg_Levels(

298:
299: IF l_request_type = QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS
300: THEN
301: oe_debug_pub.add('Processing check_mult_price_break_attrs');
302: QP_DELAYED_REQUESTS_UTIL.Check_Mixed_Qual_Seg_Levels(
303: x_return_status => l_return_status,
304: p_qualifier_rule_id => l_request_rec.param1);
305: END IF;
306:

Line 318: QP_DELAYED_REQUESTS_UTIL.Check_Continuous_Price_Breaks

314: IF l_request_type = 'OVERLAPPING_BREAKS'
315: THEN
316: IF l_request_rec.param2 = 'Y' and nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y')='Y' THEN
317: --call continuous price breaks validation function
318: QP_DELAYED_REQUESTS_UTIL.Check_Continuous_Price_Breaks
319: ( p_List_Line_ID => l_request_rec.param1
320: ,x_return_status => l_return_status);
321: ELSE
322: --dbms_output.put_line('calling overlapping breaks');

Line 323: QP_DELAYED_REQUESTS_UTIL.Check_For_overlapping_Breaks

319: ( p_List_Line_ID => l_request_rec.param1
320: ,x_return_status => l_return_status);
321: ELSE
322: --dbms_output.put_line('calling overlapping breaks');
323: QP_DELAYED_REQUESTS_UTIL.Check_For_overlapping_Breaks
324: --changed by svdeshmu on Aril 07
325: --( p_List_Line_ID => l_entity_id
326: ( p_List_Line_ID => l_request_rec.param1
327: ,x_return_status => l_return_status);

Line 340: QP_DELAYED_REQUESTS_UTIL.Upgrade_Price_Breaks

336: END IF;
337:
338: IF l_request_type = QP_Globals.G_UPGRADE_PRICE_BREAKS
339: THEN
340: QP_DELAYED_REQUESTS_UTIL.Upgrade_Price_Breaks
341: ( p_pbh_id => l_entity_id
342: ,p_list_line_no => l_request_rec.param1
343: ,p_product_attribute => l_request_rec.param2
344: ,p_product_attr_value => l_request_rec.param3

Line 361: QP_DELAYED_REQUESTS_UTIL.Check_multiple_prl

357: IF l_request_type = 'SINGLE_PRICE_LIST'
358: THEN
359:
360: --dbms_output.put_line('calling single price list');
361: QP_DELAYED_REQUESTS_UTIL.Check_multiple_prl
362: ( p_List_header_ID => l_entity_id
363: ,x_return_status => l_return_status);
364:
365: END IF;

Line 376: QP_DELAYED_REQUESTS_UTIL.Maintain_Qualifier_Den_Cols(

372:
373:
374: IF l_request_type = QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS
375: THEN
376: QP_DELAYED_REQUESTS_UTIL.Maintain_Qualifier_Den_Cols(
377: p_list_header_id => l_entity_id,
378: x_return_status => l_return_status);
379: END IF;
380:

Line 391: QP_DELAYED_REQUESTS_UTIL.Update_List_Qualification_Ind

387: IF l_request_type = QP_GLOBALS.G_UPDATE_LIST_QUAL_IND
388: THEN
389:
390: --dbms_output.put_line('calling list qualification indicator');
391: QP_DELAYED_REQUESTS_UTIL.Update_List_Qualification_Ind
392: ( p_List_header_ID => l_entity_id
393: ,x_return_status => l_return_status);
394: END IF;
395:

Line 406: QP_DELAYED_REQUESTS_UTIL.Update_Limits_Columns

402: IF l_request_type = QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS
403: THEN
404:
405: --dbms_output.put_line('calling UPDATE_LIMITS_COLUMNS');
406: QP_DELAYED_REQUESTS_UTIL.Update_Limits_Columns
407: ( p_Limit_Id => l_entity_id
408: ,x_return_status => l_return_status);
409: END IF;
410:

Line 420: QP_DELAYED_REQUESTS_UTIL.Update_Qualifier_Status

416:
417: IF l_request_type = QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
418: THEN
419: --dbms_output.put_line('calling UPDATE_QUALIFIER_STATUS ');
420: QP_DELAYED_REQUESTS_UTIL.Update_Qualifier_Status
421: ( p_list_header_id => l_entity_id
422: ,p_active_flag => l_request_rec.param1
423: ,x_return_status => l_return_status);
424: END IF;

Line 435: QP_DELAYED_REQUESTS_UTIL.Create_Security_Privilege

431:
432: IF l_request_type = QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE
433: THEN
434: --dbms_output.put_line('calling CREATE_SECURITY_PRIVILEGE ');
435: QP_DELAYED_REQUESTS_UTIL.Create_Security_Privilege
436: ( p_list_header_id => l_entity_id
437: ,p_list_type_code => l_request_rec.param1
438: ,x_return_status => l_return_status);
439: END IF;

Line 450: QP_DELAYED_REQUESTS_UTIL.Update_Attribute_Status

446:
447: IF l_request_type = QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
448: THEN
449: --dbms_output.put_line('calling UPDATE_ATTRIBUTE_STATUS ');
450: QP_DELAYED_REQUESTS_UTIL.Update_Attribute_Status
451: ( p_list_header_id => l_entity_id
452: ,p_list_line_id => l_request_rec.param1
453: ,p_context_type => l_request_rec.param2
454: ,p_context_code => l_request_rec.param3

Line 468: QP_DELAYED_REQUESTS_UTIL.update_child_break_lines(

464:
465:
466: IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_BREAKS
467: THEN
468: QP_DELAYED_REQUESTS_UTIL.update_child_break_lines(
469: p_list_line_id => l_entity_id,
470: x_return_status => l_return_status);
471: END IF;
472:

Line 481: QP_DELAYED_REQUESTS_UTIL.update_child_pricing_attr(

477: END IF;
478:
479: IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_PRICING_ATTR
480: THEN
481: QP_DELAYED_REQUESTS_UTIL.update_child_pricing_attr(
482: x_return_status => l_return_status,
483: p_list_line_id => l_entity_id);
484: END IF;
485:

Line 506: QP_DELAYED_REQUESTS_UTIL.update_pricing_attr_phase(

502: l_count := 0;
503: END;
504:
505: IF l_count = 1 THEN
506: QP_DELAYED_REQUESTS_UTIL.update_pricing_attr_phase(
507: p_list_line_id => l_entity_id,
508: x_return_status => l_return_status);
509: END IF;
510: END IF;

Line 521: QP_DELAYED_REQUESTS_UTIL.Maintain_Factor_List_Attrs(

517:
518: --Added by rchellam on 29-AUG-2001. POSCO Change.
519: IF l_request_type = QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS
520: THEN
521: QP_DELAYED_REQUESTS_UTIL.Maintain_Factor_List_Attrs(
522: p_list_line_id => l_entity_id,
523: x_return_status => l_return_status);
524: END IF;
525:

Line 538: QP_DELAYED_REQUESTS_UTIL.Warn_same_qualifier_group(

534: THEN
535: oe_debug_pub.add('qual context'||l_request_rec.param3||' attr '||l_request_rec.param4||' grp no '||l_request_rec.param2);
536:
537: /*
538: QP_DELAYED_REQUESTS_UTIL.Warn_same_qualifier_group(
539: p_list_header_id => l_entity_id,
540: p_list_line_id => l_request_rec.param1,
541: p_qualifier_grouping_no => l_request_rec.param2,
542: p_qualifier_context => l_request_rec.param3,

Line 562: QP_DELAYED_REQUESTS_UTIL.Update_Line_Qualification_Ind

558: IF l_request_type = QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
559: THEN
560:
561: --dbms_output.put_line('calling line qualification indicator');
562: QP_DELAYED_REQUESTS_UTIL.Update_Line_Qualification_Ind
563: ( p_List_line_ID => l_entity_id
564: ,x_return_status => l_return_status);
565: END IF;
566:

Line 578: QP_DELAYED_REQUESTS_UTIL.update_pricing_phase(

574:
575: IF l_request_type = QP_GLOBALS.G_UPDATE_PRICING_PHASE
576: THEN
577: oe_debug_pub.add('processing req UPDATE_PRICING_PHASE');
578: QP_DELAYED_REQUESTS_UTIL.update_pricing_phase(
579: p_pricing_phase_id => l_request_rec.param1,
580: p_automatic_flag => l_request_rec.param2, --fix for bug 3756625
581: p_count => l_request_rec.param3,
582: p_call_from => l_request_rec.param4,

Line 596: QP_DELAYED_REQUESTS_UTIL.Update_manual_modifier_flag(

592: -- Essilor Fix bug 2789138
593: IF l_request_type = QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG
594: THEN
595: oe_debug_pub.add('processing req UPDATE_MANUAL_MODIFIER_FLAG');
596: QP_DELAYED_REQUESTS_UTIL.Update_manual_modifier_flag(
597: p_pricing_phase_id => l_request_rec.param1,
598: p_automatic_flag => l_request_rec.param2,
599: x_return_status => l_return_status);
600: END IF;

Line 612: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup (x_return_status => l_return_status);

608: --hvop
609: IF l_request_type = QP_GLOBALS.G_UPDATE_HVOP
610: THEN
611: oe_debug_pub.add('processing req UPDATE_HVOP');
612: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup (x_return_status => l_return_status);
613: END IF;
614:
615: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 627: QP_DELAYED_REQUESTS_UTIL.maintain_header_pattern(

623: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
624:
625: IF l_request_type = QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN THEN
626: oe_debug_pub.add('Processing req Attribute Groups');
627: QP_DELAYED_REQUESTS_UTIL.maintain_header_pattern(
628: p_list_header_id => l_request_rec.entity_Id
629: , p_qualifier_group => l_request_rec.request_unique_key1
630: , p_setup_action => l_request_rec.request_unique_key2
631: , x_return_status => l_return_status);

Line 640: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(

636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
639: oe_debug_pub.add('Processing req Attribute Groups');
640: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(
641: p_list_header_id => l_request_rec.entity_Id
642: , p_list_line_id => l_request_rec.request_unique_key1
643: , p_qualifier_group => l_request_rec.request_unique_key2
644: , p_setup_action => l_request_rec.request_unique_key3

Line 655: QP_DELAYED_REQUESTS_UTIL.maintain_product_pattern(

651: END IF;
652:
653: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN
654: oe_debug_pub.add('Processing req Attribute Groups');
655: QP_DELAYED_REQUESTS_UTIL.maintain_product_pattern(
656: p_list_header_id => l_request_rec.entity_Id
657: , p_list_line_id => l_request_rec.request_unique_key1
658: , p_setup_action => l_request_rec.request_unique_key2
659: , x_return_status => l_return_status);

Line 689: QP_DELAYED_REQUESTS_UTIL.maintain_header_pattern(

685: --AND ( l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIER_LIST OR l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIERS OR l_entity_code = QP_GLOBALS.G_ENTITY_ALL) THEN
686:
687: IF l_request_type = QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN THEN
688: oe_debug_pub.add('Processing req Attribute Groups');
689: QP_DELAYED_REQUESTS_UTIL.maintain_header_pattern(
690: p_list_header_id => l_request_rec.entity_Id
691: , p_qualifier_group => l_request_rec.request_unique_key1
692: , p_setup_action => l_request_rec.request_unique_key2
693: , x_return_status => l_return_status);

Line 703: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(

699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
702: oe_debug_pub.add('Processing req Attribute Groups');
703: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(
704: p_list_header_id => l_request_rec.entity_Id
705: , p_list_line_id => l_request_rec.request_unique_key1
706: , p_qualifier_group => l_request_rec.request_unique_key2
707: , p_setup_action => l_request_rec.request_unique_key3

Line 719: QP_DELAYED_REQUESTS_UTIL.maintain_product_pattern(

715: END IF;
716:
717: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN
718: oe_debug_pub.add('Processing req Attribute Groups');
719: QP_DELAYED_REQUESTS_UTIL.maintain_product_pattern(
720: p_list_header_id => l_request_rec.entity_Id
721: , p_list_line_id => l_request_rec.request_unique_key1
722: , p_setup_action => l_request_rec.request_unique_key2
723: , x_return_status => l_return_status);

Line 739: QP_DELAYED_REQUESTS_UTIL.validate_selling_rounding(

735: --pattern
736: IF l_request_type = QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING
737: THEN
738: oe_debug_pub.add('processing req VALIDATE_SELLING_ROUNDING');
739: QP_DELAYED_REQUESTS_UTIL.validate_selling_rounding(
740: p_currency_header_id => l_entity_id,
741: p_to_currency_code => l_request_rec.param1,
742: x_return_status => l_return_status);
743: END IF;

Line 755: QP_DELAYED_REQUESTS_UTIL.check_segment_level_in_group(

751:
752: IF l_request_type = QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP
753: THEN
754: oe_debug_pub.add('processing req CHECK_SEGMENT_LEVEL_IN_GROUP');
755: QP_DELAYED_REQUESTS_UTIL.check_segment_level_in_group(
756: p_list_line_id => l_entity_id,
757: p_list_header_id => l_request_rec.request_unique_key1,
758: p_qualifier_grouping_no => l_request_rec.request_unique_key2,
759: x_return_status => l_return_status);

Line 771: QP_DELAYED_REQUESTS_UTIL.CHECK_LINE_FOR_HEADER_QUAL(

767:
768: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
769: THEN
770: oe_debug_pub.add('processing req CHECK_LINE_FOR_HEADER_QUAL');
771: QP_DELAYED_REQUESTS_UTIL.CHECK_LINE_FOR_HEADER_QUAL(
772: p_list_header_id => l_entity_id,
773: p_list_line_id => l_request_rec.request_unique_key1,
774: x_return_status => l_return_status);
775: END IF;

Line 786: QP_DELAYED_REQUESTS_UTIL.Check_Enabled_Func_Areas(

782:
783: -- Hierarchical Categories (sfiresto)
784: IF l_request_type = QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS THEN
785: oe_debug_pub.add('processing req CHECK_ENABLED_FUNC_AREAS');
786: QP_DELAYED_REQUESTS_UTIL.Check_Enabled_Func_Areas(
787: p_pte_source_system_id => l_entity_id,
788: x_return_status => l_return_status);
789: END IF;
790:

Line 804: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_add(

800: if QP_PERF_PVT.enabled = 'Y' then
801:
802: if l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD then
803: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ADD');
804: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_add(
805: p_list_line_id => l_entity_id,
806: p_list_header_id => l_request_rec.param2,
807: p_pricing_phase_id => l_request_rec.param1,
808: x_return_status => l_return_status);

Line 811: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_del(

807: p_pricing_phase_id => l_request_rec.param1,
808: x_return_status => l_return_status);
809: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL then
810: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_DEL');
811: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_del(
812: p_list_line_id => l_entity_id,
813: p_list_header_id => l_request_rec.param2,
814: p_pricing_phase_id => l_request_rec.param1,
815: p_product_attribute => l_request_rec.param3,

Line 820: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_ph(

816: p_product_attr_value => l_request_rec.param4,
817: x_return_status => l_return_status);
818: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH then
819: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_PHASE');
820: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_ph(
821: p_list_line_id => l_entity_id,
822: p_list_header_id => l_request_rec.param2,
823: p_pricing_phase_id => l_request_rec.param1,
824: p_old_pricing_phase_id => l_request_rec.param3,

Line 828: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_act(

824: p_old_pricing_phase_id => l_request_rec.param3,
825: x_return_status => l_return_status);
826: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT then
827: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ACTIVE');
828: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_act(
829: p_list_header_id => l_entity_id,
830: p_active_flag => l_request_rec.param1,
831: x_return_status => l_return_status);
832: --hvop elsif l_request_type = QP_GLOBALS.G_UPDATE_HVOP then

Line 835: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup(x_return_status => l_return_status);

831: x_return_status => l_return_status);
832: --hvop elsif l_request_type = QP_GLOBALS.G_UPDATE_HVOP then
833: oe_debug_pub.add('processing req G_UPDATE_HVOP')
834: ;
835: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup(x_return_status => l_return_status);
836: --hvop
837: end if;
838: end if;
839: