DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on ASO_QUOTE_PUB

Line 56: ,p_qte_line_tbl IN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE

52: ) RETURN VARCHAR2;
53:
54: FUNCTION getLineIndexFromLineId(
55: p_quote_line_id IN NUMBER
56: ,p_qte_line_tbl IN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE
57: ) RETURN NUMBER;
58:
59:
60: FUNCTION getQuoteLastUpdateDate(

Line 67: ) RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;

63:
64:
65: FUNCTION getLinePrcAttrTbl(
66: p_quote_line_id IN NUMBER
67: ) RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
68:
69: FUNCTION getLineAttrExtTbl(
70: p_quote_line_id IN NUMBER
71: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 71: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

67: ) RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
68:
69: FUNCTION getLineAttrExtTbl(
70: p_quote_line_id IN NUMBER
71: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
72:
73:
74: FUNCTION getLineDetailTbl(
75: p_quote_line_id IN NUMBER

Line 76: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

72:
73:
74: FUNCTION getLineDetailTbl(
75: p_quote_line_id IN NUMBER
76: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
77:
78:
79: FUNCTION getLineRelationshipTbl(
80: p_quote_line_id IN NUMBER

Line 81: ) RETURN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

77:
78:
79: FUNCTION getLineRelationshipTbl(
80: p_quote_line_id IN NUMBER
81: ) RETURN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
82:
83: FUNCTION getLinePrcAdjTbl(
84: p_quote_line_id IN NUMBER
85: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line 85: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;

81: ) RETURN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
82:
83: FUNCTION getLinePrcAdjTbl(
84: p_quote_line_id IN NUMBER
85: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;
86:
87: FUNCTION getHdrPrcAdjTbl(
88: p_quote_hdr_id IN NUMBER
89: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line 89: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;

85: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;
86:
87: FUNCTION getHdrPrcAdjTbl(
88: p_quote_hdr_id IN NUMBER
89: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;
90:
91: --Added for PRG bug fix,4094994
92: FUNCTION getAllLinesPrcAdjTbl(
93: p_quote_hdr_id IN NUMBER

Line 94: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;

90:
91: --Added for PRG bug fix,4094994
92: FUNCTION getAllLinesPrcAdjTbl(
93: p_quote_hdr_id IN NUMBER
94: ) RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;
95:
96:
97: FUNCTION getLinePrcAdjRelTbl(
98: p_price_adjustment_id IN NUMBER

Line 99: ) RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

95:
96:
97: FUNCTION getLinePrcAdjRelTbl(
98: p_price_adjustment_id IN NUMBER
99: ) RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
100:
101: FUNCTION getPrcAdjIndexFromPrcAdjId(
102: p_price_adjustment_id IN NUMBER
103: ,p_Price_Adjustment_tbl IN aso_quote_pub.Price_Adj_Tbl_Type

Line 103: ,p_Price_Adjustment_tbl IN aso_quote_pub.Price_Adj_Tbl_Type

99: ) RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
100:
101: FUNCTION getPrcAdjIndexFromPrcAdjId(
102: p_price_adjustment_id IN NUMBER
103: ,p_Price_Adjustment_tbl IN aso_quote_pub.Price_Adj_Tbl_Type
104: ) RETURN NUMBER;
105:
106: FUNCTION getLineTbl(
107: p_quote_header_Id IN NUMBER

Line 108: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;

104: ) RETURN NUMBER;
105:
106: FUNCTION getLineTbl(
107: p_quote_header_Id IN NUMBER
108: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
109:
110:
111: FUNCTION getLineRec(
112: p_qte_line_id IN NUMBER

Line 113: ) RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;

109:
110:
111: FUNCTION getLineRec(
112: p_qte_line_id IN NUMBER
113: ) RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
114:
115:
116: FUNCTION getHeaderRec(
117: p_quote_header_Id IN NUMBER

Line 118: ) RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;

114:
115:
116: FUNCTION getHeaderRec(
117: p_quote_header_Id IN NUMBER
118: ) RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
119:
120:
121: FUNCTION getHeaderPaymentTbl(
122: p_quote_header_Id IN NUMBER

Line 123: ) RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;

119:
120:
121: FUNCTION getHeaderPaymentTbl(
122: p_quote_header_Id IN NUMBER
123: ) RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
124:
125:
126: FUNCTION getShareePrivilege(
127: p_quote_header_Id IN NUMBER

Line 222: px_qte_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type

218: PROCEDURE Update_Config_Item_Lines(
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER ,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: px_qte_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
223: );
224:
225: procedure Validate_Items(
226: x_item_exists OUT NOCOPY jtf_number_Table,

Line 268: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type

264: ,X_Msg_Count OUT NOCOPY NUMBER
265: ,X_Msg_Data OUT NOCOPY VARCHAR2
266: ,p_quote_header_id IN NUMBER
267: ,p_qte_line_id IN NUMBER
268: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
269: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
270: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
271: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
272: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 269: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type

265: ,X_Msg_Data OUT NOCOPY VARCHAR2
266: ,p_quote_header_id IN NUMBER
267: ,p_qte_line_id IN NUMBER
268: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
269: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
270: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
271: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
272: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
273: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

Line 270: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type

266: ,p_quote_header_id IN NUMBER
267: ,p_qte_line_id IN NUMBER
268: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
269: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
270: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
271: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
272: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
273: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
274: );

Line 271: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type

267: ,p_qte_line_id IN NUMBER
268: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
269: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
270: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
271: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
272: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
273: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
274: );
275:

Line 272: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

268: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
269: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
270: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
271: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
272: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
273: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
274: );
275:
276: FUNCTION getHdrPrcAdjNonPRGTbl (

Line 273: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

269: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
270: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
271: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
272: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
273: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
274: );
275:
276: FUNCTION getHdrPrcAdjNonPRGTbl (
277: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 279: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

275:
276: FUNCTION getHdrPrcAdjNonPRGTbl (
277: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
278: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
279: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
280:
281: Procedure Split_Line(
282: p_api_version_number IN NUMBER
283: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE