DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_SHIPMENTS_PKG

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