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.CN_PLANCOPY_UTIL_PVT dependencies on CN_CALC_SQL_EXPS

Line 59: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,

55: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,
59: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
60: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
61: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
62: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
63: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs

Line 60: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

56: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,
59: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
60: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
61: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
62: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
63: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
64: p_sql_select IN VARCHAR2 := NULL,

Line 61: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,

57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,
59: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
60: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
61: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
62: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
63: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
64: p_sql_select IN VARCHAR2 := NULL,
65: p_sql_from IN VARCHAR2 := NULL,

Line 62: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,

58: p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,
59: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
60: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
61: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
62: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
63: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
64: p_sql_select IN VARCHAR2 := NULL,
65: p_sql_from IN VARCHAR2 := NULL,
66: p_piped_expression_disp IN VARCHAR2 := NULL,

Line 69: p_ovn IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE,

65: p_sql_from IN VARCHAR2 := NULL,
66: p_piped_expression_disp IN VARCHAR2 := NULL,
67: p_piped_sql_select IN VARCHAR2 := NULL,
68: p_piped_sql_from IN VARCHAR2 := NULL,
69: p_ovn IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE,
70: p_exp_type_code IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
71: p_status IN CN_CALC_SQL_EXPS.STATUS%TYPE,
72: x_return_status OUT NOCOPY VARCHAR2 ,
73: x_msg_count OUT NOCOPY NUMBER ,

Line 70: p_exp_type_code IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

66: p_piped_expression_disp IN VARCHAR2 := NULL,
67: p_piped_sql_select IN VARCHAR2 := NULL,
68: p_piped_sql_from IN VARCHAR2 := NULL,
69: p_ovn IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE,
70: p_exp_type_code IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
71: p_status IN CN_CALC_SQL_EXPS.STATUS%TYPE,
72: x_return_status OUT NOCOPY VARCHAR2 ,
73: x_msg_count OUT NOCOPY NUMBER ,
74: x_msg_data OUT NOCOPY VARCHAR2 );

Line 71: p_status IN CN_CALC_SQL_EXPS.STATUS%TYPE,

67: p_piped_sql_select IN VARCHAR2 := NULL,
68: p_piped_sql_from IN VARCHAR2 := NULL,
69: p_ovn IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE,
70: p_exp_type_code IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
71: p_status IN CN_CALC_SQL_EXPS.STATUS%TYPE,
72: x_return_status OUT NOCOPY VARCHAR2 ,
73: x_msg_count OUT NOCOPY NUMBER ,
74: x_msg_data OUT NOCOPY VARCHAR2 );
75: