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_ORDER_PRICE_PVT dependencies on OE_ORDER_PUB

Line 236: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

232: -- Function Query_Header
233:
234: PROCEDURE Query_Header
235: ( p_header_id IN NUMBER,
236: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
237: )
238: IS
239: l_org_id NUMBER;
240: l_x_header_rec_oper VARCHAR2(30);

Line 338: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

334:
335: PROCEDURE Query_Lines
336: ( p_line_id IN NUMBER
337: , p_header_id IN NUMBER
338: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
339: )
340: IS
341: l_org_id NUMBER;
342: l_count NUMBER;

Line 634: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

630: -- Procedure Query_Line
631:
632: PROCEDURE Query_Line
633: ( p_line_id IN NUMBER
634: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
635: )
636: IS
637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
638: --

Line 637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

633: ( p_line_id IN NUMBER
634: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
635: )
636: IS
637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
638: --
639: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
640: --
641: BEGIN

Line 672: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null

668: begin
669:
670: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
671: -- changes for bug 4200055
672: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
673: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
674: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
675: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
676: end if ;

Line 673: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN

669:
670: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
671: -- changes for bug 4200055
672: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
673: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
674: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
675: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
676: end if ;
677: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then

Line 674: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then

670: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
671: -- changes for bug 4200055
672: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
673: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
674: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
675: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
676: end if ;
677: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
678: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;

Line 675: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;

671: -- changes for bug 4200055
672: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
673: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
674: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
675: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
676: end if ;
677: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
678: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;
679: else

Line 677: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then

673: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
674: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
675: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
676: end if ;
677: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
678: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;
679: else
680: l_enforce_price_flag := 'N';
681: end if ;

Line 686: from oe_line_types_v where line_type_id=OE_Order_PUB.G_Line.Line_Type_id; */

682: ELSE
683: l_enforce_price_flag := 'N';
684: END IF ;
685: /* select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
686: from oe_line_types_v where line_type_id=OE_Order_PUB.G_Line.Line_Type_id; */
687: --end bug 4200055
688: -- exception when no_data_found then
689: exception when others then
690: l_enforce_price_flag := 'N';

Line 697: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null

693: If l_enforce_price_flag='N' then
694: begin
695: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
696: --changes for bug 4200055
697: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
698: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
699: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
700: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
701: end if ;

Line 698: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN

694: begin
695: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
696: --changes for bug 4200055
697: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
698: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
699: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
700: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
701: end if ;
702: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

Line 699: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then

695: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
696: --changes for bug 4200055
697: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
698: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
699: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
700: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
701: end if ;
702: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
703: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;

Line 700: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;

696: --changes for bug 4200055
697: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
698: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
699: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
700: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
701: end if ;
702: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
703: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;
704: else

Line 702: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

698: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
699: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
700: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
701: end if ;
702: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
703: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;
704: else
705: l_enforce_price_flag := 'N';
706: end if ;

Line 711: from oe_Order_types_v where Order_type_id=OE_Order_PUB.g_hdr.Order_Type_Id;*/

707: ELSE
708: l_enforce_price_flag := 'N';
709: END IF ;
710: /*select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
711: from oe_Order_types_v where Order_type_id=OE_Order_PUB.g_hdr.Order_Type_Id;*/
712: -- end bug 4200055
713: -- exception when no_data_found then
714: exception when others then
715: l_enforce_price_flag := 'N';

Line 1746: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type

1742: end Append_asked_for;
1743:
1744: procedure Get_the_parent_Line(
1745: p_Reference_line_Id Number
1746: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
1747: , p_line_Tbl_index Number
1748: )
1749: is
1750: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

Line 1750: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

1746: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
1747: , p_line_Tbl_index Number
1748: )
1749: is
1750: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1751: line_Tbl_Index pls_integer;
1752: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1754: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 1823: IF (nvl(l_transactional_curr_code, 'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX')) THEN

1819: oe_debug_pub.add('pviprana: l_conversion_rate_date ' || l_conversion_rate_date);
1820: oe_debug_pub.add('pviprana: l_conversion_rate' || l_conversion_rate);
1821: END IF;
1822:
1823: IF (nvl(l_transactional_curr_code, 'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX')) THEN
1824: IF (nvl(l_transactional_curr_code, 'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1825: (l_conversion_type_code IS NULL OR
1826: (l_conversion_type_code= 'User' AND
1827: l_conversion_rate IS NULL))) OR

Line 1828: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND

1824: IF (nvl(l_transactional_curr_code, 'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1825: (l_conversion_type_code IS NULL OR
1826: (l_conversion_type_code= 'User' AND
1827: l_conversion_rate IS NULL))) OR
1828: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1829: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1830: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1831: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1832: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');

Line 1829: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR

1825: (l_conversion_type_code IS NULL OR
1826: (l_conversion_type_code= 'User' AND
1827: l_conversion_rate IS NULL))) OR
1828: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1829: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1830: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1831: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1832: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1833: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);

Line 1830: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND

1826: (l_conversion_type_code= 'User' AND
1827: l_conversion_rate IS NULL))) OR
1828: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1829: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1830: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1831: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1832: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1833: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1834: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);

Line 1831: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN

1827: l_conversion_rate IS NULL))) OR
1828: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1829: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1830: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1831: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1832: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1833: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1834: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);
1835: FND_MESSAGE.SET_TOKEN('FUNC_CURR', l_set_of_books.currency_code);

Line 1833: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);

1829: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1830: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1831: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1832: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1833: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1834: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);
1835: FND_MESSAGE.SET_TOKEN('FUNC_CURR', l_set_of_books.currency_code);
1836: OE_MSG_PUB.Add;
1837: px_Line_Tbl(line_Tbl_index).unit_list_price := null;

Line 1861: IF nvl(l_set_of_books.currency_code,'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') THEN

1857: );
1858:
1859: END IF;
1860:
1861: IF nvl(l_set_of_books.currency_code,'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') THEN
1862: IF l_debug_level > 0 THEN
1863: oe_debug_pub.add('pviprana: second conversion: conversion_type is '|| oe_order_pub.g_hdr.conversion_type_code);
1864: END IF;
1865: gl_currency_api.convert_closest_amount

Line 1863: oe_debug_pub.add('pviprana: second conversion: conversion_type is '|| oe_order_pub.g_hdr.conversion_type_code);

1859: END IF;
1860:
1861: IF nvl(l_set_of_books.currency_code,'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') THEN
1862: IF l_debug_level > 0 THEN
1863: oe_debug_pub.add('pviprana: second conversion: conversion_type is '|| oe_order_pub.g_hdr.conversion_type_code);
1864: END IF;
1865: gl_currency_api.convert_closest_amount
1866: ( x_from_currency => l_set_of_books.currency_code
1867: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code

Line 1867: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code

1863: oe_debug_pub.add('pviprana: second conversion: conversion_type is '|| oe_order_pub.g_hdr.conversion_type_code);
1864: END IF;
1865: gl_currency_api.convert_closest_amount
1866: ( x_from_currency => l_set_of_books.currency_code
1867: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code
1868: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)
1869: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code
1870: , x_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1871: , x_user_rate => oe_order_pub.g_hdr.conversion_rate

Line 1868: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)

1864: END IF;
1865: gl_currency_api.convert_closest_amount
1866: ( x_from_currency => l_set_of_books.currency_code
1867: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code
1868: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)
1869: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code
1870: , x_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1871: , x_user_rate => oe_order_pub.g_hdr.conversion_rate
1872: , x_max_roll_days => -1

Line 1869: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code

1865: gl_currency_api.convert_closest_amount
1866: ( x_from_currency => l_set_of_books.currency_code
1867: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code
1868: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)
1869: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code
1870: , x_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1871: , x_user_rate => oe_order_pub.g_hdr.conversion_rate
1872: , x_max_roll_days => -1
1873: , x_converted_amount => px_Line_Tbl(line_Tbl_index).unit_list_price

Line 1871: , x_user_rate => oe_order_pub.g_hdr.conversion_rate

1867: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code
1868: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)
1869: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code
1870: , x_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1871: , x_user_rate => oe_order_pub.g_hdr.conversion_rate
1872: , x_max_roll_days => -1
1873: , x_converted_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1874: , x_denominator => l_denominator
1875: , x_numerator => l_numerator

Line 1971: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type

1967: End Get_the_parent_Line;
1968:
1969: procedure Get_PRG_Lines(
1970: p_line_Id Number
1971: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
1972: , p_line_Tbl_index Number
1973: )
1974: is
1975: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

Line 1975: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

1971: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
1972: , p_line_Tbl_index Number
1973: )
1974: is
1975: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1976: line_Tbl_Index pls_integer;
1977: Cursor prg_lines is
1978: select adj1.line_id prg_line_id, assoc.rltd_price_adj_id
1979: from oe_price_adjustments adj1,

Line 2027: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type

2023: -- in the case of overriding the list price of the parent
2024: procedure Get_Service_Lines(
2025: p_line_Id Number
2026: , p_header_id Number
2027: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
2028: , p_line_Tbl_index Number
2029: )
2030: is
2031: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

Line 2031: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

2027: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
2028: , p_line_Tbl_index Number
2029: )
2030: is
2031: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
2032: line_Tbl_Index pls_integer;
2033:
2034: CURSOR service_lines is
2035: select line_id from oe_order_lines_all

Line 2074: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)

2070: End LOOP;
2071: END Get_Service_Lines;
2072: -- 3529369
2073:
2074: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)
2075: is
2076: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
2077: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2078: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/

Line 2199: PROCEDURE UPDATE_GLOBAL(p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,

2195: oe_debug_pub.add( L_ROUTINE||': '||SQLERRM , 1 ) ;
2196: END IF;
2197: END reset_all_tbls;
2198:
2199: PROCEDURE UPDATE_GLOBAL(p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
2200: p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE)
2201: IS
2202: l_notify_index NUMBER;
2203: l_return_status VARCHAR2(1);

Line 2200: p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE)

2196: END IF;
2197: END reset_all_tbls;
2198:
2199: PROCEDURE UPDATE_GLOBAL(p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
2200: p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE)
2201: IS
2202: l_notify_index NUMBER;
2203: l_return_status VARCHAR2(1);
2204: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

Line 2204: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2200: p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE)
2201: IS
2202: l_notify_index NUMBER;
2203: l_return_status VARCHAR2(1);
2204: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2205: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2206: --
2207: BEGIN
2208: l_line_rec:= p_line_rec;

Line 2283: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE

2279: END;
2280:
2281:
2282: PROCEDURE POPULATE_LINE_TBL(
2283: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
2284: )
2285: IS
2286: lx_old_line_price_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
2287: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 2286: lx_old_line_price_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

2282: PROCEDURE POPULATE_LINE_TBL(
2283: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
2284: )
2285: IS
2286: lx_old_line_price_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
2287: l_control_rec OE_GLOBALS.Control_Rec_Type;
2288: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2289: l_call_lines BOOLEAN := FALSE;
2290: l_check_sec BOOLEAN := FALSE;

Line 2292: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2288: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2289: l_call_lines BOOLEAN := FALSE;
2290: l_check_sec BOOLEAN := FALSE;
2291: l_line_index NUMBER;
2292: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2293: --
2294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2295: --
2296: l_validate_desc_flex varchar2(1) := 'N';

Line 2421: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE,

2417: --bug 3702538
2418: END POPULATE_LINE_TBL;
2419:
2420: PROCEDURE SECURITY_AND_GLOBAL_PICTURE(
2421: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE,
2422: p_write_to_db IN BOOLEAN
2423: )
2424: IS
2425: l_line_index NUMBER;

Line 2426: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2422: p_write_to_db IN BOOLEAN
2423: )
2424: IS
2425: l_line_index NUMBER;
2426: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2427: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2428: l_sec_result varchar2(1);
2429: l_return_status varchar2(1);
2430: --

Line 2427: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2423: )
2424: IS
2425: l_line_index NUMBER;
2426: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2427: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2428: l_sec_result varchar2(1);
2429: l_return_status varchar2(1);
2430: --
2431: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2621: l_header_id NUMBER:=oe_order_pub.g_hdr.header_id;

2617: l_x_msg_count number;
2618: l_x_msg_data Varchar2(2000);
2619: l_x_result_out Varchar2(30);
2620: l_msg_text Varchar2(200);
2621: l_header_id NUMBER:=oe_order_pub.g_hdr.header_id;
2622: --bug 2028480 begin
2623: l_gsa_released varchar2(1) := 'N';
2624: --bug 2028480 end
2625: CURSOR gsa_violators IS

Line 2849: px_header_rec IN OE_ORDER_PUB.HEADER_REC_TYPE

2845: END IF; -- gsa_enabled
2846: END Check_GSA;
2847:
2848: PROCEDURE UPDATE_ORDER_HEADER(
2849: px_header_rec IN OE_ORDER_PUB.HEADER_REC_TYPE
2850: )
2851: IS
2852: --
2853: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2892: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE

2888:
2889: END UPDATE_ORDER_HEADER;
2890:
2891: PROCEDURE LOG_REQUEST(
2892: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
2893: )
2894: IS
2895: l_verify_payment varchar2(1);
2896: l_commitment_sequencing boolean

Line 2902: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2898: l_return_status varchar2(1);
2899: l_tax_event_code number := 0;
2900: l_tax_calculation_flag varchar2(1):=NULL;
2901: l_tax_calc_rec OE_ORDER_CACHE.Tax_Calc_Rec_Type;
2902: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2903: l_order_adj_changed_flag varchar2(1);
2904: l_commt_tax_flag varchar2(1); --bug 2505961
2905: cursor updated_lines IS
2906: SELECT l.LINE_ID

Line 2961: IF OE_Order_pub.g_hdr.order_type_id is not null THEN

2957: Begin
2958:
2959: -- Log delayed requests for the attributes change on the line
2960: BEGIN
2961: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2962:
2963: --changes for bug 4200055
2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then

Line 2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN

2960: BEGIN
2961: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2962:
2963: --changes for bug 4200055
2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

Line 2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then

2961: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2962:
2963: --changes for bug 4200055
2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2969: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

Line 2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;

2962:
2963: --changes for bug 4200055
2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2969: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2970: l_tax_event_code := 0;

Line 2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

2964: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2965: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2966: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2967: end if ;
2968: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2969: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2970: l_tax_event_code := 0;
2971: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2972: l_tax_event_code := 1;

Line 2994: where transaction_type_id = OE_Order_pub.g_hdr.order_type_id;*/

2990: 'INVOICING', 3,
2991: -1)
2992: into l_tax_event_code
2993: from oe_transaction_types_all
2994: where transaction_type_id = OE_Order_pub.g_hdr.order_type_id;*/
2995: -- end bug 4200055
2996: END IF;
2997:
2998: EXCEPTION

Line 3115: --IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' THEN --CC Reversal ER#16014135 Commented

3111: oe_globals.g_tax_flag := 'N';
3112: END IF;
3113:
3114: l_verify_payment := 'N';
3115: --IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' THEN --CC Reversal ER#16014135 Commented
3116: IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' AND OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code( oe_order_pub.g_hdr.header_id) IS NULL THEN --CC Reversal ER#16014135
3117: IF l_debug_level > 0 THEN
3118: oe_debug_pub.add( 'CREDIT CARD:'||UPDATE_LINE.ADJUSTED_UNIT_PRICE||'>'||UPDATE_LINE.UNIT_SELLING_PRICE_PER_PQTY||'?' ) ;
3119: END IF;

Line 3116: IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' AND OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code( oe_order_pub.g_hdr.header_id) IS NULL THEN --CC Reversal ER#16014135

3112: END IF;
3113:
3114: l_verify_payment := 'N';
3115: --IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' THEN --CC Reversal ER#16014135 Commented
3116: IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' AND OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code( oe_order_pub.g_hdr.header_id) IS NULL THEN --CC Reversal ER#16014135
3117: IF l_debug_level > 0 THEN
3118: oe_debug_pub.add( 'CREDIT CARD:'||UPDATE_LINE.ADJUSTED_UNIT_PRICE||'>'||UPDATE_LINE.UNIT_SELLING_PRICE_PER_PQTY||'?' ) ;
3119: END IF;
3120: IF update_line.adjusted_unit_price > update_line.unit_selling_price_per_pqty or

Line 3137: oe_debug_pub.add( 'PAYMENT TYPE:'||OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE||' BOOKED?'||UPDATE_LINE.BOOKED_FLAG ) ;

3133: END IF;
3134: END IF;
3135: ELSE
3136: IF l_debug_level > 0 THEN
3137: oe_debug_pub.add( 'PAYMENT TYPE:'||OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE||' BOOKED?'||UPDATE_LINE.BOOKED_FLAG ) ;
3138: END IF;
3139: IF nvl(update_line.booked_flag,'X') = 'Y' THEN
3140: IF l_debug_level > 0 THEN
3141: oe_debug_pub.add( 'LOG VERIFY PAYMENT REQUEST' ) ;

Line 3153: p_entity_id => oe_order_pub.g_hdr.header_id,

3149: END IF;
3150: --
3151: OE_delayed_requests_Pvt.log_request
3152: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3153: p_entity_id => oe_order_pub.g_hdr.header_id,
3154: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3155: p_requesting_entity_id => update_line.line_id,
3156: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
3157: x_return_status => l_return_status);

Line 3318: p_entity_id => oe_order_pub.g_hdr.header_id,

3314: oe_debug_pub.add( 'LOGGING REQUEST TO UPDATE ALL LINES FOR HEADER LEVEL ADJUSTMENT.' , 1 ) ;
3315: END IF;
3316: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
3317: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3318: p_entity_id => oe_order_pub.g_hdr.header_id,
3319: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3320: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3321: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
3322: x_return_status => l_return_status);

Line 3320: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,

3316: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
3317: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3318: p_entity_id => oe_order_pub.g_hdr.header_id,
3319: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3320: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3321: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
3322: x_return_status => l_return_status);
3323:
3324: END IF;

Line 3351: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE

3347: raise fnd_api.g_exc_error;
3348: End LOG_REQUEST;
3349:
3350: PROCEDURE UPDATE_ORDER_LINES(
3351: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
3352: , x_num_changed_lines OUT NOCOPY NUMBER
3353: ,p_write_to_db BOOLEAN DEFAULT FALSE
3354: )
3355: IS

Line 3477: --l.header_id=oe_order_pub.g_hdr.header_id

3473: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3474: and lines.process_status <> 'NOT_VALID'
3475: )
3476: where
3477: --l.header_id=oe_order_pub.g_hdr.header_id
3478: --and
3479: l.ordered_quantity <> 0
3480: and l.open_flag <> 'N'
3481: and l.line_id in (select line_id from qp_preq_lines_tmp lines

Line 3526: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

3522: p_applied_flag_tbl IN OUT NOCOPY VARCHAR_TYPE,
3523: p_adjusted_amount_tbl IN OUT NOCOPY NUMBER_TYPE
3524: ) IS
3525: i NUMBER;
3526: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3527: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; -- bug 8415941
3528: l_return_status VARCHAR2(30);
3529: l_index NUMBER;
3530: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;

Line 3527: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; -- bug 8415941

3523: p_adjusted_amount_tbl IN OUT NOCOPY NUMBER_TYPE
3524: ) IS
3525: i NUMBER;
3526: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3527: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; -- bug 8415941
3528: l_return_status VARCHAR2(30);
3529: l_index NUMBER;
3530: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
3531:

Line 3689: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id

3685: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION
3686: )
3687: THEN
3688: DELETE FROM OE_PRICE_ADJUSTMENTS
3689: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id
3690: AND LINE_ID IS NULL
3691: --AND LIST_LINE_TYPE_CODE NOT IN ('TAX') --Bug 13573144
3692: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','TSN') --Bug 13573144
3693: AND NVL(UPDATED_FLAG, 'N')='N'

Line 3707: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)

3703: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3704: QP_PREQ_GRP.G_STATUS_UPDATED,
3705: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3706: and ld.line_index = p_hdr_line_index
3707: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)
3708: returning price_adjustment_id,
3709: header_id,
3710: line_id,
3711: list_line_id,

Line 3764: WHERE --HEADER_ID=oe_order_pub.g_hdr.header_id

3760: l_line_type_code := 'LINE';
3761: For one_line in updated_order_lines(l_line_type_code) loop
3762: DELETE /*+ index (adj oe_price_adjustments_n2) */
3763: FROM OE_PRICE_ADJUSTMENTS adj
3764: WHERE --HEADER_ID=oe_order_pub.g_hdr.header_id
3765: LINE_ID = one_line.line_id
3766: --AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE') --bug 2858712 --Bug 13573144
3767: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE','TSN') --Bug 13573144
3768: AND NVL(UPDATED_FLAG, 'N')='N'

Line 3847: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id

3843: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3844: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3845:
3846: DELETE FROM OE_PRICE_ADJUSTMENTS
3847: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id
3848: AND LINE_ID=p_line_id
3849: AND NVL(UPDATED_FLAG, 'N')='N'
3850: AND PRICING_PHASE_ID IN (select b.pricing_phase_id
3851: from qp_event_phases a,

Line 4150: adj.header_id=oe_order_pub.g_hdr.header_id

4146: from OE_PRICE_ADJUSTMENTS adj
4147: , QP_LDETS_v ldets
4148: , QP_PREQ_LINES_TMP lines
4149: WHERE
4150: adj.header_id=oe_order_pub.g_hdr.header_id
4151: and lines.line_index = ldets.line_index
4152: and lines.process_status <> 'NOT_VALID'
4153: and ldets.list_line_id = adj.list_line_id
4154: and lines.line_type_code='ORDER' and lines.line_id=adj.header_id

Line 4196: adj.header_id=oe_order_pub.g_hdr.header_id

4192: from OE_PRICE_ADJUSTMENTS adj
4193: , QP_LDETS_v ldets
4194: , QP_PREQ_LINES_TMP lines
4195: WHERE
4196: adj.header_id=oe_order_pub.g_hdr.header_id
4197: and lines.line_index = ldets.line_index
4198: and lines.process_status <> 'NOT_VALID'
4199: and ldets.list_line_id = adj.list_line_id
4200: and lines.line_type_code='LINE' and lines.line_id=adj.line_id

Line 4486: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id

4482: , NULL --p_Line_Adj_rec.program_application_id
4483: , NULL --p_Line_Adj_rec.program_id
4484: , NULL --p_Line_Adj_rec.program_update_date
4485: , NULL --p_Line_Adj_rec.request_id
4486: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
4487: , NULL --p_Line_Adj_rec.discount_id
4488: , NULL --p_Line_Adj_rec.discount_line_id
4489: , ldets.automatic_flag
4490: , NULL --p_Line_Adj_rec.percent

Line 4738: --AND LDETS.LINE_INDEX = oe_order_pub.g_hdr.header_id + l_line_id_tbl(i)

4734: --AND LDETS.LIST_LINE_ID = l_list_line_id_tbl(i)
4735: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4736: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4737: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID
4738: --AND LDETS.LINE_INDEX = oe_order_pub.g_hdr.header_id + l_line_id_tbl(i)
4739: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4740: ) ;
4741: IF l_debug_level > 0 THEN
4742: oe_debug_pub.add( 'DELETED '||SQL%ROWCOUNT||' ATTRIBUTES' ) ;

Line 4993: AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id

4989: , OE_PRICE_ADJUSTMENTS ADJ
4990: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4991: -- AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4992: AND ADJ.LINE_ID IS NULL
4993: AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4994: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4995: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4996: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4997: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW

Line 4999: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id

4995: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4996: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4997: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4998: AND LDETS.LINE_INDEX = l_hdr_line_index
4999: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id
5000: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
5001: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
5002: );
5003: l_stmt:=14;

Line 5057: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id

5053: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
5054: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
5055: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
5056: AND LDETS.LINE_INDEX = QPLINE.LINE_INDEX
5057: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
5058: AND QPLINE.LINE_ID = ADJ.LINE_ID
5059: AND QPLINE.LINE_TYPE_CODE = 'LINE'
5060: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
5061: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)

Line 5152: p_header_rec OE_Order_PUB.Header_Rec_Type

5148: --end AG change
5149:
5150: -- AG change --
5151: procedure copy_Header_to_request(
5152: p_header_rec OE_Order_PUB.Header_Rec_Type
5153: ,px_req_line_tbl in out NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE
5154: --,p_pricing_event varchar2
5155: ,p_Request_Type_Code varchar2
5156: ,p_calculate_price_flag varchar2

Line 5272: p_Line_rec OE_Order_PUB.Line_Rec_Type

5268:
5269: end copy_Header_to_request;
5270:
5271: procedure copy_Line_to_request(
5272: p_Line_rec OE_Order_PUB.Line_Rec_Type
5273: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
5274: ,p_pricing_events varchar2
5275: ,p_request_type_code varchar2
5276: ,p_honor_price_flag varchar2

Line 5296: l_ref_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

5292: l_shipped_quantity2 NUMBER;
5293: x_item_rec OE_Order_Cache.Item_Rec_Type;
5294: l_fulfilled_qty NUMBER;
5295: --16206165 CW Start
5296: l_ref_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
5297: l_catch_weight_pricing varchar2(1) := NULL;
5298: --16206165 CW End
5299:
5300:

Line 5370: OE_Order_PUB.g_hdr.transactional_curr_code;

5366: l_req_line_rec.PRICED_QUANTITY := p_Line_rec.pricing_quantity;
5367: l_req_line_rec.PRICED_UOM_CODE := p_Line_rec.pricing_quantity_uom;
5368:
5369: l_req_line_rec.CURRENCY_CODE :=
5370: OE_Order_PUB.g_hdr.transactional_curr_code;
5371: IF l_debug_level > 0 THEN
5372: oe_debug_pub.add( 'UNIT PRICE'||P_LINE_REC.UNIT_LIST_PRICE||L_REQ_LINE_REC.CURRENCY_CODE , 3 ) ;
5373: END IF;
5374: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then

Line 5543: l_req_line_rec.Active_date_first := OE_Order_Pub.G_HDR.Ordered_date;

5539: oe_debug_pub.add( 'ITEM TYPE CODE'||P_LINE_REC.ITEM_TYPE_CODE , 3 ) ;
5540: END IF;
5541:
5542: l_req_line_rec.Active_date_first_type := 'ORD';
5543: l_req_line_rec.Active_date_first := OE_Order_Pub.G_HDR.Ordered_date;
5544:
5545: If p_Line_rec.schedule_ship_date is not null then
5546: l_req_line_rec.Active_date_Second_type := 'SHIP';
5547: l_req_line_rec.Active_date_Second := p_Line_rec.schedule_ship_date;

Line 6130: x_line_tbl OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE ) AS

6126:
6127:
6128: -- bug4529937
6129: PROCEDURE Query_Changed_Lines(p_header_id IN NUMBER,
6130: x_line_tbl OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE ) AS
6131: i PLS_INTEGER;
6132: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
6133: j PLS_INTEGER;
6134: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 6132: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

6128: -- bug4529937
6129: PROCEDURE Query_Changed_Lines(p_header_id IN NUMBER,
6130: x_line_tbl OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE ) AS
6131: i PLS_INTEGER;
6132: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
6133: j PLS_INTEGER;
6134: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6135: BEGIN
6136: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;

Line 6196: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type

6192: ,p_Control_Rec OE_ORDER_PRICE_PVT.CONTROL_REC_TYPE
6193: ,p_action_code in Varchar2
6194: ,x_any_frozen_line out nocopy Boolean
6195:
6196: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
6197:
6198: ,px_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
6199: )
6200: is

Line 6198: ,px_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type

6194: ,x_any_frozen_line out nocopy Boolean
6195:
6196: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
6197:
6198: ,px_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
6199: )
6200: is
6201: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
6202: l_return_status_Text varchar2(240) ;

Line 6203: l_header_rec OE_Order_PUB.Header_Rec_Type;

6199: )
6200: is
6201: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
6202: l_return_status_Text varchar2(240) ;
6203: l_header_rec OE_Order_PUB.Header_Rec_Type;
6204: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
6205:
6206: --1472635
6207: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;

Line 6204: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;

6200: is
6201: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
6202: l_return_status_Text varchar2(240) ;
6203: l_header_rec OE_Order_PUB.Header_Rec_Type;
6204: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
6205:
6206: --1472635
6207: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
6208: i2 PLS_INTEGER;

Line 6207: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;

6203: l_header_rec OE_Order_PUB.Header_Rec_Type;
6204: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
6205:
6206: --1472635
6207: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
6208: i2 PLS_INTEGER;
6209: l_all_lines_from_db Boolean :=False;
6210:
6211: l_Line_Rec OE_Order_PUB.Line_Rec_Type;

Line 6211: l_Line_Rec OE_Order_PUB.Line_Rec_Type;

6207: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
6208: i2 PLS_INTEGER;
6209: l_all_lines_from_db Boolean :=False;
6210:
6211: l_Line_Rec OE_Order_PUB.Line_Rec_Type;
6212:
6213: -- AG change
6214: l_line_index NUMBER := 0;
6215: line_tbl_index pls_integer;

Line 6297: -- OE_Order_PUB.g_hdr := OE_ORDER_CACHE.g_header_rec;

6293:
6294: G_STMT_NO := 'calculate_adjustments#30';
6295:
6296: Begin
6297: -- OE_Order_PUB.g_hdr := OE_ORDER_CACHE.g_header_rec;
6298: query_header( p_header_id => p_header_id, x_header_rec=>oe_order_pub.g_hdr);
6299: Exception when no_data_found then
6300: x_return_status := 'NOOP';
6301: IF l_debug_level > 0 THEN

Line 6298: query_header( p_header_id => p_header_id, x_header_rec=>oe_order_pub.g_hdr);

6294: G_STMT_NO := 'calculate_adjustments#30';
6295:
6296: Begin
6297: -- OE_Order_PUB.g_hdr := OE_ORDER_CACHE.g_header_rec;
6298: query_header( p_header_id => p_header_id, x_header_rec=>oe_order_pub.g_hdr);
6299: Exception when no_data_found then
6300: x_return_status := 'NOOP';
6301: IF l_debug_level > 0 THEN
6302: oe_debug_pub.add( G_STMT_NO||'INVALID HEADER_ID '||P_HEADER_ID , 1 ) ;

Line 6442: query_header(l_line_tbl(1).header_id, oe_order_pub.g_hdr);

6438: G_STMT_NO := 'calculate_adjustments#60';
6439:
6440: If p_control_rec.p_use_current_header = FALSE Then
6441: Begin
6442: query_header(l_line_tbl(1).header_id, oe_order_pub.g_hdr);
6443: Exception when no_data_found then
6444: -- No need to process this order
6445: x_return_status := 'NOOP';
6446: oe_debug_pub.add(G_STMT_NO||'Invalid header_id '||l_line_Tbl(1).Header_id,1);

Line 6455: x_header_rec := oe_order_pub.g_hdr;

6451: NULL;
6452: End If;
6453: END IF;
6454:
6455: x_header_rec := oe_order_pub.g_hdr;
6456: G_STMT_NO := 'calculate_adjustments#110';
6457:
6458: line_Tbl_Index := l_Line_Tbl.First;
6459: While line_Tbl_Index is not null loop

Line 6498: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);

6494: End If;
6495: --End 2740845
6496:
6497: -- Populate that Global Structure
6498: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
6499: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then
6500: OE_Order_PUB.G_LINE.unit_list_price:= Null;
6501: End If;
6502:

Line 6499: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then

6495: --End 2740845
6496:
6497: -- Populate that Global Structure
6498: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
6499: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then
6500: OE_Order_PUB.G_LINE.unit_list_price:= Null;
6501: End If;
6502:
6503: --RT{

Line 6500: OE_Order_PUB.G_LINE.unit_list_price:= Null;

6496:
6497: -- Populate that Global Structure
6498: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
6499: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then
6500: OE_Order_PUB.G_LINE.unit_list_price:= Null;
6501: End If;
6502:
6503: --RT{
6504: IF G_PRICING_EVENT='RETROBILL'

Line 6516: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <> FND_API.G_MISS_NUM and

6512: END IF;
6513: --RT}
6514:
6515:
6516: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <> FND_API.G_MISS_NUM and
6517: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
6518: Then
6519: /* Added the following if condition for fixing the bug 1828553 */
6520: /* If the service reference context is ORDER, then the service_reference*/

Line 6517: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)

6513: --RT}
6514:
6515:
6516: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <> FND_API.G_MISS_NUM and
6517: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
6518: Then
6519: /* Added the following if condition for fixing the bug 1828553 */
6520: /* If the service reference context is ORDER, then the service_reference*/
6521: /*line_id is the line_id of the parent. However, if the service ref */

Line 6591: End If; --- IF (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <> FND_API.G_MISS_NUM

6587: END;
6588: --bug 3968023
6589: END IF;
6590: --3273289}
6591: End If; --- IF (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <> FND_API.G_MISS_NUM
6592:
6593: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
6594: oe_debug_pub.add('calling get_prg_lines 5647210 added mass change');
6595: IF ((p_line_id IS NOT NULL and p_control_rec.p_write_to_db) OR oe_mass_change_pvt.Lines_Remaining = 'Y')

Line 6615: Get_item_for_iue(px_line_rec => OE_Order_PUB.G_LINE);

6611: G_STMT_NO := 'calculate_adjustments#125';
6612:
6613: -- Set the old item during pricing
6614: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
6615: Get_item_for_iue(px_line_rec => OE_Order_PUB.G_LINE);
6616: END IF;
6617:
6618: G_STMT_NO := 'calculate_adjustments#135';
6619:

Line 6871: p_header_rec => OE_Order_PUB.g_hdr

6867:
6868:
6869: -- AG change --
6870: copy_Header_to_request(
6871: p_header_rec => OE_Order_PUB.g_hdr
6872: ,px_req_line_tbl => l_req_line_tbl
6873: ,p_Request_Type_Code => p_control_rec.p_Request_Type_Code
6874: ,p_calculate_price_flag =>l_calculate_price_flag
6875: ,px_line_index => l_line_index);

Line 6885: p_line_index=> l_line_index, --oe_order_pub.g_hdr.header_id,

6881: oe_debug_pub.add('Before QP_Attr_Mapping_PUB.Build_Contexts for Header',1);
6882: QP_Attr_Mapping_PUB.Build_Contexts(
6883: p_request_type_code => 'ONT',
6884: --p_line_index=> l_line_index,
6885: p_line_index=> l_line_index, --oe_order_pub.g_hdr.header_id,
6886: p_pricing_type_code => 'H');
6887:
6888: END IF;
6889:

Line 6918: x_header_Rec := OE_Order_PUB.g_hdr;

6914: IF l_line_index > 0 THEN
6915: Populate_Temp_Table;
6916: END IF;
6917:
6918: x_header_Rec := OE_Order_PUB.g_hdr;
6919: px_line_tbl := l_line_tbl;
6920:
6921: EXCEPTION
6922: when FND_API.G_EXC_ERROR then

Line 6981: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;

6977: --now pricing take care of all the roundings.
6978: l_control_rec.rounding_flag := 'Q';
6979: --For multi_currency price list
6980: l_control_rec.use_multi_currency:='Y';
6981: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6982: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6983: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6984: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6985:

Line 6982: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;

6978: l_control_rec.rounding_flag := 'Q';
6979: --For multi_currency price list
6980: l_control_rec.use_multi_currency:='Y';
6981: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6982: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6983: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6984: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6985:
6986: If l_Control_Rec.pricing_event IN ('BATCH','RETROBILL') OR

Line 7141: , px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type

7137: procedure Report_Engine_Errors(
7138: x_return_status out nocopy Varchar2
7139:
7140: , p_Control_Rec IN OE_ORDER_PRICE_PVT.Control_rec_type
7141: , px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type
7142: , p_header_rec IN oe_Order_Pub.header_rec_type
7143: )
7144: is
7145: l_line_rec oe_order_pub.line_rec_type;

Line 7142: , p_header_rec IN oe_Order_Pub.header_rec_type

7138: x_return_status out nocopy Varchar2
7139:
7140: , p_Control_Rec IN OE_ORDER_PRICE_PVT.Control_rec_type
7141: , px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type
7142: , p_header_rec IN oe_Order_Pub.header_rec_type
7143: )
7144: is
7145: l_line_rec oe_order_pub.line_rec_type;
7146: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 7145: l_line_rec oe_order_pub.line_rec_type;

7141: , px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type
7142: , p_header_rec IN oe_Order_Pub.header_rec_type
7143: )
7144: is
7145: l_line_rec oe_order_pub.line_rec_type;
7146: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7147: i pls_Integer;
7148: j pls_Integer:=0;
7149: l_price_list Varchar2(240);

Line 7146: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

7142: , p_header_rec IN oe_Order_Pub.header_rec_type
7143: )
7144: is
7145: l_line_rec oe_order_pub.line_rec_type;
7146: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7147: i pls_Integer;
7148: j pls_Integer:=0;
7149: l_price_list Varchar2(240);
7150: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');

Line 7152: l_temp_line_rec oe_order_pub.line_rec_type;

7148: j pls_Integer:=0;
7149: l_price_list Varchar2(240);
7150: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
7151: l_invalid_line Varchar2(1):='N';
7152: l_temp_line_rec oe_order_pub.line_rec_type;
7153: l_request_id NUMBER;
7154: vmsg Varchar2(2000);
7155: l_list_line_no Varchar2(2000);
7156: --bug 3696768

Line 7198: and l.header_id = oe_order_pub.g_hdr.header_id --bug#12384028

7194: where lines.line_id = l.line_id
7195: and lines.line_type_code='LINE'
7196: and l.booked_flag = 'Y'
7197: and l.item_type_code NOT IN ('INCLUDED','CONFIG')
7198: and l.header_id = oe_order_pub.g_hdr.header_id --bug#12384028
7199: and (lines.unit_price is NULL
7200: or lines.adjusted_unit_price is NULL
7201: or lines.price_list_header_id is NULL)
7202: and lines.process_status <> 'NOT_VALID'

Line 7814: px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type,

7810: x_return_status out nocopy Varchar2,
7811:
7812: p_Control_Rec OE_ORDER_PRICE_PVT.Control_rec_type,
7813: p_any_frozen_line in Boolean,
7814: px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type,
7815: p_header_id in number,
7816: p_line_id in number,
7817: p_header_rec oe_Order_Pub.header_rec_type,
7818: p_pricing_events in varchar2

Line 7817: p_header_rec oe_Order_Pub.header_rec_type,

7813: p_any_frozen_line in Boolean,
7814: px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type,
7815: p_header_id in number,
7816: p_line_id in number,
7817: p_header_rec oe_Order_Pub.header_rec_type,
7818: p_pricing_events in varchar2
7819: )
7820: is
7821: l_line_rec oe_order_pub.line_rec_type;

Line 7821: l_line_rec oe_order_pub.line_rec_type;

7817: p_header_rec oe_Order_Pub.header_rec_type,
7818: p_pricing_events in varchar2
7819: )
7820: is
7821: l_line_rec oe_order_pub.line_rec_type;
7822: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7823: i pls_Integer;
7824: j pls_Integer;
7825: l_price_list Varchar2(240);

Line 7822: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

7818: p_pricing_events in varchar2
7819: )
7820: is
7821: l_line_rec oe_order_pub.line_rec_type;
7822: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7823: i pls_Integer;
7824: j pls_Integer;
7825: l_price_list Varchar2(240);
7826: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGAT

Line 7830: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

7826: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGAT
7827: IVE_PRICING'),'N');
7828: l_sec_result NUMBER;
7829: l_adjustment_count NUMBER:=0;
7830: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
7831: l_num_changed_lines NUMBER := 0;
7832: l_process_requests BOOLEAN := FALSE;
7833: l_process_ack BOOLEAN := FALSE;
7834: l_notify_flag BOOLEAN;

Line 8062: ,px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type

8058: -- It can be used to Price an order, an order line, or multiple lines
8059: Procedure Price_line(
8060: p_Header_id IN NUMBER
8061: ,p_Line_id IN NUMBER
8062: ,px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type
8063: ,p_Control_Rec IN OE_ORDER_PRICE_PVT.control_rec_type
8064: ,p_action_code IN VARCHAR2
8065: ,p_Pricing_Events IN VARCHAR2
8066: --RT{

Line 8067: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC

8063: ,p_Control_Rec IN OE_ORDER_PRICE_PVT.control_rec_type
8064: ,p_action_code IN VARCHAR2
8065: ,p_Pricing_Events IN VARCHAR2
8066: --RT{
8067: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
8068: --RT}
8069: ,x_Return_Status OUT NOCOPY VARCHAR2
8070:
8071: )

Line 8074: lx_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;

8070:
8071: )
8072: is
8073: l_any_frozen_line BOOLEAN;
8074: lx_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
8075: --
8076: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8077: --
8078: l_org_id NUMBER(15):=MO_GLOBAL.Get_Current_Org_Id; --TaxER

Line 8082: l_header_rec OE_Order_PUB.Header_Rec_Type; --TaxER

8078: l_org_id NUMBER(15):=MO_GLOBAL.Get_Current_Org_Id; --TaxER
8079: l_hdr_chg_count NUMBER; --TaxER
8080: l_current_event number := 0; --TaxER
8081: l_tax_calculation_event_code number := 0; --TaxER
8082: l_header_rec OE_Order_PUB.Header_Rec_Type; --TaxER
8083: l_line_rec OE_Order_PUB.Line_Rec_Type; --TaxER
8084: Begin
8085:
8086: IF l_debug_level > 0 THEN

Line 8083: l_line_rec OE_Order_PUB.Line_Rec_Type; --TaxER

8079: l_hdr_chg_count NUMBER; --TaxER
8080: l_current_event number := 0; --TaxER
8081: l_tax_calculation_event_code number := 0; --TaxER
8082: l_header_rec OE_Order_PUB.Header_Rec_Type; --TaxER
8083: l_line_rec OE_Order_PUB.Line_Rec_Type; --TaxER
8084: Begin
8085:
8086: IF l_debug_level > 0 THEN
8087: oe_debug_pub.add('ENTERING OE_ORDER_PRICE_PVT.PRICE_LINE', 0.5) ;--Added for bug 13435459

Line 8151: OE_Order_PUB.G_LINE := NULL;

8147: If x_return_status = 'NOOP' Then
8148: IF l_debug_level > 0 THEN
8149: oe_debug_pub.add( 'THERE ARE NO ORDER LINES FOR '||P_LINE_ID ) ;
8150: END IF;
8151: OE_Order_PUB.G_LINE := NULL;
8152: OE_Order_PUB.G_HDR := NULL;
8153: Return;
8154: End If;
8155:

Line 8152: OE_Order_PUB.G_HDR := NULL;

8148: IF l_debug_level > 0 THEN
8149: oe_debug_pub.add( 'THERE ARE NO ORDER LINES FOR '||P_LINE_ID ) ;
8150: END IF;
8151: OE_Order_PUB.G_LINE := NULL;
8152: OE_Order_PUB.G_HDR := NULL;
8153: Return;
8154: End If;
8155:
8156: IF l_debug_level > 0 THEN

Line 8345: OE_Order_PUB.G_LINE := NULL;

8341:
8342: END IF;
8343: --TaxER end
8344: --reseting global structure after engine call
8345: OE_Order_PUB.G_LINE := NULL;
8346: OE_Order_PUB.G_HDR := NULL;
8347:
8348: IF l_debug_level > 0 THEN
8349: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

Line 8346: OE_Order_PUB.G_HDR := NULL;

8342: END IF;
8343: --TaxER end
8344: --reseting global structure after engine call
8345: OE_Order_PUB.G_LINE := NULL;
8346: OE_Order_PUB.G_HDR := NULL;
8347:
8348: IF l_debug_level > 0 THEN
8349: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
8350: END IF;

Line 8356: OE_Order_PUB.G_LINE := NULL;

8352: Exception
8353: WHEN FND_API.G_EXC_ERROR THEN
8354:
8355: --reseting global structure after engine call
8356: OE_Order_PUB.G_LINE := NULL;
8357: OE_Order_PUB.G_HDR := NULL;
8358: x_return_status := FND_API.G_RET_STS_ERROR;
8359:
8360: IF l_debug_level > 0 THEN

Line 8357: OE_Order_PUB.G_HDR := NULL;

8353: WHEN FND_API.G_EXC_ERROR THEN
8354:
8355: --reseting global structure after engine call
8356: OE_Order_PUB.G_LINE := NULL;
8357: OE_Order_PUB.G_HDR := NULL;
8358: x_return_status := FND_API.G_RET_STS_ERROR;
8359:
8360: IF l_debug_level > 0 THEN
8361: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;

Line 8367: OE_Order_PUB.G_LINE := NULL;

8363: RAISE FND_API.G_EXC_ERROR;
8364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8365:
8366: --reseting global structure after engine call
8367: OE_Order_PUB.G_LINE := NULL;
8368: OE_Order_PUB.G_HDR := NULL;
8369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8370: IF l_debug_level > 0 THEN
8371: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;

Line 8368: OE_Order_PUB.G_HDR := NULL;

8364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8365:
8366: --reseting global structure after engine call
8367: OE_Order_PUB.G_LINE := NULL;
8368: OE_Order_PUB.G_HDR := NULL;
8369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8370: IF l_debug_level > 0 THEN
8371: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;
8372: END IF;

Line 8378: OE_Order_PUB.G_LINE := NULL;

8374: WHEN OTHERS THEN
8375:
8376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8377: --reseting global structure after engine call
8378: OE_Order_PUB.G_LINE := NULL;
8379: OE_Order_PUB.G_HDR := NULL;
8380: IF l_debug_level > 0 THEN
8381: oe_debug_pub.add( 'ERROR IN OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
8382: END IF;

Line 8379: OE_Order_PUB.G_HDR := NULL;

8375:
8376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8377: --reseting global structure after engine call
8378: OE_Order_PUB.G_LINE := NULL;
8379: OE_Order_PUB.G_HDR := NULL;
8380: IF l_debug_level > 0 THEN
8381: oe_debug_pub.add( 'ERROR IN OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
8382: END IF;
8383: IF l_debug_level > 0 THEN