APPS.HRI_OLTP_PMV_WMV_SUP_GRAPH dependencies on BIS_PMV_PARAMETERS_PUB

Line 29: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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

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

79: x_custom_sql := l_sqltext;
80:
81: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
82: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
83: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
84: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
85: x_custom_output.extend;
86: x_custom_output(1) := l_custom_rec;
87:

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

80:
81: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
82: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
83: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
84: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
85: x_custom_output.extend;
86: x_custom_output(1) := l_custom_rec;
87:
88: l_custom_rec.attribute_name := ':TIME_PROJECT_PERIOD_TYPE';

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

86: x_custom_output(1) := l_custom_rec;
87:
88: l_custom_rec.attribute_name := ':TIME_PROJECT_PERIOD_TYPE';
89: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
90: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
91: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
92: x_custom_output.extend;
93: x_custom_output(2) := l_custom_rec;
94:

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

87:
88: l_custom_rec.attribute_name := ':TIME_PROJECT_PERIOD_TYPE';
89: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
90: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
91: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
92: x_custom_output.extend;
93: x_custom_output(2) := l_custom_rec;
94:
95: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

93: x_custom_output(2) := l_custom_rec;
94:
95: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
96: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
97: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
98: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
99: x_custom_output.extend;
100: x_custom_output(3) := l_custom_rec;
101:

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

94:
95: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
96: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
97: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
98: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
99: x_custom_output.extend;
100: x_custom_output(3) := l_custom_rec;
101:
102: l_custom_rec.attribute_name := ':TIME_PROJECT_COMPARISON_TYPE';

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

100: x_custom_output(3) := l_custom_rec;
101:
102: l_custom_rec.attribute_name := ':TIME_PROJECT_COMPARISON_TYPE';
103: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
104: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
105: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
106: x_custom_output.extend;
107: x_custom_output(4) := l_custom_rec;
108:

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

101:
102: l_custom_rec.attribute_name := ':TIME_PROJECT_COMPARISON_TYPE';
103: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
104: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
105: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
106: x_custom_output.extend;
107: x_custom_output(4) := l_custom_rec;
108:
109: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

107: x_custom_output(4) := l_custom_rec;
108:
109: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
110: l_custom_rec.attribute_value := l_previous_periods;
111: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
112: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
113: x_custom_output.extend;
114: x_custom_output(5) := l_custom_rec;
115:

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

108:
109: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
110: l_custom_rec.attribute_value := l_previous_periods;
111: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
112: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
113: x_custom_output.extend;
114: x_custom_output(5) := l_custom_rec;
115:
116: l_custom_rec.attribute_name := ':TIME_PROJECT_PERIOD_NUMBER';

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

114: x_custom_output(5) := l_custom_rec;
115:
116: l_custom_rec.attribute_name := ':TIME_PROJECT_PERIOD_NUMBER';
117: l_custom_rec.attribute_value := l_projection_periods;
118: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
119: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
120: x_custom_output.extend;
121: x_custom_output(6) := l_custom_rec;
122:

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

115:
116: l_custom_rec.attribute_name := ':TIME_PROJECT_PERIOD_NUMBER';
117: l_custom_rec.attribute_value := l_projection_periods;
118: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
119: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
120: x_custom_output.extend;
121: x_custom_output(6) := l_custom_rec;
122:
123: END;