eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTFB_PICASSO_DEMO dependencies on JTFB_TEMP_BIN

Line 99: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'CAMPAIGNS', 'Campaigns', '67', '4.0');

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;
101:
102: IF l_object = 'LEADS' THEN
103: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'LEADS', 'Leads', '2,523', '-5.1');

Line 103: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'LEADS', 'Leads', '2,523', '-5.1');

99: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'CAMPAIGNS', 'Campaigns', '67', '4.0');
100: END IF;
101:
102: IF l_object = 'LEADS' THEN
103: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'LEADS', 'Leads', '2,523', '-5.1');
104: END IF;
105:
106: IF l_object = 'OPPORTUNITIES' THEN
107: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'OPPORTUNITIES', 'Opportunities', '1522', '4.1');

Line 107: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'OPPORTUNITIES', 'Opportunities', '1522', '4.1');

103: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'LEADS', 'Leads', '2,523', '-5.1');
104: END IF;
105:
106: IF l_object = 'OPPORTUNITIES' THEN
107: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'OPPORTUNITIES', 'Opportunities', '1522', '4.1');
108: END IF;
109:
110: IF l_object = 'QUOTES' THEN
111: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'QUOTES', 'Quotes', '954', '3.19');

Line 111: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'QUOTES', 'Quotes', '954', '3.19');

107: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'OPPORTUNITIES', 'Opportunities', '1522', '4.1');
108: END IF;
109:
110: IF l_object = 'QUOTES' THEN
111: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'QUOTES', 'Quotes', '954', '3.19');
112: END IF;
113:
114: IF l_object = 'CUSTOMERS' THEN
115: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'CUSTOMERS', 'Customers', '3,154', '6.5');

Line 115: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'CUSTOMERS', 'Customers', '3,154', '6.5');

111: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'QUOTES', 'Quotes', '954', '3.19');
112: END IF;
113:
114: IF l_object = 'CUSTOMERS' THEN
115: INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'CUSTOMERS', 'Customers', '3,154', '6.5');
116: END IF;
117:
118: END LOOP;
119:

Line 121: jtfb_temp_bin_pkg.insert_row(

117:
118: END LOOP;
119:
120: ELSE
121: jtfb_temp_bin_pkg.insert_row(
122: x_rowid => l_rowid
123: , x_bin_code => l_bin_code
124: , x_col1 => 'CAMPAIGNS'
125: , x_col2 => 'Campaigns'

Line 130: jtfb_temp_bin_pkg.insert_row(

126: , x_col4 => '67'
127: , x_col6 => '4.0'
128: );
129:
130: jtfb_temp_bin_pkg.insert_row(
131: x_rowid => l_rowid
132: , x_bin_code => l_bin_code
133: , x_col1 => 'LEADS'
134: , x_col2 => 'Leads'

Line 139: jtfb_temp_bin_pkg.insert_row(

135: , x_col4 => '2523'
136: , x_col6 => '-5.1'
137: );
138:
139: jtfb_temp_bin_pkg.insert_row(
140: x_rowid => l_rowid
141: , x_bin_code => l_bin_code
142: , x_col1 => 'OPPORTUNITIES'
143: , x_col2 => 'Opportunities'

Line 148: jtfb_temp_bin_pkg.insert_row(

144: , x_col4 => '1522'
145: , x_col6 => '4.1'
146: );
147:
148: jtfb_temp_bin_pkg.insert_row(
149: x_rowid => l_rowid
150: , x_bin_code => l_bin_code
151: , x_col1 => 'QUOTES'
152: , x_col2 => 'Quotes'

Line 157: jtfb_temp_bin_pkg.insert_row(

153: , x_col4 => '954'
154: , x_col6 => '3.19'
155: );
156:
157: jtfb_temp_bin_pkg.insert_row(
158: x_rowid => l_rowid
159: , x_bin_code => l_bin_code
160: , x_col1 => 'CUSTOMERS'
161: , x_col2 => 'Customers'

Line 180: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)

176: l_method_name varchar2(80) := g_pkg_name || '.load_jtfb_demo_bin1: ';
177: l_bin_code varchar2(20) := 'JTFB_DEMO_BIN1';
178:
179: begin
180: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
181: values(l_bin_code, 'APR-01', 'APR-01', '6', '4.0');
182: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
183: values(l_bin_code, 'MAR-01', 'MAR-01', '4', '2.1');
184: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)

Line 182: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)

178:
179: begin
180: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
181: values(l_bin_code, 'APR-01', 'APR-01', '6', '4.0');
182: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
183: values(l_bin_code, 'MAR-01', 'MAR-01', '4', '2.1');
184: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
185: values(l_bin_code, 'FEB-01', 'FEB-01', '2', '5.0');
186: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)

Line 184: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)

180: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
181: values(l_bin_code, 'APR-01', 'APR-01', '6', '4.0');
182: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
183: values(l_bin_code, 'MAR-01', 'MAR-01', '4', '2.1');
184: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
185: values(l_bin_code, 'FEB-01', 'FEB-01', '2', '5.0');
186: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
187: values(l_bin_code, 'JAN-01', 'JAN-01', '12', '8.0');
188: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)

Line 186: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)

182: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
183: values(l_bin_code, 'MAR-01', 'MAR-01', '4', '2.1');
184: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
185: values(l_bin_code, 'FEB-01', 'FEB-01', '2', '5.0');
186: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
187: values(l_bin_code, 'JAN-01', 'JAN-01', '12', '8.0');
188: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
189: values(l_bin_code, 'DEC-00', 'DEC-00', '0', '0.0');
190:

Line 188: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)

184: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
185: values(l_bin_code, 'FEB-01', 'FEB-01', '2', '5.0');
186: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
187: values(l_bin_code, 'JAN-01', 'JAN-01', '12', '8.0');
188: insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
189: values(l_bin_code, 'DEC-00', 'DEC-00', '0', '0.0');
190:
191: exception
192: when others then