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 3061: px_qte_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type

3057: PROCEDURE Update_Config_Item_Lines(
3058: x_return_status OUT NOCOPY VARCHAR2,
3059: x_msg_count OUT NOCOPY NUMBER ,
3060: x_msg_data OUT NOCOPY VARCHAR2,
3061: px_qte_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
3062: )
3063: IS
3064: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Config_Item_Lines';
3065: l_old_config_header_id NUMBER;

Line 3355: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type

3351: ,X_Msg_Count OUT NOCOPY NUMBER
3352: ,X_Msg_Data OUT NOCOPY VARCHAR2
3353: ,p_quote_header_id IN NUMBER
3354: ,p_qte_line_id IN NUMBER
3355: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3356: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3357: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3358: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3359: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 3356: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type

3352: ,X_Msg_Data OUT NOCOPY VARCHAR2
3353: ,p_quote_header_id IN NUMBER
3354: ,p_qte_line_id IN NUMBER
3355: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3356: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3357: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3358: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3359: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3360: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

Line 3357: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type

3353: ,p_quote_header_id IN NUMBER
3354: ,p_qte_line_id IN NUMBER
3355: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3356: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3357: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3358: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3359: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3360: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
3361: )

Line 3358: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type

3354: ,p_qte_line_id IN NUMBER
3355: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3356: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3357: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3358: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3359: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3360: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
3361: )
3362: IS

Line 3359: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

3355: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
3356: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3357: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3358: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3359: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3360: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
3361: )
3362: IS
3363:

Line 3360: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

3356: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
3357: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
3358: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
3359: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
3360: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
3361: )
3362: IS
3363:
3364: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Line';

Line 3367: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;

3363:
3364: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Line';
3365: l_api_version CONSTANT NUMBER := 1.0;
3366:
3367: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3368: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3369: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3370: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3371: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line 3368: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;

3364: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Line';
3365: l_api_version CONSTANT NUMBER := 1.0;
3366:
3367: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3368: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3369: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3370: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3371: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
3372:

Line 3369: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;

3365: l_api_version CONSTANT NUMBER := 1.0;
3366:
3367: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3368: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3369: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3370: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3371: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
3372:
3373: l_initial_count NUMBER;

Line 3370: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

3366:
3367: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3368: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3369: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3370: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3371: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
3372:
3373: l_initial_count NUMBER;
3374: l_initial_dtl_count NUMBER;

Line 3371: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

3367: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
3368: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
3369: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
3370: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
3371: l_ln_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
3372:
3373: l_initial_count NUMBER;
3374: l_initial_dtl_count NUMBER;
3375:

Line 3652: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type

3648:
3649: FUNCTION getHdrPrcAdjNonPRGTbl (
3650: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
3651: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
3652: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3653: IS
3654: CURSOR c_price_adj IS
3655: SELECT
3656: PRICE_ADJUSTMENT_ID,

Line 3747: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

3743: (quote_line_id = p_qte_line_id OR
3744: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
3745: AND modifier_line_type_code <> 'PRG';
3746:
3747: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3748: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3749:
3750: BEGIN
3751: FOR price_adj_rec IN c_price_adj LOOP

Line 3748: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

3744: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
3745: AND modifier_line_type_code <> 'PRG';
3746:
3747: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3748: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3749:
3750: BEGIN
3751: FOR price_adj_rec IN c_price_adj LOOP
3752: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;

Line 3863: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

3859: )
3860: IS
3861: l_api_name CONSTANT VARCHAR2(30) := 'Split_Line';
3862: l_api_version CONSTANT NUMBER := 1.0;
3863: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
3864: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
3865: l_count NUMBER;
3866: l_last_update_date DATE;
3867: l_qte_line_count NUMBER;

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

3860: IS
3861: l_api_name CONSTANT VARCHAR2(30) := 'Split_Line';
3862: l_api_version CONSTANT NUMBER := 1.0;
3863: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
3864: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
3865: l_count NUMBER;
3866: l_last_update_date DATE;
3867: l_qte_line_count NUMBER;
3868: lx_quote_header_id NUMBER;

Line 3871: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

3867: l_qte_line_count NUMBER;
3868: lx_quote_header_id NUMBER;
3869: lx_last_update_date DATE;
3870: -- Duplicate line Records (Temporary).
3871: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3872: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3873: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3874: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

Line 3872: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

3868: lx_quote_header_id NUMBER;
3869: lx_last_update_date DATE;
3870: -- Duplicate line Records (Temporary).
3871: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3872: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3873: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3874: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3876: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

Line 3873: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

3869: lx_last_update_date DATE;
3870: -- Duplicate line Records (Temporary).
3871: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3872: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3873: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3874: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3876: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3877: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;

Line 3874: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

3870: -- Duplicate line Records (Temporary).
3871: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3872: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3873: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3874: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3876: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3877: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3878: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

Line 3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

3871: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3872: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3873: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3874: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3876: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3877: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3878: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3879: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

Line 3876: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

3872: l_tmp_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3873: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3874: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3876: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3877: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3878: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3879: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3880: -- Duplicate line Records (Used for actually calling Save.)

Line 3877: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;

3873: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3874: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3876: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3877: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3878: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3879: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3880: -- Duplicate line Records (Used for actually calling Save.)
3881: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

Line 3878: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

3874: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3876: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3877: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3878: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3879: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3880: -- Duplicate line Records (Used for actually calling Save.)
3881: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3882: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

Line 3879: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

3875: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3876: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3877: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3878: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3879: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3880: -- Duplicate line Records (Used for actually calling Save.)
3881: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3882: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3883: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

Line 3881: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

3877: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3878: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3879: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3880: -- Duplicate line Records (Used for actually calling Save.)
3881: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3882: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3883: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3884: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3885: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

Line 3882: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

3878: l_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3879: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3880: -- Duplicate line Records (Used for actually calling Save.)
3881: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3882: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3883: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3884: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3885: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3886: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

Line 3883: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

3879: l_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3880: -- Duplicate line Records (Used for actually calling Save.)
3881: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3882: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3883: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3884: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3885: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3886: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3887: lx_return_status VARCHAR2(1);

Line 3884: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;

3880: -- Duplicate line Records (Used for actually calling Save.)
3881: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3882: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3883: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3884: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3885: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3886: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3887: lx_return_status VARCHAR2(1);
3888: lx_msg_count NUMBER;

Line 3885: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

3881: l_sv_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
3882: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3883: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3884: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3885: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3886: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3887: lx_return_status VARCHAR2(1);
3888: lx_msg_count NUMBER;
3889: lx_msg_data VARCHAR2(2000);

Line 3886: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

3882: l_sv_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3883: l_sv_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3884: l_sv_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
3885: l_sv_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
3886: l_sv_ln_price_adj_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
3887: lx_return_status VARCHAR2(1);
3888: lx_msg_count NUMBER;
3889: lx_msg_data VARCHAR2(2000);
3890: BEGIN