65: i PLS_INTEGER;
66: BEGIN
67: --To determine the table size
68: --quote_header_id array is choosen because it will definitely be passed by the mid tier
69: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
70: IBE_UTIL.DEBUG('Ready to call CONSTRUCT_PAYMENT_TBL in IBE_Quote_W1_PVT');
71: END IF;
72: IF p_quote_header_id IS NOT NULL THEN
73: l_table_size := p_quote_header_id.COUNT;
66: BEGIN
67: --To determine the table size
68: --quote_header_id array is choosen because it will definitely be passed by the mid tier
69: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
70: IBE_UTIL.DEBUG('Ready to call CONSTRUCT_PAYMENT_TBL in IBE_Quote_W1_PVT');
71: END IF;
72: IF p_quote_header_id IS NOT NULL THEN
73: l_table_size := p_quote_header_id.COUNT;
74: END IF;
250: END LOOP;
251:
252:
253: RETURN l_payment_tbl;
254: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
255: IBE_UTIL.DEBUG('returning payment table from CONSTRUCT_PAYMENT_TBL');
256: END IF;
257: END IF;
258: END Construct_Payment_Tbl;
251:
252:
253: RETURN l_payment_tbl;
254: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
255: IBE_UTIL.DEBUG('returning payment table from CONSTRUCT_PAYMENT_TBL');
256: END IF;
257: END IF;
258: END Construct_Payment_Tbl;
259:
1825: BEGIN
1826: IF p_quote_header_id IS NOT NULL THEN
1827: l_table_size := p_quote_header_id.COUNT;
1828: END IF;
1829: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1830: IBE_UTIL.DEBUG('Rday to call CONSTRUCT_SHIPMENT_TBL ');
1831: END IF;
1832:
1833: IF l_table_size > 0 THEN
1826: IF p_quote_header_id IS NOT NULL THEN
1827: l_table_size := p_quote_header_id.COUNT;
1828: END IF;
1829: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1830: IBE_UTIL.DEBUG('Rday to call CONSTRUCT_SHIPMENT_TBL ');
1831: END IF;
1832:
1833: IF l_table_size > 0 THEN
1834: FOR i IN 1..l_table_size LOOP
2091:
2092: END LOOP;
2093:
2094: RETURN l_shipment_tbl;
2095: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2096: IBE_UTIL.DEBUG('Returning shipment table from CONSTRUCT_SHIPMENT_TBL');
2097: END IF;
2098: END IF;
2099: END Construct_Shipment_Tbl;
2092: END LOOP;
2093:
2094: RETURN l_shipment_tbl;
2095: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2096: IBE_UTIL.DEBUG('Returning shipment table from CONSTRUCT_SHIPMENT_TBL');
2097: END IF;
2098: END IF;
2099: END Construct_Shipment_Tbl;
2100:
2316:
2317: END LOOP;
2318:
2319: RETURN l_tax_detail_tbl;
2320: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2321: IBE_UTIL.Debug('Returning tax details table from CONSTRUCT_TAX_DETAIL_TBL');
2322: END IF;
2323: END IF;
2324: END Construct_Tax_Detail_Tbl;
2317: END LOOP;
2318:
2319: RETURN l_tax_detail_tbl;
2320: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2321: IBE_UTIL.Debug('Returning tax details table from CONSTRUCT_TAX_DETAIL_TBL');
2322: END IF;
2323: END IF;
2324: END Construct_Tax_Detail_Tbl;
2325:
5789: p_rltd_price_adj_index => p_qlpar_rltd_price_adj_index);
5790: ELSE
5791: l_price_adj_rltship_tbl := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
5792: END IF;
5793: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5794: IBE_UTIL.DEBUG('p_q_save_type in Save_wrapper: '||p_q_save_type);
5795: END IF;
5796:
5797: if ((p_q_save_type = SAVE_ADDTOCART)
5790: ELSE
5791: l_price_adj_rltship_tbl := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
5792: END IF;
5793: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5794: IBE_UTIL.DEBUG('p_q_save_type in Save_wrapper: '||p_q_save_type);
5795: END IF;
5796:
5797: if ((p_q_save_type = SAVE_ADDTOCART)
5798: OR(p_q_save_type = SAVE_EXPRESSORDER)) then
5800: /*IF(p_q_save_type = SAVE_EXPRESSORDER) THEN
5801: l_save_type := 'SAVE_EXPRESSORDER';
5802: END IF;*/
5803:
5804: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5805: IBE_UTIL.DEBUG('L_save_type in Save_wrapper: '||l_save_type);
5806: END IF;
5807: IBE_Quote_Save_pvt.AddItemsToCart(
5808: p_api_version_number => p_api_version_number
5801: l_save_type := 'SAVE_EXPRESSORDER';
5802: END IF;*/
5803:
5804: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5805: IBE_UTIL.DEBUG('L_save_type in Save_wrapper: '||l_save_type);
5806: END IF;
5807: IBE_Quote_Save_pvt.AddItemsToCart(
5808: p_api_version_number => p_api_version_number
5809: ,p_init_msg_list => p_init_msg_list