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_HEADER_ADJ_UTIL dependencies on OE_ORDER_UTIL

Line 2781: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

2777: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add( 'HDR_ADJ_ID= ' || P_HEADER_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;
2780: END IF;
2781: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2782: p_Hdr_adj_rec =>p_header_adj_rec,
2783: p_hdr_adj_id => p_header_adj_rec.price_adjustment_id,
2784: x_index => l_index,
2785: x_return_status => l_return_status);

Line 3178: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

3174:
3175: -- calling notification framework to update global picture
3176: -- check code release level first. Notification framework is at Pack H level
3177: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3178: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3179: p_old_hdr_adj_rec => NULL,
3180: p_Hdr_adj_rec =>p_header_adj_rec,
3181: p_hdr_adj_id => p_header_adj_rec.price_adjustment_id,
3182: x_index => l_index,

Line 3307: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

3303: /* Set the operation on the record so that globals are updated as well */
3304: l_new_header_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3305: l_new_header_adj_rec.price_adjustment_id := l_adj.price_adjustment_id;
3306:
3307: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3308: p_Hdr_adj_rec =>l_new_header_adj_rec,
3309: p_hdr_adj_id => l_adj.price_adjustment_id,
3310: x_index => l_index,
3311: x_return_status => l_return_status);

Line 3369: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

3365:
3366: /* Set the operation on the record so that globals are updated as well */
3367: l_new_header_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3368: l_new_header_adj_rec.price_adjustment_id := p_price_adjustment_id;
3369: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3370: p_Hdr_adj_rec =>l_new_header_adj_rec,
3371: p_hdr_adj_id => p_price_adjustment_id,
3372: x_index => l_index,
3373: x_return_status => l_return_status);

Line 4354: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))

4350: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
4351: END IF;
4352:
4353: IF (p_header_id IS NOT NULL AND
4354: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
4355: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4356: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4357: p_header_id=>p_header_id
4358: );

Line 4355: OR OE_ORDER_UTIL.G_Precision IS NULL THEN

4351: END IF;
4352:
4353: IF (p_header_id IS NOT NULL AND
4354: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
4355: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4356: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4357: p_header_id=>p_header_id
4358: );
4359: END IF;

Line 4356: Is_fmt:= OE_ORDER_UTIL.Get_Precision(

4352:
4353: IF (p_header_id IS NOT NULL AND
4354: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
4355: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4356: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4357: p_header_id=>p_header_id
4358: );
4359: END IF;
4360:

Line 4362: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))

4358: );
4359: END IF;
4360:
4361: IF (p_line_id IS NOT NULL AND
4362: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
4363: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4364: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4365: p_line_id=>p_line_id
4366: );

Line 4363: OR OE_ORDER_UTIL.G_Precision IS NULL THEN

4359: END IF;
4360:
4361: IF (p_line_id IS NOT NULL AND
4362: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
4363: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4364: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4365: p_line_id=>p_line_id
4366: );
4367: END IF;

Line 4364: Is_fmt:= OE_ORDER_UTIL.Get_Precision(

4360:
4361: IF (p_line_id IS NOT NULL AND
4362: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
4363: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4364: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4365: p_line_id=>p_line_id
4366: );
4367: END IF;
4368:

Line 4369: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

4365: p_line_id=>p_line_id
4366: );
4367: END IF;
4368:
4369: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
4370: OE_ORDER_UTIL.G_Precision:=2;
4371: END IF;
4372:
4373:

Line 4370: OE_ORDER_UTIL.G_Precision:=2;

4366: );
4367: END IF;
4368:
4369: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
4370: OE_ORDER_UTIL.G_Precision:=2;
4371: END IF;
4372:
4373:
4374: -- Query total.

Line 4379: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))

4375: -- Separating into two separate SQLs for bug 3090569 --jvicenti
4376:
4377: IF p_header_id IS NOT NULL THEN
4378: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
4379: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
4380: INTO l_adj_total
4381: FROM oe_order_lines_all
4382: WHERE HEADER_ID = p_header_id
4383: AND charge_periodicity_code IS NULL -- addded for recurring charges

Line 4387: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))

4383: AND charge_periodicity_code IS NULL -- addded for recurring charges
4384: AND nvl(cancelled_flag,'N') ='N';
4385: ELSE
4386: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
4387: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
4388: INTO l_adj_total
4389: FROM oe_order_lines_all
4390: WHERE line_id = p_line_id
4391: AND nvl(cancelled_flag,'N') ='N';

Line 5161: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))

5157: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
5158: END IF;
5159:
5160: IF (p_header_id IS NOT NULL AND
5161: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
5162: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5163: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5164: p_header_id=>p_header_id
5165: );

Line 5162: OR OE_ORDER_UTIL.G_Precision IS NULL THEN

5158: END IF;
5159:
5160: IF (p_header_id IS NOT NULL AND
5161: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
5162: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5163: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5164: p_header_id=>p_header_id
5165: );
5166: END IF;

Line 5163: Is_fmt:= OE_ORDER_UTIL.Get_Precision(

5159:
5160: IF (p_header_id IS NOT NULL AND
5161: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
5162: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5163: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5164: p_header_id=>p_header_id
5165: );
5166: END IF;
5167:

Line 5169: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))

5165: );
5166: END IF;
5167:
5168: IF (p_line_id IS NOT NULL AND
5169: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
5170: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5171: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5172: p_line_id=>p_line_id
5173: );

Line 5170: OR OE_ORDER_UTIL.G_Precision IS NULL THEN

5166: END IF;
5167:
5168: IF (p_line_id IS NOT NULL AND
5169: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
5170: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5171: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5172: p_line_id=>p_line_id
5173: );
5174: END IF;

Line 5171: Is_fmt:= OE_ORDER_UTIL.Get_Precision(

5167:
5168: IF (p_line_id IS NOT NULL AND
5169: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
5170: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5171: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5172: p_line_id=>p_line_id
5173: );
5174: END IF;
5175:

Line 5176: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

5172: p_line_id=>p_line_id
5173: );
5174: END IF;
5175:
5176: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
5177: OE_ORDER_UTIL.G_Precision:=2;
5178: END IF;
5179:
5180:

Line 5177: OE_ORDER_UTIL.G_Precision:=2;

5173: );
5174: END IF;
5175:
5176: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
5177: OE_ORDER_UTIL.G_Precision:=2;
5178: END IF;
5179:
5180:
5181: -- Query total.

Line 5186: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))

5182: -- Separating into two separate SQLs for bug 3090569 --jvicenti
5183:
5184: IF p_header_id IS NOT NULL THEN
5185: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
5186: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
5187: INTO l_adj_total
5188: FROM oe_order_lines_all
5189: WHERE HEADER_ID = p_header_id
5190: AND nvl(charge_periodicity_code,'ONE') = p_charge_periodicity_code