DBA Data[Home] [Help]

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_PUB

Line 1650: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,

1646: Procedure Get_Transaction_Version(
1647: p_header_id IN NUMBER,
1648: p_version_number IN NUMBER := NULL,
1649: p_phase_change_flag IN VARCHAR2 := NULL,
1650: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1651: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1652: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1653: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1654: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,

Line 1651: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,

1647: p_header_id IN NUMBER,
1648: p_version_number IN NUMBER := NULL,
1649: p_phase_change_flag IN VARCHAR2 := NULL,
1650: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1651: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1652: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1653: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1654: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1655: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,

Line 1652: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,

1648: p_version_number IN NUMBER := NULL,
1649: p_phase_change_flag IN VARCHAR2 := NULL,
1650: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1651: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1652: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1653: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1654: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1655: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
1656: x_return_status OUT NOCOPY VARCHAR2)

Line 1653: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

1649: p_phase_change_flag IN VARCHAR2 := NULL,
1650: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1651: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1652: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1653: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1654: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1655: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
1656: x_return_status OUT NOCOPY VARCHAR2)
1657: IS

Line 1654: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,

1650: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1651: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1652: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1653: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1654: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1655: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
1656: x_return_status OUT NOCOPY VARCHAR2)
1657: IS
1658: l_version_number NUMBER := p_version_number;

Line 1655: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,

1651: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1652: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1653: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1654: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1655: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
1656: x_return_status OUT NOCOPY VARCHAR2)
1657: IS
1658: l_version_number NUMBER := p_version_number;
1659: l_current_version_number NUMBER;

Line 1728: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

1724: PROCEDURE Query_Row
1725: ( p_header_id IN NUMBER,
1726: p_version_number IN NUMBER := NULL,
1727: p_phase_change_flag IN VARCHAR2 := NULL,
1728: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1729: )
1730: IS
1731: l_version_number NUMBER := p_version_number;
1732: l_current_version_number NUMBER;

Line 2121: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2117: PROCEDURE Query_Row
2118: ( p_price_adjustment_id IN NUMBER
2119: , p_version_number IN NUMBER := NULL
2120: , p_phase_change_flag IN VARCHAR2 := NULL
2121: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2122: )
2123: IS
2124: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2125:

Line 2124: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2120: , p_phase_change_flag IN VARCHAR2 := NULL
2121: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2122: )
2123: IS
2124: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2125:
2126: l_version_number NUMBER := p_version_number;
2127: l_current_version_number NUMBER;
2128: --

Line 2181: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

2177: , p_header_id IN NUMBER :=
2178: FND_API.G_MISS_NUM
2179: , p_version_number IN NUMBER := NULL
2180: , p_phase_change_flag IN VARCHAR2 := NULL
2181: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
2182: )
2183: IS
2184: l_count NUMBER;
2185: l_version_number NUMBER := p_version_number;

Line 2617: x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

2613: PROCEDURE Query_Row
2614: ( p_sales_credit_id IN NUMBER,
2615: p_version_number IN NUMBER := NULL,
2616: p_phase_change_flag IN VARCHAR2 := NULL,
2617: x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
2618: )
2619: IS
2620: l_version_number NUMBER := p_version_number;
2621: l_current_version_number NUMBER;

Line 2622: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2618: )
2619: IS
2620: l_version_number NUMBER := p_version_number;
2621: l_current_version_number NUMBER;
2622: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2623: --
2624: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2625: --
2626: BEGIN

Line 2667: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type

2663: , p_header_id IN NUMBER :=
2664: FND_API.G_MISS_NUM
2665: , p_version_number IN NUMBER := NULL
2666: , p_phase_change_flag IN VARCHAR2 := NULL
2667: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
2668: )
2669: IS
2670: l_version_number NUMBER := p_version_number;
2671: l_current_version_number NUMBER;

Line 2885: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

2881: PROCEDURE Query_Row
2882: ( p_line_id IN NUMBER
2883: , p_version_number IN NUMBER := NULL
2884: , p_phase_change_flag IN VARCHAR2 := NULL
2885: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2886: )
2887: IS
2888: l_version_number NUMBER := p_version_number;
2889: l_current_version_number NUMBER;

Line 2890: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2886: )
2887: IS
2888: l_version_number NUMBER := p_version_number;
2889: l_current_version_number NUMBER;
2890: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2891: BEGIN
2892: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
2893: l_current_version_number := Get_Version_Number(p_line_id => p_line_id);
2894: IF l_version_number >= l_current_version_number THEN

Line 2936: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

2932: , p_line_set_id IN NUMBER :=
2933: FND_API.G_MISS_NUM
2934: , p_version_number IN NUMBER := NULL
2935: , p_phase_change_flag IN VARCHAR2 := NULL
2936: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2937: )
2938: IS
2939: l_version_number NUMBER := p_version_number;
2940: l_current_version_number NUMBER;

Line 4438: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

4434: PROCEDURE Query_Row
4435: ( p_price_adjustment_id IN NUMBER
4436: , p_version_number IN NUMBER := NULL
4437: , p_phase_change_flag IN VARCHAR2 := NULL
4438: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4439: )
4440: IS
4441: l_version_number NUMBER := p_version_number;
4442: l_current_version_number NUMBER;

Line 4443: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4439: )
4440: IS
4441: l_version_number NUMBER := p_version_number;
4442: l_current_version_number NUMBER;
4443: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4444: BEGIN
4445: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
4446: l_current_version_number := Get_Version_Number(p_price_adjustment_id => p_price_adjustment_id);
4447: IF l_version_number >= l_current_version_number THEN

Line 4488: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

4484: , p_Header_id IN NUMBER :=
4485: FND_API.G_MISS_NUM
4486: , p_version_number IN NUMBER := NULL
4487: , p_phase_change_flag IN VARCHAR2 := NULL
4488: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
4489: )
4490: IS
4491: l_version_number NUMBER := p_version_number;
4492: l_current_version_number NUMBER;

Line 5034: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

5030: PROCEDURE Query_Row
5031: ( p_sales_credit_id IN NUMBER
5032: , p_version_number IN NUMBER := NULL
5033: , p_phase_change_flag IN VARCHAR2 := NULL
5034: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
5035: )
5036: IS
5037: l_version_number NUMBER := p_version_number;
5038: l_current_version_number NUMBER;

Line 5040: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

5036: IS
5037: l_version_number NUMBER := p_version_number;
5038: l_current_version_number NUMBER;
5039:
5040: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5041: --
5042: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5043: --
5044: BEGIN

Line 5092: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type

5088: , p_header_id IN NUMBER :=
5089: FND_API.G_MISS_NUM
5090: , p_version_number IN NUMBER := NULL
5091: , p_phase_change_flag IN VARCHAR2 := NULL
5092: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
5093: )
5094: IS
5095: l_version_number NUMBER := p_version_number;
5096: l_current_version_number NUMBER;