DBA Data[Home] [Help]

APPS.RLM_EXTINTERFACE_SV dependencies on OE_ORDER_PUB

Line 40: g_oe_line_tbl(x_linecount) := oe_order_pub.g_miss_line_rec;

36: END IF;
37: --
38: x_linecount := counter;
39: --
40: g_oe_line_tbl(x_linecount) := oe_order_pub.g_miss_line_rec;
41: --
42: RLM_TPA_SV.BuildOELine(g_oe_line_tbl(x_linecount),x_Op_tab(counter));
43: RLM_TPA_SV.BuildTpOELine(g_oe_line_tbl(x_linecount),x_Op_tab(counter));
44: --

Line 87: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

83: e_ProcessOrderFailed EXCEPTION;
84: v_DebugMode NUMBER;
85: v_FileName VARCHAR2(2000);
86: l_control_rec OE_GLOBALS.Control_Rec_Type := OE_GLOBALS.G_MISS_CONTROL_REC;
87: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
88: v_line_id NUMBER;
89: x_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
90: x_token FND_NEW_MESSAGES.TYPE%TYPE;
91: v_msg_text VARCHAR2(32000);

Line 94: l_oe_line_tbl_out oe_order_pub.line_tbl_type;

90: x_token FND_NEW_MESSAGES.TYPE%TYPE;
91: v_msg_text VARCHAR2(32000);
92: l_start_time NUMBER;
93: l_end_time NUMBER;
94: l_oe_line_tbl_out oe_order_pub.line_tbl_type;
95: --
96: BEGIN
97: --
98: IF (l_debug <> -1) THEN

Line 649: l_line_rec oe_order_pub.line_rec_type;

645: x_oe_api_version NUMBER:=1;
646: x_api_service_level VARCHAR2(30):= OE_GLOBALS.G_CHECK_SECURITY_ONLY;
647: e_ProcessConstraint EXCEPTION;
648: l_control_rec OE_GLOBALS.control_rec_type;
649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;

Line 650: l_line_tbl oe_order_pub.Line_Tbl_Type;

646: x_api_service_level VARCHAR2(30):= OE_GLOBALS.G_CHECK_SECURITY_ONLY;
647: e_ProcessConstraint EXCEPTION;
648: l_control_rec OE_GLOBALS.control_rec_type;
649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;

Line 651: l_header_out_rec oe_order_pub.Header_Rec_Type;

647: e_ProcessConstraint EXCEPTION;
648: l_control_rec OE_GLOBALS.control_rec_type;
649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;

Line 652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;

648: l_control_rec OE_GLOBALS.control_rec_type;
649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;

Line 653: l_header_val_rec oe_order_pub.header_val_rec_type;

649: l_line_rec oe_order_pub.line_rec_type;
650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;

Line 654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;

650: l_line_tbl oe_order_pub.Line_Tbl_Type;
651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;

Line 655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;

651: l_header_out_rec oe_order_pub.Header_Rec_Type;
652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;

Line 656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;

652: l_header_adj_out_tbl oe_order_pub.Header_Adj_Tbl_Type;
653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;

Line 657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;

653: l_header_val_rec oe_order_pub.header_val_rec_type;
654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;

Line 658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;

654: l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;

Line 659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;

655: l_Header_price_Att_out_tbl oe_order_pub.Header_Price_Att_Tbl_Type;
656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

Line 660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;

656: l_Header_Adj_Att_out_tbl oe_order_pub.Header_Adj_Att_Tbl_Type;
657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;

Line 661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;

657: l_Header_Adj_Assoc_out_tbl oe_order_pub.Header_Adj_Assoc_Tbl_Type;
658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;

Line 662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;

658: l_Header_Scredit_out_tbl oe_order_pub.Header_Scredit_Tbl_Type;
659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;

Line 663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

659: l_header_Scredit_val_tbl oe_order_pub.header_Scredit_val_Tbl_Type;
660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;

Line 664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;

660: l_line_out_tbl oe_order_pub.Line_Tbl_Type;
661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;

Line 665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;

661: l_line_val_tbl oe_order_pub.Line_val_Tbl_Type;
662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;

Line 666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;

662: l_line_adj_val_tbl oe_order_pub.line_Adj_val_Tbl_Type;
663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;

Line 667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;

663: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;

Line 668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;

664: l_Line_price_Att_out_tbl oe_order_pub.Line_price_Att_Tbl_Type;
665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
672: b_Result BOOLEAN := FALSE;

Line 669: l_action_request_out_tbl oe_order_pub.request_tbl_type;

665: l_Line_Adj_Att_out_tbl oe_order_pub.Line_Adj_Att_Tbl_Type;
666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
672: b_Result BOOLEAN := FALSE;
673: v_DebugMode NUMBER;

Line 670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;

666: l_Line_Adj_Assoc_out_tbl oe_order_pub.Line_Adj_Assoc_Tbl_Type;
667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
672: b_Result BOOLEAN := FALSE;
673: v_DebugMode NUMBER;
674: x_api_version_number NUMBER := 1;

Line 671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;

667: l_Line_Scredit_out_tbl oe_order_pub.Line_Scredit_Tbl_Type;
668: l_Line_Scredit_val_tbl oe_order_pub.Line_Scredit_val_Tbl_Type;
669: l_action_request_out_tbl oe_order_pub.request_tbl_type;
670: l_Lot_Serial_tbl oe_order_pub.Lot_Serial_Tbl_Type;
671: l_Lot_Serial_val_tbl oe_order_pub.Lot_Serial_val_Tbl_Type;
672: b_Result BOOLEAN := FALSE;
673: v_DebugMode NUMBER;
674: x_api_version_number NUMBER := 1;
675: v_interface_line NUMBER;

Line 687: l_line_tbl(1) := oe_order_pub.g_miss_line_rec;

683: rlm_core_sv.dpush(k_SDEBUG,'CallProcessConstraintAPI');
684: rlm_core_sv.dlog(k_DEBUG,'x_Operation',x_Operation);
685: END IF;
686: --
687: l_line_tbl(1) := oe_order_pub.g_miss_line_rec;
688: RLM_TPA_SV.BuildOELine(l_line_tbl(1),x_Key_rec.req_rec);
689: l_line_tbl(1).line_id := x_Key_rec.dem_rec.line_id;
690: l_line_tbl(1).operation := x_Operation;
691: l_line_tbl(1).ordered_quantity := x_OperationQty;

Line 1255: PROCEDURE BuildTPOELine(x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,

1251:
1252: PROCEDURE BuildTPOELine
1253:
1254: ===========================================================================*/
1255: PROCEDURE BuildTPOELine(x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
1256: x_Op_rec IN rlm_rd_sv.t_generic_rec)
1257: IS
1258: BEGIN
1259: --

Line 1333: PROCEDURE BuildOELine(x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,

1329:
1330: PROCEDURE BuildOELine
1331:
1332: ===========================================================================*/
1333: PROCEDURE BuildOELine(x_oe_line_rec IN OUT NOCOPY oe_order_pub.line_rec_type,
1334: x_Op_rec IN rlm_rd_sv.t_generic_rec)
1335: IS
1336: b_ATP BOOLEAN;
1337: BEGIN