DBA Data[Home] [Help]

APPS.OE_CNCL_UTIL dependencies on OE_ORDER_PUB

Line 10: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CNCL_Util';
7:
8:
9: PROCEDURE Get_Header_Ids
10: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
11: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
12: )
13: IS
14: l_sold_to_org_id NUMBER;

Line 11: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type

7:
8:
9: PROCEDURE Get_Header_Ids
10: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
11: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
12: )
13: IS
14: l_sold_to_org_id NUMBER;
15: l_ship_to_org_id NUMBER;

Line 1269: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

1265: END Get_Header_Ids;
1266:
1267:
1268: PROCEDURE Get_Line_Ids
1269: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
1270: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
1271: )
1272: IS
1273: l_sold_to_org_id NUMBER;

Line 1270: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type

1266:
1267:
1268: PROCEDURE Get_Line_Ids
1269: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
1270: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
1271: )
1272: IS
1273: l_sold_to_org_id NUMBER;
1274: l_deliver_to_org_id NUMBER;

Line 2601: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

2597:
2598: -- Procedure Get_Header_Scredit_Ids
2599:
2600: PROCEDURE Get_Header_Scredit_Ids
2601: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
2602: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type
2603: )
2604: IS
2605:

Line 2602: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type

2598: -- Procedure Get_Header_Scredit_Ids
2599:
2600: PROCEDURE Get_Header_Scredit_Ids
2601: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
2602: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type
2603: )
2604: IS
2605:
2606: --

Line 2686: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

2682: END Get_Header_Scredit_Ids;
2683:
2684:
2685: PROCEDURE Get_Line_Scredit_Ids
2686: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
2687: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2688: )
2689: IS
2690: --

Line 2687: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type

2683:
2684:
2685: PROCEDURE Get_Line_Scredit_Ids
2686: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
2687: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2688: )
2689: IS
2690: --
2691: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2764: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2760:
2761:
2762:
2763: PROCEDURE Get_Header_Adj_Ids
2764: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2765: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
2766: )
2767: IS
2768: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 2765: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type

2761:
2762:
2763: PROCEDURE Get_Header_Adj_Ids
2764: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2765: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
2766: )
2767: IS
2768: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2769: --

Line 2768: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2764: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2765: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
2766: )
2767: IS
2768: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2769: --
2770: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2771: --
2772: BEGIN

Line 2819: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

2815: END Get_Header_Adj_Ids;
2816:
2817:
2818: PROCEDURE Get_Line_Adj_Ids
2819: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2820: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
2821: )
2822: IS
2823: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 2820: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type

2816:
2817:
2818: PROCEDURE Get_Line_Adj_Ids
2819: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2820: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
2821: )
2822: IS
2823: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2824: --

Line 2823: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

2819: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2820: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
2821: )
2822: IS
2823: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2824: --
2825: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2826: --
2827: BEGIN

Line 2878: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

2874: -- Procedure Convert_Miss_To_Null....FOR HEADER
2875: -- copied from OEXUHDRB.pls 115.204 to fix bug 3576009...added TP_ATTRIBUTE1-15 and TP_CONTEXT for completeness
2876:
2877: PROCEDURE Convert_Miss_To_Null
2878: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
2879: )
2880: IS
2881: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
2882: BEGIN

Line 2881: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;

2877: PROCEDURE Convert_Miss_To_Null
2878: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
2879: )
2880: IS
2881: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
2882: BEGIN
2883:
2884: oe_debug_pub.add('Entering OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER', 1);
2885:

Line 3599: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3595: -- copied from OEXULINB.pls 115.574 to fix bug 3576009...added CHANGE_SEQUENCE, CUSTOMER_ITEM_NET_PRICE, CUSTOMER_PAYMENT_TERM_ID, and USER_ITEM_DESCRIPTION for completeness
3596:
3597:
3598: PROCEDURE Convert_Miss_To_Null
3599: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3600: )
3601: IS
3602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3603: BEGIN

Line 4970: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

4966: -- copied from OEXUHADB.pls 115.67 to fix same issue raised by bug 3576009
4967:
4968:
4969: PROCEDURE Convert_Miss_To_Null
4970: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
4971: )
4972: IS
4973: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
4974: --

Line 4973: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;

4969: PROCEDURE Convert_Miss_To_Null
4970: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
4971: )
4972: IS
4973: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
4974: --
4975: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4976: --
4977: BEGIN

Line 5392: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

5388:
5389:
5390:
5391: PROCEDURE Convert_Miss_To_Null
5392: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
5393: )
5394: IS
5395: --
5396: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5551: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

5547: -- copied from OEXULADB.pls 115.117 to fix same issue raised by bug 3576009
5548:
5549:
5550: PROCEDURE Convert_Miss_To_Null
5551: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
5552: )
5553: IS
5554: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
5555: --

Line 5554: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;

5550: PROCEDURE Convert_Miss_To_Null
5551: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
5552: )
5553: IS
5554: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
5555: --
5556: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5557: --
5558: BEGIN

Line 5980: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

5976:
5977:
5978:
5979: PROCEDURE Convert_Miss_To_Null
5980: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
5981: )
5982: IS
5983: --
5984: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;