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.ASO_QUOTE_LINES_PVT dependencies on ASO_SHIPMENTS

Line 631: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');

627: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;
628: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
629:
630: IF aso_debug_pub.g_debug_flag = 'Y' THEN
631: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');
632: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');
633: END IF;
634:
635: ASO_SHIPMENTS_PKG.Insert_Row(

Line 632: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');

628: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
629:
630: IF aso_debug_pub.g_debug_flag = 'Y' THEN
631: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');
632: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');
633: END IF;
634:
635: ASO_SHIPMENTS_PKG.Insert_Row(
636: px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_ID,

Line 635: ASO_SHIPMENTS_PKG.Insert_Row(

631: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');
632: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');
633: END IF;
634:
635: ASO_SHIPMENTS_PKG.Insert_Row(
636: px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_ID,
637: p_CREATION_DATE => SYSDATE,
638: p_CREATED_BY => G_USER_ID,
639: p_LAST_UPDATE_DATE => SYSDATE,

Line 1058: -- insert rows into aso_shipments_tbl

1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1055: aso_debug_pub.add('Insert_Quote_lines - payment.insert_row ', 1, 'N');
1056: end if;
1057:
1058: -- insert rows into aso_shipments_tbl
1059:
1060:
1061: -- insert into quote party table
1062:

Line 1216: FROM aso_shipments

1212: and organization_id = lc_organization_id;
1213:
1214: CURSOR C_shipment IS
1215: SELECT count(*) ,sum(quantity)
1216: FROM aso_shipments
1217: WHERE quote_line_id = p_qte_line_rec.quote_line_id;
1218:
1219: CURSOR C_header IS
1220: SELECT quote_header_id, organization_id, inventory_item_id

Line 2083: FROM aso_shipments

2079:
2080: -- update the existing rec
2081:
2082: SELECT shipment_id into l_shipment_tbl(1).shipment_id
2083: FROM aso_shipments
2084: WHERE quote_line_id = l_qte_line_rec.quote_line_id
2085: AND quote_header_id = l_qte_line_rec.quote_header_id;
2086:
2087: l_shipment_tbl(1).quote_header_id := l_qte_line_rec.quote_header_id;

Line 4428: UPDATE ASO_SHIPMENTS

4424: l_shipment_tbl(i).reserved_quantity := l_shipment_tbl_out(i).reserved_quantity;
4425: l_shipment_tbl(i).reservation_id := l_shipment_tbl_out(i).reservation_id;
4426:
4427:
4428: UPDATE ASO_SHIPMENTS
4429: SET reservation_id = l_shipment_tbl(i).reservation_id,
4430: reserved_quantity = l_shipment_tbl(i).reserved_quantity,
4431: last_update_date = sysdate,
4432: last_updated_by = fnd_global.user_id,

Line 4697: FROM aso_shipments

4693: and a.transaction_line_id = b.transaction_line_id;
4694:
4695: CURSOR C_ship_partial (l_quote_line_id NUMBER) IS
4696: SELECT count(*)
4697: FROM aso_shipments
4698: WHERE quote_line_id = l_quote_line_id;
4699:
4700: CURSOR get_cust_acct(cust_QUOTE_HEADER_ID Number) IS
4701: SELECT CUST_ACCOUNT_ID

Line 4858: FROM ASO_SHIPMENTS

4854:
4855: CURSOR c_db_ship_freight_terms(p_shipment_id number) IS
4856: SELECT ship_method_code_from,ship_method_code,
4857: Freight_terms_code_from,Freight_terms_code
4858: FROM ASO_SHIPMENTS
4859: WHERE shipment_id = p_shipment_id;
4860:
4861: cursor c_service_ref_type_code(p_quote_line_detail_id number) is
4862: select service_ref_type_code from aso_quote_line_details

Line 7564: -- aso_shipments_tbl

7560: aso_debug_pub.add('Update_Quote_line - after line_price_attribs.update ', 1, 'N');
7561: end if;
7562:
7563:
7564: -- aso_shipments_tbl
7565:
7566:
7567: FOR i IN 1..l_Shipment_Tbl.count LOOP
7568:

Line 7585: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).ship_method_code'||l_shipment_tbl(1).ship_method_code, 1, 'Y');

7581: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;
7582: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
7583:
7584: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7585: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).ship_method_code'||l_shipment_tbl(1).ship_method_code, 1, 'Y');
7586: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).freight_terms_code'||l_shipment_tbl(1).freight_terms_code, 1, 'Y');
7587: END IF;
7588:
7589: ASO_SHIPMENTS_PKG.Insert_Row(

Line 7586: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).freight_terms_code'||l_shipment_tbl(1).freight_terms_code, 1, 'Y');

7582: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
7583:
7584: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7585: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).ship_method_code'||l_shipment_tbl(1).ship_method_code, 1, 'Y');
7586: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).freight_terms_code'||l_shipment_tbl(1).freight_terms_code, 1, 'Y');
7587: END IF;
7588:
7589: ASO_SHIPMENTS_PKG.Insert_Row(
7590: px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_ID,

Line 7589: ASO_SHIPMENTS_PKG.Insert_Row(

7585: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).ship_method_code'||l_shipment_tbl(1).ship_method_code, 1, 'Y');
7586: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).freight_terms_code'||l_shipment_tbl(1).freight_terms_code, 1, 'Y');
7587: END IF;
7588:
7589: ASO_SHIPMENTS_PKG.Insert_Row(
7590: px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_ID,
7591: p_CREATION_DATE => SYSDATE,
7592: p_CREATED_BY => G_USER_ID,
7593: p_LAST_UPDATE_DATE => SYSDATE,

Line 7726: ASO_SHIPMENTS_PKG.Update_Row(

7722:
7723: END IF;
7724:
7725:
7726: ASO_SHIPMENTS_PKG.Update_Row(
7727: p_SHIPMENT_ID => l_shipment_tbl(i).SHIPMENT_ID,
7728: p_CREATION_DATE => l_shipment_tbl(i).creation_date,
7729: p_CREATED_BY => G_USER_ID,
7730: p_LAST_UPDATE_DATE => SYSDATE,

Line 7805: ASO_SHIPMENTS_PKG.Delete_Row(

7801: END IF;
7802: END IF;
7803:
7804:
7805: ASO_SHIPMENTS_PKG.Delete_Row(
7806: p_SHIPMENT_ID => l_shipment_tbl(i).SHIPMENT_ID);
7807:
7808: END IF;
7809:

Line 8902: FROM ASO_SHIPMENTS

8898: IF l_shipment_tbl(i).quantity is not NULL AND
8899: l_shipment_tbl(i).quantity <> FND_API.G_MISS_NUM THEN
8900:
8901: SELECT reservation_id INTO l_shipment_tbl(i).reservation_id
8902: FROM ASO_SHIPMENTS
8903: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
8904:
8905: ASO_RESERVATION_INT.Update_reservation(
8906: P_Api_Version_Number => 1.0,

Line 8914: UPDATE ASO_SHIPMENTS

8910: X_Msg_Count => x_msg_count,
8911: X_Msg_Data => x_msg_data
8912: );
8913:
8914: UPDATE ASO_SHIPMENTS
8915: SET reservation_id = l_shipment_tbl(i).reservation_id,
8916: reserved_quantity = l_shipment_tbl(i).reserved_quantity,
8917: last_update_date = sysdate,
8918: last_updated_by = fnd_global.user_id,

Line 9116: FROM aso_shipments

9112: WHERE quote_number = X_qte_number;
9113:
9114: CURSOR C_Shipment IS
9115: SELECT shipment_id, reservation_id
9116: FROM aso_shipments
9117: WHERE quote_line_id = p_qte_line_rec.quote_line_id;
9118:
9119: CURSOR C_Inst_Details(shipment_id NUMBER) IS
9120: SELECT line_inst_detail_id