DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on ASO_QUOTE_PUB

Line 104: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,

100: := G_MISS_saveshare_control_rec ,
101: P_party_id IN Number ,
102: P_cust_account_id IN Number ,
103: P_retrieval_number IN Number ,
104: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
105: P_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
106: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
107: P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
108: P_source_last_update_date IN Date := FND_API.G_MISS_DATE ,

Line 119: L_control_rec aso_quote_pub.control_rec_type;

115: x_return_status OUT NOCOPY VARCHAR2 ,
116: x_msg_count OUT NOCOPY NUMBER ,
117: x_msg_data OUT NOCOPY VARCHAR2 ) is
118:
119: L_control_rec aso_quote_pub.control_rec_type;
120: l_quote_header_id NUMBER;
121: l_api_name CONSTANT VARCHAR2(30) := 'SAVESHARE_V2';
122: l_api_version CONSTANT NUMBER := 1.0;
123: l_last_update_date DATE ;

Line 1073: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,

1069: -"Edit" button called from List of Saved Carts, List of Shared Out Carts, List of Recipient Carts,
1070: or Cart Details */
1071:
1072: Procedure activate_quote (
1073: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
1074: P_Party_id IN NUMBER := FND_API.G_MISS_NUM ,
1075: P_Cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1076: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
1077: := ASO_QUOTE_PUB.G_MISS_Control_Rec,

Line 1076: P_control_rec IN ASO_QUOTE_PUB.control_rec_type

1072: Procedure activate_quote (
1073: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
1074: P_Party_id IN NUMBER := FND_API.G_MISS_NUM ,
1075: P_Cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1076: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
1077: := ASO_QUOTE_PUB.G_MISS_Control_Rec,
1078: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
1079: p_api_version IN NUMBER := 1 ,
1080: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 1077: := ASO_QUOTE_PUB.G_MISS_Control_Rec,

1073: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
1074: P_Party_id IN NUMBER := FND_API.G_MISS_NUM ,
1075: P_Cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1076: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
1077: := ASO_QUOTE_PUB.G_MISS_Control_Rec,
1078: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
1079: p_api_version IN NUMBER := 1 ,
1080: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1081: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 1088: l_quote_header_rec ASO_QUOTE_PUB.Qte_header_rec_type;

1084: x_msg_data OUT NOCOPY VARCHAR2 ) is
1085:
1086: l_current_cartname VARCHAR2(2000);
1087: l_new_cartname VARCHAR2(2000);
1088: l_quote_header_rec ASO_QUOTE_PUB.Qte_header_rec_type;
1089: l_quote_header_id NUMBER;
1090: l_last_update_date date;
1091: l_control_rec ASO_Quote_Pub.Control_Rec_Type
1092: := ASO_Quote_Pub.G_Miss_Control_Rec;

Line 1091: l_control_rec ASO_Quote_Pub.Control_Rec_Type

1087: l_new_cartname VARCHAR2(2000);
1088: l_quote_header_rec ASO_QUOTE_PUB.Qte_header_rec_type;
1089: l_quote_header_id NUMBER;
1090: l_last_update_date date;
1091: l_control_rec ASO_Quote_Pub.Control_Rec_Type
1092: := ASO_Quote_Pub.G_Miss_Control_Rec;
1093: l_ac_present NUMBER := null; --active cart present in active carts table or not
1094: l_ac_party_id NUMBER := null;
1095: l_qhac_present NUMBER := null; --active cart present in quote headers or not

Line 1092: := ASO_Quote_Pub.G_Miss_Control_Rec;

1088: l_quote_header_rec ASO_QUOTE_PUB.Qte_header_rec_type;
1089: l_quote_header_id NUMBER;
1090: l_last_update_date date;
1091: l_control_rec ASO_Quote_Pub.Control_Rec_Type
1092: := ASO_Quote_Pub.G_Miss_Control_Rec;
1093: l_ac_present NUMBER := null; --active cart present in active carts table or not
1094: l_ac_party_id NUMBER := null;
1095: l_qhac_present NUMBER := null; --active cart present in quote headers or not
1096: l_qhac_quote_name VARCHAR2(2000) := null;

Line 1763: P_target_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,

1759: */
1760: Procedure APPEND_QUOTE(
1761: P_source_quote_header_id IN Number ,
1762: P_source_last_update_date IN Date ,
1763: P_target_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
1764: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
1765: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
1766: P_delete_source_cart IN Varchar2 := FND_API.G_TRUE ,
1767: P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,

Line 1764: P_control_rec IN ASO_QUOTE_PUB.control_rec_type

1760: Procedure APPEND_QUOTE(
1761: P_source_quote_header_id IN Number ,
1762: P_source_last_update_date IN Date ,
1763: P_target_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
1764: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
1765: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
1766: P_delete_source_cart IN Varchar2 := FND_API.G_TRUE ,
1767: P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,
1768: P_minisite_id IN Number := FND_API.G_MISS_NUM ,

Line 1765: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,

1761: P_source_quote_header_id IN Number ,
1762: P_source_last_update_date IN Date ,
1763: P_target_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
1764: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
1765: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
1766: P_delete_source_cart IN Varchar2 := FND_API.G_TRUE ,
1767: P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,
1768: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
1769: p_api_version IN NUMBER := 1 ,

Line 1780: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

1776: l_api_name CONSTANT VARCHAR2(30) := 'APPENDQUOTE_V2';
1777: l_api_version CONSTANT NUMBER := 1.0;
1778:
1779:
1780: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
1781: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
1782: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
1784: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 1781: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

1777: l_api_version CONSTANT NUMBER := 1.0;
1778:
1779:
1780: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
1781: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
1782: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
1784: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1785: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_rec_Type

Line 1782: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;

1778:
1779:
1780: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
1781: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
1782: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
1784: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1785: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_rec_Type
1786: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;

Line 1783: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;

1779:
1780: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
1781: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
1782: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
1784: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1785: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_rec_Type
1786: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
1787: l_last_update_date DATE;

Line 1784: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

1780: l_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
1781: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
1782: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
1784: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1785: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_rec_Type
1786: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
1787: l_last_update_date DATE;
1788: l_qte_header_id NUMBER;

Line 1785: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_rec_Type

1781: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
1782: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
1784: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1785: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_rec_Type
1786: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
1787: l_last_update_date DATE;
1788: l_qte_header_id NUMBER;
1789:

Line 1786: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;

1782: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
1784: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1785: l_hd_shipment_tbl ASO_Quote_Pub.Shipment_rec_Type
1786: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec;
1787: l_last_update_date DATE;
1788: l_qte_header_id NUMBER;
1789:
1790: -- added 12/22/03: PRG, no line merge

Line 1791: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

1787: l_last_update_date DATE;
1788: l_qte_header_id NUMBER;
1789:
1790: -- added 12/22/03: PRG, no line merge
1791: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1792: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1793:
1794: BEGIN
1795:

Line 1792: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

1788: l_qte_header_id NUMBER;
1789:
1790: -- added 12/22/03: PRG, no line merge
1791: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1792: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1793:
1794: BEGIN
1795:
1796: SAVEPOINT APPENDQUOTE_V2;

Line 2921: ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type

2917:
2918: PROCEDURE Validate_share_Update(
2919: p_api_version_number IN NUMBER := 1.0
2920: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2921: ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2922: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
2923: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
2924: -- partyid and accountid cannot be gmiss coming in
2925: ,p_party_id IN NUMBER