APPS.OPI_OPM_COMMON_PKG dependencies on OP_ORDR_DTL

Line 74: l_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE;

70: FROM gl_srce_mst
71: WHERE TRANS_SOURCE_TYPE=5;
72: /*local Variables */
73: l_rate_type_code gl_srce_mst.rate_type_code%TYPE;
74: l_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE;
75: l_error_code number:=0;
76: l_exchange_rate number;
77: l_converted_amount number;
78: BEGIN

Line 134: l_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE;

130: FROM gl_srce_mst
131: WHERE TRANS_SOURCE_TYPE=5;
132: /*local Variables */
133: l_rate_type_code gl_srce_mst.rate_type_code%TYPE;
134: l_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE;
135: l_error_code number:=0;
136: l_exchange_rate NUMBER;
137: BEGIN
138: IF(PV_OPMCO_CE_F_CURR =p_from_curr AND PV_OPMCO_CE_T_CURR =p_to_curr AND

Line 164: FUNCTION OPI_OPM_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,

160: END IF;
161: END OPMCO_CURRCONV_ERROR;
162:
163:
164: FUNCTION OPI_OPM_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
165: p_charge_amount IN NUMBER,
166: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
167: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
168: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,

Line 166: p_extended_price IN op_ordr_dtl.extended_price%TYPE,

162:
163:
164: FUNCTION OPI_OPM_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
165: p_charge_amount IN NUMBER,
166: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
167: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
168: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
169: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
170: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE

Line 167: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,

163:
164: FUNCTION OPI_OPM_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
165: p_charge_amount IN NUMBER,
166: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
167: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
168: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
169: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
170: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
171: )

Line 168: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,

164: FUNCTION OPI_OPM_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
165: p_charge_amount IN NUMBER,
166: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
167: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
168: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
169: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
170: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
171: )
172: RETURN NUMBER IS

Line 169: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,

165: p_charge_amount IN NUMBER,
166: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
167: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
168: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
169: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
170: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
171: )
172: RETURN NUMBER IS
173:

Line 170: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE

166: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
167: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
168: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
169: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
170: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
171: )
172: RETURN NUMBER IS
173:
174: /*Cursor to find total value for order*/

Line 176: CURSOR cur_order_value(P_order_id op_ordr_dtl.order_id%TYPE)

172: RETURN NUMBER IS
173:
174: /*Cursor to find total value for order*/
175:
176: CURSOR cur_order_value(P_order_id op_ordr_dtl.order_id%TYPE)
177: IS
178: SELECT SUM(DECODE(Base_Currency,Billing_Currency,
179: Extended_price,
180: Decode(mul_div_sign,0,Extended_price*Exchange_Rate,

Line 182: FROM op_ordr_dtl

178: SELECT SUM(DECODE(Base_Currency,Billing_Currency,
179: Extended_price,
180: Decode(mul_div_sign,0,Extended_price*Exchange_Rate,
181: Extended_price/Exchange_Rate)))
182: FROM op_ordr_dtl
183: WHERE order_id = P_order_id
184: AND line_status >= 20;
185:
186: l_line_charge NUMBER;