DBA Data[Home] [Help]

APPS.OE_OE_FORM_CANCEL_LINE dependencies on OE_ORDER_PUB

Line 20: g_line_rec OE_Order_PUB.Line_Rec_Type;

16: --
17: -- Notes
18: --
19: -- End of Comments
20: g_line_rec OE_Order_PUB.Line_Rec_Type;
21: g_db_line_rec OE_Order_PUB.Line_Rec_Type;
22: FUNCTION Get_line
23: ( p_db_record IN BOOLEAN := FALSE
24: , p_line_id IN NUMBER

Line 21: g_db_line_rec OE_Order_PUB.Line_Rec_Type;

17: -- Notes
18: --
19: -- End of Comments
20: g_line_rec OE_Order_PUB.Line_Rec_Type;
21: g_db_line_rec OE_Order_PUB.Line_Rec_Type;
22: FUNCTION Get_line
23: ( p_db_record IN BOOLEAN := FALSE
24: , p_line_id IN NUMBER
25: )

Line 26: RETURN OE_Order_PUB.Line_Rec_Type;

22: FUNCTION Get_line
23: ( p_db_record IN BOOLEAN := FALSE
24: , p_line_id IN NUMBER
25: )
26: RETURN OE_Order_PUB.Line_Rec_Type;
27:
28: Procedure Process_cancel_quantity
29: ( p_num_of_records IN NUMBER
30: ,p_record_ids IN OE_GLOBALS.Selected_Record_Tbl -- MOAC

Line 45: l_line_rec OE_ORDER_PUB.line_rec_type;

41:
42: ,x_error_count OUT NOCOPY NUMBER
43:
44: ) IS
45: l_line_rec OE_ORDER_PUB.line_rec_type;
46: l_control_rec OE_GLOBALS.Control_Rec_Type;
47: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
48: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
49: l_api_name CONSTANT VARCHAR2(30) := 'Process_Cancel_quantity';

Line 47: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

43:
44: ) IS
45: l_line_rec OE_ORDER_PUB.line_rec_type;
46: l_control_rec OE_GLOBALS.Control_Rec_Type;
47: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
48: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
49: l_api_name CONSTANT VARCHAR2(30) := 'Process_Cancel_quantity';
50: l_line_id NUMBER;
51: l_return_status VARCHAR2(30);

Line 48: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

44: ) IS
45: l_line_rec OE_ORDER_PUB.line_rec_type;
46: l_control_rec OE_GLOBALS.Control_Rec_Type;
47: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
48: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
49: l_api_name CONSTANT VARCHAR2(30) := 'Process_Cancel_quantity';
50: l_line_id NUMBER;
51: l_return_status VARCHAR2(30);
52: l_error_count NUMBER :=0;

Line 114: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

110: END IF;
111: l_num_of_records := p_num_of_records;
112: g_num_of_records := l_num_of_records; -- Added For bug#2965878
113:
114: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
115: l_old_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
116:
117: SAVEPOINT Process_cancel_quantity;
118:

Line 115: l_old_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

111: l_num_of_records := p_num_of_records;
112: g_num_of_records := l_num_of_records; -- Added For bug#2965878
113:
114: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
115: l_old_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
116:
117: SAVEPOINT Process_cancel_quantity;
118:
119: IF l_orgid is null THEN

Line 293: --l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

289: END IF;
290: goto end_loop;
291: END IF;
292:
293: --l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
294: IF l_tblcount = 0 THEN
295: l_tblcount := 1;
296: END IF;
297: l_line_tbl(l_tblcount) := l_line_rec;

Line 424: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

420:
421: ,x_error_count OUT NOCOPY NUMBER
422:
423: ) IS
424: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
425: l_line_rec OE_ORDER_PUB.line_rec_type;
426: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
427: l_control_rec OE_GLOBALS.Control_Rec_Type;
428: l_api_name CONSTANT VARCHAR2(30) := 'Process_Cancel_Order';

Line 425: l_line_rec OE_ORDER_PUB.line_rec_type;

421: ,x_error_count OUT NOCOPY NUMBER
422:
423: ) IS
424: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
425: l_line_rec OE_ORDER_PUB.line_rec_type;
426: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
427: l_control_rec OE_GLOBALS.Control_Rec_Type;
428: l_api_name CONSTANT VARCHAR2(30) := 'Process_Cancel_Order';
429: l_header_id Number;

Line 426: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

422:
423: ) IS
424: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
425: l_line_rec OE_ORDER_PUB.line_rec_type;
426: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
427: l_control_rec OE_GLOBALS.Control_Rec_Type;
428: l_api_name CONSTANT VARCHAR2(30) := 'Process_Cancel_Order';
429: l_header_id Number;
430: l_return_status VARCHAR2(30);

Line 447: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

443: oe_msg_pub.initialize;
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'PROCEDURE PROCESS_CANCEL_ORDER' , 1 ) ;
446: END IF;
447: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
448: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
449: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE; --OE.G_OPR_UPDATE;
450: x_error_count := l_error_count;
451: g_ord_lvl_can := TRUE; --Fix for bug# 2922468.

Line 448: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'PROCEDURE PROCESS_CANCEL_ORDER' , 1 ) ;
446: END IF;
447: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
448: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
449: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE; --OE.G_OPR_UPDATE;
450: x_error_count := l_error_count;
451: g_ord_lvl_can := TRUE; --Fix for bug# 2922468.
452: IF l_debug_level > 0 THEN

Line 468: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

464: FOR i IN 1..l_num_of_records LOOP
465: SAVEPOINT Process_cancel_order;
466:
467:
468: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
469: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
470: IF l_orgid is null OR l_record_ids(i).org_id <> l_orgid THEN
471: l_orgid := l_record_ids(i).Org_Id;
472:

Line 469: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

465: SAVEPOINT Process_cancel_order;
466:
467:
468: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
469: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
470: IF l_orgid is null OR l_record_ids(i).org_id <> l_orgid THEN
471: l_orgid := l_record_ids(i).Org_Id;
472:
473: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

Line 632: RETURN OE_Order_PUB.Line_Rec_Type

628: FUNCTION Get_line
629: ( p_db_record IN BOOLEAN := FALSE
630: , p_line_id IN NUMBER
631: )
632: RETURN OE_Order_PUB.Line_Rec_Type
633: IS
634: --
635: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
636: --

Line 688: l_header_rec OE_ORDER_PUB.header_rec_type :=

684: x_msg_count OUT NOCOPY NUMBER,
685:
686: x_msg_data OUT NOCOPY VARCHAR2)IS
687:
688: l_header_rec OE_ORDER_PUB.header_rec_type :=
689: oe_order_pub.g_miss_header_rec;
690: l_api_name varchar2(30) := 'Cancel Remaining Order';
691: l_header_id Number;
692: j Integer;

Line 689: oe_order_pub.g_miss_header_rec;

685:
686: x_msg_data OUT NOCOPY VARCHAR2)IS
687:
688: l_header_rec OE_ORDER_PUB.header_rec_type :=
689: oe_order_pub.g_miss_header_rec;
690: l_api_name varchar2(30) := 'Cancel Remaining Order';
691: l_header_id Number;
692: j Integer;
693: initial Integer;

Line 716: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

712: */
713: l_num_of_records := p_num_of_records;
714: FOR i IN 1..l_num_of_records LOOP
715: SAVEPOINT Cancel_Remaining_Order;
716: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
717: IF l_orgid is null OR l_record_ids(i).org_id <> l_orgid THEN
718: l_orgid := l_record_ids(i).Org_Id;
719:
720: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

Line 802: Procedure Call_Process_Order ( p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,

798: ROLLBACK TO SAVEPOINT Cancel_Remaining_Order;
799:
800: END cancel_remaining_order;
801:
802: Procedure Call_Process_Order ( p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
803: p_old_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
804: x_return_status OUT NOCOPY VARCHAR2)
805: IS
806:

Line 803: p_old_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,

799:
800: END cancel_remaining_order;
801:
802: Procedure Call_Process_Order ( p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
803: p_old_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
804: x_return_status OUT NOCOPY VARCHAR2)
805: IS
806:
807: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_line_tbl;

Line 807: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_line_tbl;

803: p_old_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
804: x_return_status OUT NOCOPY VARCHAR2)
805: IS
806:
807: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_line_tbl;
808: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_old_line_tbl;
809: x_msg_count number;
810: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
811: x_msg_data varchar2(32000);

Line 808: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_old_line_tbl;

804: x_return_status OUT NOCOPY VARCHAR2)
805: IS
806:
807: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_line_tbl;
808: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_old_line_tbl;
809: x_msg_count number;
810: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
811: x_msg_data varchar2(32000);
812: l_control_rec OE_GLOBALS.Control_Rec_Type;