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.ASO_QUOTE_UTIL_PVT dependencies on ASO_QUOTE_PUB

Line 257: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type

253: p_end_customer_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
255: p_header_paynow_charges IN NUMBER := FND_API.G_MISS_NUM
256: )
257: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
258: IS
259: cursor l_last_update_date_csr(p_qte_header_id NUMBER) IS
260: SELECT aqh.last_update_date
261: FROM aso_quote_headers_all aqh

Line 265: l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;

261: FROM aso_quote_headers_all aqh
262: WHERE aqh.quote_header_id = p_qte_header_id;
263: l_last_update_date DATE;
264:
265: l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;
266:
267:
268:
269: BEGIN

Line 787: RETURN ASO_Quote_Pub.Qte_Line_Rec_Type

783: p_line_paynow_tax IN NUMBER := FND_API.G_MISS_NUM,
784: p_line_paynow_subtotal IN NUMBER := FND_API.G_MISS_NUM,
785: p_config_model_type IN VARCHAR2 := FND_API.G_MISS_CHAR
786: )
787: RETURN ASO_Quote_Pub.Qte_Line_Rec_Type
788: IS
789:
790: l_qte_line_rec ASO_Quote_Pub.Qte_Line_Rec_Type;
791:

Line 790: l_qte_line_rec ASO_Quote_Pub.Qte_Line_Rec_Type;

786: )
787: RETURN ASO_Quote_Pub.Qte_Line_Rec_Type
788: IS
789:
790: l_qte_line_rec ASO_Quote_Pub.Qte_Line_Rec_Type;
791:
792: BEGIN
793:
794: IF p_creation_date= ROSETTA_G_MISTAKE_DATE THEN

Line 1169: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type

1165: p_line_paynow_tax IN jtf_number_table := NULL,
1166: p_line_paynow_subtotal IN jtf_number_table := NULL,
1167: p_config_model_type IN jtf_varchar2_table_100 := NULL
1168: )
1169: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
1170: IS
1171: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1172: l_table_size PLS_INTEGER := 0;
1173: i PLS_INTEGER;

Line 1171: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

1167: p_config_model_type IN jtf_varchar2_table_100 := NULL
1168: )
1169: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
1170: IS
1171: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
1172: l_table_size PLS_INTEGER := 0;
1173: i PLS_INTEGER;
1174: BEGIN
1175: IF p_operation_code IS NOT NULL THEN

Line 1642: RETURN ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

1638: END LOOP;
1639:
1640: RETURN l_qte_line_tbl;
1641: ELSE
1642: RETURN ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;
1643: END IF;
1644: END Construct_Qte_Line_Tbl;
1645:
1646:

Line 1733: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type

1729: p_component_sequence_id IN NUMBER := FND_API.G_MISS_NUM,
1730: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
1731:
1732: )
1733: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type
1734: IS
1735: l_qte_line_dtl_rec ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type;
1736: BEGIN
1737: IF p_quote_line_detail_id= ROSETTA_G_MISS_NUM THEN

Line 1735: l_qte_line_dtl_rec ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type;

1731:
1732: )
1733: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type
1734: IS
1735: l_qte_line_dtl_rec ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type;
1736: BEGIN
1737: IF p_quote_line_detail_id= ROSETTA_G_MISS_NUM THEN
1738: l_qte_line_dtl_rec.quote_line_detail_id := FND_API.G_MISS_NUM;
1739: ELSE

Line 2049: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type

2045: p_component_sequence_id IN jtf_number_table := NULL,
2046: p_object_version_number IN jtf_number_table := NULL
2047:
2048: )
2049: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
2050: IS
2051: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
2052: l_table_size PLS_INTEGER := 0;
2053: i PLS_INTEGER;

Line 2051: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

2047:
2048: )
2049: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
2050: IS
2051: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
2052: l_table_size PLS_INTEGER := 0;
2053: i PLS_INTEGER;
2054: BEGIN
2055: IF p_operation_code IS NOT NULL THEN

Line 2456: RETURN ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;

2452: END LOOP;
2453:
2454: RETURN l_qte_line_dtl_tbl;
2455: ELSE
2456: RETURN ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
2457: END IF;
2458: END Construct_Qte_Line_Dtl_Tbl;
2459:
2460:

Line 2482: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type

2478: p_related_qte_line_index IN jtf_number_table := NULL,
2479: p_operation_code IN jtf_varchar2_table_100 := NULL,
2480: p_object_version_number IN jtf_number_table := NULL
2481: )
2482: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type
2483: IS
2484: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
2485: l_table_size PLS_INTEGER := 0;
2486: i PLS_INTEGER;

Line 2484: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

2480: p_object_version_number IN jtf_number_table := NULL
2481: )
2482: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type
2483: IS
2484: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
2485: l_table_size PLS_INTEGER := 0;
2486: i PLS_INTEGER;
2487: BEGIN
2488: IF p_operation_code IS NOT NULL THEN

Line 2612: RETURN ASO_Quote_Pub.G_MISS_LINE_RLTSHIP_TBL;

2608: END LOOP;
2609:
2610: RETURN l_line_rltship_tbl;
2611: ELSE
2612: RETURN ASO_Quote_Pub.G_MISS_LINE_RLTSHIP_TBL;
2613: END IF;
2614: END Construct_Line_Rltship_Tbl;
2615:
2616:

Line 2675: RETURN ASO_Quote_Pub.Payment_Tbl_Type

2671: p_cvv2 IN jtf_varchar2_table_100 := NULL,
2672: p_object_version_number IN jtf_number_table := NULL
2673:
2674: )
2675: RETURN ASO_Quote_Pub.Payment_Tbl_Type
2676: IS
2677: l_payment_tbl ASO_Quote_Pub.Payment_Tbl_Type;
2678: l_table_size PLS_INTEGER := 0;
2679: i PLS_INTEGER;

Line 2677: l_payment_tbl ASO_Quote_Pub.Payment_Tbl_Type;

2673:
2674: )
2675: RETURN ASO_Quote_Pub.Payment_Tbl_Type
2676: IS
2677: l_payment_tbl ASO_Quote_Pub.Payment_Tbl_Type;
2678: l_table_size PLS_INTEGER := 0;
2679: i PLS_INTEGER;
2680: BEGIN
2681: IF p_operation_code IS NOT NULL THEN

Line 2955: RETURN ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

2951: END LOOP;
2952:
2953: RETURN l_payment_tbl;
2954: ELSE
2955: RETURN ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2956: END IF;
2957: END Construct_Payment_Tbl;
2958:
2959: FUNCTION Construct_Payment_Rec(

Line 3015: RETURN ASO_Quote_Pub.Payment_Rec_Type

3011: p_instrument_id IN NUMBER := FND_API.G_MISS_NUM,
3012: p_instr_assignment_id IN NUMBER := FND_API.G_MISS_NUM,
3013: p_cvv2 IN VARCHAR2 := FND_API.G_MISS_CHAR
3014: )
3015: RETURN ASO_Quote_Pub.Payment_Rec_Type
3016: is
3017: l_payment_rec ASO_Quote_Pub.Payment_Rec_Type;
3018: Begin
3019:

Line 3017: l_payment_rec ASO_Quote_Pub.Payment_Rec_Type;

3013: p_cvv2 IN VARCHAR2 := FND_API.G_MISS_CHAR
3014: )
3015: RETURN ASO_Quote_Pub.Payment_Rec_Type
3016: is
3017: l_payment_rec ASO_Quote_Pub.Payment_Rec_Type;
3018: Begin
3019:
3020: l_payment_rec.operation_code := p_operation_code;
3021:

Line 3313: RETURN ASO_Quote_Pub.Shipment_Rec_Type

3309: p_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3310: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
3311:
3312: )
3313: RETURN ASO_Quote_Pub.Shipment_Rec_Type
3314: IS
3315: l_shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
3316: BEGIN
3317:

Line 3315: l_shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;

3311:
3312: )
3313: RETURN ASO_Quote_Pub.Shipment_Rec_Type
3314: IS
3315: l_shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
3316: BEGIN
3317:
3318: l_shipment_rec.operation_code := p_operation_code;
3319: IF p_qte_line_index = ROSETTA_G_MISS_NUM THEN

Line 3593: RETURN ASO_Quote_Pub.Shipment_Tbl_Type

3589: p_demand_class_code IN jtf_varchar2_table_100 := NULL,
3590: p_object_version_number IN jtf_number_table := NULL
3591:
3592: )
3593: RETURN ASO_Quote_Pub.Shipment_Tbl_Type
3594: IS
3595: l_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type;
3596: l_table_size PLS_INTEGER := 0;
3597: i PLS_INTEGER;

Line 3595: l_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type;

3591:
3592: )
3593: RETURN ASO_Quote_Pub.Shipment_Tbl_Type
3594: IS
3595: l_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type;
3596: l_table_size PLS_INTEGER := 0;
3597: i PLS_INTEGER;
3598: BEGIN
3599: IF p_operation_code IS NOT NULL THEN

Line 3952: RETURN ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

3948: END LOOP;
3949:
3950: RETURN l_shipment_tbl;
3951: ELSE
3952: RETURN ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
3953: END IF;
3954: END Construct_Shipment_Tbl;
3955:
3956:

Line 4007: RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type

4003: p_attribute20 IN jtf_varchar2_table_300 := NULL,
4004: p_object_version_number IN jtf_number_table := NULL,
4005: p_tax_rate_id IN jtf_number_table := NULL
4006: )
4007: RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type
4008: IS
4009: l_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
4010: l_table_size PLS_INTEGER := 0;
4011: i PLS_INTEGER;

Line 4009: l_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;

4005: p_tax_rate_id IN jtf_number_table := NULL
4006: )
4007: RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type
4008: IS
4009: l_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
4010: l_table_size PLS_INTEGER := 0;
4011: i PLS_INTEGER;
4012: BEGIN
4013: IF p_operation_code IS NOT NULL THEN

Line 4248: RETURN ASO_Quote_Pub.G_MISS_TAX_DETAIL_TBL;

4244: END LOOP;
4245:
4246: RETURN l_tax_detail_tbl;
4247: ELSE
4248: RETURN ASO_Quote_Pub.G_MISS_TAX_DETAIL_TBL;
4249: END IF;
4250: END Construct_Tax_Detail_Tbl;
4251:
4252: FUNCTION Construct_Tax_Detail_Rec(

Line 4301: RETURN ASO_Quote_Pub.Tax_Detail_Rec_Type

4297: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
4298: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
4299: p_tax_rate_id IN NUMBER := FND_API.G_MISS_NUM
4300: )
4301: RETURN ASO_Quote_Pub.Tax_Detail_Rec_Type
4302: is
4303: l_tax_detail_rec ASO_Quote_Pub.Tax_Detail_Rec_Type;
4304: BEGIN
4305: l_tax_detail_rec.operation_code := p_operation_code;

Line 4303: l_tax_detail_rec ASO_Quote_Pub.Tax_Detail_Rec_Type;

4299: p_tax_rate_id IN NUMBER := FND_API.G_MISS_NUM
4300: )
4301: RETURN ASO_Quote_Pub.Tax_Detail_Rec_Type
4302: is
4303: l_tax_detail_rec ASO_Quote_Pub.Tax_Detail_Rec_Type;
4304: BEGIN
4305: l_tax_detail_rec.operation_code := p_operation_code;
4306:
4307: IF p_qte_line_index = ROSETTA_G_MISS_NUM THEN

Line 4631: RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type

4627: p_attribute20 IN jtf_varchar2_table_300 := NULL,
4628: p_object_version_number IN jtf_number_table := NULL
4629:
4630: )
4631: RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type
4632: IS
4633: l_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4634: l_table_size PLS_INTEGER := 0;
4635: i PLS_INTEGER;

Line 4633: l_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

4629:
4630: )
4631: RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type
4632: IS
4633: l_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
4634: l_table_size PLS_INTEGER := 0;
4635: i PLS_INTEGER;
4636: BEGIN
4637: IF p_operation_code IS NOT NULL THEN

Line 5117: RETURN ASO_Quote_Pub.G_MISS_PRICE_ATTRIBUTES_TBL;

5113: END LOOP;
5114:
5115: RETURN l_price_attributes_tbl;
5116: ELSE
5117: RETURN ASO_Quote_Pub.G_MISS_PRICE_ATTRIBUTES_TBL;
5118: END IF;
5119: END Construct_Price_Attributes_Tbl;
5120:
5121:

Line 5216: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type

5212: p_attribute19 IN jtf_varchar2_table_300 := NULL,
5213: p_attribute20 IN jtf_varchar2_table_300 := NULL,
5214: p_object_version_number IN jtf_number_table := NULL
5215: )
5216: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
5217: IS
5218: l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
5219: l_table_size PLS_INTEGER := 0;
5220: i PLS_INTEGER;

Line 5218: l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

5214: p_object_version_number IN jtf_number_table := NULL
5215: )
5216: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
5217: IS
5218: l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
5219: l_table_size PLS_INTEGER := 0;
5220: i PLS_INTEGER;
5221: BEGIN
5222: IF p_operation_code IS NOT NULL THEN

Line 5631: RETURN ASO_Quote_Pub.G_MISS_PRICE_ADJ_TBL;

5627: END LOOP;
5628:
5629: RETURN l_price_adj_tbl;
5630: ELSE
5631: RETURN ASO_Quote_Pub.G_MISS_PRICE_ADJ_TBL;
5632: END IF;
5633: END Construct_Price_Adj_Tbl;
5634:
5635:

Line 5686: RETURN ASO_Quote_Pub.Sales_Credit_Tbl_Type

5682: p_attribute20 IN jtf_varchar2_table_300 := NULL,
5683: p_object_version_number IN jtf_number_table := NULL
5684:
5685: )
5686: RETURN ASO_Quote_Pub.Sales_Credit_Tbl_Type
5687: IS
5688: l_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5689: l_table_size PLS_INTEGER := 0;
5690: i PLS_INTEGER;

Line 5688: l_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;

5684:
5685: )
5686: RETURN ASO_Quote_Pub.Sales_Credit_Tbl_Type
5687: IS
5688: l_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
5689: l_table_size PLS_INTEGER := 0;
5690: i PLS_INTEGER;
5691: BEGIN
5692: IF p_operation_code IS NOT NULL THEN

Line 5918: RETURN ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;

5914:
5915: END LOOP;
5916: RETURN l_sales_credit_tbl;
5917: ELSE
5918: RETURN ASO_Quote_Pub.G_MISS_SALES_CREDIT_TBL;
5919: END IF;
5920: END Construct_Sales_Credit_Tbl;
5921:
5922: -- there IS total 14 fields here IN line

Line 6099: RETURN ASO_QUOTE_PUB.Qte_Access_Tbl_Type

6095: p_object_version_number IN jtf_number_table := NULL,
6096: p_batch_price_flag IN jtf_varchar2_table_100 := NULL,
6097: p_operation_code IN jtf_varchar2_table_100 := NULL
6098: )
6099: RETURN ASO_QUOTE_PUB.Qte_Access_Tbl_Type
6100: IS
6101: l_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type;
6102: l_table_size PLS_INTEGER := 0;
6103: i PLS_INTEGER;

Line 6101: l_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type;

6097: p_operation_code IN jtf_varchar2_table_100 := NULL
6098: )
6099: RETURN ASO_QUOTE_PUB.Qte_Access_Tbl_Type
6100: IS
6101: l_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type;
6102: l_table_size PLS_INTEGER := 0;
6103: i PLS_INTEGER;
6104: BEGIN
6105: IF p_access_id IS NOT NULL THEN

Line 6307: RETURN ASO_Quote_Pub.G_MISS_QTE_ACCESS_TBL;

6303: END LOOP;
6304:
6305: RETURN l_qte_access_tbl;
6306: ELSE
6307: RETURN ASO_Quote_Pub.G_MISS_QTE_ACCESS_TBL;
6308: END IF;
6309: END Construct_Qte_Access_Tbl;
6310:
6311: -- there IS total 7 fields here IN line

Line 6426: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type

6422: p_dependency_flag VARCHAR2 := FND_API.G_MISS_CHAR,
6423: p_defaulting_flag VARCHAR2 := FND_API.G_MISS_CHAR,
6424: p_defaulting_fwk_flag VARCHAR2 := FND_API.G_MISS_CHAR,
6425: p_application_type_code VARCHAR2 := FND_API.G_MISS_CHAR,
6426: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
6427: )
6428: IS
6429: BEGIN
6430: IF p_last_update_date = ROSETTA_G_MISTAKE_DATE THEN

Line 6490: x_Submit_control_rec OUT NOCOPY ASO_Quote_Pub.Submit_Control_Rec_Type

6486: p_book_flag IN VARCHAR2 := FND_API.G_FALSE,
6487: p_reserve_flag IN VARCHAR2 := FND_API.G_FALSE,
6488: p_calculate_price IN VARCHAR2 := FND_API.G_FALSE,
6489: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
6490: x_Submit_control_rec OUT NOCOPY ASO_Quote_Pub.Submit_Control_Rec_Type
6491: )
6492: IS
6493: BEGIN
6494: x_submit_control_rec.book_flag := p_book_flag;

Line 6572: p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,

6568:
6569:
6570: -- there IS total 5 fields here OUT NOCOPY /* file.sql.39 change */ line
6571: PROCEDURE Set_Order_Header_Rec_Out(
6572: p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,
6573: x_order_number OUT NOCOPY NUMBER ,
6574: x_order_header_id OUT NOCOPY NUMBER ,
6575: x_order_request_id OUT NOCOPY NUMBER ,
6576: x_contract_id OUT NOCOPY NUMBER ,

Line 6591: p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,

6587:
6588:
6589: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso quote header table
6590: PROCEDURE Set_Qte_Header_Tbl_Out(
6591: p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,
6592: x_quote_header_id OUT NOCOPY jtf_number_table,
6593: x_last_update_date OUT NOCOPY jtf_date_table
6594:
6595: /*-- The following output parameters are ignored

Line 7023: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,

7019:
7020:
7021: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso quote line table
7022: PROCEDURE Set_Qte_Line_Tbl_Out(
7023: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
7024: x_quote_line_id OUT NOCOPY jtf_number_table
7025:
7026: /*-- The following output parameters are ignored
7027: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 7327: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,

7323:
7324:
7325: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso quote line detail table
7326: PROCEDURE Set_Qte_Line_Dtl_Tbl_Out(
7327: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
7328: x_quote_line_detail_id OUT NOCOPY jtf_number_table
7329:
7330: /*-- The following output parameters are ignored
7331: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 7647: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,

7643:
7644:
7645: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso quote line relationship table
7646: PROCEDURE Set_Line_Rltship_Tbl_Out(
7647: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,
7648: x_line_relationship_id OUT NOCOPY jtf_number_table
7649:
7650: /*-- The following output parameters are ignored
7651: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 7751: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,

7747:
7748:
7749: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso payment table
7750: PROCEDURE Set_Payment_Tbl_Out(
7751: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,
7752: x_payment_id OUT NOCOPY jtf_number_table
7753:
7754: /*-- The following output parameters are ignored
7755: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 7958: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,

7954:
7955:
7956: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso shipment table
7957: PROCEDURE Set_Shipment_Tbl_Out(
7958: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,
7959: x_shipment_id OUT NOCOPY jtf_number_table
7960:
7961: /*-- The following output parameters are ignored
7962: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 8262: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,

8258:
8259:
8260: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso tax detail table
8261: PROCEDURE Set_Tax_Detail_Tbl_Out(
8262: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,
8263: x_tax_detail_id OUT NOCOPY jtf_number_table
8264:
8265: /*-- The following output parameters are ignored
8266: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 8458: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,

8454:
8455:
8456: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso price adjustment table
8457: PROCEDURE Set_Price_Adj_Tbl_Out(
8458: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,
8459: x_price_adjustment_id OUT NOCOPY jtf_number_table
8460:
8461: /*-- The following output parameters are ignored
8462: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 8834: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,

8830:
8831:
8832: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso price attributes table
8833: PROCEDURE Set_Price_Attributes_Tbl_Out(
8834: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,
8835: x_price_attribute_id OUT NOCOPY jtf_number_table
8836:
8837: /*-- The following output parameters are ignored
8838: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 9398: p_qte_sales_credit_tbl IN ASO_Quote_Pub.Sales_Credit_Tbl_Type,

9394:
9395:
9396: -- copy data OUT NOCOPY /* file.sql.39 change */ from aso sales credit table
9397: PROCEDURE Set_Sales_Credit_Tbl_Out(
9398: p_qte_sales_credit_tbl IN ASO_Quote_Pub.Sales_Credit_Tbl_Type,
9399: x_sales_credit_id OUT NOCOPY jtf_number_table
9400:
9401: /*-- The following output parameters are ignored
9402: x_qte_line_index OUT NOCOPY jtf_number_table,

Line 9710: p_qte_access_tbl IN ASO_Quote_Pub.Qte_Access_Tbl_Type,

9706: END Set_Opp_Qte_Out_Rec_Out;
9707:
9708: -- copy info OUT NOCOPY /* file.sql.39 change */ from aso quote accesses tbl
9709: PROCEDURE Set_Qte_Access_Tbl_Out(
9710: p_qte_access_tbl IN ASO_Quote_Pub.Qte_Access_Tbl_Type,
9711: x_access_id OUT NOCOPY jtf_number_table
9712: )
9713: IS
9714: ddindx binary_integer;

Line 9735: p_template_tbl IN ASO_Quote_Pub.Template_Tbl_Type,

9731: END Set_Qte_Access_Tbl_Out;
9732:
9733: -- copy info OUT NOCOPY /* file.sql.39 change */ from aso template tbl
9734: PROCEDURE Set_Template_Tbl_Out(
9735: p_template_tbl IN ASO_Quote_Pub.Template_Tbl_Type,
9736: x_template_id OUT NOCOPY jtf_number_table
9737: )
9738: IS
9739: ddindx binary_integer;

Line 10042: RETURN ASO_Quote_Pub.Template_Rec_Type

10038:
10039: FUNCTION Construct_Template_Rec(
10040: p_template_id IN NUMBER := FND_API.G_MISS_NUM
10041: )
10042: RETURN ASO_Quote_Pub.Template_Rec_Type
10043: IS
10044:
10045: l_template_rec ASO_Quote_Pub.Template_Rec_Type;
10046:

Line 10045: l_template_rec ASO_Quote_Pub.Template_Rec_Type;

10041: )
10042: RETURN ASO_Quote_Pub.Template_Rec_Type
10043: IS
10044:
10045: l_template_rec ASO_Quote_Pub.Template_Rec_Type;
10046:
10047: BEGIN
10048:
10049: IF p_template_id = ROSETTA_G_MISS_NUM THEN

Line 10063: RETURN ASO_Quote_Pub.Template_Tbl_Type

10059:
10060: FUNCTION Construct_Template_Tbl(
10061: p_template_id IN jtf_number_table := NULL
10062: )
10063: RETURN ASO_Quote_Pub.Template_Tbl_Type
10064: IS
10065: l_template_tbl ASO_Quote_Pub.Template_Tbl_Type;
10066: l_table_size PLS_INTEGER := 0;
10067: i PLS_INTEGER;

Line 10065: l_template_tbl ASO_Quote_Pub.Template_Tbl_Type;

10061: p_template_id IN jtf_number_table := NULL
10062: )
10063: RETURN ASO_Quote_Pub.Template_Tbl_Type
10064: IS
10065: l_template_tbl ASO_Quote_Pub.Template_Tbl_Type;
10066: l_table_size PLS_INTEGER := 0;
10067: i PLS_INTEGER;
10068: BEGIN
10069:

Line 10090: RETURN ASO_Quote_Pub.G_MISS_TEMPLATE_TBL;

10086: END LOOP;
10087:
10088: RETURN l_template_tbl;
10089: ELSE
10090: RETURN ASO_Quote_Pub.G_MISS_TEMPLATE_TBL;
10091: END IF;
10092: END Construct_Template_Tbl;
10093:
10094:

Line 10160: p_qte_header_rec IN ASO_Quote_Pub.Qte_header_rec_Type,

10156: END Construct_Ln_Misc_Rec;
10157:
10158:
10159: PROCEDURE Set_Qte_header_rec_Out(
10160: p_qte_header_rec IN ASO_Quote_Pub.Qte_header_rec_Type,
10161: x_q_quote_header_id OUT NOCOPY NUMBER,
10162: x_q_creation_date OUT NOCOPY DATE,
10163: x_q_created_by OUT NOCOPY NUMBER,
10164: x_q_last_updated_by OUT NOCOPY NUMBER,

Line 10442: p_shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type,

10438: x_q_header_paynow_charges := p_qte_header_rec.header_paynow_charges;
10439: end;
10440:
10441: PROCEDURE Set_Shipment_rec_Out(
10442: p_shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type,
10443: x_qs_operation_code OUT NOCOPY VARCHAR2,
10444: x_qs_qte_line_index OUT NOCOPY NUMBER,
10445: x_qs_shipment_id OUT NOCOPY NUMBER,
10446: x_qs_creation_date OUT NOCOPY DATE,

Line 10601: p_payment_rec IN ASO_Quote_Pub.Payment_rec_Type,

10597: end;
10598:
10599:
10600: PROCEDURE Set_Payment_rec_Out(
10601: p_payment_rec IN ASO_Quote_Pub.Payment_rec_Type,
10602: x_qp_operation_code OUT NOCOPY VARCHAR2,
10603: x_qp_qte_line_index OUT NOCOPY NUMBER,
10604: x_qp_payment_id OUT NOCOPY NUMBER,
10605: x_qp_creation_date OUT NOCOPY DATE,

Line 10717: p_tax_detail_rec IN ASO_Quote_Pub.Tax_detail_rec_Type,

10713: end;
10714:
10715:
10716: PROCEDURE Set_Tax_detail_rec_Out(
10717: p_tax_detail_rec IN ASO_Quote_Pub.Tax_detail_rec_Type,
10718: x_qt_operation_code OUT NOCOPY VARCHAR2,
10719: x_qt_qte_line_index OUT NOCOPY NUMBER,
10720: x_qt_shipment_index OUT NOCOPY NUMBER,
10721: x_qt_tax_detail_id OUT NOCOPY NUMBER,

Line 10818: p_qte_line_rec IN ASO_Quote_Pub.Qte_line_rec_Type,

10814: end;
10815:
10816:
10817: PROCEDURE Set_Qte_line_rec_Out(
10818: p_qte_line_rec IN ASO_Quote_Pub.Qte_line_rec_Type,
10819: x_ql_creation_date OUT NOCOPY DATE,
10820: x_ql_created_by OUT NOCOPY NUMBER,
10821: x_ql_last_updated_by OUT NOCOPY NUMBER,
10822: x_ql_last_update_date OUT NOCOPY DATE,

Line 11000: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,

10996: x_ql_config_model_type := p_qte_line_rec.config_model_type;
10997: end;
10998:
10999: PROCEDURE Set_Config_Valid_Table_Out(
11000: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,
11001: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
11002: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
11003: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
11004: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 11089: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type

11085: p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
11086: p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
11087: p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
11088: )
11089: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type
11090: IS
11091: l_rel_obj_tbl ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
11092: l_table_size PLS_INTEGER := 0;
11093: i PLS_INTEGER;

Line 11091: l_rel_obj_tbl ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;

11087: p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
11088: )
11089: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type
11090: IS
11091: l_rel_obj_tbl ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
11092: l_table_size PLS_INTEGER := 0;
11093: i PLS_INTEGER;
11094: BEGIN
11095:

Line 11252: RETURN ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;

11248: END LOOP;
11249:
11250: RETURN l_rel_obj_tbl;
11251: ELSE
11252: RETURN ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
11253: END IF;
11254:
11255: END Construct_Related_Obj_Tbl;
11256:

Line 11258: p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,

11254:
11255: END Construct_Related_Obj_Tbl;
11256:
11257: PROCEDURE Set_Related_Obj_Tbl_Out(
11258: p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,
11259: x_related_object_id OUT NOCOPY jtf_number_table
11260: )
11261: IS
11262: ddindx binary_integer;