DBA Data[Home] [Help]

APPS.OE_PORTAL_HEADER dependencies on OE_ORDER_PUB

Line 7: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Portal_Header';
5:
6: Procedure Write_Header
7: ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
8: , p_db_record IN BOOLEAN := FALSE
9: );
10:
11:

Line 15: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type

11:
12: PROCEDURE Get_header
13: ( p_db_record IN BOOLEAN := FALSE
14: , p_header_id IN NUMBER
15: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
16: );
17:
18: PROCEDURE Clear_header;
19:

Line 110: l_header_rec OE_Order_PUB.Header_Rec_Type;

106:
107: , x_customer_number OUT NOCOPY VARCHAR2
108:
109: ) IS
110: l_header_rec OE_Order_PUB.Header_Rec_Type;
111: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
112: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
113: l_control_rec OE_GLOBALS.Control_Rec_Type;
114: l_return_status VARCHAR2(1);

Line 111: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

107: , x_customer_number OUT NOCOPY VARCHAR2
108:
109: ) IS
110: l_header_rec OE_Order_PUB.Header_Rec_Type;
111: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
112: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
113: l_control_rec OE_GLOBALS.Control_Rec_Type;
114: l_return_status VARCHAR2(1);
115: --

Line 112: l_old_header_rec OE_Order_PUB.Header_Rec_Type;

108:
109: ) IS
110: l_header_rec OE_Order_PUB.Header_Rec_Type;
111: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
112: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
113: l_control_rec OE_GLOBALS.Control_Rec_Type;
114: l_return_status VARCHAR2(1);
115: --
116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 150: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;

146: l_control_rec.clear_api_requests := FALSE;
147:
148: -- Load IN parameters if any exist
149:
150: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
151: l_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
152: l_header_rec.sold_to_org_id := p_sold_to_org_id;
153: l_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
154:

Line 151: l_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;

147:
148: -- Load IN parameters if any exist
149:
150: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
151: l_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
152: l_header_rec.sold_to_org_id := p_sold_to_org_id;
153: l_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
154:
155: -- Defaulting of flex values is currently done by the form.

Line 153: l_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;

149:
150: l_old_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
151: l_header_rec :=OE_ORDER_PUB.G_MISS_HEADER_REC;
152: l_header_rec.sold_to_org_id := p_sold_to_org_id;
153: l_header_val_rec :=OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
154:
155: -- Defaulting of flex values is currently done by the form.
156: -- Set flex attributes to NULL in order to avoid defaulting them.
157:

Line 478: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;

474: IS
475: l_db_record BOOLEAN;
476: l_cascade_flag BOOLEAN;
477: l_lock_control NUMBER;
478: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
479: l_control_rec OE_GLOBALS.Control_Rec_Type;
480: l_return_status VARCHAR2(1);
481: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
482: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

Line 481: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

477: l_lock_control NUMBER;
478: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
479: l_control_rec OE_GLOBALS.Control_Rec_Type;
480: l_return_status VARCHAR2(1);
481: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
482: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
483: --
484: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
485: --

Line 482: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

478: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
479: l_control_rec OE_GLOBALS.Control_Rec_Type;
480: l_return_status VARCHAR2(1);
481: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
482: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
483: --
484: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
485: --
486: BEGIN

Line 522: l_x_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

518:
519: l_control_rec.clear_api_cache := FALSE;
520: l_control_rec.clear_api_requests := FALSE;
521:
522: l_x_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
523:
524: Get_header
525: ( p_db_record => l_db_record
526: , p_header_id => p_header_id

Line 820: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;

816:
817: , p_header_id IN NUMBER
818: )
819: IS
820: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
821: l_control_rec OE_GLOBALS.Control_Rec_Type;
822: l_return_status VARCHAR2(1);
823: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
824: --

Line 823: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

819: IS
820: l_x_old_header_rec OE_Order_PUB.Header_Rec_Type;
821: l_control_rec OE_GLOBALS.Control_Rec_Type;
822: l_return_status VARCHAR2(1);
823: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
824: --
825: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
826: --
827: BEGIN

Line 900: l_x_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

896:
897: l_control_rec.clear_api_cache := FALSE;
898: l_control_rec.clear_api_requests := FALSE;
899:
900: l_x_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
901: l_x_header_rec.cancelled_flag := 'Y';
902: -- Set Operation.
903:
904: l_x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line 1126: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type

1122:
1123: PROCEDURE Get_header
1124: ( p_db_record IN BOOLEAN := FALSE
1125: , p_header_id IN NUMBER
1126: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1127: )
1128: IS
1129: --
1130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1184: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.CLEAR_HEADER' , 1 ) ;
1182: END IF;
1183:
1184: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1185: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1186:
1187: IF l_debug_level > 0 THEN
1188: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.CLEAR_HEADER' , 1 ) ;

Line 1185: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

1181: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.CLEAR_HEADER' , 1 ) ;
1182: END IF;
1183:
1184: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1185: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1186:
1187: IF l_debug_level > 0 THEN
1188: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.CLEAR_HEADER' , 1 ) ;
1189: END IF;

Line 1196: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

1192:
1193:
1194:
1195: PROCEDURE Write_header
1196: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
1197: , p_db_record IN BOOLEAN := FALSE
1198: )
1199: IS
1200: --