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: -----------------------------------------------------------------------*/
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
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
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;
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;
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
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
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;
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;
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: --
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 :=
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
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
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
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: )
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
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';
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);
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;
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;
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;
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:
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
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;
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