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_QUOTE_MISC_PVT dependencies on ASO_QUOTE_PUB

Line 246: ,p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type

242:
243:
244: FUNCTION getLineIndexFromLineId(
245: p_quote_line_id IN NUMBER
246: ,p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type
247: ) RETURN NUMBER
248: IS
249: BEGIN
250:

Line 292: ) RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE

288:
289:
290: FUNCTION getLinePrcAttrTbl(
291: p_quote_line_id IN NUMBER
292: ) RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE
293: IS
294: l_ln_price_attributes_rec ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_Type;
295: l_ln_price_attributes_tbl ASO_QUOTE_PUB.PRICE_ATTRIBUTES_Tbl_Type
296: := ASO_QUOTE_PUB.g_miss_PRICE_ATTRIBUTES_Tbl;

Line 294: l_ln_price_attributes_rec ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_Type;

290: FUNCTION getLinePrcAttrTbl(
291: p_quote_line_id IN NUMBER
292: ) RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE
293: IS
294: l_ln_price_attributes_rec ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_Type;
295: l_ln_price_attributes_tbl ASO_QUOTE_PUB.PRICE_ATTRIBUTES_Tbl_Type
296: := ASO_QUOTE_PUB.g_miss_PRICE_ATTRIBUTES_Tbl;
297:
298: CURSOR c_getlnprcattrtbl(p_quote_line_id number) is

Line 295: l_ln_price_attributes_tbl ASO_QUOTE_PUB.PRICE_ATTRIBUTES_Tbl_Type

291: p_quote_line_id IN NUMBER
292: ) RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE
293: IS
294: l_ln_price_attributes_rec ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_Type;
295: l_ln_price_attributes_tbl ASO_QUOTE_PUB.PRICE_ATTRIBUTES_Tbl_Type
296: := ASO_QUOTE_PUB.g_miss_PRICE_ATTRIBUTES_Tbl;
297:
298: CURSOR c_getlnprcattrtbl(p_quote_line_id number) is
299: SELECT APA.price_attribute_id

Line 296: := ASO_QUOTE_PUB.g_miss_PRICE_ATTRIBUTES_Tbl;

292: ) RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE
293: IS
294: l_ln_price_attributes_rec ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_Type;
295: l_ln_price_attributes_tbl ASO_QUOTE_PUB.PRICE_ATTRIBUTES_Tbl_Type
296: := ASO_QUOTE_PUB.g_miss_PRICE_ATTRIBUTES_Tbl;
297:
298: CURSOR c_getlnprcattrtbl(p_quote_line_id number) is
299: SELECT APA.price_attribute_id
300: ,APA.creation_date

Line 597: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type

593: END GETLINEPRCATTRTBL;
594:
595: FUNCTION getLineAttrExtTbl(
596: p_quote_line_id IN NUMBER
597: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
598: IS
599:
600: l_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
601: := ASO_QUOTE_PUB.g_miss_Line_Attribs_Ext_Tbl;

Line 600: l_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type

596: p_quote_line_id IN NUMBER
597: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
598: IS
599:
600: l_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
601: := ASO_QUOTE_PUB.g_miss_Line_Attribs_Ext_Tbl;
602:
603: l_line_attr_ext_rec ASO_QUOTE_PUB.Line_Attribs_Ext_rec_Type;
604:

Line 601: := ASO_QUOTE_PUB.g_miss_Line_Attribs_Ext_Tbl;

597: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
598: IS
599:
600: l_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
601: := ASO_QUOTE_PUB.g_miss_Line_Attribs_Ext_Tbl;
602:
603: l_line_attr_ext_rec ASO_QUOTE_PUB.Line_Attribs_Ext_rec_Type;
604:
605: CURSOR c_getLineAttrExtTbl(p_quote_line_id number) is

Line 603: l_line_attr_ext_rec ASO_QUOTE_PUB.Line_Attribs_Ext_rec_Type;

599:
600: l_line_attr_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
601: := ASO_QUOTE_PUB.g_miss_Line_Attribs_Ext_Tbl;
602:
603: l_line_attr_ext_rec ASO_QUOTE_PUB.Line_Attribs_Ext_rec_Type;
604:
605: CURSOR c_getLineAttrExtTbl(p_quote_line_id number) is
606: SELECT lae.LINE_ATTRIBUTE_ID
607: ,lae.CREATION_DATE

Line 669: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

665: END getLineAttrExtTbl;
666:
667: FUNCTION getLineDetailTbl(
668: p_quote_line_id IN NUMBER
669: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
670: IS
671: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
672: := ASO_QUOTE_PUB.g_miss_Qte_Line_Dtl_tbl;
673: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

Line 671: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

667: FUNCTION getLineDetailTbl(
668: p_quote_line_id IN NUMBER
669: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
670: IS
671: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
672: := ASO_QUOTE_PUB.g_miss_Qte_Line_Dtl_tbl;
673: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
674:
675: CURSOR c_getDetLinetbl(p_quote_line_id number) IS

Line 672: := ASO_QUOTE_PUB.g_miss_Qte_Line_Dtl_tbl;

668: p_quote_line_id IN NUMBER
669: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
670: IS
671: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
672: := ASO_QUOTE_PUB.g_miss_Qte_Line_Dtl_tbl;
673: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
674:
675: CURSOR c_getDetLinetbl(p_quote_line_id number) IS
676: SELECT dl.quote_line_detail_id

Line 673: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

669: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
670: IS
671: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
672: := ASO_QUOTE_PUB.g_miss_Qte_Line_Dtl_tbl;
673: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
674:
675: CURSOR c_getDetLinetbl(p_quote_line_id number) IS
676: SELECT dl.quote_line_detail_id
677: ,dl.creation_date

Line 822: ) RETURN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

818:
819:
820: FUNCTION getLineRelationshipTbl(
821: p_quote_line_id IN NUMBER
822: ) RETURN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
823: IS
824: l_line_rltship_rec ASO_QUOTE_PUB.Line_Rltship_rec_Type;
825: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
826: := ASO_QUOTE_PUB.g_miss_Line_Rltship_Tbl;

Line 824: l_line_rltship_rec ASO_QUOTE_PUB.Line_Rltship_rec_Type;

820: FUNCTION getLineRelationshipTbl(
821: p_quote_line_id IN NUMBER
822: ) RETURN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
823: IS
824: l_line_rltship_rec ASO_QUOTE_PUB.Line_Rltship_rec_Type;
825: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
826: := ASO_QUOTE_PUB.g_miss_Line_Rltship_Tbl;
827: CURSOR c_getRelLinetbl(l_quote_line_id number) IS
828: SELECT LINE_RELATIONSHIP_ID

Line 825: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

821: p_quote_line_id IN NUMBER
822: ) RETURN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
823: IS
824: l_line_rltship_rec ASO_QUOTE_PUB.Line_Rltship_rec_Type;
825: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
826: := ASO_QUOTE_PUB.g_miss_Line_Rltship_Tbl;
827: CURSOR c_getRelLinetbl(l_quote_line_id number) IS
828: SELECT LINE_RELATIONSHIP_ID
829: ,CREATION_DATE

Line 826: := ASO_QUOTE_PUB.g_miss_Line_Rltship_Tbl;

822: ) RETURN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
823: IS
824: l_line_rltship_rec ASO_QUOTE_PUB.Line_Rltship_rec_Type;
825: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
826: := ASO_QUOTE_PUB.g_miss_Line_Rltship_Tbl;
827: CURSOR c_getRelLinetbl(l_quote_line_id number) IS
828: SELECT LINE_RELATIONSHIP_ID
829: ,CREATION_DATE
830: ,CREATED_BY

Line 875: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type

871: END getLineRelationshipTbl;
872:
873: FUNCTION getLinePrcAdjTbl(
874: p_quote_line_id IN NUMBER
875: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
876: IS
877: l_line_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
878: l_line_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
879: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;

Line 877: l_line_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

873: FUNCTION getLinePrcAdjTbl(
874: p_quote_line_id IN NUMBER
875: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
876: IS
877: l_line_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
878: l_line_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
879: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
880: CURSOR c_getLinePrcAdjTbl(l_quote_line_id number) IS
881: SELECT PRICE_ADJUSTMENT_ID

Line 878: l_line_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type

874: p_quote_line_id IN NUMBER
875: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
876: IS
877: l_line_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
878: l_line_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
879: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
880: CURSOR c_getLinePrcAdjTbl(l_quote_line_id number) IS
881: SELECT PRICE_ADJUSTMENT_ID
882: ,CREATION_DATE

Line 879: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;

875: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
876: IS
877: l_line_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
878: l_line_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
879: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
880: CURSOR c_getLinePrcAdjTbl(l_quote_line_id number) IS
881: SELECT PRICE_ADJUSTMENT_ID
882: ,CREATION_DATE
883: ,CREATED_BY

Line 1061: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type

1057: END getLinePrcAdjTbl;
1058:
1059: FUNCTION getHdrPrcAdjTbl(
1060: p_quote_hdr_id IN NUMBER
1061: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
1062: IS
1063: l_hdr_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1064: l_hdr_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1065: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;

Line 1063: l_hdr_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

1059: FUNCTION getHdrPrcAdjTbl(
1060: p_quote_hdr_id IN NUMBER
1061: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
1062: IS
1063: l_hdr_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1064: l_hdr_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1065: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
1066: CURSOR c_getHdrPrcAdjTbl(l_quote_hdr_id number) IS
1067: SELECT PRICE_ADJUSTMENT_ID

Line 1064: l_hdr_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type

1060: p_quote_hdr_id IN NUMBER
1061: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
1062: IS
1063: l_hdr_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1064: l_hdr_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1065: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
1066: CURSOR c_getHdrPrcAdjTbl(l_quote_hdr_id number) IS
1067: SELECT PRICE_ADJUSTMENT_ID
1068: ,CREATION_DATE

Line 1065: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;

1061: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
1062: IS
1063: l_hdr_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1064: l_hdr_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1065: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
1066: CURSOR c_getHdrPrcAdjTbl(l_quote_hdr_id number) IS
1067: SELECT PRICE_ADJUSTMENT_ID
1068: ,CREATION_DATE
1069: ,CREATED_BY

Line 1247: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type

1243: END getHdrPrcAdjTbl;
1244:
1245: FUNCTION getAllLinesPrcAdjTbl(
1246: p_quote_hdr_id IN NUMBER
1247: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
1248: IS
1249: l_AllLines_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1250: l_AllLines_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1251: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;

Line 1249: l_AllLines_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

1245: FUNCTION getAllLinesPrcAdjTbl(
1246: p_quote_hdr_id IN NUMBER
1247: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
1248: IS
1249: l_AllLines_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1250: l_AllLines_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1251: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
1252: CURSOR c_getAllLinesPrcAdjTbl(l_quote_hdr_id number) IS
1253: SELECT PRICE_ADJUSTMENT_ID

Line 1250: l_AllLines_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type

1246: p_quote_hdr_id IN NUMBER
1247: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
1248: IS
1249: l_AllLines_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1250: l_AllLines_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1251: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
1252: CURSOR c_getAllLinesPrcAdjTbl(l_quote_hdr_id number) IS
1253: SELECT PRICE_ADJUSTMENT_ID
1254: ,CREATION_DATE

Line 1251: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;

1247: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
1248: IS
1249: l_AllLines_PrcAdj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1250: l_AllLines_PrcAdj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1251: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
1252: CURSOR c_getAllLinesPrcAdjTbl(l_quote_hdr_id number) IS
1253: SELECT PRICE_ADJUSTMENT_ID
1254: ,CREATION_DATE
1255: ,CREATED_BY

Line 1434: ,p_Price_Adjustment_tbl IN aso_quote_pub.Price_Adj_Tbl_Type

1430: END getAllLinesPrcAdjTbl;
1431:
1432: FUNCTION getPrcAdjIndexFromPrcAdjId(
1433: p_price_adjustment_id IN NUMBER
1434: ,p_Price_Adjustment_tbl IN aso_quote_pub.Price_Adj_Tbl_Type
1435: ) RETURN NUMBER
1436: IS
1437: BEGIN
1438:

Line 1453: ) RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type

1449:
1450:
1451: FUNCTION getLinePrcAdjRelTbl(
1452: p_price_adjustment_id IN NUMBER
1453: ) RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
1454: IS
1455: l_line_PrcAdjRel_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
1456: l_line_PrcAdjRel_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1457: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl;

Line 1455: l_line_PrcAdjRel_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;

1451: FUNCTION getLinePrcAdjRelTbl(
1452: p_price_adjustment_id IN NUMBER
1453: ) RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
1454: IS
1455: l_line_PrcAdjRel_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
1456: l_line_PrcAdjRel_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1457: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl;
1458: CURSOR c_getLinePrcAdjRelTbl(l_price_adjustment_id number) IS
1459: SELECT ADJ_RELATIONSHIP_ID

Line 1456: l_line_PrcAdjRel_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

1452: p_price_adjustment_id IN NUMBER
1453: ) RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
1454: IS
1455: l_line_PrcAdjRel_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
1456: l_line_PrcAdjRel_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1457: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl;
1458: CURSOR c_getLinePrcAdjRelTbl(l_price_adjustment_id number) IS
1459: SELECT ADJ_RELATIONSHIP_ID
1460: ,CREATION_DATE

Line 1457: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl;

1453: ) RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
1454: IS
1455: l_line_PrcAdjRel_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
1456: l_line_PrcAdjRel_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
1457: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl;
1458: CURSOR c_getLinePrcAdjRelTbl(l_price_adjustment_id number) IS
1459: SELECT ADJ_RELATIONSHIP_ID
1460: ,CREATION_DATE
1461: ,CREATED_BY

Line 1504: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE

1500:
1501:
1502: FUNCTION getLineTbl(
1503: p_quote_header_Id IN NUMBER
1504: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE
1505: IS
1506:
1507: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
1508: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;

Line 1507: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;

1503: p_quote_header_Id IN NUMBER
1504: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE
1505: IS
1506:
1507: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
1508: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
1509: CURSOR c_getlinetbl(l_quote_header_id number) IS
1510: SELECT l.QUOTE_LINE_ID
1511: ,l.CREATION_DATE

Line 1508: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;

1504: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE
1505: IS
1506:
1507: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
1508: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
1509: CURSOR c_getlinetbl(l_quote_header_id number) IS
1510: SELECT l.QUOTE_LINE_ID
1511: ,l.CREATION_DATE
1512: ,l.CREATED_BY

Line 1638: ) RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE

1634:
1635:
1636: FUNCTION getLineRec(
1637: p_qte_line_id IN NUMBER
1638: ) RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE
1639: IS
1640:
1641: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
1642: CURSOR c_getlineRec(l_qte_line_id number) IS

Line 1641: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;

1637: p_qte_line_id IN NUMBER
1638: ) RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE
1639: IS
1640:
1641: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
1642: CURSOR c_getlineRec(l_qte_line_id number) IS
1643: SELECT l.QUOTE_LINE_ID
1644: ,l.CREATION_DATE
1645: ,l.CREATED_BY

Line 1765: ) RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE

1761: END getLineRec;
1762:
1763: FUNCTION getHeaderRec(
1764: p_quote_header_Id IN NUMBER
1765: ) RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE
1766: IS
1767: CURSOR c_getHeaderRec(p_quote_header_id NUMBER) IS
1768: SELECT last_update_date
1769: ,ORG_ID

Line 1812: l_qte_header_rec ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;

1808: ,ORDER_ID
1809: FROM aso_quote_headers
1810: WHERE quote_header_id = p_quote_header_id;
1811:
1812: l_qte_header_rec ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
1813:
1814:
1815: BEGIN
1816: l_qte_header_rec.quote_header_id := p_quote_header_id;

Line 1869: ) RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE

1865: END getHeaderRec;
1866:
1867: FUNCTION getHeaderPaymentTbl(
1868: p_quote_header_Id IN NUMBER
1869: ) RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE
1870: IS
1871:
1872: l_index number :=1;
1873: l_payment_tbl aso_quote_pub.payment_tbl_type;

Line 1873: l_payment_tbl aso_quote_pub.payment_tbl_type;

1869: ) RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE
1870: IS
1871:
1872: l_index number :=1;
1873: l_payment_tbl aso_quote_pub.payment_tbl_type;
1874: l_payment_rec aso_quote_pub.payment_rec_type;
1875:
1876:
1877: CURSOR c_getPaymentRec(p_quote_header_id number) is

Line 1874: l_payment_rec aso_quote_pub.payment_rec_type;

1870: IS
1871:
1872: l_index number :=1;
1873: l_payment_tbl aso_quote_pub.payment_tbl_type;
1874: l_payment_rec aso_quote_pub.payment_rec_type;
1875:
1876:
1877: CURSOR c_getPaymentRec(p_quote_header_id number) is
1878: SELECT payment_id

Line 3179: px_qte_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type

3175: PROCEDURE Update_Config_Item_Lines(
3176: x_return_status OUT NOCOPY VARCHAR2,
3177: x_msg_count OUT NOCOPY NUMBER ,
3178: x_msg_data OUT NOCOPY VARCHAR2,
3179: px_qte_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
3180: )
3181: IS
3182: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Config_Item_Lines';
3183: l_old_config_header_id NUMBER;

Line 3473: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type

3469: ,X_Msg_Count OUT NOCOPY NUMBER
3470: ,X_Msg_Data OUT NOCOPY VARCHAR2
3471: ,p_quote_header_id IN NUMBER
3472: ,p_qte_line_id IN NUMBER
3473: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3474: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3475: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3476: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3477: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 3474: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type

3470: ,X_Msg_Data OUT NOCOPY VARCHAR2
3471: ,p_quote_header_id IN NUMBER
3472: ,p_qte_line_id IN NUMBER
3473: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3474: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3475: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3476: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3477: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3478: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

Line 3475: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type

3471: ,p_quote_header_id IN NUMBER
3472: ,p_qte_line_id IN NUMBER
3473: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3474: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3475: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3476: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3477: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3478: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
3479: )

Line 3476: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type

3472: ,p_qte_line_id IN NUMBER
3473: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3474: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3475: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3476: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3477: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3478: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
3479: )
3480: IS

Line 3477: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

3473: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3474: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3475: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3476: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3477: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3478: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
3479: )
3480: IS
3481:

Line 3478: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

3474: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3475: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3476: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3477: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3478: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
3479: )
3480: IS
3481:
3482: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Line';

Line 3485: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;

3481:
3482: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Line';
3483: l_api_version CONSTANT NUMBER := 1.0;
3484:
3485: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3486: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3487: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3488: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3489: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line 3486: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;

3482: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Line';
3483: l_api_version CONSTANT NUMBER := 1.0;
3484:
3485: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3486: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3487: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3488: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3489: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
3490:

Line 3487: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;

3483: l_api_version CONSTANT NUMBER := 1.0;
3484:
3485: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3486: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3487: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3488: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3489: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
3490:
3491: l_initial_count NUMBER;

Line 3488: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

3484:
3485: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3486: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3487: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3488: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3489: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
3490:
3491: l_initial_count NUMBER;
3492: l_initial_dtl_count NUMBER;

Line 3489: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

3485: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3486: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3487: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3488: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3489: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
3490:
3491: l_initial_count NUMBER;
3492: l_initial_dtl_count NUMBER;
3493:

Line 3770: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type

3766:
3767: FUNCTION getHdrPrcAdjNonPRGTbl (
3768: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
3769: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
3770: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3771: IS
3772: CURSOR c_price_adj IS
3773: SELECT
3774: PRICE_ADJUSTMENT_ID,

Line 3865: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

3861: (quote_line_id = p_qte_line_id OR
3862: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
3863: AND modifier_line_type_code <> 'PRG';
3864:
3865: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3866: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3867:
3868: BEGIN
3869: FOR price_adj_rec IN c_price_adj LOOP

Line 3866: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

3862: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
3863: AND modifier_line_type_code <> 'PRG';
3864:
3865: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3866: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3867:
3868: BEGIN
3869: FOR price_adj_rec IN c_price_adj LOOP
3870: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;

Line 3981: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

3977: )
3978: IS
3979: l_api_name CONSTANT VARCHAR2(30) := 'Split_Line';
3980: l_api_version CONSTANT NUMBER := 1.0;
3981: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
3982: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
3983: l_count NUMBER;
3984: l_last_update_date DATE;
3985: l_qte_line_count NUMBER;

Line 3982: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;

3978: IS
3979: l_api_name CONSTANT VARCHAR2(30) := 'Split_Line';
3980: l_api_version CONSTANT NUMBER := 1.0;
3981: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
3982: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
3983: l_count NUMBER;
3984: l_last_update_date DATE;
3985: l_qte_line_count NUMBER;
3986: lx_quote_header_id NUMBER;

Line 3989: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

3985: l_qte_line_count NUMBER;
3986: lx_quote_header_id NUMBER;
3987: lx_last_update_date DATE;
3988: -- Duplicate line Records (Temporary).
3989: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3990: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3991: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3992: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

Line 3990: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

3986: lx_quote_header_id NUMBER;
3987: lx_last_update_date DATE;
3988: -- Duplicate line Records (Temporary).
3989: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3990: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3991: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3992: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3994: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

Line 3991: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

3987: lx_last_update_date DATE;
3988: -- Duplicate line Records (Temporary).
3989: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3990: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3991: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3992: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3994: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3995: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;

Line 3992: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

3988: -- Duplicate line Records (Temporary).
3989: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3990: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3991: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3992: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3994: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3995: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3996: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

Line 3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

3989: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3990: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3991: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3992: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3994: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3995: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3996: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3997: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

Line 3994: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

3990: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3991: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3992: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3994: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3995: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3996: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3997: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3998: -- Duplicate line Records (Used for actually calling Save.)

Line 3995: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;

3991: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3992: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3994: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3995: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3996: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3997: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3998: -- Duplicate line Records (Used for actually calling Save.)
3999: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

Line 3996: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

3992: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3994: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3995: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3996: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3997: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3998: -- Duplicate line Records (Used for actually calling Save.)
3999: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4000: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

Line 3997: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

3993: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3994: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3995: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3996: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3997: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3998: -- Duplicate line Records (Used for actually calling Save.)
3999: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4000: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4001: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

Line 3999: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

3995: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3996: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3997: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3998: -- Duplicate line Records (Used for actually calling Save.)
3999: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4000: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4001: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4002: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4003: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

Line 4000: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

3996: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3997: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3998: -- Duplicate line Records (Used for actually calling Save.)
3999: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4000: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4001: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4002: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4003: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4004: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

Line 4001: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

3997: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3998: -- Duplicate line Records (Used for actually calling Save.)
3999: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4000: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4001: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4002: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4003: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4004: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4005: lx_return_status VARCHAR2(1);

Line 4002: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;

3998: -- Duplicate line Records (Used for actually calling Save.)
3999: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4000: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4001: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4002: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4003: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4004: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4005: lx_return_status VARCHAR2(1);
4006: lx_msg_count NUMBER;

Line 4003: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

3999: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4000: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4001: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4002: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4003: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4004: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4005: lx_return_status VARCHAR2(1);
4006: lx_msg_count NUMBER;
4007: lx_msg_data VARCHAR2(2000);

Line 4004: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

4000: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4001: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4002: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4003: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4004: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4005: lx_return_status VARCHAR2(1);
4006: lx_msg_count NUMBER;
4007: lx_msg_data VARCHAR2(2000);
4008: BEGIN