DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_C_EXTN_GRAPH dependencies on BIS_PMV_PARAMETERS_PUB

Line 32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

28:
29: BEGIN
30:
31: /* Initialize table/record variables */
32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34:
35: /* Get security clause for Manager based security */
36: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

Line 103: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

99: x_custom_sql := l_sqltext;
100:
101: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
102: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
103: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
104: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
105: x_custom_output.extend;
106: x_custom_output(1) := l_custom_rec;
107:

Line 104: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

100:
101: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
102: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
103: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
104: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
105: x_custom_output.extend;
106: x_custom_output(1) := l_custom_rec;
107:
108: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

Line 110: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

106: x_custom_output(1) := l_custom_rec;
107:
108: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
109: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
110: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
111: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
112: x_custom_output.extend;
113: x_custom_output(2) := l_custom_rec;
114:

Line 111: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

107:
108: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
109: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
110: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
111: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
112: x_custom_output.extend;
113: x_custom_output(2) := l_custom_rec;
114:
115: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

Line 117: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

113: x_custom_output(2) := l_custom_rec;
114:
115: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
116: l_custom_rec.attribute_value := l_previous_periods;
117: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
118: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
119: x_custom_output.extend;
120: x_custom_output(3) := l_custom_rec;
121:

Line 118: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

114:
115: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
116: l_custom_rec.attribute_value := l_previous_periods;
117: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
118: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
119: x_custom_output.extend;
120: x_custom_output(3) := l_custom_rec;
121:
122: l_custom_rec.attribute_name := ':MONTHS_MULTIPLIER';

Line 124: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

120: x_custom_output(3) := l_custom_rec;
121:
122: l_custom_rec.attribute_name := ':MONTHS_MULTIPLIER';
123: l_custom_rec.attribute_value := 30.42;
124: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
125: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
126: x_custom_output.extend;
127: x_custom_output(4) := l_custom_rec;
128:

Line 125: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

121:
122: l_custom_rec.attribute_name := ':MONTHS_MULTIPLIER';
123: l_custom_rec.attribute_value := 30.42;
124: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
125: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
126: x_custom_output.extend;
127: x_custom_output(4) := l_custom_rec;
128:
129: