eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_ORDER_SAVE_PVT dependencies on OE_ORDER_PUB

Line 271: PROCEDURE DefaultFromLineSiteId(p_line_tbl IN OE_Order_PUB.Line_Tbl_Type

267:
268: END ActivateOrder;
269:
270:
271: PROCEDURE DefaultFromLineSiteId(p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
272: ,p_party_id IN NUMBER
273: ,p_siteuse_type IN VARCHAR2
274: ,x_site_use_id OUT NOCOPY NUMBER)
275: IS

Line 342: p_order_line_rec IN OE_Order_PUB.Line_Rec_Type,

338: END DefaultFromLineSiteId;
339:
340: PROCEDURE MergeLines(
341: p_header_id IN Number,
342: p_order_line_rec IN OE_Order_PUB.Line_Rec_Type,
343: x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
344: )
345: IS
346: cursor c_get_lineInfo(l_lineid varchar2,l_ordhdrId varchar2,l_rethdrId number) is

Line 343: x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type

339:
340: PROCEDURE MergeLines(
341: p_header_id IN Number,
342: p_order_line_rec IN OE_Order_PUB.Line_Rec_Type,
343: x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
344: )
345: IS
346: cursor c_get_lineInfo(l_lineid varchar2,l_ordhdrId varchar2,l_rethdrId number) is
347: select * from oe_order_lines_all

Line 370: x_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

366: if (c_get_lineInfo%found) then
367: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
368: Ibe_Util.Debug('MergeLines Already a record exists.');
369: END IF;
370: x_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
371: x_line_rec.item_type_code := p_order_line_rec.item_type_code;
372: x_line_rec.ordered_quantity := p_order_line_rec.ordered_quantity + l_line_rec.ordered_quantity;
373: x_line_rec.line_id := l_line_rec.line_id;
374: x_line_rec.operation := OE_Globals.G_OPR_UPDATE;

Line 422: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type

418: END DefaultLineTypes;
419:
420:
421: PROCEDURE DefaultLineRecord(
422: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type
423: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
424: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
425: ,x_order_line_tbl OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
426: )

Line 423: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type

419:
420:
421: PROCEDURE DefaultLineRecord(
422: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type
423: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
424: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
425: ,x_order_line_tbl OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
426: )
427: IS

Line 425: ,x_order_line_tbl OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

421: PROCEDURE DefaultLineRecord(
422: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type
423: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
424: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
425: ,x_order_line_tbl OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
426: )
427: IS
428:
429: CURSOR c_salesrep_info(l_lineid number) IS

Line 442: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_Order_PUB.G_MISS_LINE_TBL;

438: where line_id= c_origqtyLineId;
439:
440: l_tmp_origQty NUMBER;
441: l_salesrep_info_rec c_salesrep_info%rowtype;
442: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_Order_PUB.G_MISS_LINE_TBL;
443: l_linetype_id NUMBER;
444: lx_line_rec OE_Order_PUB.Line_Rec_Type;
445: l_salesrep_id NUMBER;
446: l_orderhdr_typeid NUMBER;

Line 444: lx_line_rec OE_Order_PUB.Line_Rec_Type;

440: l_tmp_origQty NUMBER;
441: l_salesrep_info_rec c_salesrep_info%rowtype;
442: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_Order_PUB.G_MISS_LINE_TBL;
443: l_linetype_id NUMBER;
444: lx_line_rec OE_Order_PUB.Line_Rec_Type;
445: l_salesrep_id NUMBER;
446: l_orderhdr_typeid NUMBER;
447:
448: BEGIN

Line 655: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC

651: END GetActiveReturnOrder;
652:
653:
654: PROCEDURE DefaultHeaderRecord(
655: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC
656: ,p_party_id IN NUMBER
657: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
658: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
659: )

Line 658: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type

654: PROCEDURE DefaultHeaderRecord(
655: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC
656: ,p_party_id IN NUMBER
657: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
658: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
659: )
660: IS
661:
662: CURSOR c_defaulthdr_rec(c_ordhdr_id number) IS

Line 874: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type

870: END DefaultHeaderRecord;
871:
872:
873: PROCEDURE CancelOrder(
874: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
875: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
876: )
877: IS
878: cursor c_get_hdrInfo(l_hrdId Number) is

Line 875: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type

871:
872:
873: PROCEDURE CancelOrder(
874: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
875: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
876: )
877: IS
878: cursor c_get_hdrInfo(l_hrdId Number) is
879: select flow_status_code, order_category_code from oe_order_headers_all where header_id = l_hrdId;

Line 927: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type

923:
924: END CancelOrder;
925:
926: PROCEDURE DefaultHdrLineAddress(
927: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type
928: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
929: ,p_party_id IN NUMBER:= FND_API.G_MISS_NUM
930: ,p_shipto_partysite_id IN NUMBER:= FND_API.G_MISS_NUM
931: ,p_billto_partysite_id IN NUMBER:= FND_API.G_MISS_NUM

Line 928: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type

924: END CancelOrder;
925:
926: PROCEDURE DefaultHdrLineAddress(
927: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type
928: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
929: ,p_party_id IN NUMBER:= FND_API.G_MISS_NUM
930: ,p_shipto_partysite_id IN NUMBER:= FND_API.G_MISS_NUM
931: ,p_billto_partysite_id IN NUMBER:= FND_API.G_MISS_NUM
932: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type

Line 932: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type

928: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
929: ,p_party_id IN NUMBER:= FND_API.G_MISS_NUM
930: ,p_shipto_partysite_id IN NUMBER:= FND_API.G_MISS_NUM
931: ,p_billto_partysite_id IN NUMBER:= FND_API.G_MISS_NUM
932: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
933: ,x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
934: ,x_return_status OUT NOCOPY VARCHAR2
935: ,x_msg_count OUT NOCOPY NUMBER
936: ,x_msg_data OUT NOCOPY VARCHAR2

Line 933: ,x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

929: ,p_party_id IN NUMBER:= FND_API.G_MISS_NUM
930: ,p_shipto_partysite_id IN NUMBER:= FND_API.G_MISS_NUM
931: ,p_billto_partysite_id IN NUMBER:= FND_API.G_MISS_NUM
932: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
933: ,x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
934: ,x_return_status OUT NOCOPY VARCHAR2
935: ,x_msg_count OUT NOCOPY NUMBER
936: ,x_msg_data OUT NOCOPY VARCHAR2
937: )

Line 1252: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC,

1248: END DefaultHdrLineAddress;
1249:
1250:
1251: PROCEDURE SetLineShipInvoiceIds(
1252: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC,
1253: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL,
1254: x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1255: )
1256: IS

Line 1253: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL,

1249:
1250:
1251: PROCEDURE SetLineShipInvoiceIds(
1252: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC,
1253: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL,
1254: x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1255: )
1256: IS
1257:

Line 1254: x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

1250:
1251: PROCEDURE SetLineShipInvoiceIds(
1252: p_order_header_rec IN OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC,
1253: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL,
1254: x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1255: )
1256: IS
1257:
1258: Cursor c_get_hdr_ids(cl_hdr_id number) IS

Line 1262: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;

1258: Cursor c_get_hdr_ids(cl_hdr_id number) IS
1259: select ship_to_org_id,invoice_to_org_id from oe_order_headers_all where header_id = cl_hdr_id;
1260:
1261: l_get_hdr_ids c_get_hdr_ids%rowtype;
1262: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;
1263: l_shipto_org_id NUMBER;
1264: l_invoiceto_org_id NUMBER;
1265: l_db_shipto_org_id NUMBER;
1266: l_db_invoiceto_org_id NUMBER;

Line 1385: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;

1381: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1382: IBE_Util.debug('line id from line: '|| l_lineid);
1383: end if;
1384: l_linetbl_count := l_linetbl_count +1;
1385: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;
1386: l_order_line_tbl(l_linetbl_count).line_id := l_lineid;
1387: l_order_line_tbl(l_linetbl_count).operation := OE_Globals.G_OPR_UPDATE;
1388: l_order_line_tbl(l_linetbl_count).invoice_to_org_id := l_invoiceto_org_id;
1389: l_order_line_tbl(l_linetbl_count).ship_to_org_id := l_shipto_org_id;

Line 1419: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type,

1415: -- SO IT CANT BE OVERWRITTEN WHICH CREATES UNNECESSARY PBM WHILE BOOKING THE RETURN.
1416: -- UNTIL OE UPTAKES MODEL/CHILDEN RELATION IN RETURN ORDERS DONT OVERRIDE.
1417:
1418: Procedure SaveMDLRelatedOperations(p_context_type IN VARCHAR2,
1419: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
1420: p_order_header_id IN NUMBER,
1421: p_save_type IN VARCHAR2:=FND_API.G_MISS_CHAR,
1422: x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1423: )

Line 1422: x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

1418: Procedure SaveMDLRelatedOperations(p_context_type IN VARCHAR2,
1419: p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
1420: p_order_header_id IN NUMBER,
1421: p_save_type IN VARCHAR2:=FND_API.G_MISS_CHAR,
1422: x_order_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
1423: )
1424: IS
1425:
1426: cursor l_childlineid_cur(c_mdlop_lineid Number, c_modop_hdr_id number) is

Line 1452: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;

1448:
1449: l_tmpparent_rec l_tmpparent_cur%rowtype;
1450: l_childlineid_rec l_childlineid_cur%rowtype;
1451: c_linetmp_rec c_linetmp_cur%rowtype;
1452: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;
1453: l_origparent_qty NUMBER;
1454: l_origchild_qty NUMBER;
1455: l_new_qty NUMBER;
1456: l_linetbl_count NUMBER;

Line 1492: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;

1488: END IF;
1489: for l_childlineid_rec in l_childlineid_cur(l_order_line_tbl(i).LINE_ID,p_order_header_id)
1490: loop
1491: l_linetbl_count := l_linetbl_count+1;
1492: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;
1493: l_order_line_tbl(l_linetbl_count).LINE_ID := l_childlineid_rec.LINE_ID;
1494: l_order_line_tbl(l_linetbl_count).OPERATION := OE_Globals.G_OPR_DELETE;
1495: end loop;
1496: end if;

Line 1522: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;

1518:
1519: for l_childlineid_rec in l_childlineid_cur(l_order_line_tbl(i).LINE_ID,p_order_header_id)
1520: loop
1521: l_linetbl_count := l_linetbl_count+1;
1522: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;
1523: l_order_line_tbl(l_linetbl_count).LINE_ID := l_childlineid_rec.LINE_ID;
1524: l_order_line_tbl(l_linetbl_count).OPERATION := OE_Globals.G_OPR_UPDATE;
1525:
1526: if(l_order_line_tbl(i).ORDERED_QUANTITY is not null

Line 1575: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;

1571: if (l_line_type IN ('MODEL','KIT')) then
1572: for l_childlineid_rec in l_childlineid_cur(l_order_line_tbl(k).LINE_ID,p_order_header_id)
1573: loop
1574: l_linetbl_count := l_linetbl_count+1;
1575: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;
1576: l_order_line_tbl(l_linetbl_count).LINE_ID := l_childlineid_rec.LINE_ID;
1577: l_order_line_tbl(l_linetbl_count).OPERATION := OE_Globals.G_OPR_UPDATE;
1578:
1579: if(l_order_line_tbl(k).ship_to_contact_id is not null AND

Line 1694: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;

1690: ORDER BY line_number;
1691:
1692:
1693: QtyChkLineRec QtyChkLineCur%rowtype;
1694: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;
1695:
1696: l_api_name VARCHAR2(50) := 'CheckOverReturnQty';
1697: l_api_version NUMBER := 1.0;
1698: lineTblCnt NUMBER := 0;

Line 1777: l_order_line_tbl(lineTblCnt) := OE_Order_PUB.G_MISS_LINE_REC;

1773: OPEN QtyChkLineCur(p_order_header_id);
1774: LOOP
1775: FETCH QtyChkLineCur INTO QtyChkLineRec;
1776: EXIT WHEN QtyChkLineCur%NOTFOUND;
1777: l_order_line_tbl(lineTblCnt) := OE_Order_PUB.G_MISS_LINE_REC;
1778: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1779: IBE_Util.Debug('Line Id: '||QtyChkLineRec.LINE_ID);
1780: END IF;
1781: l_order_line_tbl(lineTblCnt).LINE_ID := QtyChkLineRec.LINE_ID;

Line 2697: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type

2693: PROCEDURE Save(
2694: p_api_version_number IN NUMBER
2695: ,p_init_msg_list IN VARCHAR2
2696: ,p_commit IN VARCHAR2
2697: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
2698: ,p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type
2699: ,p_submit_control_rec IN IBE_Order_W1_PVT.Control_Rec_Type
2700: ,p_save_type IN NUMBER
2701: ,p_party_id IN NUMBER

Line 2698: ,p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type

2694: p_api_version_number IN NUMBER
2695: ,p_init_msg_list IN VARCHAR2
2696: ,p_commit IN VARCHAR2
2697: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
2698: ,p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type
2699: ,p_submit_control_rec IN IBE_Order_W1_PVT.Control_Rec_Type
2700: ,p_save_type IN NUMBER
2701: ,p_party_id IN NUMBER
2702: ,p_shipto_partysite_id IN NUMBER

Line 2721: l_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_PUB.G_MISS_HEADER_REC;

2717:
2718: cursor cr_persontype(cr_prtyid number) is
2719: select party_type from hz_parties where party_id = cr_prtyid;
2720:
2721: l_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_PUB.G_MISS_HEADER_REC;
2722:
2723: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
2724: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
2725: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;

Line 2723: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;

2719: select party_type from hz_parties where party_id = cr_prtyid;
2720:
2721: l_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_PUB.G_MISS_HEADER_REC;
2722:
2723: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
2724: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
2725: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
2726: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
2727: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;

Line 2724: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;

2720:
2721: l_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_PUB.G_MISS_HEADER_REC;
2722:
2723: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
2724: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
2725: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
2726: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
2727: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
2728:

Line 2725: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;

2721: l_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_PUB.G_MISS_HEADER_REC;
2722:
2723: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
2724: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
2725: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
2726: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
2727: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
2728:
2729: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_TBL;

Line 2726: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;

2722:
2723: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
2724: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
2725: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
2726: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
2727: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
2728:
2729: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
2730: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;

Line 2727: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;

2723: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
2724: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
2725: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
2726: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
2727: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
2728:
2729: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
2730: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
2731: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;

Line 2729: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_TBL;

2725: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
2726: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
2727: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
2728:
2729: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
2730: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
2731: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
2732: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
2733: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;

Line 2730: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;

2726: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
2727: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
2728:
2729: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
2730: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
2731: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
2732: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
2733: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
2734: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;

Line 2731: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;

2727: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
2728:
2729: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
2730: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
2731: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
2732: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
2733: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
2734: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
2735: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;

Line 2732: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;

2728:
2729: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
2730: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
2731: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
2732: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
2733: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
2734: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
2735: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
2736: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

Line 2733: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;

2729: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
2730: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
2731: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
2732: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
2733: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
2734: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
2735: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
2736: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2737:

Line 2734: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;

2730: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
2731: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
2732: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
2733: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
2734: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
2735: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
2736: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2737:
2738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

Line 2735: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;

2731: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
2732: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
2733: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
2734: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
2735: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
2736: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2737:
2738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2739: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

Line 2736: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

2732: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
2733: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
2734: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
2735: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
2736: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2737:
2738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2739: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2740: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

Line 2738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

2734: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
2735: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
2736: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2737:
2738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2739: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2740: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
2741: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2742: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

Line 2739: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

2735: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
2736: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2737:
2738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2739: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2740: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
2741: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2742: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2743: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

Line 2740: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

2736: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2737:
2738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2739: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2740: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
2741: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2742: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2743: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2744: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

Line 2741: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

2737:
2738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2739: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2740: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
2741: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2742: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2743: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2744: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2745: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=OE_Order_PUB.G_MISS_REQUEST_TBL;

Line 2742: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

2738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2739: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2740: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
2741: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2742: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2743: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2744: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2745: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=OE_Order_PUB.G_MISS_REQUEST_TBL;
2746:

Line 2743: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

2739: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2740: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
2741: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2742: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2743: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2744: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2745: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=OE_Order_PUB.G_MISS_REQUEST_TBL;
2746:
2747: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2744: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

2740: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
2741: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2742: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2743: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2744: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2745: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=OE_Order_PUB.G_MISS_REQUEST_TBL;
2746:
2747: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2748: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

Line 2745: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=OE_Order_PUB.G_MISS_REQUEST_TBL;

2741: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2742: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2743: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2744: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2745: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=OE_Order_PUB.G_MISS_REQUEST_TBL;
2746:
2747: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2748: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2749: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

Line 2747: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2743: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2744: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2745: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=OE_Order_PUB.G_MISS_REQUEST_TBL;
2746:
2747: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2748: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2749: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2750: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2748: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

2744: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2745: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=OE_Order_PUB.G_MISS_REQUEST_TBL;
2746:
2747: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2748: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2749: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2750: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2749: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

2745: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=OE_Order_PUB.G_MISS_REQUEST_TBL;
2746:
2747: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2748: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2749: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2750: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 2750: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

2746:
2747: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2748: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2749: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2750: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2747: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2748: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2749: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2750: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2748: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2749: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2750: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2756: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

2749: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2750: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2756: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2757: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

2750: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2756: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2757: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2758: lx_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_Pub.G_MISS_HEADER_REC;

Line 2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

2751: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2756: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2757: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2758: lx_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_Pub.G_MISS_HEADER_REC;
2759: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2756: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2752: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2756: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2757: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2758: lx_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_Pub.G_MISS_HEADER_REC;
2759: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2760:

Line 2757: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2753: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2756: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2757: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2758: lx_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_Pub.G_MISS_HEADER_REC;
2759: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2760:
2761: x_mergeline_rec OE_Order_PUB.Line_Rec_Type;

Line 2758: lx_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_Pub.G_MISS_HEADER_REC;

2754: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2756: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2757: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2758: lx_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_Pub.G_MISS_HEADER_REC;
2759: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2760:
2761: x_mergeline_rec OE_Order_PUB.Line_Rec_Type;
2762: lx_line_rec OE_Order_PUB.Line_rec_type;

Line 2759: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;

2755: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2756: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2757: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2758: lx_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_Pub.G_MISS_HEADER_REC;
2759: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2760:
2761: x_mergeline_rec OE_Order_PUB.Line_Rec_Type;
2762: lx_line_rec OE_Order_PUB.Line_rec_type;
2763: l_return_values varchar2(2000);

Line 2761: x_mergeline_rec OE_Order_PUB.Line_Rec_Type;

2757: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2758: lx_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_Pub.G_MISS_HEADER_REC;
2759: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2760:
2761: x_mergeline_rec OE_Order_PUB.Line_Rec_Type;
2762: lx_line_rec OE_Order_PUB.Line_rec_type;
2763: l_return_values varchar2(2000);
2764: l_api_name VARCHAR2(50) := 'Save_Order';
2765: l_api_version NUMBER := 1.0;

Line 2762: lx_line_rec OE_Order_PUB.Line_rec_type;

2758: lx_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_Pub.G_MISS_HEADER_REC;
2759: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2760:
2761: x_mergeline_rec OE_Order_PUB.Line_Rec_Type;
2762: lx_line_rec OE_Order_PUB.Line_rec_type;
2763: l_return_values varchar2(2000);
2764: l_api_name VARCHAR2(50) := 'Save_Order';
2765: l_api_version NUMBER := 1.0;
2766:

Line 3071: l_order_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

3067: end if;
3068:
3069: IF(l_order_header_rec.operation = OE_Globals.G_OPR_DELETE) THEN
3070: l_cancel_flow := FND_API.G_TRUE;
3071: l_order_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
3072: END IF;
3073: END IF; --No Of Existing Lines
3074:
3075: ENd If; --Main If

Line 3464: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type

3460: PROCEDURE CheckConstraint(
3461: p_api_version_number IN NUMBER
3462: ,p_init_msg_list IN VARCHAR2
3463: ,p_commit IN VARCHAR2
3464: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
3465: ,p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type
3466: ,p_submit_control_rec IN IBE_Order_W1_PVT.Control_Rec_Type
3467: ,p_combine_same_lines IN VARCHAR2
3468: ,p_party_id IN NUMBER

Line 3465: ,p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type

3461: p_api_version_number IN NUMBER
3462: ,p_init_msg_list IN VARCHAR2
3463: ,p_commit IN VARCHAR2
3464: ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type
3465: ,p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type
3466: ,p_submit_control_rec IN IBE_Order_W1_PVT.Control_Rec_Type
3467: ,p_combine_same_lines IN VARCHAR2
3468: ,p_party_id IN NUMBER
3469: ,x_return_status OUT NOCOPY VARCHAR2

Line 3494: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;

3490: -- could be removed and HeaderRecord, LineTable and ControlRecord could be sent
3491: -- together in a Single Call.
3492:
3493:
3494: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3495: l_retplcy_orderhdr_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3496: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3497: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3498: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 3495: l_retplcy_orderhdr_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;

3491: -- together in a Single Call.
3492:
3493:
3494: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3495: l_retplcy_orderhdr_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3496: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3497: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3498: l_control_rec OE_GLOBALS.Control_Rec_Type;
3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

Line 3496: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;

3492:
3493:
3494: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3495: l_retplcy_orderhdr_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3496: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3497: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3498: l_control_rec OE_GLOBALS.Control_Rec_Type;
3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

Line 3497: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

3493:
3494: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3495: l_retplcy_orderhdr_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3496: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3497: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3498: l_control_rec OE_GLOBALS.Control_Rec_Type;
3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

Line 3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

3495: l_retplcy_orderhdr_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3496: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3497: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3498: l_control_rec OE_GLOBALS.Control_Rec_Type;
3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3503: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

Line 3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

3496: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3497: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3498: l_control_rec OE_GLOBALS.Control_Rec_Type;
3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3503: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3504: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

Line 3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

3497: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3498: l_control_rec OE_GLOBALS.Control_Rec_Type;
3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3503: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3504: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3505: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

Line 3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

3498: l_control_rec OE_GLOBALS.Control_Rec_Type;
3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3503: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3504: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3505: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3506: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;

Line 3503: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3503: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3504: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3505: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3506: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3507:

Line 3504: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3503: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3504: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3505: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3506: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3507:
3508: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 3505: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3503: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3504: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3505: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3506: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3507:
3508: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3509: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

Line 3506: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;

3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3503: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3504: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3505: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3506: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3507:
3508: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3509: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3510: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

Line 3508: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3504: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3505: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3506: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3507:
3508: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3509: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3510: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3511: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3509: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

3505: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3506: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3507:
3508: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3509: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3510: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3511: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 3510: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

3506: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3507:
3508: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3509: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3510: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3511: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 3511: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

3507:
3508: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3509: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3510: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3511: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3508: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3509: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3510: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3511: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

3509: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3510: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3511: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3517: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

3510: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3511: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3517: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3518: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

3511: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3517: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3518: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3519: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;

Line 3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

3512: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3517: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3518: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3519: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3520: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 3517: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3513: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3517: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3518: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3519: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3520: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
3521:

Line 3518: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3514: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3517: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3518: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3519: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3520: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
3521:
3522: l_tmp_line_id varchar2(100) := '';

Line 3519: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;

3515: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3517: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3518: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3519: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3520: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
3521:
3522: l_tmp_line_id varchar2(100) := '';
3523: l_line_id number;

Line 3520: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;

3516: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3517: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3518: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3519: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3520: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
3521:
3522: l_tmp_line_id varchar2(100) := '';
3523: l_line_id number;
3524: l_line_return_status varchar2(10);

Line 3533: l_line_rec OE_Order_PUB.Line_Rec_Type;

3529:
3530: cursor c_get_lineInfo(l_lineId Number) is
3531: select * from oe_order_lines_all where line_id = l_lineId;
3532:
3533: l_line_rec OE_Order_PUB.Line_Rec_Type;
3534: l_line_type_id NUMBER;
3535: l_siteuse_id NUMBER;
3536:
3537: TYPE Fail_TmpLineRec IS TABLE OF VARCHAR2(240)

Line 3950: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;

3946: l_return_values varchar2(2000);
3947: l_api_version NUMBER := 1.0;
3948: l_api_name VARCHAR2(30) := 'ORDER_UPDATELINEBILL';
3949:
3950: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3951: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3952: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3953: l_control_rec OE_GLOBALS.Control_Rec_Type;
3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

Line 3951: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

3947: l_api_version NUMBER := 1.0;
3948: l_api_name VARCHAR2(30) := 'ORDER_UPDATELINEBILL';
3949:
3950: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3951: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3952: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3953: l_control_rec OE_GLOBALS.Control_Rec_Type;
3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

Line 3952: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;

3948: l_api_name VARCHAR2(30) := 'ORDER_UPDATELINEBILL';
3949:
3950: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3951: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3952: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3953: l_control_rec OE_GLOBALS.Control_Rec_Type;
3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

Line 3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

3950: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3951: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3952: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3953: l_control_rec OE_GLOBALS.Control_Rec_Type;
3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3958: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

Line 3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

3951: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3952: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3953: l_control_rec OE_GLOBALS.Control_Rec_Type;
3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3958: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3959: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

Line 3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

3952: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3953: l_control_rec OE_GLOBALS.Control_Rec_Type;
3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3958: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3959: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3960: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

Line 3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

3953: l_control_rec OE_GLOBALS.Control_Rec_Type;
3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3958: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3959: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3960: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3961: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;

Line 3958: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3958: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3959: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3960: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3961: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3962:

Line 3959: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3958: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3959: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3960: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3961: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3962:
3963: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 3960: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3958: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3959: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3960: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3961: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3962:
3963: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3964: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

Line 3961: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;

3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
3958: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
3959: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3960: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3961: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3962:
3963: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3964: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3965: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

Line 3963: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3959: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
3960: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3961: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3962:
3963: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3964: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3965: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3966: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3964: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

3960: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
3961: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3962:
3963: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3964: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3965: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3966: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 3965: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

3961: l_Action_Request_tbl OE_Order_PUB.request_tbl_type :=OE_Order_PUB.g_miss_request_tbl;
3962:
3963: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3964: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3965: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3966: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 3966: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

3962:
3963: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3964: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3965: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3966: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3963: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3964: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3965: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3966: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

3964: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
3965: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3966: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3972: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

3965: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
3966: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3972: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3973: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

3966: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3972: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3973: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3974: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;

Line 3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

3967: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3972: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3973: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3974: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3975: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 3972: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3968: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3972: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3973: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3974: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3975: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
3976: --l_siteuse_type VARCHAR2(20);

Line 3973: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3969: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3972: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3973: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3974: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3975: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
3976: --l_siteuse_type VARCHAR2(20);
3977: l_siteuse_billto VARCHAR2(20);

Line 3974: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;

3970: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3972: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3973: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3974: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3975: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
3976: --l_siteuse_type VARCHAR2(20);
3977: l_siteuse_billto VARCHAR2(20);
3978: l_siteuse_shipto VARCHAR2(20);

Line 3975: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;

3971: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
3972: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3973: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3974: lx_order_header_rec OE_Order_PUB.Header_Rec_Type;
3975: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
3976: --l_siteuse_type VARCHAR2(20);
3977: l_siteuse_billto VARCHAR2(20);
3978: l_siteuse_shipto VARCHAR2(20);
3979: l_cust_acct_role_id NUMBER;

Line 4131: l_order_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;

4127: end if;
4128:
4129: l_order_header_rec.header_id := p_order_header_id;
4130: l_order_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4131: l_order_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;
4132: l_order_line_tbl(1).header_id := p_order_header_id;
4133: l_order_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4134: l_order_line_tbl(1).line_id := p_order_line_id;
4135: