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 7682: -- aso_shipments_tbl

7678: aso_debug_pub.add('Update_Quote_line - after line_price_attribs.update ', 1, 'N');
7679: end if;
7680:
7681:
7682: -- aso_shipments_tbl
7683:
7684:
7685: FOR i IN 1..l_Shipment_Tbl.count LOOP
7686:

Line 7703: 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');

7699: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;
7700: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
7701:
7702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7703: 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');
7704: 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');
7705: END IF;
7706:
7707: ASO_SHIPMENTS_PKG.Insert_Row(

Line 7704: 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');

7700: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
7701:
7702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7703: 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');
7704: 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');
7705: END IF;
7706:
7707: ASO_SHIPMENTS_PKG.Insert_Row(
7708: px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_ID,

Line 7707: ASO_SHIPMENTS_PKG.Insert_Row(

7703: 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');
7704: 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');
7705: END IF;
7706:
7707: ASO_SHIPMENTS_PKG.Insert_Row(
7708: px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_ID,
7709: p_CREATION_DATE => SYSDATE,
7710: p_CREATED_BY => G_USER_ID,
7711: p_LAST_UPDATE_DATE => SYSDATE,

Line 7844: ASO_SHIPMENTS_PKG.Update_Row(

7840:
7841: END IF;
7842:
7843:
7844: ASO_SHIPMENTS_PKG.Update_Row(
7845: p_SHIPMENT_ID => l_shipment_tbl(i).SHIPMENT_ID,
7846: p_CREATION_DATE => l_shipment_tbl(i).creation_date,
7847: p_CREATED_BY => G_USER_ID,
7848: p_LAST_UPDATE_DATE => SYSDATE,

Line 7923: ASO_SHIPMENTS_PKG.Delete_Row(

7919: END IF;
7920: END IF;
7921:
7922:
7923: ASO_SHIPMENTS_PKG.Delete_Row(
7924: p_SHIPMENT_ID => l_shipment_tbl(i).SHIPMENT_ID);
7925:
7926: END IF;
7927:

Line 9020: FROM ASO_SHIPMENTS

9016: IF l_shipment_tbl(i).quantity is not NULL AND
9017: l_shipment_tbl(i).quantity <> FND_API.G_MISS_NUM THEN
9018:
9019: SELECT reservation_id INTO l_shipment_tbl(i).reservation_id
9020: FROM ASO_SHIPMENTS
9021: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
9022:
9023: ASO_RESERVATION_INT.Update_reservation(
9024: P_Api_Version_Number => 1.0,

Line 9032: UPDATE ASO_SHIPMENTS

9028: X_Msg_Count => x_msg_count,
9029: X_Msg_Data => x_msg_data
9030: );
9031:
9032: UPDATE ASO_SHIPMENTS
9033: SET reservation_id = l_shipment_tbl(i).reservation_id,
9034: reserved_quantity = l_shipment_tbl(i).reserved_quantity,
9035: last_update_date = sysdate,
9036: last_updated_by = fnd_global.user_id,

Line 9234: FROM aso_shipments

9230: WHERE quote_number = X_qte_number;
9231:
9232: CURSOR C_Shipment IS
9233: SELECT shipment_id, reservation_id
9234: FROM aso_shipments
9235: WHERE quote_line_id = p_qte_line_rec.quote_line_id;
9236:
9237: CURSOR C_Inst_Details(shipment_id NUMBER) IS
9238: SELECT line_inst_detail_id