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.OE_VERSION_PRICE_ADJUST_COMP dependencies on OE_VERSION_PRICE_ADJUST_COMP

Line 1: PACKAGE BODY OE_VERSION_PRICE_ADJUST_COMP AS

1: PACKAGE BODY OE_VERSION_PRICE_ADJUST_COMP AS
2: /* $Header: OEXPCOMB.pls 120.3 2006/06/08 22:27:28 sdatti noship $ */
3:
4: PROCEDURE QUERY_HEADER_ADJ_ROW
5: (p_header_id NUMBER,

Line 17: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_ROW');

13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14: BEGIN
15: oe_debug_pub.add('l_debug_level'||l_debug_level );
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_ROW');
18: oe_debug_pub.add('header' ||p_header_id);
19: oe_debug_pub.add('price adjust' ||p_price_adjustment_id);
20: oe_debug_pub.add('version' ||p_version);
21: END IF;

Line 270: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_TRANS_ROW', 1);

266: l_phase_change_flag VARCHAR2(1);
267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: BEGIN
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_TRANS_ROW', 1);
271: oe_debug_pub.add('header' ||p_header_id);
272: oe_debug_pub.add('hprice' ||p_price_adjustment_id);
273: oe_debug_pub.add('version' ||p_version);
274: END IF;

Line 518: x_header_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.header_adj_tbl_type,

514: g_trans_version NUMBER,
515: g_prior_phase_change_flag VARCHAR2,
516: g_curr_phase_change_flag VARCHAR2,
517: g_next_phase_change_flag VARCHAR2,
518: x_header_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.header_adj_tbl_type,
519: p_total_lines NUMBER)
520: IS
521:
522: p_curr_rec OE_Order_PUB.Header_adj_Rec_Type;

Line 571: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_ROW(p_header_id => p_header_id,

567: oe_debug_pub.add('prior version' ||p_prior_version);
568: END IF;
569:
570: IF p_prior_version IS NOT NULL THEN
571: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_ROW(p_header_id => p_header_id,
572: p_price_adjustment_id => p_price_adjustment_id,
573: p_version => p_prior_version,
574: p_phase_change_flag => g_prior_phase_change_flag,
575: x_header_adj_rec => p_prior_rec);

Line 588: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_ROW(p_header_id => p_header_id,

584: oe_debug_pub.add('current version' ||p_current_version);
585: END IF;
586:
587: IF p_current_version IS NOT NULL THEN
588: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_ROW(p_header_id => p_header_id,
589: p_price_adjustment_id => p_price_adjustment_id,
590: p_version => p_current_version,
591: p_phase_change_flag => g_curr_phase_change_flag,
592: x_header_adj_rec => p_curr_rec);

Line 608: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_TRANS_ROW(p_header_id => p_header_id,

604: END IF;
605:
606: IF p_next_version = g_trans_version then
607: IF g_trans_version is not null then
608: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_TRANS_ROW(p_header_id => p_header_id,
609: p_price_adjustment_id => p_price_adjustment_id,
610: p_version => p_next_version,
611: x_header_adj_rec => p_next_rec);
612: END IF;

Line 621: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_ROW(p_header_id => p_header_id,

617: p_next_rec_exists := 'Y';
618: END IF;
619: ELSE
620: IF p_next_version IS NOT NULL THEN
621: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_ROW(p_header_id => p_header_id,
622: p_price_adjustment_id => p_price_adjustment_id,
623: p_version => p_next_version,
624: p_phase_change_flag => g_next_phase_change_flag,
625: x_header_adj_rec => p_next_rec);

Line 2905: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_header_adj_Attributes ');

2901: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
2902: oe_debug_pub.add('current ind '|| ind);
2903: END IF;
2904: IF l_debug_level > 0 THEN
2905: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_header_adj_Attributes ');
2906: END IF;
2907: /*
2908: j := 0;
2909: dbms_output.put_line('No of records'||x_header_adj_changed_attr_tbl.count);

Line 2931: x_header_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.header_adj_tbl_type)

2927: g_trans_version NUMBER,
2928: g_prior_phase_change_flag VARCHAR2,
2929: g_curr_phase_change_flag VARCHAR2,
2930: g_next_phase_change_flag VARCHAR2,
2931: x_header_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.header_adj_tbl_type)
2932: IS
2933:
2934: CURSOR C_get_adjustments(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
2935: SELECT distinct price_adjustment_id

Line 3066: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_ROW');

3062: l_phase_change_flag VARCHAR2(1);
3063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3064: BEGIN
3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_ROW');
3067: oe_debug_pub.add('header' ||p_header_id);
3068: oe_debug_pub.add('header' ||p_price_adjustment_id);
3069: oe_debug_pub.add('version' ||p_version);
3070: END IF;

Line 3320: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_TRANS_ROW' );

3316: l_phase_change_flag VARCHAR2(1);
3317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3318: BEGIN
3319: IF l_debug_level > 0 THEN
3320: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_TRANS_ROW' );
3321: oe_debug_pub.add('header' ||p_header_id);
3322: oe_debug_pub.add('price' ||p_price_adjustment_id);
3323: oe_debug_pub.add('version' ||p_version);
3324: END IF;

Line 3570: x_line_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.line_adj_tbl_type,

3566: g_trans_version NUMBER,
3567: g_prior_phase_change_flag VARCHAR2,
3568: g_curr_phase_change_flag VARCHAR2,
3569: g_next_phase_change_flag VARCHAR2,
3570: x_line_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.line_adj_tbl_type,
3571: p_total_lines NUMBER,
3572: x_line_number VARCHAR2)
3573: IS
3574: p_curr_rec OE_Order_PUB.line_adj_Rec_Type;

Line 3623: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_ROW(p_header_id => p_header_id,

3619: oe_debug_pub.add('prior version' ||p_prior_version);
3620: END IF;
3621:
3622: IF p_prior_version IS NOT NULL THEN
3623: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_ROW(p_header_id => p_header_id,
3624: p_price_adjustment_id => p_price_adjustment_id,
3625: p_version => p_prior_version,
3626: p_phase_change_flag => g_prior_phase_change_flag,
3627: x_line_adj_rec => p_prior_rec);

Line 3640: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_ROW(p_header_id => p_header_id,

3636: oe_debug_pub.add('current version' ||p_current_version);
3637: END IF;
3638:
3639: IF p_current_version IS NOT NULL THEN
3640: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_ROW(p_header_id => p_header_id,
3641: p_price_adjustment_id => p_price_adjustment_id,
3642: p_version => p_current_version,
3643: p_phase_change_flag => g_curr_phase_change_flag,
3644: x_line_adj_rec => p_curr_rec);

Line 3660: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_TRANS_ROW(p_header_id => p_header_id,

3656: END IF;
3657:
3658: IF p_next_version = g_trans_version then
3659: IF g_trans_version is not null then
3660: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_TRANS_ROW(p_header_id => p_header_id,
3661: p_price_adjustment_id => p_price_adjustment_id,
3662: p_version => p_next_version,
3663: x_line_adj_rec => p_next_rec);
3664: END IF;

Line 3673: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_ROW(p_header_id => p_header_id,

3669: p_next_rec_exists := 'Y';
3670: END IF;
3671: ELSE
3672: IF p_next_version IS NOT NULL THEN
3673: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_ROW(p_header_id => p_header_id,
3674: p_price_adjustment_id => p_price_adjustment_id,
3675: p_version => p_next_version,
3676: p_phase_change_flag => g_next_phase_change_flag,
3677: x_line_adj_rec => p_next_rec);

Line 6109: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_line_adj_Attributes ');

6105: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
6106: oe_debug_pub.add('current ind '|| ind);
6107: END IF;
6108: IF l_debug_level > 0 THEN
6109: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_line_adj_Attributes ');
6110: END IF;
6111: /*
6112: j := 0;
6113: dbms_output.put_line('No of resales dreditcords'||x_line_adj_changed_attr_tbl.count);

Line 6135: x_line_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.line_adj_tbl_type)

6131: g_trans_version NUMBER,
6132: g_prior_phase_change_flag VARCHAR2,
6133: g_curr_phase_change_flag VARCHAR2,
6134: g_next_phase_change_flag VARCHAR2,
6135: x_line_adj_changed_attr_tbl IN OUT NOCOPY OE_VERSION_PRICE_ADJUST_COMP.line_adj_tbl_type)
6136: IS
6137:
6138: CURSOR C_get_adjustments(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
6139: SELECT distinct price_adjustment_id,line_id

Line 6336: END OE_VERSION_PRICE_ADJUST_COMP;

6332: Return NULL;
6333: END get_dff_seg_prompt;
6334: --bug 4302049
6335:
6336: END OE_VERSION_PRICE_ADJUST_COMP;