APPS.PMI_COMMON_PKG dependencies on GL_SRCE_MST

Line 65: The data in gl_srce_mst is seeded by GMFSEED.sql at the time of customer installation

61: p_amount IN NUMBER)
62: RETURN NUMBER IS
63: /* Cursor to get Rate type Code for Sales orders
64: Trans Source type is Hardcoded with 5 as we need rate type for sales orders.
65: The data in gl_srce_mst is seeded by GMFSEED.sql at the time of customer installation
66: */
67: CURSOR cur_get_rate_type
68: IS
69: SELECT rate_type_code

Line 70: FROM gl_srce_mst

66: */
67: CURSOR cur_get_rate_type
68: IS
69: SELECT rate_type_code
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;

Line 73: l_rate_type_code gl_srce_mst.rate_type_code%TYPE;

69: SELECT rate_type_code
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;

Line 125: The data in gl_srce_mst is seeded by GMFSEED.sql at the time of customer installation

121: p_Rate_date IN DATE)
122: RETURN NUMBER IS
123: /* Cursor to get Rate type Code for Sales orders
124: Trans Source type is Hardcoded with 5 as we need rate type for sales orders.
125: The data in gl_srce_mst is seeded by GMFSEED.sql at the time of customer installation
126: */
127: CURSOR cur_get_rate_type
128: IS
129: SELECT rate_type_code

Line 130: FROM gl_srce_mst

126: */
127: CURSOR cur_get_rate_type
128: IS
129: SELECT rate_type_code
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;

Line 133: l_rate_type_code gl_srce_mst.rate_type_code%TYPE;

129: SELECT rate_type_code
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