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_BULK_VALIDATE dependencies on QP_NUMBER

Line 3376: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) >=

3372: and pia.orig_sys_line_ref=pb.orig_sys_line_ref
3373: )
3374: -- Got the remaining Price Break Lines that are not being updated in this request
3375: AND (
3376: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3377: qp_number.canonical_to_number(pa.pricing_attr_value_to)
3378: ) -- New Price Break To is greater than (or equal to) New Price Break From
3379: OR
3380: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <

Line 3377: qp_number.canonical_to_number(pa.pricing_attr_value_to)

3373: )
3374: -- Got the remaining Price Break Lines that are not being updated in this request
3375: AND (
3376: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3377: qp_number.canonical_to_number(pa.pricing_attr_value_to)
3378: ) -- New Price Break To is greater than (or equal to) New Price Break From
3379: OR
3380: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3381: qp_number.canonical_to_number(pb.pricing_attr_value_to)

Line 3380: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <

3376: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3377: qp_number.canonical_to_number(pa.pricing_attr_value_to)
3378: ) -- New Price Break To is greater than (or equal to) New Price Break From
3379: OR
3380: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3381: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3382: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3383: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3384: ) -- New Price Break From in between Old Price Break

Line 3381: qp_number.canonical_to_number(pb.pricing_attr_value_to)

3377: qp_number.canonical_to_number(pa.pricing_attr_value_to)
3378: ) -- New Price Break To is greater than (or equal to) New Price Break From
3379: OR
3380: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3381: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3382: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3383: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3384: ) -- New Price Break From in between Old Price Break
3385: OR

Line 3382: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=

3378: ) -- New Price Break To is greater than (or equal to) New Price Break From
3379: OR
3380: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3381: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3382: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3383: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3384: ) -- New Price Break From in between Old Price Break
3385: OR
3386: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=

Line 3383: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3379: OR
3380: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3381: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3382: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3383: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3384: ) -- New Price Break From in between Old Price Break
3385: OR
3386: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3387: qp_number.canonical_to_number(pb.pricing_attr_value_to)

Line 3386: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=

3382: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3383: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3384: ) -- New Price Break From in between Old Price Break
3385: OR
3386: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3387: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3388: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3389: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3390: ) -- New Price Break To in between Old Price Break

Line 3387: qp_number.canonical_to_number(pb.pricing_attr_value_to)

3383: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3384: ) -- New Price Break From in between Old Price Break
3385: OR
3386: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3387: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3388: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3389: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3390: ) -- New Price Break To in between Old Price Break
3391: OR

Line 3388: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >

3384: ) -- New Price Break From in between Old Price Break
3385: OR
3386: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3387: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3388: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3389: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3390: ) -- New Price Break To in between Old Price Break
3391: OR
3392: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <

Line 3389: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3385: OR
3386: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3387: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3388: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3389: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3390: ) -- New Price Break To in between Old Price Break
3391: OR
3392: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3393: qp_number.canonical_to_number(pb.pricing_attr_value_from)

Line 3392: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <

3388: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3389: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3390: ) -- New Price Break To in between Old Price Break
3391: OR
3392: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3393: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3394: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3395: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3396: ) -- Old Price Break in between New Price Break

Line 3393: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3389: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3390: ) -- New Price Break To in between Old Price Break
3391: OR
3392: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3393: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3394: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3395: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3396: ) -- Old Price Break in between New Price Break
3397: );

Line 3394: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >

3390: ) -- New Price Break To in between Old Price Break
3391: OR
3392: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3393: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3394: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3395: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3396: ) -- Old Price Break in between New Price Break
3397: );
3398:

Line 3395: qp_number.canonical_to_number(pb.pricing_attr_value_to)

3391: OR
3392: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3393: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3394: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3395: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3396: ) -- Old Price Break in between New Price Break
3397: );
3398:
3399: Cursor C_old_cont_grp_break_line(p_orig_sys_line_ref VARCHAR2,

Line 3591: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369

3587: AND pa.request_id=p_request_id
3588: AND pb.request_id=p_request_id
3589: -- end changes
3590:
3591: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369
3592: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3593: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3594: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3595: OR

Line 3592: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND

3588: AND pb.request_id=p_request_id
3589: -- end changes
3590:
3591: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369
3592: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3593: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3594: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3595: OR
3596: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=

Line 3593: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=

3589: -- end changes
3590:
3591: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369
3592: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3593: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3594: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3595: OR
3596: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3597: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND

Line 3594: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3590:
3591: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369
3592: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3593: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3594: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3595: OR
3596: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3597: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3598: qp_number.canonical_to_number(pa.pricing_attr_value_to) >

Line 3596: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=

3592: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3593: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3594: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3595: OR
3596: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3597: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3598: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3599: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3600: OR

Line 3597: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND

3593: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3594: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3595: OR
3596: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3597: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3598: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3599: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3600: OR
3601: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=

Line 3598: qp_number.canonical_to_number(pa.pricing_attr_value_to) >

3594: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3595: OR
3596: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3597: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3598: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3599: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3600: OR
3601: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3602: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND

Line 3599: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3595: OR
3596: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3597: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3598: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3599: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3600: OR
3601: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3602: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3603: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=

Line 3601: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=

3597: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3598: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3599: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3600: OR
3601: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3602: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3603: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=
3604: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3605:

Line 3602: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND

3598: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3599: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3600: OR
3601: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3602: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3603: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=
3604: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3605:
3606: BEGIN

Line 3603: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=

3599: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3600: OR
3601: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3602: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3603: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=
3604: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3605:
3606: BEGIN
3607: qp_bulk_loader_pub.write_log('Entering Entity pricing attribute validation');

Line 3604: qp_number.canonical_to_number(pb.pricing_attr_value_to));

3600: OR
3601: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3602: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3603: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=
3604: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3605:
3606: BEGIN
3607: qp_bulk_loader_pub.write_log('Entering Entity pricing attribute validation');
3608: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);