APPS.HRI_OLTP_PMV_UTIL_PARAM dependencies on HRI_MTDT_PARAM

Line 44: hri_mtdt_param.g_param_mtdt_tab

40: BEGIN
41:
42: /* Add the time dates to the binds table */
43: p_bind_tab('TIME_CURR_START_DATE').pmv_bind_string :=
44: hri_mtdt_param.g_param_mtdt_tab
45: ('TIME_CURR_START_DATE').pmv_bind_string;
46: p_bind_tab('TIME_CURR_START_DATE').sql_bind_string :=
47: 'to_date(''' || to_char(p_parameter_rec.time_curr_start_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
48:

Line 50: hri_mtdt_param.g_param_mtdt_tab

46: p_bind_tab('TIME_CURR_START_DATE').sql_bind_string :=
47: 'to_date(''' || to_char(p_parameter_rec.time_curr_start_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
48:
49: p_bind_tab('TIME_CURR_END_DATE').pmv_bind_string :=
50: hri_mtdt_param.g_param_mtdt_tab
51: ('TIME_CURR_END_DATE').pmv_bind_string;
52: p_bind_tab('TIME_CURR_END_DATE').sql_bind_string :=
53: 'to_date(''' || to_char(p_parameter_rec.time_curr_end_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
54:

Line 56: hri_mtdt_param.g_param_mtdt_tab

52: p_bind_tab('TIME_CURR_END_DATE').sql_bind_string :=
53: 'to_date(''' || to_char(p_parameter_rec.time_curr_end_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
54:
55: p_bind_tab('TIME_CURR_ASOF_DATE').pmv_bind_string :=
56: hri_mtdt_param.g_param_mtdt_tab
57: ('TIME_CURR_ASOF_DATE').pmv_bind_string;
58: p_bind_tab('TIME_CURR_ASOF_DATE').sql_bind_string :=
59: 'to_date(''' || to_char(p_parameter_rec.time_curr_end_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
60:

Line 62: hri_mtdt_param.g_param_mtdt_tab

58: p_bind_tab('TIME_CURR_ASOF_DATE').sql_bind_string :=
59: 'to_date(''' || to_char(p_parameter_rec.time_curr_end_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
60:
61: p_bind_tab('TIME_COMP_START_DATE').pmv_bind_string :=
62: hri_mtdt_param.g_param_mtdt_tab
63: ('TIME_COMP_START_DATE').pmv_bind_string;
64: p_bind_tab('TIME_COMP_START_DATE').sql_bind_string :=
65: 'to_date(''' || to_char(p_parameter_rec.time_comp_start_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
66:

Line 68: hri_mtdt_param.g_param_mtdt_tab

64: p_bind_tab('TIME_COMP_START_DATE').sql_bind_string :=
65: 'to_date(''' || to_char(p_parameter_rec.time_comp_start_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
66:
67: p_bind_tab('TIME_COMP_END_DATE').pmv_bind_string :=
68: hri_mtdt_param.g_param_mtdt_tab
69: ('TIME_COMP_END_DATE').pmv_bind_string;
70: p_bind_tab('TIME_COMP_END_DATE').sql_bind_string :=
71: 'to_date(''' || to_char(p_parameter_rec.time_comp_end_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
72:

Line 74: hri_mtdt_param.g_param_mtdt_tab

70: p_bind_tab('TIME_COMP_END_DATE').sql_bind_string :=
71: 'to_date(''' || to_char(p_parameter_rec.time_comp_end_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
72:
73: p_bind_tab('TIME_COMP_ASOF_DATE').pmv_bind_string :=
74: hri_mtdt_param.g_param_mtdt_tab
75: ('TIME_COMP_ASOF_DATE').pmv_bind_string;
76: p_bind_tab('TIME_COMP_ASOF_DATE').sql_bind_string :=
77: 'to_date(''' || to_char(p_parameter_rec.time_comp_end_date,'DD-MM-YYYY') || ''',''DD-MM-YYYY'')';
78:

Line 82: hri_mtdt_param.g_param_mtdt_tab('CURRENCY').pmv_bind_string;

78:
79: /* Add currency binds to bind table, if set */
80: IF (p_parameter_rec.currency_code IS NOT NULL) THEN
81: p_bind_tab('CURRENCY').pmv_bind_string :=
82: hri_mtdt_param.g_param_mtdt_tab('CURRENCY').pmv_bind_string;
83: p_bind_tab('CURRENCY').sql_bind_string := '''' || p_parameter_rec.currency_code || '''';
84: p_bind_tab('RATE_TYPE').pmv_bind_string :=
85: hri_mtdt_param.g_param_mtdt_tab('RATE_TYPE').pmv_bind_string;
86: p_bind_tab('RATE_TYPE').sql_bind_string := '''' || p_parameter_rec.rate_type || '''';

Line 85: hri_mtdt_param.g_param_mtdt_tab('RATE_TYPE').pmv_bind_string;

81: p_bind_tab('CURRENCY').pmv_bind_string :=
82: hri_mtdt_param.g_param_mtdt_tab('CURRENCY').pmv_bind_string;
83: p_bind_tab('CURRENCY').sql_bind_string := '''' || p_parameter_rec.currency_code || '''';
84: p_bind_tab('RATE_TYPE').pmv_bind_string :=
85: hri_mtdt_param.g_param_mtdt_tab('RATE_TYPE').pmv_bind_string;
86: p_bind_tab('RATE_TYPE').sql_bind_string := '''' || p_parameter_rec.rate_type || '''';
87: END IF;
88:
89: /* Defaulting required parameters for bug 4134385

Line 324: hri_mtdt_param.g_param_mtdt_tab

320:
321: /* Add the parameter details to the parameter table if the parameter is set */
322: IF l_add_to_bind_table THEN
323: p_bind_tab(p_page_parameter_tbl(i).parameter_name).pmv_bind_string :=
324: hri_mtdt_param.g_param_mtdt_tab
325: (p_page_parameter_tbl(i).parameter_name).pmv_bind_string;
326: p_bind_tab(p_page_parameter_tbl(i).parameter_name).sql_bind_string :=
327: p_page_parameter_tbl(i).parameter_id;
328: END IF;