DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_SHIPMENTS_PKG

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

1051: x_shipment_rec.ship_method_code_from := p_shipment_tbl(1).ship_method_code;
1052: x_shipment_rec.freight_terms_code_from := p_shipment_tbl(1).freight_terms_code;
1053:
1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1055: 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');
1056: 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');
1057: END IF;
1058:
1059: l_sysdate := sysdate;

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

1052: x_shipment_rec.freight_terms_code_from := p_shipment_tbl(1).freight_terms_code;
1053:
1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1055: 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');
1056: 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');
1057: END IF;
1058:
1059: l_sysdate := sysdate;
1060: -- BC4J Fix

Line 1063: ASO_SHIPMENTS_PKG.Insert_Row(

1059: l_sysdate := sysdate;
1060: -- BC4J Fix
1061: lx_shipment_id := p_shipment_tbl(1).shipment_id;
1062:
1063: ASO_SHIPMENTS_PKG.Insert_Row(
1064: px_SHIPMENT_ID => lx_shipment_id,
1065: p_CREATION_DATE => SYSDATE,
1066: p_CREATED_BY => G_USER_ID,
1067: p_LAST_UPDATE_DATE => l_sysdate,

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

2310: l_shipment_rec.ship_method_code_from := p_shipment_tbl(1).ship_method_code;
2311: l_shipment_rec.freight_terms_code_from := p_shipment_tbl(1).freight_terms_code;
2312:
2313: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2314: 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');
2315: 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');
2316: END IF;
2317:
2318: l_sysdate := sysdate;

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

2311: l_shipment_rec.freight_terms_code_from := p_shipment_tbl(1).freight_terms_code;
2312:
2313: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2314: 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');
2315: 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');
2316: END IF;
2317:
2318: l_sysdate := sysdate;
2319: -- BC4J Fix

Line 2326: ASO_SHIPMENTS_PKG.Insert_Row(

2322: x_shipment_tbl(i).last_update_date := l_sysdate;
2323: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;
2324: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
2325:
2326: ASO_SHIPMENTS_PKG.Insert_Row(
2327: px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_ID,
2328: p_CREATION_DATE => SYSDATE,
2329: p_CREATED_BY => G_USER_ID,
2330: p_LAST_UPDATE_DATE => l_sysdate,

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

2430:
2431: END IF;
2432:
2433: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2434: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.ship_method_code'||l_shipment_rec.ship_method_code, 1, 'Y');
2435: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.freight_terms_code'||l_shipment_rec.freight_terms_code, 1, 'Y');
2436: END IF;
2437:
2438: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;

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

2431: END IF;
2432:
2433: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2434: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.ship_method_code'||l_shipment_rec.ship_method_code, 1, 'Y');
2435: aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.update_rows - l_shipment_rec.freight_terms_code'||l_shipment_rec.freight_terms_code, 1, 'Y');
2436: END IF;
2437:
2438: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;
2439: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;

Line 2441: ASO_SHIPMENTS_PKG.Update_Row(

2437:
2438: x_shipment_tbl(i).ship_method_code_from := l_shipment_rec.ship_method_code_from;
2439: x_shipment_tbl(i).freight_terms_code_from := l_shipment_rec.freight_terms_code_from;
2440:
2441: ASO_SHIPMENTS_PKG.Update_Row(
2442: p_SHIPMENT_ID => l_shipment_rec.SHIPMENT_ID,
2443: p_CREATION_DATE => l_shipment_rec.creation_date,
2444: p_CREATED_BY => G_USER_ID,
2445: p_LAST_UPDATE_DATE => l_sysdate,

Line 2504: ASO_SHIPMENTS_PKG.Delete_Row(

2500: p_REQUEST_DATE_TYPE => l_shipment_rec.REQUEST_DATE_TYPE,
2501: p_demand_class_code => l_shipment_rec.demand_class_code
2502: );
2503: ELSIF P_Shipment_Tbl(i).operation_code = 'DELETE' THEN
2504: ASO_SHIPMENTS_PKG.Delete_Row(
2505: p_SHIPMENT_ID => P_Shipment_Tbl(i).SHIPMENT_ID);
2506: END IF;
2507: END LOOP;
2508: