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 299: --l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

295: END IF;
296: goto end_loop;
297: END IF;
298:
299: --l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
300: IF l_tblcount = 0 THEN
301: l_tblcount := 1;
302: END IF;
303: l_line_tbl(l_tblcount) := l_line_rec;

Line 430: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

426:
427: ,x_error_count OUT NOCOPY NUMBER
428:
429: ) IS
430: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
431: l_line_rec OE_ORDER_PUB.line_rec_type;
432: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
433: l_control_rec OE_GLOBALS.Control_Rec_Type;
434: l_api_name CONSTANT VARCHAR2(30) := 'Process_Cancel_Order';

Line 431: l_line_rec OE_ORDER_PUB.line_rec_type;

427: ,x_error_count OUT NOCOPY NUMBER
428:
429: ) IS
430: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
431: l_line_rec OE_ORDER_PUB.line_rec_type;
432: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
433: l_control_rec OE_GLOBALS.Control_Rec_Type;
434: l_api_name CONSTANT VARCHAR2(30) := 'Process_Cancel_Order';
435: l_header_id Number;

Line 432: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

428:
429: ) IS
430: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
431: l_line_rec OE_ORDER_PUB.line_rec_type;
432: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
433: l_control_rec OE_GLOBALS.Control_Rec_Type;
434: l_api_name CONSTANT VARCHAR2(30) := 'Process_Cancel_Order';
435: l_header_id Number;
436: l_return_status VARCHAR2(30);

Line 453: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

449: oe_msg_pub.initialize;
450: IF l_debug_level > 0 THEN
451: oe_debug_pub.add( 'PROCEDURE PROCESS_CANCEL_ORDER' , 1 ) ;
452: END IF;
453: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
454: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
455: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE; --OE.G_OPR_UPDATE;
456: x_error_count := l_error_count;
457: g_ord_lvl_can := TRUE; --Fix for bug# 2922468.

Line 454: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

450: IF l_debug_level > 0 THEN
451: oe_debug_pub.add( 'PROCEDURE PROCESS_CANCEL_ORDER' , 1 ) ;
452: END IF;
453: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
454: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
455: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE; --OE.G_OPR_UPDATE;
456: x_error_count := l_error_count;
457: g_ord_lvl_can := TRUE; --Fix for bug# 2922468.
458: IF l_debug_level > 0 THEN

Line 474: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

470: FOR i IN 1..l_num_of_records LOOP
471: SAVEPOINT Process_cancel_order;
472:
473:
474: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
475: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
476: IF l_orgid is null OR l_record_ids(i).org_id <> l_orgid THEN
477: l_orgid := l_record_ids(i).Org_Id;
478:

Line 475: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

471: SAVEPOINT Process_cancel_order;
472:
473:
474: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
475: l_old_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
476: IF l_orgid is null OR l_record_ids(i).org_id <> l_orgid THEN
477: l_orgid := l_record_ids(i).Org_Id;
478:
479: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

Line 643: RETURN OE_Order_PUB.Line_Rec_Type

639: FUNCTION Get_line
640: ( p_db_record IN BOOLEAN := FALSE
641: , p_line_id IN NUMBER
642: )
643: RETURN OE_Order_PUB.Line_Rec_Type
644: IS
645: --
646: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
647: --

Line 699: l_header_rec OE_ORDER_PUB.header_rec_type :=

695: x_msg_count OUT NOCOPY NUMBER,
696:
697: x_msg_data OUT NOCOPY VARCHAR2)IS
698:
699: l_header_rec OE_ORDER_PUB.header_rec_type :=
700: oe_order_pub.g_miss_header_rec;
701: l_api_name varchar2(30) := 'Cancel Remaining Order';
702: l_header_id Number;
703: j Integer;

Line 700: oe_order_pub.g_miss_header_rec;

696:
697: x_msg_data OUT NOCOPY VARCHAR2)IS
698:
699: l_header_rec OE_ORDER_PUB.header_rec_type :=
700: oe_order_pub.g_miss_header_rec;
701: l_api_name varchar2(30) := 'Cancel Remaining Order';
702: l_header_id Number;
703: j Integer;
704: initial Integer;

Line 727: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

723: */
724: l_num_of_records := p_num_of_records;
725: FOR i IN 1..l_num_of_records LOOP
726: SAVEPOINT Cancel_Remaining_Order;
727: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;
728: IF l_orgid is null OR l_record_ids(i).org_id <> l_orgid THEN
729: l_orgid := l_record_ids(i).Org_Id;
730:
731: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

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

809: ROLLBACK TO SAVEPOINT Cancel_Remaining_Order;
810:
811: END cancel_remaining_order;
812:
813: Procedure Call_Process_Order ( p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
814: p_old_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
815: x_return_status OUT NOCOPY VARCHAR2)
816: IS
817:

Line 814: p_old_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,

810:
811: END cancel_remaining_order;
812:
813: Procedure Call_Process_Order ( p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
814: p_old_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
815: x_return_status OUT NOCOPY VARCHAR2)
816: IS
817:
818: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_line_tbl;

Line 818: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_line_tbl;

814: p_old_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
815: x_return_status OUT NOCOPY VARCHAR2)
816: IS
817:
818: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_line_tbl;
819: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_old_line_tbl;
820: x_msg_count number;
821: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
822: x_msg_data varchar2(32000);

Line 819: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_old_line_tbl;

815: x_return_status OUT NOCOPY VARCHAR2)
816: IS
817:
818: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_line_tbl;
819: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE := p_old_line_tbl;
820: x_msg_count number;
821: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
822: x_msg_data varchar2(32000);
823: l_control_rec OE_GLOBALS.Control_Rec_Type;