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

Line 50: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,

46: END Find_Index;
47:
48:
49: FUNCTION Find_Same_Item_In_Qte_Line_Tbl(
50: p_qte_line_tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type,
51: p_inventory_item_id IN NUMBER ,
52: p_uom_code IN VARCHAR2
53: )
54: RETURN NUMBER

Line 157: x_qte_line_relation_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type,

153: PROCEDURE Include_Related_Lines(
154: p_qte_line_rel_tbl IN VARCHAR2 ,
155: p_list_line_id_tbl IN jtf_number_table,
156: x_list_line_id_tbl OUT NOCOPY jtf_number_table,
157: x_qte_line_relation_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type,
158: x_list_line_relation_tbl OUT NOCOPY SL_Line_Rel_Tbl_Type)
159: IS
160: TYPE rel_line_csr_type IS REF CURSOR;
161: rel_line_csr rel_line_csr_type;

Line 237: x_qte_line_rel_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type,

233: p_to_create_quote IN BOOLEAN ,
234: p_list_header_id_tbl IN jtf_number_table,
235: p_list_line_id_tbl IN jtf_number_table,
236: p_line_index_tbl IN jtf_number_table,
237: x_qte_line_rel_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type,
238: x_list_line_rel_tbl OUT NOCOPY SL_Line_Rel_Tbl_Type
239: )
240: IS
241: TYPE Csr_Type IS REF CURSOR;

Line 1641: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

1637: l_list_line_id_tbl jtf_number_table := jtf_number_table();
1638: l_sl_header_rec SL_Header_Rec_Type;
1639: l_sl_line_tbl SL_Line_Tbl_Type;
1640: l_sl_line_rel_tbl SL_Line_Rel_Tbl_Type;
1641: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
1642: BEGIN
1643: -- Standard Start of API savepoint
1644: SAVEPOINT Save_List_From_Items_PVT;
1645:

Line 2347: x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type ,

2343: p_price_list_id IN NUMBER ,
2344: p_currency_code IN VARCHAR2 ,
2345: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
2346: p_minisite_id IN NUMBER := FND_API.G_MISS_CHAR ,
2347: x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type ,
2348: x_qte_line_detail_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
2349: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,
2350: x_qte_line_index_tbl OUT NOCOPY jtf_number_table ,
2351: x_ql_line_codes OUT NOCOPY jtf_number_table ,

Line 2348: x_qte_line_detail_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,

2344: p_currency_code IN VARCHAR2 ,
2345: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
2346: p_minisite_id IN NUMBER := FND_API.G_MISS_CHAR ,
2347: x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type ,
2348: x_qte_line_detail_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
2349: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,
2350: x_qte_line_index_tbl OUT NOCOPY jtf_number_table ,
2351: x_ql_line_codes OUT NOCOPY jtf_number_table ,
2352: x_contMDL OUT NOCOPY VARCHAR2

Line 2686: p_control_rec IN ASO_Quote_Pub.control_rec_type ,

2682: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
2683: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
2684: p_mode IN VARCHAR2 := 'MERGE' ,
2685: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
2686: p_control_rec IN ASO_Quote_Pub.control_rec_type ,
2687: p_q_header_rec IN ASO_Quote_Pub.qte_header_rec_type,
2688: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR ,
2689: p_email_address IN jtf_varchar2_table_2000 := NULL ,
2690: p_privilege_type IN jtf_varchar2_table_100 := NULL ,

Line 2687: p_q_header_rec IN ASO_Quote_Pub.qte_header_rec_type,

2683: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
2684: p_mode IN VARCHAR2 := 'MERGE' ,
2685: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
2686: p_control_rec IN ASO_Quote_Pub.control_rec_type ,
2687: p_q_header_rec IN ASO_Quote_Pub.qte_header_rec_type,
2688: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR ,
2689: p_email_address IN jtf_varchar2_table_2000 := NULL ,
2690: p_privilege_type IN jtf_varchar2_table_100 := NULL ,
2691: p_url IN VARCHAR2 ,

Line 2704: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

2700:
2701: l_list_line_id_tbl jtf_number_table;
2702: l_list_line_id_map_tbl jtf_number_table;
2703: l_qte_line_index_tbl jtf_number_table;
2704: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2705: l_qte_line_detail_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
2706: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
2707: l_list_line_relation_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type;
2708: lx_quote_header_id NUMBER;

Line 2705: l_qte_line_detail_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

2701: l_list_line_id_tbl jtf_number_table;
2702: l_list_line_id_map_tbl jtf_number_table;
2703: l_qte_line_index_tbl jtf_number_table;
2704: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2705: l_qte_line_detail_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
2706: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
2707: l_list_line_relation_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type;
2708: lx_quote_header_id NUMBER;
2709: lx_last_update_date DATE;

Line 2706: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

2702: l_list_line_id_map_tbl jtf_number_table;
2703: l_qte_line_index_tbl jtf_number_table;
2704: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2705: l_qte_line_detail_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
2706: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
2707: l_list_line_relation_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type;
2708: lx_quote_header_id NUMBER;
2709: lx_last_update_date DATE;
2710:

Line 2713: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

2709: lx_last_update_date DATE;
2710:
2711: -- add 3/26/03: to be used for ibe_quote_save_pvt.save api
2712: l_ql_line_codes jtf_number_table;
2713: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2714:
2715: -- added on 5/21/03: SBM --
2716: l_qte_line_detail_indx number;
2717: l_qte_line_id number;

Line 2718: l_control_rec ASO_Quote_Pub.control_rec_type;

2714:
2715: -- added on 5/21/03: SBM --
2716: l_qte_line_detail_indx number;
2717: l_qte_line_id number;
2718: l_control_rec ASO_Quote_Pub.control_rec_type;
2719: lx_contMDL varchar2(1);
2720:
2721: --Maithili- added for Offer code integration.
2722: l_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 2722: l_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

2718: l_control_rec ASO_Quote_Pub.control_rec_type;
2719: lx_contMDL varchar2(1);
2720:
2721: --Maithili- added for Offer code integration.
2722: l_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
2723:
2724: Cursor c_get_promo_details(p_promocode VARCHAR2, p_currency_code VARCHAR2) is
2725: SELECT list_header_id
2726: FROM qp_list_headers_vl

Line 2890: l_control_rec := aso_quote_pub.G_MISS_Control_Rec;

2886: if (lx_contMDL = 'Y') then
2887: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2888: IBE_Util.Debug('Coming back from update_config_item_lines: lx_contMDL is Y');
2889: END IF;
2890: l_control_rec := aso_quote_pub.G_MISS_Control_Rec;
2891: end if;
2892:
2893: --Maithili
2894: IF (p_promocode is not null and p_promocode <> FND_API.G_MISS_CHAR) THEN

Line 2952: l_control_rec := aso_quote_pub.G_MISS_Control_Rec;

2948: -- if lx_contMDL = Y, then there must be at least a MDL in the shop list
2949: -- 1) get line det record from 1st index of line det Tbl
2950: if (lx_contMDL = 'Y') then
2951: for i in 1..l_qte_line_detail_tbl.count loop
2952: l_control_rec := aso_quote_pub.G_MISS_Control_Rec;
2953: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2954: IBE_Util.Debug('Begin ASO_CFG_PUB.get_config_details');
2955: END IF;
2956: