DBA Data[Home] [Help]

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_PUB

Line 1713: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,

1709: Procedure Get_Transaction_Version(
1710: p_header_id IN NUMBER,
1711: p_version_number IN NUMBER := NULL,
1712: p_phase_change_flag IN VARCHAR2 := NULL,
1713: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1714: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1715: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1716: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1717: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,

Line 1714: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,

1710: p_header_id IN NUMBER,
1711: p_version_number IN NUMBER := NULL,
1712: p_phase_change_flag IN VARCHAR2 := NULL,
1713: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1714: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1715: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1716: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1717: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1718: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,

Line 1715: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,

1711: p_version_number IN NUMBER := NULL,
1712: p_phase_change_flag IN VARCHAR2 := NULL,
1713: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1714: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1715: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1716: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1717: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1718: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
1719: x_return_status OUT NOCOPY VARCHAR2)

Line 1716: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

1712: p_phase_change_flag IN VARCHAR2 := NULL,
1713: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1714: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1715: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1716: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1717: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1718: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
1719: x_return_status OUT NOCOPY VARCHAR2)
1720: IS

Line 1717: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,

1713: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1714: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1715: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1716: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1717: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1718: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
1719: x_return_status OUT NOCOPY VARCHAR2)
1720: IS
1721: l_version_number NUMBER := p_version_number;

Line 1718: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,

1714: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1715: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1716: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1717: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1718: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
1719: x_return_status OUT NOCOPY VARCHAR2)
1720: IS
1721: l_version_number NUMBER := p_version_number;
1722: l_current_version_number NUMBER;

Line 1791: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

1787: PROCEDURE Query_Row
1788: ( p_header_id IN NUMBER,
1789: p_version_number IN NUMBER := NULL,
1790: p_phase_change_flag IN VARCHAR2 := NULL,
1791: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1792: )
1793: IS
1794: l_version_number NUMBER := p_version_number;
1795: l_current_version_number NUMBER;

Line 2184: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2180: PROCEDURE Query_Row
2181: ( p_price_adjustment_id IN NUMBER
2182: , p_version_number IN NUMBER := NULL
2183: , p_phase_change_flag IN VARCHAR2 := NULL
2184: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2185: )
2186: IS
2187: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2188:

Line 2187: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2183: , p_phase_change_flag IN VARCHAR2 := NULL
2184: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2185: )
2186: IS
2187: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2188:
2189: l_version_number NUMBER := p_version_number;
2190: l_current_version_number NUMBER;
2191: --

Line 2244: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

2240: , p_header_id IN NUMBER :=
2241: FND_API.G_MISS_NUM
2242: , p_version_number IN NUMBER := NULL
2243: , p_phase_change_flag IN VARCHAR2 := NULL
2244: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
2245: )
2246: IS
2247: l_count NUMBER;
2248: l_version_number NUMBER := p_version_number;

Line 2680: x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

2676: PROCEDURE Query_Row
2677: ( p_sales_credit_id IN NUMBER,
2678: p_version_number IN NUMBER := NULL,
2679: p_phase_change_flag IN VARCHAR2 := NULL,
2680: x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
2681: )
2682: IS
2683: l_version_number NUMBER := p_version_number;
2684: l_current_version_number NUMBER;

Line 2685: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2681: )
2682: IS
2683: l_version_number NUMBER := p_version_number;
2684: l_current_version_number NUMBER;
2685: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2686: --
2687: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2688: --
2689: BEGIN

Line 2730: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type

2726: , p_header_id IN NUMBER :=
2727: FND_API.G_MISS_NUM
2728: , p_version_number IN NUMBER := NULL
2729: , p_phase_change_flag IN VARCHAR2 := NULL
2730: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
2731: )
2732: IS
2733: l_version_number NUMBER := p_version_number;
2734: l_current_version_number NUMBER;

Line 2948: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

2944: PROCEDURE Query_Row
2945: ( p_line_id IN NUMBER
2946: , p_version_number IN NUMBER := NULL
2947: , p_phase_change_flag IN VARCHAR2 := NULL
2948: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2949: )
2950: IS
2951: l_version_number NUMBER := p_version_number;
2952: l_current_version_number NUMBER;

Line 2953: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2949: )
2950: IS
2951: l_version_number NUMBER := p_version_number;
2952: l_current_version_number NUMBER;
2953: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2954: BEGIN
2955: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
2956: l_current_version_number := Get_Version_Number(p_line_id => p_line_id);
2957: IF l_version_number >= l_current_version_number THEN

Line 2999: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

2995: , p_line_set_id IN NUMBER :=
2996: FND_API.G_MISS_NUM
2997: , p_version_number IN NUMBER := NULL
2998: , p_phase_change_flag IN VARCHAR2 := NULL
2999: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3000: )
3001: IS
3002: l_version_number NUMBER := p_version_number;
3003: l_current_version_number NUMBER;

Line 4534: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

4530: PROCEDURE Query_Row
4531: ( p_price_adjustment_id IN NUMBER
4532: , p_version_number IN NUMBER := NULL
4533: , p_phase_change_flag IN VARCHAR2 := NULL
4534: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4535: )
4536: IS
4537: l_version_number NUMBER := p_version_number;
4538: l_current_version_number NUMBER;

Line 4539: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4535: )
4536: IS
4537: l_version_number NUMBER := p_version_number;
4538: l_current_version_number NUMBER;
4539: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4540: BEGIN
4541: IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
4542: l_current_version_number := Get_Version_Number(p_price_adjustment_id => p_price_adjustment_id);
4543: IF l_version_number >= l_current_version_number THEN

Line 4584: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

4580: , p_Header_id IN NUMBER :=
4581: FND_API.G_MISS_NUM
4582: , p_version_number IN NUMBER := NULL
4583: , p_phase_change_flag IN VARCHAR2 := NULL
4584: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
4585: )
4586: IS
4587: l_version_number NUMBER := p_version_number;
4588: l_current_version_number NUMBER;

Line 5130: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

5126: PROCEDURE Query_Row
5127: ( p_sales_credit_id IN NUMBER
5128: , p_version_number IN NUMBER := NULL
5129: , p_phase_change_flag IN VARCHAR2 := NULL
5130: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
5131: )
5132: IS
5133: l_version_number NUMBER := p_version_number;
5134: l_current_version_number NUMBER;

Line 5136: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

5132: IS
5133: l_version_number NUMBER := p_version_number;
5134: l_current_version_number NUMBER;
5135:
5136: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5137: --
5138: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5139: --
5140: BEGIN

Line 5188: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type

5184: , p_header_id IN NUMBER :=
5185: FND_API.G_MISS_NUM
5186: , p_version_number IN NUMBER := NULL
5187: , p_phase_change_flag IN VARCHAR2 := NULL
5188: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
5189: )
5190: IS
5191: l_version_number NUMBER := p_version_number;
5192: l_current_version_number NUMBER;