DBA Data[Home] [Help]

APPS.OE_BLANKET_PVT dependencies on OE_BLANKET_PUB

Line 8: g_blaket_header_rec oe_blanket_pub.header_Rec_type ;

4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Blanket_PVT';
7: g_header_id NUMBER;
8: g_blaket_header_rec oe_blanket_pub.header_Rec_type ;
9:
10: /*----------------------------------------------------------------------
11: PROCEDURE Header
12: -----------------------------------------------------------------------*/

Line 15: ( p_control_rec IN OE_BLANKET_PUB.Control_Rec_Type

11: PROCEDURE Header
12: -----------------------------------------------------------------------*/
13:
14: PROCEDURE Header
15: ( p_control_rec IN OE_BLANKET_PUB.Control_Rec_Type
16: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
17: , p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_Rec_Type
18: , p_x_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_Rec_Type
19: , x_return_status OUT NOCOPY VARCHAR2

Line 17: , p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_Rec_Type

13:
14: PROCEDURE Header
15: ( p_control_rec IN OE_BLANKET_PUB.Control_Rec_Type
16: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
17: , p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_Rec_Type
18: , p_x_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_Rec_Type
19: , x_return_status OUT NOCOPY VARCHAR2
20: )
21: IS

Line 18: , p_x_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_Rec_Type

14: PROCEDURE Header
15: ( p_control_rec IN OE_BLANKET_PUB.Control_Rec_Type
16: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
17: , p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_Rec_Type
18: , p_x_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_Rec_Type
19: , x_return_status OUT NOCOPY VARCHAR2
20: )
21: IS
22: l_old_header_rec OE_Blanket_PUB.header_Rec_Type;

Line 22: l_old_header_rec OE_Blanket_PUB.header_Rec_Type;

18: , p_x_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_Rec_Type
19: , x_return_status OUT NOCOPY VARCHAR2
20: )
21: IS
22: l_old_header_rec OE_Blanket_PUB.header_Rec_Type;
23: l_return_status varchar2(1);
24: l_sec_result NUMBER;
25: --
26: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 252: ( p_control_rec IN oe_blanket_pub.Control_Rec_Type

248:
249: /*---------------------------------------------------------------------- */
250:
251: PROCEDURE Lines
252: ( p_control_rec IN oe_blanket_pub.Control_Rec_Type
253: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
254: , p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_Type
255: , p_x_old_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_Type
256: , x_return_status OUT NOCOPY VARCHAR2

Line 254: , p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_Type

250:
251: PROCEDURE Lines
252: ( p_control_rec IN oe_blanket_pub.Control_Rec_Type
253: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
254: , p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_Type
255: , p_x_old_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_Type
256: , x_return_status OUT NOCOPY VARCHAR2
257: )
258: IS

Line 255: , p_x_old_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_Type

251: PROCEDURE Lines
252: ( p_control_rec IN oe_blanket_pub.Control_Rec_Type
253: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
254: , p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_Type
255: , p_x_old_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_Type
256: , x_return_status OUT NOCOPY VARCHAR2
257: )
258: IS
259: l_old_line_rec OE_Blanket_PUB.line_rec_Type;

Line 259: l_old_line_rec OE_Blanket_PUB.line_rec_Type;

255: , p_x_old_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_Type
256: , x_return_status OUT NOCOPY VARCHAR2
257: )
258: IS
259: l_old_line_rec OE_Blanket_PUB.line_rec_Type;
260: l_line_rec OE_Blanket_PUB.line_rec_Type;
261: l_return_status varchar2(1);
262: I number;
263: l_sec_result NUMBER;

Line 260: l_line_rec OE_Blanket_PUB.line_rec_Type;

256: , x_return_status OUT NOCOPY VARCHAR2
257: )
258: IS
259: l_old_line_rec OE_Blanket_PUB.line_rec_Type;
260: l_line_rec OE_Blanket_PUB.line_rec_Type;
261: l_return_status varchar2(1);
262: I number;
263: l_sec_result NUMBER;
264: --

Line 531: , p_header_rec IN oe_blanket_pub.header_Rec_type :=

527: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
528: , x_return_status OUT NOCOPY VARCHAR2
529: , x_msg_count OUT NOCOPY NUMBER
530: , x_msg_data OUT NOCOPY VARCHAR2
531: , p_header_rec IN oe_blanket_pub.header_Rec_type :=
532: oe_blanket_pub.G_MISS_header_rec
533: , p_line_tbl IN oe_blanket_pub.line_tbl_Type :=
534: oe_blanket_pub.G_MISS_line_tbl
535: , p_control_rec IN oe_blanket_pub.Control_rec_type :=

Line 532: oe_blanket_pub.G_MISS_header_rec

528: , x_return_status OUT NOCOPY VARCHAR2
529: , x_msg_count OUT NOCOPY NUMBER
530: , x_msg_data OUT NOCOPY VARCHAR2
531: , p_header_rec IN oe_blanket_pub.header_Rec_type :=
532: oe_blanket_pub.G_MISS_header_rec
533: , p_line_tbl IN oe_blanket_pub.line_tbl_Type :=
534: oe_blanket_pub.G_MISS_line_tbl
535: , p_control_rec IN oe_blanket_pub.Control_rec_type :=
536: oe_blanket_pub.G_MISS_CONTROL_REC

Line 533: , p_line_tbl IN oe_blanket_pub.line_tbl_Type :=

529: , x_msg_count OUT NOCOPY NUMBER
530: , x_msg_data OUT NOCOPY VARCHAR2
531: , p_header_rec IN oe_blanket_pub.header_Rec_type :=
532: oe_blanket_pub.G_MISS_header_rec
533: , p_line_tbl IN oe_blanket_pub.line_tbl_Type :=
534: oe_blanket_pub.G_MISS_line_tbl
535: , p_control_rec IN oe_blanket_pub.Control_rec_type :=
536: oe_blanket_pub.G_MISS_CONTROL_REC
537: , x_header_rec OUT NOCOPY oe_blanket_pub.header_Rec_type

Line 534: oe_blanket_pub.G_MISS_line_tbl

530: , x_msg_data OUT NOCOPY VARCHAR2
531: , p_header_rec IN oe_blanket_pub.header_Rec_type :=
532: oe_blanket_pub.G_MISS_header_rec
533: , p_line_tbl IN oe_blanket_pub.line_tbl_Type :=
534: oe_blanket_pub.G_MISS_line_tbl
535: , p_control_rec IN oe_blanket_pub.Control_rec_type :=
536: oe_blanket_pub.G_MISS_CONTROL_REC
537: , x_header_rec OUT NOCOPY oe_blanket_pub.header_Rec_type
538: , x_line_tbl OUT NOCOPY oe_blanket_pub.line_tbl_Type

Line 535: , p_control_rec IN oe_blanket_pub.Control_rec_type :=

531: , p_header_rec IN oe_blanket_pub.header_Rec_type :=
532: oe_blanket_pub.G_MISS_header_rec
533: , p_line_tbl IN oe_blanket_pub.line_tbl_Type :=
534: oe_blanket_pub.G_MISS_line_tbl
535: , p_control_rec IN oe_blanket_pub.Control_rec_type :=
536: oe_blanket_pub.G_MISS_CONTROL_REC
537: , x_header_rec OUT NOCOPY oe_blanket_pub.header_Rec_type
538: , x_line_tbl OUT NOCOPY oe_blanket_pub.line_tbl_Type
539: )

Line 536: oe_blanket_pub.G_MISS_CONTROL_REC

532: oe_blanket_pub.G_MISS_header_rec
533: , p_line_tbl IN oe_blanket_pub.line_tbl_Type :=
534: oe_blanket_pub.G_MISS_line_tbl
535: , p_control_rec IN oe_blanket_pub.Control_rec_type :=
536: oe_blanket_pub.G_MISS_CONTROL_REC
537: , x_header_rec OUT NOCOPY oe_blanket_pub.header_Rec_type
538: , x_line_tbl OUT NOCOPY oe_blanket_pub.line_tbl_Type
539: )
540: IS

Line 537: , x_header_rec OUT NOCOPY oe_blanket_pub.header_Rec_type

533: , p_line_tbl IN oe_blanket_pub.line_tbl_Type :=
534: oe_blanket_pub.G_MISS_line_tbl
535: , p_control_rec IN oe_blanket_pub.Control_rec_type :=
536: oe_blanket_pub.G_MISS_CONTROL_REC
537: , x_header_rec OUT NOCOPY oe_blanket_pub.header_Rec_type
538: , x_line_tbl OUT NOCOPY oe_blanket_pub.line_tbl_Type
539: )
540: IS
541: l_api_name CONSTANT VARCHAR2(30):= 'Process_Blanket';

Line 538: , x_line_tbl OUT NOCOPY oe_blanket_pub.line_tbl_Type

534: oe_blanket_pub.G_MISS_line_tbl
535: , p_control_rec IN oe_blanket_pub.Control_rec_type :=
536: oe_blanket_pub.G_MISS_CONTROL_REC
537: , x_header_rec OUT NOCOPY oe_blanket_pub.header_Rec_type
538: , x_line_tbl OUT NOCOPY oe_blanket_pub.line_tbl_Type
539: )
540: IS
541: l_api_name CONSTANT VARCHAR2(30):= 'Process_Blanket';
542: l_return_status VARCHAR2(1);

Line 543: l_old_header_rec OE_Blanket_PUB.header_Rec_Type;

539: )
540: IS
541: l_api_name CONSTANT VARCHAR2(30):= 'Process_Blanket';
542: l_return_status VARCHAR2(1);
543: l_old_header_rec OE_Blanket_PUB.header_Rec_Type;
544: l_header_rec OE_Blanket_PUB.header_Rec_Type := p_header_rec;
545: l_line_rec OE_Blanket_PUB.Line_Rec_Type;
546: l_line_tbl OE_Blanket_PUB.line_tbl_Type := p_line_tbl;
547: l_old_line_rec OE_Blanket_PUB.Line_rec_Type;

Line 544: l_header_rec OE_Blanket_PUB.header_Rec_Type := p_header_rec;

540: IS
541: l_api_name CONSTANT VARCHAR2(30):= 'Process_Blanket';
542: l_return_status VARCHAR2(1);
543: l_old_header_rec OE_Blanket_PUB.header_Rec_Type;
544: l_header_rec OE_Blanket_PUB.header_Rec_Type := p_header_rec;
545: l_line_rec OE_Blanket_PUB.Line_Rec_Type;
546: l_line_tbl OE_Blanket_PUB.line_tbl_Type := p_line_tbl;
547: l_old_line_rec OE_Blanket_PUB.Line_rec_Type;
548: l_old_line_tbl OE_Blanket_PUB.line_tbl_Type;

Line 545: l_line_rec OE_Blanket_PUB.Line_Rec_Type;

541: l_api_name CONSTANT VARCHAR2(30):= 'Process_Blanket';
542: l_return_status VARCHAR2(1);
543: l_old_header_rec OE_Blanket_PUB.header_Rec_Type;
544: l_header_rec OE_Blanket_PUB.header_Rec_Type := p_header_rec;
545: l_line_rec OE_Blanket_PUB.Line_Rec_Type;
546: l_line_tbl OE_Blanket_PUB.line_tbl_Type := p_line_tbl;
547: l_old_line_rec OE_Blanket_PUB.Line_rec_Type;
548: l_old_line_tbl OE_Blanket_PUB.line_tbl_Type;
549: I number;

Line 546: l_line_tbl OE_Blanket_PUB.line_tbl_Type := p_line_tbl;

542: l_return_status VARCHAR2(1);
543: l_old_header_rec OE_Blanket_PUB.header_Rec_Type;
544: l_header_rec OE_Blanket_PUB.header_Rec_Type := p_header_rec;
545: l_line_rec OE_Blanket_PUB.Line_Rec_Type;
546: l_line_tbl OE_Blanket_PUB.line_tbl_Type := p_line_tbl;
547: l_old_line_rec OE_Blanket_PUB.Line_rec_Type;
548: l_old_line_tbl OE_Blanket_PUB.line_tbl_Type;
549: I number;
550:

Line 547: l_old_line_rec OE_Blanket_PUB.Line_rec_Type;

543: l_old_header_rec OE_Blanket_PUB.header_Rec_Type;
544: l_header_rec OE_Blanket_PUB.header_Rec_Type := p_header_rec;
545: l_line_rec OE_Blanket_PUB.Line_Rec_Type;
546: l_line_tbl OE_Blanket_PUB.line_tbl_Type := p_line_tbl;
547: l_old_line_rec OE_Blanket_PUB.Line_rec_Type;
548: l_old_line_tbl OE_Blanket_PUB.line_tbl_Type;
549: I number;
550:
551: --MOAC

Line 548: l_old_line_tbl OE_Blanket_PUB.line_tbl_Type;

544: l_header_rec OE_Blanket_PUB.header_Rec_Type := p_header_rec;
545: l_line_rec OE_Blanket_PUB.Line_Rec_Type;
546: l_line_tbl OE_Blanket_PUB.line_tbl_Type := p_line_tbl;
547: l_old_line_rec OE_Blanket_PUB.Line_rec_Type;
548: l_old_line_tbl OE_Blanket_PUB.line_tbl_Type;
549: I number;
550:
551: --MOAC
552: l_org_id NUMBER;

Line 658: oe_debug_pub.ADD('Exiting OE_BLANKET_PUB.PROCESS_BLANKET', 1);

654: );
655:
656:
657: if l_debug_level > 0 then
658: oe_debug_pub.ADD('Exiting OE_BLANKET_PUB.PROCESS_BLANKET', 1);
659: end if;
660: EXCEPTION
661:
662: WHEN FND_API.G_EXC_ERROR THEN