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

Line 23: px_line_tbl IN Oe_Order_Pub.Line_Tbl_Type,

19: End If;
20: End Adj_Debug;
21:
22: procedure Sort_Line_Table(
23: px_line_tbl IN Oe_Order_Pub.Line_Tbl_Type,
24: px_price_line_id_tbl IN OUT NOCOPY Oe_Order_Adj_Pvt.Index_Tbl_Type)
25: IS
26: l_line_index Number;
27: --

Line 42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,

38: End;
39:
40:
41: Procedure Call_Process_Order(
42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,
43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,

Line 43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,

39:
40:
41: Procedure Call_Process_Order(
42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,
43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,
47: x_return_status OUT NOCOPY VARCHAR2)

Line 44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,

40:
41: Procedure Call_Process_Order(
42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,
43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,
47: x_return_status OUT NOCOPY VARCHAR2)
48: IS

Line 45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,

41: Procedure Call_Process_Order(
42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,
43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,
47: x_return_status OUT NOCOPY VARCHAR2)
48: IS
49: lx_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;

Line 49: lx_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;

45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,
47: x_return_status OUT NOCOPY VARCHAR2)
48: IS
49: lx_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;
50: l_line_index NUMBER;
51: -- process_order in variables
52:
53: I NUMBER;

Line 58: l_new_line_tbl OE_Order_Pub.Line_Tbl_Type;

54: l_msg_count NUMBER;
55: l_msg_data VARCHAR2(2000);
56: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
57: l_index NUMBER:=1;
58: l_new_line_tbl OE_Order_Pub.Line_Tbl_Type;
59: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
60: --
61: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
62: --

Line 59: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;

55: l_msg_data VARCHAR2(2000);
56: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
57: l_index NUMBER:=1;
58: l_new_line_tbl OE_Order_Pub.Line_Tbl_Type;
59: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
60: --
61: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
62: --
63: BEGIN

Line 154: px_line_rec in out nocopy OE_Order_PUB.line_rec_type

150:
151:
152:
153: procedure set_item_for_iue(
154: px_line_rec in out nocopy OE_Order_PUB.line_rec_type
155: ,p_related_item_id NUMBER
156: )
157: is
158: l_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 215: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

211:
212:
213: Procedure delete_attribs_for_iue(p_price_adjustment_id in number)
214: is
215: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
216: l_return_status VARCHAR2(30);
217: l_index NUMBER;
218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
219:

Line 253: ( px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

249: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = p_price_adjustment_id;
250: End;
251:
252: Procedure Item_Upgrade
253: ( px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
254: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
255: p_pricing_events IN VARCHAR2
256: )
257: IS

Line 254: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

250: End;
251:
252: Procedure Item_Upgrade
253: ( px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
254: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
255: p_pricing_events IN VARCHAR2
256: )
257: IS
258:

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

454: , NULL --p_Line_Adj_rec.program_application_id
455: , NULL --p_Line_Adj_rec.program_id
456: , NULL --p_Line_Adj_rec.program_update_date
457: , NULL --p_Line_Adj_rec.request_id
458: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
459: , NULL --p_Line_Adj_rec.discount_id
460: , NULL --p_Line_Adj_rec.discount_line_id
461: , ldets.automatic_flag
462: , NULL --p_Line_Adj_rec.percent

Line 571: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,

567:
568:
569:
570: Procedure Term_Substitution
571: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
572: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
573: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
574: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
575: )

Line 572: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,

568:
569:
570: Procedure Term_Substitution
571: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
572: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
573: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
574: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
575: )
576: Is

Line 573: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

569:
570: Procedure Term_Substitution
571: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
572: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
573: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
574: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
575: )
576: Is
577: cursor oe_price_adj_cur(p_line_id number) is

Line 574: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type

570: Procedure Term_Substitution
571: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
572: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
573: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
574: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
575: )
576: Is
577: cursor oe_price_adj_cur(p_line_id number) is
578: select price_adjustment_id,LIST_LINE_ID,PRICING_PHASE_ID ,

Line 617: -- l_header_rec OE_ORDER_PUB.Header_Rec_Type := oe_order_cache.g_header_rec;

613: k number;
614: l number;
615: vcount number;
616: m number;
617: -- l_header_rec OE_ORDER_PUB.Header_Rec_Type := oe_order_cache.g_header_rec;
618: --bug 4190357
619: l_count NUMBER;
620: --bug 4190357
621: l_old_shipping_method_code Varchar2(30); --bug 4190357

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

872: , NULL --p_Line_Adj_rec.program_application_id
873: , NULL --p_Line_Adj_rec.program_id
874: , NULL --p_Line_Adj_rec.program_update_date
875: , NULL --p_Line_Adj_rec.request_id
876: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
877: , NULL --p_Line_Adj_rec.discount_id
878: , NULL --p_Line_Adj_rec.discount_line_id
879: , ldets.automatic_flag
880: , NULL --p_Line_Adj_rec.percent

Line 983: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type

979: End Loop;
980: END Term_Substitution;
981:
982: Procedure Set_Prg(
983: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
984: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
985: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
986: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
987: , p_line_uom_code IN QP_PREQ_LINES_TMP.line_uom_code%TYPE

Line 1000: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;

996: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
997: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
998: )
999: IS
1000: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1001: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1002: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1003: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1004: l_pricing_event varchar2(30);

Line 1209: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type

1205: raise fnd_api.g_exc_error;
1206: end Set_Prg;
1207:
1208: Procedure Delete_Prg(
1209: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
1210: )
1211: IS
1212: l_line_rec OE_Order_Pub.line_rec_type := px_line_rec;
1213: l_pricing_event varchar2(30);

Line 1212: l_line_rec OE_Order_Pub.line_rec_type := px_line_rec;

1208: Procedure Delete_Prg(
1209: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
1210: )
1211: IS
1212: l_line_rec OE_Order_Pub.line_rec_type := px_line_rec;
1213: l_pricing_event varchar2(30);
1214: l_return_status varchar2(1);
1215: --
1216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1277: procedure Process_PRG(px_line_Tbl in out nocopy oe_order_pub.line_tbl_type

1273: When Others then
1274: Raise FND_API.G_EXC_ERROR;
1275: End Delete_Prg;
1276:
1277: procedure Process_PRG(px_line_Tbl in out nocopy oe_order_pub.line_tbl_type
1278: , px_old_line_tbl in out nocopy oe_order_pub.line_tbl_type
1279: , px_price_line_id_tbl IN OUT NOCOPY Oe_Order_Adj_Pvt.Index_Tbl_Type
1280: )
1281: IS

Line 1278: , px_old_line_tbl in out nocopy oe_order_pub.line_tbl_type

1274: Raise FND_API.G_EXC_ERROR;
1275: End Delete_Prg;
1276:
1277: procedure Process_PRG(px_line_Tbl in out nocopy oe_order_pub.line_tbl_type
1278: , px_old_line_tbl in out nocopy oe_order_pub.line_tbl_type
1279: , px_price_line_id_tbl IN OUT NOCOPY Oe_Order_Adj_Pvt.Index_Tbl_Type
1280: )
1281: IS
1282: cursor prg_lines IS

Line 1306: l_line_rec oe_order_pub.line_rec_type;

1302: , QP_PREQ_PUB.G_STATUS_UPDATED
1303: , QP_PREQ_PUB.G_STATUS_DELETED
1304: , 'FREEGOOD'
1305: );
1306: l_line_rec oe_order_pub.line_rec_type;
1307: l_buy_line_rec oe_order_pub.line_rec_type;
1308: l_parent_line_index pls_integer;
1309: l_parent_line_id pls_integer;
1310: l_return_status varchar2(1);

Line 1307: l_buy_line_rec oe_order_pub.line_rec_type;

1303: , QP_PREQ_PUB.G_STATUS_DELETED
1304: , 'FREEGOOD'
1305: );
1306: l_line_rec oe_order_pub.line_rec_type;
1307: l_buy_line_rec oe_order_pub.line_rec_type;
1308: l_parent_line_index pls_integer;
1309: l_parent_line_id pls_integer;
1310: l_return_status varchar2(1);
1311: E_CLOSED_LINE Exception;

Line 1410: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;

1406: IF (l_line_rec.operation <> OE_GLOBALS.G_OPR_NONE) THEN
1407: px_line_tbl(px_price_line_id_tbl(i.line_id)) := l_line_rec;
1408: END IF;
1409: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_NEW) THEN
1410: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
1411: l_line_rec.cancelled_quantity := 0;
1412: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1413: l_line_rec.Header_id := oe_order_cache.g_header_rec.header_id;
1414: l_line_rec.line_id := OE_DEFAULT_LINE.get_line;

Line 1867: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

1863: AND ldets.list_line_type_code<>'PLL'
1864:
1865: AND (l_booked_flag = 'N' or ldets.list_line_type_code<>'IUE');
1866:
1867: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1868: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1869: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1870: l_index NUMBER;
1871: l_return_status VARCHAR2(1);

Line 1868: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

1864:
1865: AND (l_booked_flag = 'N' or ldets.list_line_type_code<>'IUE');
1866:
1867: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1868: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1869: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1870: l_index NUMBER;
1871: l_return_status VARCHAR2(1);
1872:

Line 1886: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;

1882: l_Line_Adj_rec.created_by := fnd_global.user_id;
1883: l_Line_Adj_rec.last_update_date := sysdate;
1884: l_Line_Adj_rec.last_updated_by := fnd_global.user_id;
1885: l_Line_Adj_rec.last_update_login := fnd_global.user_id;
1886: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
1887: l_Line_Adj_rec.automatic_flag := l_insert.auto_flag;
1888: l_Line_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;
1889: l_Line_Adj_rec.LIST_LINE_ID := l_insert.LIST_LINE_ID;
1890: l_Line_Adj_rec.LIST_LINE_TYPE_CODE := l_insert.LIST_LINE_TYPE_CODE;

Line 1969: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;

1965: l_Header_Adj_rec.created_by := fnd_global.user_id;
1966: l_Header_Adj_rec.last_update_date := sysdate;
1967: l_Header_Adj_rec.last_updated_by := fnd_global.user_id;
1968: l_Header_Adj_rec.last_update_login := fnd_global.user_id;
1969: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
1970: l_Header_Adj_rec.automatic_flag := l_insert.auto_flag;
1971: l_Header_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;
1972: l_Header_Adj_rec.LIST_LINE_ID := l_insert.LIST_LINE_ID;
1973: l_Header_Adj_rec.LIST_LINE_TYPE_CODE := l_insert.LIST_LINE_TYPE_CODE;

Line 2076: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type

2072:
2073:
2074: --bug 3702538
2075: procedure Register_price_list(
2076: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type
2077: )
2078: IS
2079:
2080: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2120: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type,

2116: (
2117: x_return_status OUT NOCOPY Varchar2,
2118: p_Control_Rec IN OE_ORDER_PRICE_PVT.Control_rec_type,
2119: p_any_frozen_line IN Boolean,
2120: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type,
2121: px_old_line_Tbl IN OUT NOCOPY oe_order_pub.line_tbl_type,
2122: p_header_id IN number,
2123: p_line_id IN number,
2124: p_header_rec IN oe_Order_Pub.header_rec_type,

Line 2121: px_old_line_Tbl IN OUT NOCOPY oe_order_pub.line_tbl_type,

2117: x_return_status OUT NOCOPY Varchar2,
2118: p_Control_Rec IN OE_ORDER_PRICE_PVT.Control_rec_type,
2119: p_any_frozen_line IN Boolean,
2120: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type,
2121: px_old_line_Tbl IN OUT NOCOPY oe_order_pub.line_tbl_type,
2122: p_header_id IN number,
2123: p_line_id IN number,
2124: p_header_rec IN oe_Order_Pub.header_rec_type,
2125: p_pricing_events IN varchar2

Line 2124: p_header_rec IN oe_Order_Pub.header_rec_type,

2120: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type,
2121: px_old_line_Tbl IN OUT NOCOPY oe_order_pub.line_tbl_type,
2122: p_header_id IN number,
2123: p_line_id IN number,
2124: p_header_rec IN oe_Order_Pub.header_rec_type,
2125: p_pricing_events IN varchar2
2126: ) IS
2127:
2128: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 2129: lx_new_header_rec oe_Order_Pub.header_rec_type := p_header_rec;

2125: p_pricing_events IN varchar2
2126: ) IS
2127:
2128: l_control_rec OE_GLOBALS.Control_Rec_Type;
2129: lx_new_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
2130: l_notify_flag BOOLEAN;
2131: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
2132:
2133:

Line 2324: , decode(p_header_id, NULL, oe_order_pub.g_hdr.header_id, p_header_id) --p_Line_Adj_rec.header_id

2320: , NULL --p_Line_Adj_rec.program_application_id
2321: , NULL --p_Line_Adj_rec.program_id
2322: , NULL --p_Line_Adj_rec.program_update_date
2323: , NULL --p_Line_Adj_rec.request_id
2324: , decode(p_header_id, NULL, oe_order_pub.g_hdr.header_id, p_header_id) --p_Line_Adj_rec.header_id
2325: , NULL --p_Line_Adj_rec.discount_id
2326: , NULL --p_Line_Adj_rec.discount_line_id
2327: , ldets.automatic_flag
2328: , NULL --p_Line_Adj_rec.percent