APPS.BIX_PMV_AO_OUTGR_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 34: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

30: l_session_where_clause VARCHAR2(3000);
31: l_call_center VARCHAR2(3000);
32: l_view_by VARCHAR2(3000);
33:
34: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
35:
36: BEGIN
37: --
38: --Initialize p_custom_output

Line 125: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

121: p_custom_sql := l_sqltext;
122:
123: l_custom_rec.attribute_name := ':l_row_type';
124: l_custom_rec.attribute_value:= 'C';
125: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
126: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
127:
128: p_custom_output.Extend();
129: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 126: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

122:
123: l_custom_rec.attribute_name := ':l_row_type';
124: l_custom_rec.attribute_value:= 'C';
125: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
126: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
127:
128: p_custom_output.Extend();
129: p_custom_output(p_custom_output.count) := l_custom_rec;
130:

Line 135: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

131: IF l_call_center IS NOT NULL
132: THEN
133: l_custom_rec.attribute_name := ':l_call_center';
134: l_custom_rec.attribute_value:= l_call_center;
135: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
136: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
137:
138: p_custom_output.Extend();
139: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 136: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

132: THEN
133: l_custom_rec.attribute_name := ':l_call_center';
134: l_custom_rec.attribute_value:= l_call_center;
135: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
136: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
137:
138: p_custom_output.Extend();
139: p_custom_output(p_custom_output.count) := l_custom_rec;
140: END IF;

Line 146: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

142: IF l_campaign_id IS NOT NULL
143: THEN
144: l_custom_rec.attribute_name := ':l_campaign_id';
145: l_custom_rec.attribute_value:= l_campaign_id;
146: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
147: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
148:
149: p_custom_output.Extend();
150: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 147: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

143: THEN
144: l_custom_rec.attribute_name := ':l_campaign_id';
145: l_custom_rec.attribute_value:= l_campaign_id;
146: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
147: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
148:
149: p_custom_output.Extend();
150: p_custom_output(p_custom_output.count) := l_custom_rec;
151: END IF;

Line 157: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

153: IF l_schedule_id IS NOT NULL
154: THEN
155: l_custom_rec.attribute_name := ':l_schedule_id';
156: l_custom_rec.attribute_value:= l_schedule_id;
157: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
158: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
159:
160: p_custom_output.Extend();
161: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 158: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

154: THEN
155: l_custom_rec.attribute_name := ':l_schedule_id';
156: l_custom_rec.attribute_value:= l_schedule_id;
157: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
158: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
159:
160: p_custom_output.Extend();
161: p_custom_output(p_custom_output.count) := l_custom_rec;
162: END IF;

Line 167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

163: IF l_source_code_id IS NOT NULL
164: THEN
165: l_custom_rec.attribute_name := ':l_source_code_id';
166: l_custom_rec.attribute_value:= l_source_code_id;
167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
169:
170: p_custom_output.Extend();
171: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

164: THEN
165: l_custom_rec.attribute_name := ':l_source_code_id';
166: l_custom_rec.attribute_value:= l_source_code_id;
167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
169:
170: p_custom_output.Extend();
171: p_custom_output(p_custom_output.count) := l_custom_rec;
172: END IF;

Line 177: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

173:
174:
175: l_custom_rec.attribute_name := ':l_lookup_type';
176: l_custom_rec.attribute_value:= 'BIX_PMV_AO_OUTCOMES';
177: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
178: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
179:
180: p_custom_output.Extend();
181: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 178: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

174:
175: l_custom_rec.attribute_name := ':l_lookup_type';
176: l_custom_rec.attribute_value:= 'BIX_PMV_AO_OUTCOMES';
177: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
178: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
179:
180: p_custom_output.Extend();
181: p_custom_output(p_custom_output.count) := l_custom_rec;
182: