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

205: PROCEDURE Update_Config_Item_Lines(
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER ,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: px_qte_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
210: );
211:
212: procedure Validate_Items(
213: x_item_exists OUT NOCOPY jtf_number_Table,

Line 255: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type

251: ,X_Msg_Count OUT NOCOPY NUMBER
252: ,X_Msg_Data OUT NOCOPY VARCHAR2
253: ,p_quote_header_id IN NUMBER
254: ,p_qte_line_id IN NUMBER
255: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
256: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
257: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
258: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
259: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 256: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type

252: ,X_Msg_Data OUT NOCOPY VARCHAR2
253: ,p_quote_header_id IN NUMBER
254: ,p_qte_line_id IN NUMBER
255: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
256: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
257: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
258: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
259: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
260: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

Line 257: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type

253: ,p_quote_header_id IN NUMBER
254: ,p_qte_line_id IN NUMBER
255: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
256: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
257: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
258: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
259: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
260: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
261: );

Line 258: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type

254: ,p_qte_line_id IN NUMBER
255: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
256: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
257: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
258: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
259: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
260: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
261: );
262:

Line 259: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

255: ,x_qte_line_tbl IN OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
256: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
257: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
258: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
259: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
260: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
261: );
262:
263: FUNCTION getHdrPrcAdjNonPRGTbl (

Line 260: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

256: ,x_qte_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
257: ,x_line_attr_ext_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
258: ,x_line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
259: ,x_ln_price_attributes_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
260: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
261: );
262:
263: FUNCTION getHdrPrcAdjNonPRGTbl (
264: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 266: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

262:
263: FUNCTION getHdrPrcAdjNonPRGTbl (
264: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
265: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
266: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
267:
268: Procedure Split_Line(
269: p_api_version_number IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE