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 2724: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

2720: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2721: IF l_debug_level > 0 THEN
2722: oe_debug_pub.add( 'HDR_ADJ_ID= ' || P_HEADER_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;
2723: END IF;
2724: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2725: p_Hdr_adj_rec =>p_header_adj_rec,
2726: p_hdr_adj_id => p_header_adj_rec.price_adjustment_id,
2727: x_index => l_index,
2728: x_return_status => l_return_status);

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

3115:
3116: -- calling notification framework to update global picture
3117: -- check code release level first. Notification framework is at Pack H level
3118: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3119: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3120: p_old_hdr_adj_rec => NULL,
3121: p_Hdr_adj_rec =>p_header_adj_rec,
3122: p_hdr_adj_id => p_header_adj_rec.price_adjustment_id,
3123: x_index => l_index,

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

3244: /* Set the operation on the record so that globals are updated as well */
3245: l_new_header_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3246: l_new_header_adj_rec.price_adjustment_id := l_adj.price_adjustment_id;
3247:
3248: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3249: p_Hdr_adj_rec =>l_new_header_adj_rec,
3250: p_hdr_adj_id => l_adj.price_adjustment_id,
3251: x_index => l_index,
3252: x_return_status => l_return_status);

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

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

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

4291: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
4292: END IF;
4293:
4294: IF (p_header_id IS NOT NULL AND
4295: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
4296: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4297: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4298: p_header_id=>p_header_id
4299: );

Line 4296: OR OE_ORDER_UTIL.G_Precision IS NULL THEN

4292: END IF;
4293:
4294: IF (p_header_id IS NOT NULL AND
4295: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
4296: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4297: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4298: p_header_id=>p_header_id
4299: );
4300: END IF;

Line 4297: Is_fmt:= OE_ORDER_UTIL.Get_Precision(

4293:
4294: IF (p_header_id IS NOT NULL AND
4295: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
4296: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4297: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4298: p_header_id=>p_header_id
4299: );
4300: END IF;
4301:

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

4299: );
4300: END IF;
4301:
4302: IF (p_line_id IS NOT NULL AND
4303: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
4304: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4305: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4306: p_line_id=>p_line_id
4307: );

Line 4304: OR OE_ORDER_UTIL.G_Precision IS NULL THEN

4300: END IF;
4301:
4302: IF (p_line_id IS NOT NULL AND
4303: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
4304: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4305: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4306: p_line_id=>p_line_id
4307: );
4308: END IF;

Line 4305: Is_fmt:= OE_ORDER_UTIL.Get_Precision(

4301:
4302: IF (p_line_id IS NOT NULL AND
4303: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
4304: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
4305: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
4306: p_line_id=>p_line_id
4307: );
4308: END IF;
4309:

Line 4310: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

4306: p_line_id=>p_line_id
4307: );
4308: END IF;
4309:
4310: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
4311: OE_ORDER_UTIL.G_Precision:=2;
4312: END IF;
4313:
4314:

Line 4311: OE_ORDER_UTIL.G_Precision:=2;

4307: );
4308: END IF;
4309:
4310: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
4311: OE_ORDER_UTIL.G_Precision:=2;
4312: END IF;
4313:
4314:
4315: -- Query total.

Line 4320: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))

4316: -- Separating into two separate SQLs for bug 3090569 --jvicenti
4317:
4318: IF p_header_id IS NOT NULL THEN
4319: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
4320: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
4321: INTO l_adj_total
4322: FROM oe_order_lines_all
4323: WHERE HEADER_ID = p_header_id
4324: AND charge_periodicity_code IS NULL -- addded for recurring charges

Line 4328: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))

4324: AND charge_periodicity_code IS NULL -- addded for recurring charges
4325: AND nvl(cancelled_flag,'N') ='N';
4326: ELSE
4327: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
4328: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
4329: INTO l_adj_total
4330: FROM oe_order_lines_all
4331: WHERE line_id = p_line_id
4332: AND nvl(cancelled_flag,'N') ='N';

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

5001: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
5002: END IF;
5003:
5004: IF (p_header_id IS NOT NULL AND
5005: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
5006: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5007: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5008: p_header_id=>p_header_id
5009: );

Line 5006: OR OE_ORDER_UTIL.G_Precision IS NULL THEN

5002: END IF;
5003:
5004: IF (p_header_id IS NOT NULL AND
5005: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
5006: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5007: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5008: p_header_id=>p_header_id
5009: );
5010: END IF;

Line 5007: Is_fmt:= OE_ORDER_UTIL.Get_Precision(

5003:
5004: IF (p_header_id IS NOT NULL AND
5005: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))
5006: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5007: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5008: p_header_id=>p_header_id
5009: );
5010: END IF;
5011:

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

5009: );
5010: END IF;
5011:
5012: IF (p_line_id IS NOT NULL AND
5013: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
5014: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5015: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5016: p_line_id=>p_line_id
5017: );

Line 5014: OR OE_ORDER_UTIL.G_Precision IS NULL THEN

5010: END IF;
5011:
5012: IF (p_line_id IS NOT NULL AND
5013: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
5014: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5015: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5016: p_line_id=>p_line_id
5017: );
5018: END IF;

Line 5015: Is_fmt:= OE_ORDER_UTIL.Get_Precision(

5011:
5012: IF (p_line_id IS NOT NULL AND
5013: NVL(p_Line_id,-1)<>NVL(OE_ORDER_UTIL.G_Line_id,-10))
5014: OR OE_ORDER_UTIL.G_Precision IS NULL THEN
5015: Is_fmt:= OE_ORDER_UTIL.Get_Precision(
5016: p_line_id=>p_line_id
5017: );
5018: END IF;
5019:

Line 5020: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

5016: p_line_id=>p_line_id
5017: );
5018: END IF;
5019:
5020: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
5021: OE_ORDER_UTIL.G_Precision:=2;
5022: END IF;
5023:
5024:

Line 5021: OE_ORDER_UTIL.G_Precision:=2;

5017: );
5018: END IF;
5019:
5020: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
5021: OE_ORDER_UTIL.G_Precision:=2;
5022: END IF;
5023:
5024:
5025: -- Query total.

Line 5030: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))

5026: -- Separating into two separate SQLs for bug 3090569 --jvicenti
5027:
5028: IF p_header_id IS NOT NULL THEN
5029: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
5030: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
5031: INTO l_adj_total
5032: FROM oe_order_lines_all
5033: WHERE HEADER_ID = p_header_id
5034: AND nvl(charge_periodicity_code,'ONE') = p_charge_periodicity_code