DBA Data[Home] [Help]

APPS.ASO_QUOTE_UTIL_PVT dependencies on ASO_QUOTE_PUB

Line 152: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type;

148: p_end_customer_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
150: p_header_paynow_charges IN NUMBER := FND_API.G_MISS_NUM
151: )
152: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type;
153:
154: FUNCTION Construct_Qte_Line_Tbl(
155: p_creation_date IN jtf_date_table := NULL,
156: p_created_by IN jtf_number_table := NULL,

Line 244: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type;

240: p_line_paynow_tax IN jtf_number_table := NULL,
241: p_line_paynow_subtotal IN jtf_number_table := NULL,
242: p_config_model_type IN jtf_varchar2_table_100 := NULL
243: )
244: RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type;
245:
246: FUNCTION Construct_Qte_Line_Rec(
247: p_creation_date IN DATE := FND_API.G_MISS_DATE,
248: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 336: RETURN ASO_Quote_Pub.Qte_Line_Rec_Type;

332: p_line_paynow_tax IN NUMBER := FND_API.G_MISS_NUM,
333: p_line_paynow_subtotal IN NUMBER := FND_API.G_MISS_NUM,
334: p_config_model_type IN VARCHAR2 := FND_API.G_MISS_CHAR
335: )
336: RETURN ASO_Quote_Pub.Qte_Line_Rec_Type;
337:
338:
339: FUNCTION Construct_Qte_Line_Dtl_Tbl(
340: p_quote_line_detail_id IN jtf_number_table := NULL,

Line 423: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

419: p_ato_line_index IN jtf_number_table := NULL,
420: p_component_sequence_id IN jtf_number_table := NULL,
421: p_object_version_number IN jtf_number_table := NULL
422: )
423: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
424:
425: FUNCTION Construct_Qte_Line_Dtl_Rec(
426: p_quote_line_detail_id IN NUMBER := FND_API.G_MISS_NUM,
427: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 509: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type;

505: p_ato_line_index IN NUMBER := FND_API.G_MISS_NUM,
506: p_component_sequence_id IN NUMBER := FND_API.G_MISS_NUM,
507: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
508: )
509: RETURN ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type;
510:
511: FUNCTION Construct_Line_Rltship_Tbl(
512: p_line_relationship_id IN jtf_number_table := NULL,
513: p_creation_date IN jtf_date_table := NULL,

Line 531: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type;

527: p_related_qte_line_index IN jtf_number_table := NULL,
528: p_operation_code IN jtf_varchar2_table_100 := NULL,
529: p_object_version_number IN jtf_number_table := NULL
530: )
531: RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type;
532:
533: FUNCTION Construct_Payment_Tbl(
534: p_operation_code IN jtf_varchar2_table_100 := NULL,
535: p_qte_line_index IN jtf_number_table := NULL,

Line 590: RETURN ASO_Quote_Pub.Payment_Tbl_Type;

586: p_cvv2 IN jtf_varchar2_table_100 := NULL,
587: p_object_version_number IN jtf_number_table := NULL
588:
589: )
590: RETURN ASO_Quote_Pub.Payment_Tbl_Type;
591:
592: FUNCTION Construct_Payment_Rec(
593: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
594: p_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,

Line 649: RETURN ASO_Quote_Pub.Payment_Rec_Type;

645: p_instr_assignment_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_cvv2 IN VARCHAR2 := FND_API.G_MISS_CHAR
647:
648: )
649: RETURN ASO_Quote_Pub.Payment_Rec_Type;
650:
651:
652: FUNCTION Construct_Shipment_Rec(
653: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 730: RETURN ASO_Quote_Pub.Shipment_Rec_Type;

726: p_request_date_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
729: )
730: RETURN ASO_Quote_Pub.Shipment_Rec_Type;
731:
732: FUNCTION Construct_Shipment_Tbl(
733: p_operation_code IN jtf_varchar2_table_100 := NULL,
734: p_qte_line_index IN jtf_number_table := NULL,

Line 810: RETURN ASO_Quote_Pub.Shipment_Tbl_Type;

806: p_request_date_type IN jtf_varchar2_table_100 := NULL,
807: p_demand_class_code IN jtf_varchar2_table_100 := NULL,
808: p_object_version_number IN jtf_number_table := NULL
809: )
810: RETURN ASO_Quote_Pub.Shipment_Tbl_Type;
811:
812: FUNCTION Construct_Tax_Detail_Tbl(
813: p_operation_code IN jtf_varchar2_table_100 := NULL,
814: p_qte_line_index IN jtf_number_table := NULL,

Line 861: RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type;

857: p_attribute20 IN jtf_varchar2_table_300 := NULL,
858: p_object_version_number IN jtf_number_table := NULL,
859: p_tax_rate_id IN jtf_number_table := NULL
860: )
861: RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type;
862:
863: FUNCTION Construct_Tax_Detail_Rec(
864: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,

Line 912: RETURN ASO_Quote_Pub.Tax_Detail_Rec_Type;

908: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
910: p_tax_rate_id IN NUMBER := FND_API.G_MISS_NUM
911: )
912: RETURN ASO_Quote_Pub.Tax_Detail_Rec_Type;
913:
914:
915: FUNCTION Construct_Price_Attributes_Tbl(
916: p_operation_code IN jtf_varchar2_table_100 := NULL,

Line 1055: RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type;

1051: p_attribute19 IN jtf_varchar2_table_300 := NULL,
1052: p_attribute20 IN jtf_varchar2_table_300 := NULL,
1053: p_object_version_number IN jtf_number_table := NULL
1054: )
1055: RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1056:
1057: FUNCTION Construct_Price_Adj_Tbl(
1058: p_operation_code IN jtf_varchar2_table_100 := NULL,
1059: p_qte_line_index IN jtf_number_table := NULL,

Line 1150: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;

1146: p_attribute19 IN jtf_varchar2_table_300 := NULL,
1147: p_attribute20 IN jtf_varchar2_table_300 := NULL,
1148: p_object_version_number IN jtf_number_table := NULL
1149: )
1150: RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type;
1151:
1152: FUNCTION Construct_Sales_Credit_Tbl(
1153: p_operation_code IN jtf_varchar2_table_100 := NULL,
1154: p_qte_line_index IN jtf_number_table := NULL,

Line 1200: RETURN ASO_Quote_Pub.Sales_Credit_Tbl_Type;

1196: p_attribute19 IN jtf_varchar2_table_300 := NULL,
1197: p_attribute20 IN jtf_varchar2_table_300 := NULL,
1198: p_object_version_number IN jtf_number_table := NULL
1199: )
1200: RETURN ASO_Quote_Pub.Sales_Credit_Tbl_Type;
1201:
1202: FUNCTION Construct_Opp_Qte_In_Rec(
1203: p_opportunity_id IN NUMBER := FND_API.G_MISS_NUM,
1204: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,

Line 1274: RETURN ASO_QUOTE_PUB.Qte_Access_Tbl_Type;

1270: p_object_version_number IN jtf_number_table := NULL,
1271: p_batch_price_flag IN jtf_varchar2_table_100 := NULL,
1272: p_operation_code IN jtf_varchar2_table_100 := NULL
1273: )
1274: RETURN ASO_QUOTE_PUB.Qte_Access_Tbl_Type;
1275:
1276: FUNCTION Construct_Copy_Qte_Hdr_Rec(
1277: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
1278: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1315: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type

1311: p_dependency_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1312: p_defaulting_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1313: p_defaulting_fwk_flag VARCHAR2 := FND_API.G_MISS_CHAR,
1314: p_application_type_code VARCHAR2 := FND_API.G_MISS_CHAR,
1315: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
1316: );
1317:
1318: PROCEDURE Set_Submit_Control_Rec_W(
1319: p_book_flag IN VARCHAR2 := FND_API.G_FALSE,

Line 1323: x_Submit_control_rec OUT NOCOPY ASO_Quote_Pub.Submit_Control_Rec_Type

1319: p_book_flag IN VARCHAR2 := FND_API.G_FALSE,
1320: p_reserve_flag IN VARCHAR2 := FND_API.G_FALSE,
1321: p_calculate_price IN VARCHAR2 := FND_API.G_FALSE,
1322: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
1323: x_Submit_control_rec OUT NOCOPY ASO_Quote_Pub.Submit_Control_Rec_Type
1324: );
1325:
1326: PROCEDURE Set_Copy_Quote_Control_Rec_W(
1327: p_copy_header_only VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1359: p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,

1355: x_copy_quote_control_rec OUT NOCOPY ASO_Copy_Quote_Pub.Copy_Quote_Control_Rec_Type
1356: );
1357:
1358: PROCEDURE Set_Order_Header_Rec_Out(
1359: p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,
1360: x_order_number OUT NOCOPY NUMBER ,
1361: x_order_header_id OUT NOCOPY NUMBER ,
1362: x_order_request_id OUT NOCOPY NUMBER ,
1363: x_contract_id OUT NOCOPY NUMBER ,

Line 1368: p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,

1364: x_status OUT NOCOPY VARCHAR2
1365: );
1366:
1367: PROCEDURE Set_Qte_Header_Tbl_Out(
1368: p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,
1369: x_quote_header_id OUT NOCOPY jtf_number_table,
1370: x_last_update_date OUT NOCOPY jtf_date_table
1371:
1372: /*-- The following output parameters are ignored

Line 1474: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,

1470: --*/
1471: );
1472:
1473: PROCEDURE Set_Qte_Line_Tbl_Out(
1474: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
1475: x_quote_line_id OUT NOCOPY jtf_number_table
1476:
1477: /*-- The following output parameters are ignored
1478: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1548: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,

1544: --*/
1545: );
1546:
1547: PROCEDURE Set_Qte_Line_Dtl_Tbl_Out(
1548: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
1549: x_quote_line_detail_id OUT NOCOPY jtf_number_table
1550:
1551: /*-- The following output parameters are ignored
1552: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1626: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,

1622: --*/
1623: );
1624:
1625: PROCEDURE Set_Line_Rltship_Tbl_Out(
1626: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,
1627: x_line_relationship_id OUT NOCOPY jtf_number_table
1628:
1629: /*-- The following output parameters are ignored
1630: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1650: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,

1646: --*/
1647: );
1648:
1649: PROCEDURE Set_Payment_Tbl_Out(
1650: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,
1651: x_payment_id OUT NOCOPY jtf_number_table
1652:
1653: /*-- The following output parameters are ignored
1654: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1700: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,

1696: --*/
1697: );
1698:
1699: PROCEDURE Set_Shipment_Tbl_Out(
1700: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,
1701: x_shipment_id OUT NOCOPY jtf_number_table
1702:
1703: /*-- The following output parameters are ignored
1704: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1774: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,

1770: --*/
1771: );
1772:
1773: PROCEDURE Set_Tax_Detail_Tbl_Out(
1774: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,
1775: x_tax_detail_id OUT NOCOPY jtf_number_table
1776:
1777: /*-- The following output parameters are ignored
1778: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1821: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,

1817: --*/
1818: );
1819:
1820: PROCEDURE Set_Price_Adj_Tbl_Out(
1821: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,
1822: x_price_adjustment_id OUT NOCOPY jtf_number_table
1823:
1824: /*-- The following output parameters are ignored
1825: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1913: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,

1909: --*/
1910: );
1911:
1912: PROCEDURE Set_Price_Attributes_Tbl_Out(
1913: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,
1914: x_price_attribute_id OUT NOCOPY jtf_number_table
1915:
1916: /*-- The following output parameters are ignored
1917: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 2052: p_qte_sales_credit_tbl IN ASO_Quote_Pub.Sales_Credit_Tbl_Type,

2048: --*/
2049: );
2050:
2051: PROCEDURE Set_Sales_Credit_Tbl_Out(
2052: p_qte_sales_credit_tbl IN ASO_Quote_Pub.Sales_Credit_Tbl_Type,
2053: x_sales_credit_id OUT NOCOPY jtf_number_table
2054:
2055: /*-- The following output parameters are ignored
2056: x_qte_line_index OUT NOCOPY jtf_number_table,

Line 2131: p_qte_access_tbl IN ASO_Quote_Pub.Qte_Access_Tbl_Type,

2127: x_currency_code OUT NOCOPY VARCHAR2
2128: );
2129:
2130: PROCEDURE Set_Qte_Access_Tbl_Out(
2131: p_qte_access_tbl IN ASO_Quote_Pub.Qte_Access_Tbl_Type,
2132: x_access_id OUT NOCOPY jtf_number_table
2133: );
2134:
2135: PROCEDURE Set_Template_Tbl_Out(

Line 2136: p_template_tbl IN ASO_Quote_Pub.Template_Tbl_Type,

2132: x_access_id OUT NOCOPY jtf_number_table
2133: );
2134:
2135: PROCEDURE Set_Template_Tbl_Out(
2136: p_template_tbl IN ASO_Quote_Pub.Template_Tbl_Type,
2137: x_template_id OUT NOCOPY jtf_number_table
2138: );
2139:
2140: PROCEDURE Set_Atp_Tbl_Out (

Line 2204: RETURN ASO_Quote_Pub.Template_Tbl_Type;

2200: );
2201: FUNCTION Construct_Template_Tbl(
2202: p_template_id IN jtf_number_table := NULL
2203: )
2204: RETURN ASO_Quote_Pub.Template_Tbl_Type;
2205:
2206: FUNCTION Construct_Template_Rec(
2207: p_template_id IN NUMBER := FND_API.G_MISS_NUM
2208: )

Line 2209: RETURN ASO_Quote_Pub.Template_Rec_Type;

2205:
2206: FUNCTION Construct_Template_Rec(
2207: p_template_id IN NUMBER := FND_API.G_MISS_NUM
2208: )
2209: RETURN ASO_Quote_Pub.Template_Rec_Type;
2210:
2211:
2212: FUNCTION Construct_Trigger_Attr_Tbl(
2213: p_trigger_attribute IN jtf_varchar2_table_100 := NULL

Line 2231: p_qte_header_rec IN ASO_Quote_Pub.Qte_header_rec_Type,

2227: RETURN ASO_Defaulting_Int.Line_Misc_Rec_Type;
2228:
2229:
2230: PROCEDURE Set_Qte_header_rec_Out(
2231: p_qte_header_rec IN ASO_Quote_Pub.Qte_header_rec_Type,
2232: x_q_quote_header_id OUT NOCOPY NUMBER,
2233: x_q_creation_date OUT NOCOPY DATE,
2234: x_q_created_by OUT NOCOPY NUMBER,
2235: x_q_last_updated_by OUT NOCOPY NUMBER,

Line 2374: p_shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type,

2370: );
2371:
2372:
2373: PROCEDURE Set_Shipment_rec_Out(
2374: p_shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type,
2375: x_qs_operation_code OUT NOCOPY VARCHAR2,
2376: x_qs_qte_line_index OUT NOCOPY NUMBER,
2377: x_qs_shipment_id OUT NOCOPY NUMBER,
2378: x_qs_creation_date OUT NOCOPY DATE,

Line 2454: p_payment_rec IN ASO_Quote_Pub.Payment_rec_Type,

2450: x_qs_object_version_number OUT NOCOPY NUMBER
2451: );
2452:
2453: PROCEDURE Set_Payment_rec_Out(
2454: p_payment_rec IN ASO_Quote_Pub.Payment_rec_Type,
2455: x_qp_operation_code OUT NOCOPY VARCHAR2,
2456: x_qp_qte_line_index OUT NOCOPY NUMBER,
2457: x_qp_payment_id OUT NOCOPY NUMBER,
2458: x_qp_creation_date OUT NOCOPY DATE,

Line 2513: p_tax_detail_rec IN ASO_Quote_Pub.Tax_detail_rec_Type,

2509: );
2510:
2511:
2512: PROCEDURE Set_Tax_detail_rec_Out(
2513: p_tax_detail_rec IN ASO_Quote_Pub.Tax_detail_rec_Type,
2514: x_qt_operation_code OUT NOCOPY VARCHAR2,
2515: x_qt_qte_line_index OUT NOCOPY NUMBER,
2516: x_qt_shipment_index OUT NOCOPY NUMBER,
2517: x_qt_tax_detail_id OUT NOCOPY NUMBER,

Line 2565: p_qte_line_rec IN ASO_Quote_Pub.Qte_line_rec_Type,

2561: );
2562:
2563:
2564: PROCEDURE Set_Qte_line_rec_Out(
2565: p_qte_line_rec IN ASO_Quote_Pub.Qte_line_rec_Type,
2566: x_ql_creation_date OUT NOCOPY DATE,
2567: x_ql_created_by OUT NOCOPY NUMBER,
2568: x_ql_last_updated_by OUT NOCOPY NUMBER,
2569: x_ql_last_update_date OUT NOCOPY DATE,

Line 2668: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,

2664: x_def_control_rec OUT NOCOPY ASO_Defaulting_Int.Control_Rec_Type
2665: );
2666:
2667: PROCEDURE Set_Config_Valid_Table_Out(
2668: p_config_table IN ASO_QUOTE_PUB.Config_Vaild_Tbl_Type,
2669: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
2670: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2671: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2672: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 2701: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;

2697: p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
2698: p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
2699: p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
2700: )
2701: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
2702:
2703:
2704: PROCEDURE Set_Related_Obj_Tbl_Out(
2705: p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,

Line 2705: p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,

2701: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
2702:
2703:
2704: PROCEDURE Set_Related_Obj_Tbl_Out(
2705: p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,
2706: x_related_object_id OUT NOCOPY jtf_number_table
2707: );
2708:
2709: