88: l_object varchar2(50);
89: begin
90: IF p_context IS NOT NULL THEN
91: -- parse p_context and populate the relevant rows into the temp table
92: l_p_objects := jtfb_dcf.get_parameter_value(p_context,'JTFB_P_OBJECTS');
93: -- this is a multi select parameter which returs a value like 'CAMPAIGNS~~LEADS'
94:
95: FOR i IN 1..jtfb_dcf.get_multiselect_count(l_p_objects) LOOP
96: l_object := jtfb_dcf.get_multiselect_value(l_p_objects,i);
91: -- parse p_context and populate the relevant rows into the temp table
92: l_p_objects := jtfb_dcf.get_parameter_value(p_context,'JTFB_P_OBJECTS');
93: -- this is a multi select parameter which returs a value like 'CAMPAIGNS~~LEADS'
94:
95: FOR i IN 1..jtfb_dcf.get_multiselect_count(l_p_objects) LOOP
96: l_object := jtfb_dcf.get_multiselect_value(l_p_objects,i);
97:
98: IF l_object = 'CAMPAIGNS' THEN
99: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'CAMPAIGNS', 'Campaigns', '67', '4.0');
92: l_p_objects := jtfb_dcf.get_parameter_value(p_context,'JTFB_P_OBJECTS');
93: -- this is a multi select parameter which returs a value like 'CAMPAIGNS~~LEADS'
94:
95: FOR i IN 1..jtfb_dcf.get_multiselect_count(l_p_objects) LOOP
96: l_object := jtfb_dcf.get_multiselect_value(l_p_objects,i);
97:
98: IF l_object = 'CAMPAIGNS' THEN
99: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'CAMPAIGNS', 'Campaigns', '67', '4.0');
100: END IF;
204: l_object varchar2(256);
205:
206: begin
207:
208: l_object := jtfb_dcf.get_parameter_value(p_context,'JTFB_P_OBJECTS');
209:
210: if (l_object = 'CAMPAIGNS')
211: then
212: jtfb_temp_report_pkg.insert_row(