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 1341: p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,

1337: x_copy_quote_control_rec OUT NOCOPY ASO_Copy_Quote_Pub.Copy_Quote_Control_Rec_Type
1338: );
1339:
1340: PROCEDURE Set_Order_Header_Rec_Out(
1341: p_order_header_rec IN ASO_Quote_Pub.Order_Header_Rec_Type,
1342: x_order_number OUT NOCOPY NUMBER ,
1343: x_order_header_id OUT NOCOPY NUMBER ,
1344: x_order_request_id OUT NOCOPY NUMBER ,
1345: x_contract_id OUT NOCOPY NUMBER ,

Line 1350: p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,

1346: x_status OUT NOCOPY VARCHAR2
1347: );
1348:
1349: PROCEDURE Set_Qte_Header_Tbl_Out(
1350: p_qte_header_tbl IN ASO_Quote_Pub.Qte_Header_Tbl_Type,
1351: x_quote_header_id OUT NOCOPY jtf_number_table,
1352: x_last_update_date OUT NOCOPY jtf_date_table
1353:
1354: /*-- The following output parameters are ignored

Line 1456: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,

1452: --*/
1453: );
1454:
1455: PROCEDURE Set_Qte_Line_Tbl_Out(
1456: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
1457: x_quote_line_id OUT NOCOPY jtf_number_table
1458:
1459: /*-- The following output parameters are ignored
1460: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1530: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,

1526: --*/
1527: );
1528:
1529: PROCEDURE Set_Qte_Line_Dtl_Tbl_Out(
1530: p_qte_line_dtl_tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
1531: x_quote_line_detail_id OUT NOCOPY jtf_number_table
1532:
1533: /*-- The following output parameters are ignored
1534: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1608: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,

1604: --*/
1605: );
1606:
1607: PROCEDURE Set_Line_Rltship_Tbl_Out(
1608: p_qte_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type,
1609: x_line_relationship_id OUT NOCOPY jtf_number_table
1610:
1611: /*-- The following output parameters are ignored
1612: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1632: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,

1628: --*/
1629: );
1630:
1631: PROCEDURE Set_Payment_Tbl_Out(
1632: p_qte_payment_tbl IN ASO_Quote_Pub.Payment_Tbl_Type,
1633: x_payment_id OUT NOCOPY jtf_number_table
1634:
1635: /*-- The following output parameters are ignored
1636: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1682: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,

1678: --*/
1679: );
1680:
1681: PROCEDURE Set_Shipment_Tbl_Out(
1682: p_qte_shipment_tbl IN ASO_Quote_Pub.Shipment_Tbl_Type,
1683: x_shipment_id OUT NOCOPY jtf_number_table
1684:
1685: /*-- The following output parameters are ignored
1686: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1756: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,

1752: --*/
1753: );
1754:
1755: PROCEDURE Set_Tax_Detail_Tbl_Out(
1756: p_qte_tax_detail_tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type,
1757: x_tax_detail_id OUT NOCOPY jtf_number_table
1758:
1759: /*-- The following output parameters are ignored
1760: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1803: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,

1799: --*/
1800: );
1801:
1802: PROCEDURE Set_Price_Adj_Tbl_Out(
1803: p_qte_price_adj_tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type,
1804: x_price_adjustment_id OUT NOCOPY jtf_number_table
1805:
1806: /*-- The following output parameters are ignored
1807: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 1895: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,

1891: --*/
1892: );
1893:
1894: PROCEDURE Set_Price_Attributes_Tbl_Out(
1895: p_qte_price_attributes_tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type,
1896: x_price_attribute_id OUT NOCOPY jtf_number_table
1897:
1898: /*-- The following output parameters are ignored
1899: x_operation_code OUT NOCOPY jtf_varchar2_table_100,

Line 2034: p_qte_sales_credit_tbl IN ASO_Quote_Pub.Sales_Credit_Tbl_Type,

2030: --*/
2031: );
2032:
2033: PROCEDURE Set_Sales_Credit_Tbl_Out(
2034: p_qte_sales_credit_tbl IN ASO_Quote_Pub.Sales_Credit_Tbl_Type,
2035: x_sales_credit_id OUT NOCOPY jtf_number_table
2036:
2037: /*-- The following output parameters are ignored
2038: x_qte_line_index OUT NOCOPY jtf_number_table,

Line 2113: p_qte_access_tbl IN ASO_Quote_Pub.Qte_Access_Tbl_Type,

2109: x_currency_code OUT NOCOPY VARCHAR2
2110: );
2111:
2112: PROCEDURE Set_Qte_Access_Tbl_Out(
2113: p_qte_access_tbl IN ASO_Quote_Pub.Qte_Access_Tbl_Type,
2114: x_access_id OUT NOCOPY jtf_number_table
2115: );
2116:
2117: PROCEDURE Set_Template_Tbl_Out(

Line 2118: p_template_tbl IN ASO_Quote_Pub.Template_Tbl_Type,

2114: x_access_id OUT NOCOPY jtf_number_table
2115: );
2116:
2117: PROCEDURE Set_Template_Tbl_Out(
2118: p_template_tbl IN ASO_Quote_Pub.Template_Tbl_Type,
2119: x_template_id OUT NOCOPY jtf_number_table
2120: );
2121:
2122: PROCEDURE Set_Atp_Tbl_Out (

Line 2186: RETURN ASO_Quote_Pub.Template_Tbl_Type;

2182: );
2183: FUNCTION Construct_Template_Tbl(
2184: p_template_id IN jtf_number_table := NULL
2185: )
2186: RETURN ASO_Quote_Pub.Template_Tbl_Type;
2187:
2188: FUNCTION Construct_Template_Rec(
2189: p_template_id IN NUMBER := FND_API.G_MISS_NUM
2190: )

Line 2191: RETURN ASO_Quote_Pub.Template_Rec_Type;

2187:
2188: FUNCTION Construct_Template_Rec(
2189: p_template_id IN NUMBER := FND_API.G_MISS_NUM
2190: )
2191: RETURN ASO_Quote_Pub.Template_Rec_Type;
2192:
2193:
2194: FUNCTION Construct_Trigger_Attr_Tbl(
2195: p_trigger_attribute IN jtf_varchar2_table_100 := NULL

Line 2213: p_qte_header_rec IN ASO_Quote_Pub.Qte_header_rec_Type,

2209: RETURN ASO_Defaulting_Int.Line_Misc_Rec_Type;
2210:
2211:
2212: PROCEDURE Set_Qte_header_rec_Out(
2213: p_qte_header_rec IN ASO_Quote_Pub.Qte_header_rec_Type,
2214: x_q_quote_header_id OUT NOCOPY NUMBER,
2215: x_q_creation_date OUT NOCOPY DATE,
2216: x_q_created_by OUT NOCOPY NUMBER,
2217: x_q_last_updated_by OUT NOCOPY NUMBER,

Line 2356: p_shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type,

2352: );
2353:
2354:
2355: PROCEDURE Set_Shipment_rec_Out(
2356: p_shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type,
2357: x_qs_operation_code OUT NOCOPY VARCHAR2,
2358: x_qs_qte_line_index OUT NOCOPY NUMBER,
2359: x_qs_shipment_id OUT NOCOPY NUMBER,
2360: x_qs_creation_date OUT NOCOPY DATE,

Line 2436: p_payment_rec IN ASO_Quote_Pub.Payment_rec_Type,

2432: x_qs_object_version_number OUT NOCOPY NUMBER
2433: );
2434:
2435: PROCEDURE Set_Payment_rec_Out(
2436: p_payment_rec IN ASO_Quote_Pub.Payment_rec_Type,
2437: x_qp_operation_code OUT NOCOPY VARCHAR2,
2438: x_qp_qte_line_index OUT NOCOPY NUMBER,
2439: x_qp_payment_id OUT NOCOPY NUMBER,
2440: x_qp_creation_date OUT NOCOPY DATE,

Line 2495: p_tax_detail_rec IN ASO_Quote_Pub.Tax_detail_rec_Type,

2491: );
2492:
2493:
2494: PROCEDURE Set_Tax_detail_rec_Out(
2495: p_tax_detail_rec IN ASO_Quote_Pub.Tax_detail_rec_Type,
2496: x_qt_operation_code OUT NOCOPY VARCHAR2,
2497: x_qt_qte_line_index OUT NOCOPY NUMBER,
2498: x_qt_shipment_index OUT NOCOPY NUMBER,
2499: x_qt_tax_detail_id OUT NOCOPY NUMBER,

Line 2547: p_qte_line_rec IN ASO_Quote_Pub.Qte_line_rec_Type,

2543: );
2544:
2545:
2546: PROCEDURE Set_Qte_line_rec_Out(
2547: p_qte_line_rec IN ASO_Quote_Pub.Qte_line_rec_Type,
2548: x_ql_creation_date OUT NOCOPY DATE,
2549: x_ql_created_by OUT NOCOPY NUMBER,
2550: x_ql_last_updated_by OUT NOCOPY NUMBER,
2551: x_ql_last_update_date OUT NOCOPY DATE,

Line 2675: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;

2671: p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
2672: p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
2673: p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
2674: )
2675: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
2676:
2677:
2678: PROCEDURE Set_Related_Obj_Tbl_Out(
2679: p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,

Line 2679: p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,

2675: RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type;
2676:
2677:
2678: PROCEDURE Set_Related_Obj_Tbl_Out(
2679: p_rel_obj_tbl IN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type,
2680: x_related_object_id OUT NOCOPY jtf_number_table
2681: );
2682:
2683: