APPS.CN_MULTI_RATE_SCHEDULES_PUB dependencies on CN_CALC_SQL_EXPS

Line 66: FUNCTION get_exp_id(p_name in CN_CALC_SQL_EXPS.NAME%TYPE)

62: RAISE fnd_api.g_exc_error;
63: END get_rate_sch_dim_id;
64:
65: -- to get an expression ID from its name
66: FUNCTION get_exp_id(p_name in CN_CALC_SQL_EXPS.NAME%TYPE)
67: RETURN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE IS
68:
69: l_calc_sql_exp_id CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE;
70: BEGIN

Line 67: RETURN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE IS

63: END get_rate_sch_dim_id;
64:
65: -- to get an expression ID from its name
66: FUNCTION get_exp_id(p_name in CN_CALC_SQL_EXPS.NAME%TYPE)
67: RETURN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE IS
68:
69: l_calc_sql_exp_id CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE;
70: BEGIN
71: select CALC_SQL_EXP_ID into l_calc_sql_exp_id

Line 69: l_calc_sql_exp_id CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE;

65: -- to get an expression ID from its name
66: FUNCTION get_exp_id(p_name in CN_CALC_SQL_EXPS.NAME%TYPE)
67: RETURN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE IS
68:
69: l_calc_sql_exp_id CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE;
70: BEGIN
71: select CALC_SQL_EXP_ID into l_calc_sql_exp_id
72: from CN_CALC_SQL_EXPS
73: where name = p_name;

Line 72: from CN_CALC_SQL_EXPS

68:
69: l_calc_sql_exp_id CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE;
70: BEGIN
71: select CALC_SQL_EXP_ID into l_calc_sql_exp_id
72: from CN_CALC_SQL_EXPS
73: where name = p_name;
74:
75: RETURN l_calc_sql_exp_id;
76: EXCEPTION