DBA Data[Home] [Help]

APPS.OE_BLANKET_PUB dependencies on OE_BLANKET_PUB

Line 1: PACKAGE BODY OE_Blanket_PUB AS

1: PACKAGE BODY OE_Blanket_PUB AS
2: /* $Header: OEXPBSOB.pls 120.0.12010000.5 2009/01/24 01:08:04 smusanna ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Blanket_PUB';

2: /* $Header: OEXPBSOB.pls 120.0.12010000.5 2009/01/24 01:08:04 smusanna ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Blanket_PUB';
7:
8: PROCEDURE set_context (p_org_id in number) is
9: l_org_id number ;
10: l_return_status varchar2(1);

Line 27: ( p_header_val_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Val_Rec_type

23:
24: ----------------------------------------------------------
25: PROCEDURE Header_Id_Conversion
26: ----------------------------------------------------------
27: ( p_header_val_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Val_Rec_type
28: , p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_type
29: )IS
30: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
31: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 28: , p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_type

24: ----------------------------------------------------------
25: PROCEDURE Header_Id_Conversion
26: ----------------------------------------------------------
27: ( p_header_val_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Val_Rec_type
28: , p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_type
29: )IS
30: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
31: l_header_rec OE_Order_PUB.Header_Rec_Type;
32: l_order_type_d INTEGER ;

Line 210: ( p_line_val_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Val_Rec_Type

206:
207: ----------------------------------------------------------
208: PROCEDURE Line_Id_Conversion
209: ----------------------------------------------------------
210: ( p_line_val_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Val_Rec_Type
211: , p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type
212: )IS
213: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
214: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 211: , p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type

207: ----------------------------------------------------------
208: PROCEDURE Line_Id_Conversion
209: ----------------------------------------------------------
210: ( p_line_val_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Val_Rec_Type
211: , p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type
212: )IS
213: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
214: l_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_organization_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 423: l_control_rec OE_Blanket_Pub.control_rec_type;

419: , x_header_rec OUT NOCOPY header_Rec_type
420: , x_line_tbl OUT NOCOPY line_tbl_Type
421: ) IS
422:
423: l_control_rec OE_Blanket_Pub.control_rec_type;
424: l_header_rec OE_Blanket_Pub.header_Rec_type;
425: l_header_val_rec OE_Blanket_Pub.Header_Val_Rec_Type := OE_Blanket_Pub.G_MISS_HEADER_VAL_REC;
426: l_line_rec OE_Blanket_Pub.Line_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_REC;
427: l_line_val_rec OE_Blanket_Pub.Line_Val_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_VAL_REC;

Line 424: l_header_rec OE_Blanket_Pub.header_Rec_type;

420: , x_line_tbl OUT NOCOPY line_tbl_Type
421: ) IS
422:
423: l_control_rec OE_Blanket_Pub.control_rec_type;
424: l_header_rec OE_Blanket_Pub.header_Rec_type;
425: l_header_val_rec OE_Blanket_Pub.Header_Val_Rec_Type := OE_Blanket_Pub.G_MISS_HEADER_VAL_REC;
426: l_line_rec OE_Blanket_Pub.Line_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_REC;
427: l_line_val_rec OE_Blanket_Pub.Line_Val_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_VAL_REC;
428: l_org_id NUMBER;

Line 425: l_header_val_rec OE_Blanket_Pub.Header_Val_Rec_Type := OE_Blanket_Pub.G_MISS_HEADER_VAL_REC;

421: ) IS
422:
423: l_control_rec OE_Blanket_Pub.control_rec_type;
424: l_header_rec OE_Blanket_Pub.header_Rec_type;
425: l_header_val_rec OE_Blanket_Pub.Header_Val_Rec_Type := OE_Blanket_Pub.G_MISS_HEADER_VAL_REC;
426: l_line_rec OE_Blanket_Pub.Line_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_REC;
427: l_line_val_rec OE_Blanket_Pub.Line_Val_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_VAL_REC;
428: l_org_id NUMBER;
429: l_line_tbl line_tbl_Type := p_line_tbl;

Line 426: l_line_rec OE_Blanket_Pub.Line_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_REC;

422:
423: l_control_rec OE_Blanket_Pub.control_rec_type;
424: l_header_rec OE_Blanket_Pub.header_Rec_type;
425: l_header_val_rec OE_Blanket_Pub.Header_Val_Rec_Type := OE_Blanket_Pub.G_MISS_HEADER_VAL_REC;
426: l_line_rec OE_Blanket_Pub.Line_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_REC;
427: l_line_val_rec OE_Blanket_Pub.Line_Val_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_VAL_REC;
428: l_org_id NUMBER;
429: l_line_tbl line_tbl_Type := p_line_tbl;
430: l_line_val_tbl line_val_tbl_Type := p_line_val_tbl;

Line 427: l_line_val_rec OE_Blanket_Pub.Line_Val_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_VAL_REC;

423: l_control_rec OE_Blanket_Pub.control_rec_type;
424: l_header_rec OE_Blanket_Pub.header_Rec_type;
425: l_header_val_rec OE_Blanket_Pub.Header_Val_Rec_Type := OE_Blanket_Pub.G_MISS_HEADER_VAL_REC;
426: l_line_rec OE_Blanket_Pub.Line_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_REC;
427: l_line_val_rec OE_Blanket_Pub.Line_Val_Rec_Type := OE_Blanket_Pub.G_MISS_BLANKET_LINE_VAL_REC;
428: l_org_id NUMBER;
429: l_line_tbl line_tbl_Type := p_line_tbl;
430: l_line_val_tbl line_val_tbl_Type := p_line_val_tbl;
431: l_count INTEGER;

Line 637: End OE_BLANKET_PUB;

633:
634:
635: END Process_Blanket;
636:
637: End OE_BLANKET_PUB;
638: