DBA Data[Home] [Help]

APPS.ASO_SHIPPING_INT dependencies on ASO_SHIPPING_INT

Line 1: PACKAGE BODY ASO_SHIPPING_INT as

1: PACKAGE BODY ASO_SHIPPING_INT as
2: /* $Header: asoishpb.pls 120.3 2006/02/07 11:53:58 skulkarn ship $ */
3: -- Start of Comments
4: -- Package name : ASO_SHIPPING_INT
5: -- Purpose :

Line 4: -- Package name : ASO_SHIPPING_INT

1: PACKAGE BODY ASO_SHIPPING_INT as
2: /* $Header: asoishpb.pls 120.3 2006/02/07 11:53:58 skulkarn ship $ */
3: -- Start of Comments
4: -- Package name : ASO_SHIPPING_INT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_SHIPPING_INT';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_SHIPPING_INT';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoishpb.pls';
12:
13: --wli_start
14: FUNCTION Get_Total_Freight_Charges(p_qte_header_id NUMBER)

Line 99: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_quantity:'||l_quantity,1,'Y');

95: fetch c_line_charge
96: into l_operand, l_arithmetic_operator, l_quantity, l_line_list_price, l_adjusted_amount;
97: exit when c_line_charge%notfound;
98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
99: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_quantity:'||l_quantity,1,'Y');
100: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_line_list_price:'||l_line_list_price,1,'Y');
101: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_adjusted_amount:'||l_adjusted_amount,1,'Y');
102: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_arithmetic_operator:'||l_arithmetic_operator,1,'Y');
103: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_operand:'||l_operand,1,'Y');

Line 100: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_line_list_price:'||l_line_list_price,1,'Y');

96: into l_operand, l_arithmetic_operator, l_quantity, l_line_list_price, l_adjusted_amount;
97: exit when c_line_charge%notfound;
98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
99: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_quantity:'||l_quantity,1,'Y');
100: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_line_list_price:'||l_line_list_price,1,'Y');
101: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_adjusted_amount:'||l_adjusted_amount,1,'Y');
102: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_arithmetic_operator:'||l_arithmetic_operator,1,'Y');
103: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_operand:'||l_operand,1,'Y');
104: END IF;

Line 101: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_adjusted_amount:'||l_adjusted_amount,1,'Y');

97: exit when c_line_charge%notfound;
98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
99: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_quantity:'||l_quantity,1,'Y');
100: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_line_list_price:'||l_line_list_price,1,'Y');
101: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_adjusted_amount:'||l_adjusted_amount,1,'Y');
102: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_arithmetic_operator:'||l_arithmetic_operator,1,'Y');
103: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_operand:'||l_operand,1,'Y');
104: END IF;
105:

Line 102: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_arithmetic_operator:'||l_arithmetic_operator,1,'Y');

98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
99: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_quantity:'||l_quantity,1,'Y');
100: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_line_list_price:'||l_line_list_price,1,'Y');
101: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_adjusted_amount:'||l_adjusted_amount,1,'Y');
102: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_arithmetic_operator:'||l_arithmetic_operator,1,'Y');
103: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_operand:'||l_operand,1,'Y');
104: END IF;
105:
106: if (l_arithmetic_operator = '%') then

Line 103: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_operand:'||l_operand,1,'Y');

99: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_quantity:'||l_quantity,1,'Y');
100: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_line_list_price:'||l_line_list_price,1,'Y');
101: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_adjusted_amount:'||l_adjusted_amount,1,'Y');
102: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_arithmetic_operator:'||l_arithmetic_operator,1,'Y');
103: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_operand:'||l_operand,1,'Y');
104: END IF;
105:
106: if (l_arithmetic_operator = '%') then
107: l_charge_amount := l_charge_amount + (l_adjusted_amount*l_quantity) ;

Line 120: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_charge_amount:'||NVL(l_charge_amount,0),1,'Y');

116: end if;
117:
118: end loop;
119: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
120: aso_debug_pub.add('ASO_SHIPPING_INT:c_line_charge - l_charge_amount:'||NVL(l_charge_amount,0),1,'Y');
121: END IF;
122: return nvl(l_charge_amount,0);
123: end get_line_freight_charges;
124: --wli_end

Line 230: End ASO_SHIPPING_INT;

226: RETURN nvl(l_total_freight_charge,0);
227: END Get_Header_Freight_Charges;
228:
229:
230: End ASO_SHIPPING_INT;