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_HEADERS_PVT dependencies on ASO_SHIPMENTS

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

1055: x_shipment_rec.ship_method_code_from := p_shipment_tbl(1).ship_method_code;
1056: x_shipment_rec.freight_terms_code_from := p_shipment_tbl(1).freight_terms_code;
1057:
1058: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1059: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');
1060: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');
1061: END IF;
1062:
1063: l_sysdate := sysdate;

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

1056: x_shipment_rec.freight_terms_code_from := p_shipment_tbl(1).freight_terms_code;
1057:
1058: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1059: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');
1060: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');
1061: END IF;
1062:
1063: l_sysdate := sysdate;
1064: -- BC4J Fix

Line 1067: ASO_SHIPMENTS_PKG.Insert_Row(

1063: l_sysdate := sysdate;
1064: -- BC4J Fix
1065: lx_shipment_id := p_shipment_tbl(1).shipment_id;
1066:
1067: ASO_SHIPMENTS_PKG.Insert_Row(
1068: px_SHIPMENT_ID => lx_shipment_id,
1069: p_CREATION_DATE => SYSDATE,
1070: p_CREATED_BY => G_USER_ID,
1071: p_LAST_UPDATE_DATE => l_sysdate,

Line 1673: FROM ASO_SHIPMENTS

1669: -- The following cursors is needed for ship_method_code and Freight Terms Code From column Maintenance.
1670: CURSOR c_db_ship_freight_terms(p_shipment_id NUMBER) IS
1671: SELECT ship_method_code_from,ship_method_code,
1672: Freight_terms_code_from,Freight_terms_code
1673: FROM ASO_SHIPMENTS
1674: WHERE shipment_id = p_shipment_id;
1675:
1676: cursor c_quote_number is
1677: select quote_number from aso_quote_headers_all

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

2369: l_shipment_rec.ship_method_code_from := p_shipment_tbl(1).ship_method_code;
2370: l_shipment_rec.freight_terms_code_from := p_shipment_tbl(1).freight_terms_code;
2371:
2372: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2373: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');
2374: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');
2375: END IF;
2376:
2377: l_sysdate := sysdate;

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

2370: l_shipment_rec.freight_terms_code_from := p_shipment_tbl(1).freight_terms_code;
2371:
2372: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2373: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');
2374: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows - p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');
2375: END IF;
2376:
2377: l_sysdate := sysdate;
2378: -- BC4J Fix

Line 2385: ASO_SHIPMENTS_PKG.Insert_Row(

2381: x_shipment_tbl(i).last_update_date := l_sysdate;
2382: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;
2383: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
2384:
2385: ASO_SHIPMENTS_PKG.Insert_Row(
2386: px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_ID,
2387: p_CREATION_DATE => SYSDATE,
2388: p_CREATED_BY => G_USER_ID,
2389: p_LAST_UPDATE_DATE => l_sysdate,

Line 2493: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.ship_method_code'||l_shipment_rec.ship_method_code, 1, 'Y');

2489:
2490: END IF;
2491:
2492: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2493: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.ship_method_code'||l_shipment_rec.ship_method_code, 1, 'Y');
2494: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.freight_terms_code'||l_shipment_rec.freight_terms_code, 1, 'Y');
2495: END IF;
2496:
2497: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;

Line 2494: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.freight_terms_code'||l_shipment_rec.freight_terms_code, 1, 'Y');

2490: END IF;
2491:
2492: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2493: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.ship_method_code'||l_shipment_rec.ship_method_code, 1, 'Y');
2494: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.freight_terms_code'||l_shipment_rec.freight_terms_code, 1, 'Y');
2495: END IF;
2496:
2497: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;
2498: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;

Line 2500: ASO_SHIPMENTS_PKG.Update_Row(

2496:
2497: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;
2498: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
2499:
2500: ASO_SHIPMENTS_PKG.Update_Row(
2501: p_SHIPMENT_ID => l_shipment_rec.SHIPMENT_ID,
2502: p_CREATION_DATE => l_shipment_rec.creation_date,
2503: p_CREATED_BY => G_USER_ID,
2504: p_LAST_UPDATE_DATE => l_sysdate,

Line 2563: ASO_SHIPMENTS_PKG.Delete_Row(

2559: p_REQUEST_DATE_TYPE => l_shipment_rec.REQUEST_DATE_TYPE,
2560: p_demand_class_code => l_shipment_rec.demand_class_code
2561: );
2562: ELSIF P_Shipment_Tbl(i).operation_code = 'DELETE' THEN
2563: ASO_SHIPMENTS_PKG.Delete_Row(
2564: p_SHIPMENT_ID => P_Shipment_Tbl(i).SHIPMENT_ID);
2565: END IF;
2566: END LOOP;
2567:

Line 6776: SELECT shipment_id FROM ASO_SHIPMENTS

6772: WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
6773: AND quote_line_id IS NULL;
6774:
6775: CURSOR c_shipment_rec IS
6776: SELECT shipment_id FROM ASO_SHIPMENTS
6777: WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
6778: AND quote_line_id IS NULL;
6779:
6780: CURSOR c_tax_rec IS

Line 11763: (select shipment_id from ASO_SHIPMENTS

11759: WHERE QUOTE_HEADER_ID = p_qte_header_id;
11760:
11761: DELETE FROM ASO_FREIGHT_CHARGES
11762: WHERE quote_shipment_id in
11763: (select shipment_id from ASO_SHIPMENTS
11764: where QUOTE_HEADER_ID = p_qte_header_id);
11765:
11766: DELETE FROM ASO_SHIPMENTS
11767: WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line 11766: DELETE FROM ASO_SHIPMENTS

11762: WHERE quote_shipment_id in
11763: (select shipment_id from ASO_SHIPMENTS
11764: where QUOTE_HEADER_ID = p_qte_header_id);
11765:
11766: DELETE FROM ASO_SHIPMENTS
11767: WHERE QUOTE_HEADER_ID = p_qte_header_id;
11768:
11769: DELETE FROM ASO_TAX_DETAILS
11770: WHERE QUOTE_HEADER_ID = p_qte_header_id;