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.PMI_SALES_PKG dependencies on OP_ORDR_DTL

Line 5: This function returns Top customers/Item from op_ordr_dtl

1: PACKAGE pmi_sales_pkg AUTHID CURRENT_USER as
2: /* $Header: PMISAANS.pls 115.5 2003/02/19 04:46:55 srpuri ship $ */
3: /* #############################################################################
4: Function PMISA_GET_TOP_N
5: This function returns Top customers/Item from op_ordr_dtl
6: with group by on Organization and Item/Customer for a fiven period
7: with respect to margin made. The list is calculated and populated in a
8: PL/SQL package table which is referred if the passed parameters are same
9:

Line 157: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,

153: 6. If No Charge is found the function returns 0
154:
155: ################################################################################# */
156:
157: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
158: p_line_id IN op_ordr_dtl.line_id%TYPE,
159: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
160: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
161: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,

Line 158: p_line_id IN op_ordr_dtl.line_id%TYPE,

154:
155: ################################################################################# */
156:
157: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
158: p_line_id IN op_ordr_dtl.line_id%TYPE,
159: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
160: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
161: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
162: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,

Line 159: p_extended_price IN op_ordr_dtl.extended_price%TYPE,

155: ################################################################################# */
156:
157: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
158: p_line_id IN op_ordr_dtl.line_id%TYPE,
159: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
160: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
161: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
162: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
163: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE

Line 160: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,

156:
157: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
158: p_line_id IN op_ordr_dtl.line_id%TYPE,
159: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
160: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
161: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
162: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
163: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
164: )

Line 161: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,

157: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
158: p_line_id IN op_ordr_dtl.line_id%TYPE,
159: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
160: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
161: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
162: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
163: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
164: )
165: RETURN NUMBER;

Line 162: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,

158: p_line_id IN op_ordr_dtl.line_id%TYPE,
159: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
160: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
161: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
162: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
163: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
164: )
165: RETURN NUMBER;
166: /*

Line 163: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE

159: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
160: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
161: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
162: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
163: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
164: )
165: RETURN NUMBER;
166: /*
167: PMIOM_GET_CHARGE is the Order Management equivalent of PMISA_GET_CHARGE. Instead of identifying charge_type on a charge line basis, there are pricing lists that have list_type_codes at the header (QP_LIST_HEADERS_B) and line (QP_LIST_LINES_ALL) levels.