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.INV_3PL_BILLING_UNITS_PVT dependencies on DBMS_SQL

Line 199: d_sql_p := DBMS_SQL.open_cursor;

195: RAISE ERROR_IN_PROGRAM;
196: END IF;
197:
198: BEGIN
199: d_sql_p := DBMS_SQL.open_cursor;
200: d_sql_stmt :=
201: 'SELECT count(*) cnt '
202: || 'FROM mtl_billing_rule_lines rule_lines, '
203: || 'mtl_billing_rule_headers_b rule_headers, '

Line 234: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);

230: END IF;
231: IF g_debug = 1 THEN
232: debug('Prepared the statment ');
233: END IF;
234: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
235: DBMS_SQL.define_column(d_sql_p, 1, d_space_seeded_src_used);
236: IF g_debug = 1 THEN
237: debug('Binding the variables ');
238: END IF;

Line 235: DBMS_SQL.define_column(d_sql_p, 1, d_space_seeded_src_used);

231: IF g_debug = 1 THEN
232: debug('Prepared the statment ');
233: END IF;
234: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
235: DBMS_SQL.define_column(d_sql_p, 1, d_space_seeded_src_used);
236: IF g_debug = 1 THEN
237: debug('Binding the variables ');
238: END IF;
239:

Line 240: DBMS_SQL.bind_variable(d_sql_p, 'OU_Id', p_OU_Id);

236: IF g_debug = 1 THEN
237: debug('Binding the variables ');
238: END IF;
239:
240: DBMS_SQL.bind_variable(d_sql_p, 'OU_Id', p_OU_Id);
241: IF (p_client_id is NOT NULL) THEN
242: DBMS_SQL.bind_variable(d_sql_p, 'client_id', p_client_id);
243: END IF;
244: IF (p_rule_id is NOT NULL) THEN

Line 242: DBMS_SQL.bind_variable(d_sql_p, 'client_id', p_client_id);

238: END IF;
239:
240: DBMS_SQL.bind_variable(d_sql_p, 'OU_Id', p_OU_Id);
241: IF (p_client_id is NOT NULL) THEN
242: DBMS_SQL.bind_variable(d_sql_p, 'client_id', p_client_id);
243: END IF;
244: IF (p_rule_id is NOT NULL) THEN
245: DBMS_SQL.bind_variable(d_sql_p, 'rule_id', p_rule_id);
246: END IF;

Line 245: DBMS_SQL.bind_variable(d_sql_p, 'rule_id', p_rule_id);

241: IF (p_client_id is NOT NULL) THEN
242: DBMS_SQL.bind_variable(d_sql_p, 'client_id', p_client_id);
243: END IF;
244: IF (p_rule_id is NOT NULL) THEN
245: DBMS_SQL.bind_variable(d_sql_p, 'rule_id', p_rule_id);
246: END IF;
247: IF (p_contract_id is NOT NULL) THEN
248: DBMS_SQL.bind_variable(d_sql_p, 'contract_id', p_contract_id);
249: END IF;

Line 248: DBMS_SQL.bind_variable(d_sql_p, 'contract_id', p_contract_id);

244: IF (p_rule_id is NOT NULL) THEN
245: DBMS_SQL.bind_variable(d_sql_p, 'rule_id', p_rule_id);
246: END IF;
247: IF (p_contract_id is NOT NULL) THEN
248: DBMS_SQL.bind_variable(d_sql_p, 'contract_id', p_contract_id);
249: END IF;
250: IF (p_item_id is NOT NULL) THEN
251: DBMS_SQL.bind_variable(d_sql_p, 'item_id', p_item_id);
252: END IF;

Line 251: DBMS_SQL.bind_variable(d_sql_p, 'item_id', p_item_id);

247: IF (p_contract_id is NOT NULL) THEN
248: DBMS_SQL.bind_variable(d_sql_p, 'contract_id', p_contract_id);
249: END IF;
250: IF (p_item_id is NOT NULL) THEN
251: DBMS_SQL.bind_variable(d_sql_p, 'item_id', p_item_id);
252: END IF;
253:
254: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
255:

Line 254: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);

250: IF (p_item_id is NOT NULL) THEN
251: DBMS_SQL.bind_variable(d_sql_p, 'item_id', p_item_id);
252: END IF;
253:
254: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
255:
256: LOOP
257: BEGIN
258: IF (DBMS_SQL.fetch_rows(d_sql_p) > 0) THEN

Line 258: IF (DBMS_SQL.fetch_rows(d_sql_p) > 0) THEN

254: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
255:
256: LOOP
257: BEGIN
258: IF (DBMS_SQL.fetch_rows(d_sql_p) > 0) THEN
259: DBMS_SQL.column_value(d_sql_p, 1, d_space_seeded_src_used);
260: IF g_debug = 1 THEN
261: debug('After fetch , d_space_seeded_src_used-> '||d_space_seeded_src_used);
262: END IF;

Line 259: DBMS_SQL.column_value(d_sql_p, 1, d_space_seeded_src_used);

255:
256: LOOP
257: BEGIN
258: IF (DBMS_SQL.fetch_rows(d_sql_p) > 0) THEN
259: DBMS_SQL.column_value(d_sql_p, 1, d_space_seeded_src_used);
260: IF g_debug = 1 THEN
261: debug('After fetch , d_space_seeded_src_used-> '||d_space_seeded_src_used);
262: END IF;
263: EXIT;

Line 269: DBMS_SQL.close_cursor(d_sql_p);

265: d_space_seeded_src_used := 0;
266: IF g_debug = 1 THEN
267: debug('Seeded Space source not used -> '||d_space_seeded_src_used);
268: END IF;
269: DBMS_SQL.close_cursor(d_sql_p);
270: EXIT;
271: END IF;
272: EXCEPTION
273: WHEN OTHERS THEN

Line 280: IF DBMS_SQL.is_open(d_sql_p) THEN

276: END IF;
277: EXIT;
278: END;
279: END LOOP;
280: IF DBMS_SQL.is_open(d_sql_p) THEN
281: DBMS_SQL.close_cursor(d_sql_p);
282: END IF;
283: EXCEPTION
284: WHEN OTHERS THEN

Line 281: DBMS_SQL.close_cursor(d_sql_p);

277: EXIT;
278: END;
279: END LOOP;
280: IF DBMS_SQL.is_open(d_sql_p) THEN
281: DBMS_SQL.close_cursor(d_sql_p);
282: END IF;
283: EXCEPTION
284: WHEN OTHERS THEN
285: d_space_seeded_src_used := 0;

Line 289: IF DBMS_SQL.is_open(d_sql_p) THEN

285: d_space_seeded_src_used := 0;
286: IF g_debug = 1 THEN
287: debug('Exception in dynamic sql for seeded space source -> '||sqlerrm);
288: END IF;
289: IF DBMS_SQL.is_open(d_sql_p) THEN
290: DBMS_SQL.close_cursor(d_sql_p);
291: END IF;
292: END;
293:

Line 290: DBMS_SQL.close_cursor(d_sql_p);

286: IF g_debug = 1 THEN
287: debug('Exception in dynamic sql for seeded space source -> '||sqlerrm);
288: END IF;
289: IF DBMS_SQL.is_open(d_sql_p) THEN
290: DBMS_SQL.close_cursor(d_sql_p);
291: END IF;
292: END;
293:
294: IF (d_space_seeded_src_used > 0) THEN

Line 506: d_sql_p := DBMS_SQL.open_cursor;

502: debug ('p_client_id -> '|| p_client_id);
503: debug ('p_item_id -> '|| p_item_id);
504: debug ('p_OU_id -> '|| p_OU_id);
505:
506: d_sql_p := DBMS_SQL.open_cursor;
507: d_sql_stmt :=
508: 'SELECT client_id, client_code, client_name, client_number, '
509: || 'contract_id, contract_number, counter_item_id, '
510: || 'last_computation_Date, net_Reading, last_reading, '

Line 544: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);

540: IF g_debug = 1 THEN
541: debug('Prepared statements for Contracts ');
542: END IF;
543:
544: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
545: DBMS_SQL.define_column(d_sql_p, 1, lc_client_id);
546: DBMS_SQL.define_column(d_sql_p, 2, lc_client_code, 10);
547: DBMS_SQL.define_column(d_sql_p, 3, lc_client_name, 360);
548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);

Line 545: DBMS_SQL.define_column(d_sql_p, 1, lc_client_id);

541: debug('Prepared statements for Contracts ');
542: END IF;
543:
544: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
545: DBMS_SQL.define_column(d_sql_p, 1, lc_client_id);
546: DBMS_SQL.define_column(d_sql_p, 2, lc_client_code, 10);
547: DBMS_SQL.define_column(d_sql_p, 3, lc_client_name, 360);
548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);
549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);

Line 546: DBMS_SQL.define_column(d_sql_p, 2, lc_client_code, 10);

542: END IF;
543:
544: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
545: DBMS_SQL.define_column(d_sql_p, 1, lc_client_id);
546: DBMS_SQL.define_column(d_sql_p, 2, lc_client_code, 10);
547: DBMS_SQL.define_column(d_sql_p, 3, lc_client_name, 360);
548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);
549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);
550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);

Line 547: DBMS_SQL.define_column(d_sql_p, 3, lc_client_name, 360);

543:
544: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
545: DBMS_SQL.define_column(d_sql_p, 1, lc_client_id);
546: DBMS_SQL.define_column(d_sql_p, 2, lc_client_code, 10);
547: DBMS_SQL.define_column(d_sql_p, 3, lc_client_name, 360);
548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);
549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);
550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);
551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);

Line 548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);

544: DBMS_SQL.parse(d_sql_p, d_sql_stmt, DBMS_SQL.native);
545: DBMS_SQL.define_column(d_sql_p, 1, lc_client_id);
546: DBMS_SQL.define_column(d_sql_p, 2, lc_client_code, 10);
547: DBMS_SQL.define_column(d_sql_p, 3, lc_client_name, 360);
548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);
549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);
550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);
551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);
552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);

Line 549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);

545: DBMS_SQL.define_column(d_sql_p, 1, lc_client_id);
546: DBMS_SQL.define_column(d_sql_p, 2, lc_client_code, 10);
547: DBMS_SQL.define_column(d_sql_p, 3, lc_client_name, 360);
548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);
549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);
550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);
551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);
552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);
553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);

Line 550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);

546: DBMS_SQL.define_column(d_sql_p, 2, lc_client_code, 10);
547: DBMS_SQL.define_column(d_sql_p, 3, lc_client_name, 360);
548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);
549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);
550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);
551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);
552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);
553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);
554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);

Line 551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);

547: DBMS_SQL.define_column(d_sql_p, 3, lc_client_name, 360);
548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);
549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);
550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);
551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);
552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);
553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);
554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);
555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);

Line 552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);

548: DBMS_SQL.define_column(d_sql_p, 4, lc_client_number, 30);
549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);
550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);
551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);
552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);
553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);
554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);
555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);
556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);

Line 553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);

549: DBMS_SQL.define_column(d_sql_p, 5, lc_contract_id);
550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);
551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);
552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);
553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);
554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);
555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);
556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);
557: DBMS_SQL.define_column(d_sql_p, 13, lc_billing_source_id);

Line 554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);

550: DBMS_SQL.define_column(d_sql_p, 6, lc_contract_number, 120);
551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);
552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);
553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);
554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);
555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);
556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);
557: DBMS_SQL.define_column(d_sql_p, 13, lc_billing_source_id);
558: DBMS_SQL.define_column(d_sql_p, 14, lc_billing_source_name, 80);

Line 555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);

551: DBMS_SQL.define_column(d_sql_p, 7, lc_counter_item_id);
552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);
553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);
554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);
555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);
556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);
557: DBMS_SQL.define_column(d_sql_p, 13, lc_billing_source_id);
558: DBMS_SQL.define_column(d_sql_p, 14, lc_billing_source_name, 80);
559: DBMS_SQL.define_column(d_sql_p, 15, lc_service_line_start_date);

Line 556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);

552: DBMS_SQL.define_column(d_sql_p, 8, lc_last_computation_Date);
553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);
554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);
555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);
556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);
557: DBMS_SQL.define_column(d_sql_p, 13, lc_billing_source_id);
558: DBMS_SQL.define_column(d_sql_p, 14, lc_billing_source_name, 80);
559: DBMS_SQL.define_column(d_sql_p, 15, lc_service_line_start_date);
560: DBMS_SQL.define_column(d_sql_p, 16, lc_service_line_end_date);

Line 557: DBMS_SQL.define_column(d_sql_p, 13, lc_billing_source_id);

553: DBMS_SQL.define_column(d_sql_p, 9, lc_net_Reading);
554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);
555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);
556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);
557: DBMS_SQL.define_column(d_sql_p, 13, lc_billing_source_id);
558: DBMS_SQL.define_column(d_sql_p, 14, lc_billing_source_name, 80);
559: DBMS_SQL.define_column(d_sql_p, 15, lc_service_line_start_date);
560: DBMS_SQL.define_column(d_sql_p, 16, lc_service_line_end_date);
561:

Line 558: DBMS_SQL.define_column(d_sql_p, 14, lc_billing_source_name, 80);

554: DBMS_SQL.define_column(d_sql_p, 10, lc_last_reading);
555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);
556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);
557: DBMS_SQL.define_column(d_sql_p, 13, lc_billing_source_id);
558: DBMS_SQL.define_column(d_sql_p, 14, lc_billing_source_name, 80);
559: DBMS_SQL.define_column(d_sql_p, 15, lc_service_line_start_date);
560: DBMS_SQL.define_column(d_sql_p, 16, lc_service_line_end_date);
561:
562: IF g_debug = 1 THEN

Line 559: DBMS_SQL.define_column(d_sql_p, 15, lc_service_line_start_date);

555: DBMS_SQL.define_column(d_sql_p, 11, lc_billing_uom, 3);
556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);
557: DBMS_SQL.define_column(d_sql_p, 13, lc_billing_source_id);
558: DBMS_SQL.define_column(d_sql_p, 14, lc_billing_source_name, 80);
559: DBMS_SQL.define_column(d_sql_p, 15, lc_service_line_start_date);
560: DBMS_SQL.define_column(d_sql_p, 16, lc_service_line_end_date);
561:
562: IF g_debug = 1 THEN
563: debug('Bind the variables');

Line 560: DBMS_SQL.define_column(d_sql_p, 16, lc_service_line_end_date);

556: DBMS_SQL.define_column(d_sql_p, 12, lc_service_item_org_id, 200);
557: DBMS_SQL.define_column(d_sql_p, 13, lc_billing_source_id);
558: DBMS_SQL.define_column(d_sql_p, 14, lc_billing_source_name, 80);
559: DBMS_SQL.define_column(d_sql_p, 15, lc_service_line_start_date);
560: DBMS_SQL.define_column(d_sql_p, 16, lc_service_line_end_date);
561:
562: IF g_debug = 1 THEN
563: debug('Bind the variables');
564: END IF;

Line 566: DBMS_SQL.bind_variable(d_sql_p, 'OU_Id', p_OU_Id);

562: IF g_debug = 1 THEN
563: debug('Bind the variables');
564: END IF;
565:
566: DBMS_SQL.bind_variable(d_sql_p, 'OU_Id', p_OU_Id);
567: IF (p_client_id is NOT NULL) THEN
568: DBMS_SQL.bind_variable(d_sql_p, 'client_id', p_client_id);
569: END IF;
570: IF (p_rule_id is NOT NULL) THEN

Line 568: DBMS_SQL.bind_variable(d_sql_p, 'client_id', p_client_id);

564: END IF;
565:
566: DBMS_SQL.bind_variable(d_sql_p, 'OU_Id', p_OU_Id);
567: IF (p_client_id is NOT NULL) THEN
568: DBMS_SQL.bind_variable(d_sql_p, 'client_id', p_client_id);
569: END IF;
570: IF (p_rule_id is NOT NULL) THEN
571: DBMS_SQL.bind_variable(d_sql_p, 'rule_id', p_rule_id);
572: END IF;

Line 571: DBMS_SQL.bind_variable(d_sql_p, 'rule_id', p_rule_id);

567: IF (p_client_id is NOT NULL) THEN
568: DBMS_SQL.bind_variable(d_sql_p, 'client_id', p_client_id);
569: END IF;
570: IF (p_rule_id is NOT NULL) THEN
571: DBMS_SQL.bind_variable(d_sql_p, 'rule_id', p_rule_id);
572: END IF;
573: IF (p_contract_id is NOT NULL) THEN
574: DBMS_SQL.bind_variable(d_sql_p, 'contract_id', p_contract_id);
575: END IF;

Line 574: DBMS_SQL.bind_variable(d_sql_p, 'contract_id', p_contract_id);

570: IF (p_rule_id is NOT NULL) THEN
571: DBMS_SQL.bind_variable(d_sql_p, 'rule_id', p_rule_id);
572: END IF;
573: IF (p_contract_id is NOT NULL) THEN
574: DBMS_SQL.bind_variable(d_sql_p, 'contract_id', p_contract_id);
575: END IF;
576: IF (p_item_id is NOT NULL) THEN
577: DBMS_SQL.bind_variable(d_sql_p, 'item_id', p_item_id);
578: END IF;

Line 577: DBMS_SQL.bind_variable(d_sql_p, 'item_id', p_item_id);

573: IF (p_contract_id is NOT NULL) THEN
574: DBMS_SQL.bind_variable(d_sql_p, 'contract_id', p_contract_id);
575: END IF;
576: IF (p_item_id is NOT NULL) THEN
577: DBMS_SQL.bind_variable(d_sql_p, 'item_id', p_item_id);
578: END IF;
579: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
580:
581: IF g_debug = 1 THEN

Line 579: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);

575: END IF;
576: IF (p_item_id is NOT NULL) THEN
577: DBMS_SQL.bind_variable(d_sql_p, 'item_id', p_item_id);
578: END IF;
579: d_sql_rows_processed := DBMS_SQL.EXECUTE(d_sql_p);
580:
581: IF g_debug = 1 THEN
582: debug('Fetched ref cursor');
583: END IF;

Line 586: IF dbms_sql.fetch_rows(d_sql_p) = 0 THEN

582: debug('Fetched ref cursor');
583: END IF;
584:
585: LOOP
586: IF dbms_sql.fetch_rows(d_sql_p) = 0 THEN
587: EXIT;
588: END IF;
589:
590: dbms_sql.column_value(d_sql_p,1,v_client_id);

Line 590: dbms_sql.column_value(d_sql_p,1,v_client_id);

586: IF dbms_sql.fetch_rows(d_sql_p) = 0 THEN
587: EXIT;
588: END IF;
589:
590: dbms_sql.column_value(d_sql_p,1,v_client_id);
591: dbms_sql.column_value(d_sql_p,2,v_client_code);
592: dbms_sql.column_value(d_sql_p,3,v_client_name);
593: dbms_sql.column_value(d_sql_p,4,v_client_number);
594: dbms_sql.column_value(d_sql_p,5,v_contract_id);

Line 591: dbms_sql.column_value(d_sql_p,2,v_client_code);

587: EXIT;
588: END IF;
589:
590: dbms_sql.column_value(d_sql_p,1,v_client_id);
591: dbms_sql.column_value(d_sql_p,2,v_client_code);
592: dbms_sql.column_value(d_sql_p,3,v_client_name);
593: dbms_sql.column_value(d_sql_p,4,v_client_number);
594: dbms_sql.column_value(d_sql_p,5,v_contract_id);
595: dbms_sql.column_value(d_sql_p,6,v_contract_number);

Line 592: dbms_sql.column_value(d_sql_p,3,v_client_name);

588: END IF;
589:
590: dbms_sql.column_value(d_sql_p,1,v_client_id);
591: dbms_sql.column_value(d_sql_p,2,v_client_code);
592: dbms_sql.column_value(d_sql_p,3,v_client_name);
593: dbms_sql.column_value(d_sql_p,4,v_client_number);
594: dbms_sql.column_value(d_sql_p,5,v_contract_id);
595: dbms_sql.column_value(d_sql_p,6,v_contract_number);
596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);

Line 593: dbms_sql.column_value(d_sql_p,4,v_client_number);

589:
590: dbms_sql.column_value(d_sql_p,1,v_client_id);
591: dbms_sql.column_value(d_sql_p,2,v_client_code);
592: dbms_sql.column_value(d_sql_p,3,v_client_name);
593: dbms_sql.column_value(d_sql_p,4,v_client_number);
594: dbms_sql.column_value(d_sql_p,5,v_contract_id);
595: dbms_sql.column_value(d_sql_p,6,v_contract_number);
596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);
597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);

Line 594: dbms_sql.column_value(d_sql_p,5,v_contract_id);

590: dbms_sql.column_value(d_sql_p,1,v_client_id);
591: dbms_sql.column_value(d_sql_p,2,v_client_code);
592: dbms_sql.column_value(d_sql_p,3,v_client_name);
593: dbms_sql.column_value(d_sql_p,4,v_client_number);
594: dbms_sql.column_value(d_sql_p,5,v_contract_id);
595: dbms_sql.column_value(d_sql_p,6,v_contract_number);
596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);
597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);
598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);

Line 595: dbms_sql.column_value(d_sql_p,6,v_contract_number);

591: dbms_sql.column_value(d_sql_p,2,v_client_code);
592: dbms_sql.column_value(d_sql_p,3,v_client_name);
593: dbms_sql.column_value(d_sql_p,4,v_client_number);
594: dbms_sql.column_value(d_sql_p,5,v_contract_id);
595: dbms_sql.column_value(d_sql_p,6,v_contract_number);
596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);
597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);
598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);
599: dbms_sql.column_value(d_sql_p,10,v_last_reading);

Line 596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);

592: dbms_sql.column_value(d_sql_p,3,v_client_name);
593: dbms_sql.column_value(d_sql_p,4,v_client_number);
594: dbms_sql.column_value(d_sql_p,5,v_contract_id);
595: dbms_sql.column_value(d_sql_p,6,v_contract_number);
596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);
597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);
598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);
599: dbms_sql.column_value(d_sql_p,10,v_last_reading);
600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);

Line 597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);

593: dbms_sql.column_value(d_sql_p,4,v_client_number);
594: dbms_sql.column_value(d_sql_p,5,v_contract_id);
595: dbms_sql.column_value(d_sql_p,6,v_contract_number);
596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);
597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);
598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);
599: dbms_sql.column_value(d_sql_p,10,v_last_reading);
600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);
601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);

Line 598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);

594: dbms_sql.column_value(d_sql_p,5,v_contract_id);
595: dbms_sql.column_value(d_sql_p,6,v_contract_number);
596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);
597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);
598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);
599: dbms_sql.column_value(d_sql_p,10,v_last_reading);
600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);
601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);
602: dbms_sql.column_value(d_sql_p,13,v_billing_source_id);

Line 599: dbms_sql.column_value(d_sql_p,10,v_last_reading);

595: dbms_sql.column_value(d_sql_p,6,v_contract_number);
596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);
597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);
598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);
599: dbms_sql.column_value(d_sql_p,10,v_last_reading);
600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);
601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);
602: dbms_sql.column_value(d_sql_p,13,v_billing_source_id);
603: dbms_sql.column_value(d_sql_p,14,v_billing_source_name);

Line 600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);

596: dbms_sql.column_value(d_sql_p,7,v_counter_item_id);
597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);
598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);
599: dbms_sql.column_value(d_sql_p,10,v_last_reading);
600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);
601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);
602: dbms_sql.column_value(d_sql_p,13,v_billing_source_id);
603: dbms_sql.column_value(d_sql_p,14,v_billing_source_name);
604: dbms_sql.column_value(d_sql_p,15,v_service_line_start_date);

Line 601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);

597: dbms_sql.column_value(d_sql_p,8,v_last_computation_Date);
598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);
599: dbms_sql.column_value(d_sql_p,10,v_last_reading);
600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);
601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);
602: dbms_sql.column_value(d_sql_p,13,v_billing_source_id);
603: dbms_sql.column_value(d_sql_p,14,v_billing_source_name);
604: dbms_sql.column_value(d_sql_p,15,v_service_line_start_date);
605: dbms_sql.column_value(d_sql_p,16,v_service_line_end_date);

Line 602: dbms_sql.column_value(d_sql_p,13,v_billing_source_id);

598: dbms_sql.column_value(d_sql_p,9,v_net_Reading);
599: dbms_sql.column_value(d_sql_p,10,v_last_reading);
600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);
601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);
602: dbms_sql.column_value(d_sql_p,13,v_billing_source_id);
603: dbms_sql.column_value(d_sql_p,14,v_billing_source_name);
604: dbms_sql.column_value(d_sql_p,15,v_service_line_start_date);
605: dbms_sql.column_value(d_sql_p,16,v_service_line_end_date);
606:

Line 603: dbms_sql.column_value(d_sql_p,14,v_billing_source_name);

599: dbms_sql.column_value(d_sql_p,10,v_last_reading);
600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);
601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);
602: dbms_sql.column_value(d_sql_p,13,v_billing_source_id);
603: dbms_sql.column_value(d_sql_p,14,v_billing_source_name);
604: dbms_sql.column_value(d_sql_p,15,v_service_line_start_date);
605: dbms_sql.column_value(d_sql_p,16,v_service_line_end_date);
606:
607: BEGIN

Line 604: dbms_sql.column_value(d_sql_p,15,v_service_line_start_date);

600: dbms_sql.column_value(d_sql_p,11,v_billing_uom);
601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);
602: dbms_sql.column_value(d_sql_p,13,v_billing_source_id);
603: dbms_sql.column_value(d_sql_p,14,v_billing_source_name);
604: dbms_sql.column_value(d_sql_p,15,v_service_line_start_date);
605: dbms_sql.column_value(d_sql_p,16,v_service_line_end_date);
606:
607: BEGIN
608: SAVEPOINT process_client;

Line 605: dbms_sql.column_value(d_sql_p,16,v_service_line_end_date);

601: dbms_sql.column_value(d_sql_p,12,v_service_item_org_id);
602: dbms_sql.column_value(d_sql_p,13,v_billing_source_id);
603: dbms_sql.column_value(d_sql_p,14,v_billing_source_name);
604: dbms_sql.column_value(d_sql_p,15,v_service_line_start_date);
605: dbms_sql.column_value(d_sql_p,16,v_service_line_end_date);
606:
607: BEGIN
608: SAVEPOINT process_client;
609: fnd_message.clear;

Line 879: IF DBMS_SQL.is_open(d_sql_p) THEN

875: debug('Committed the current record');
876: END IF;
877: END LOOP; /* Main Contract Cursor */
878:
879: IF DBMS_SQL.is_open(d_sql_p) THEN
880: DBMS_SQL.close_cursor(d_sql_p);
881: END IF;
882: RETCODE := 1;
883: IF NOT (l_success) THEN

Line 880: DBMS_SQL.close_cursor(d_sql_p);

876: END IF;
877: END LOOP; /* Main Contract Cursor */
878:
879: IF DBMS_SQL.is_open(d_sql_p) THEN
880: DBMS_SQL.close_cursor(d_sql_p);
881: END IF;
882: RETCODE := 1;
883: IF NOT (l_success) THEN
884:

Line 905: IF DBMS_SQL.is_open(d_sql_p) THEN

901: RETURN;
902:
903: EXCEPTION
904: WHEN ERROR_IN_PROGRAM THEN
905: IF DBMS_SQL.is_open(d_sql_p) THEN
906: DBMS_SQL.close_cursor(d_sql_p);
907: END IF;
908: RETCODE := 2;
909: IF g_debug = 1 THEN

Line 906: DBMS_SQL.close_cursor(d_sql_p);

902:
903: EXCEPTION
904: WHEN ERROR_IN_PROGRAM THEN
905: IF DBMS_SQL.is_open(d_sql_p) THEN
906: DBMS_SQL.close_cursor(d_sql_p);
907: END IF;
908: RETCODE := 2;
909: IF g_debug = 1 THEN
910: debug('Error occurred - '||SQLERRM);

Line 916: IF DBMS_SQL.is_open(d_sql_p) THEN

912: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
913: ROLLBACK;
914: RETURN;
915: WHEN OTHERS THEN
916: IF DBMS_SQL.is_open(d_sql_p) THEN
917: DBMS_SQL.close_cursor(d_sql_p);
918: END IF;
919: RETCODE := 2;
920: IF g_debug = 1 THEN

Line 917: DBMS_SQL.close_cursor(d_sql_p);

913: ROLLBACK;
914: RETURN;
915: WHEN OTHERS THEN
916: IF DBMS_SQL.is_open(d_sql_p) THEN
917: DBMS_SQL.close_cursor(d_sql_p);
918: END IF;
919: RETCODE := 2;
920: IF g_debug = 1 THEN
921: debug(' Unexpected error occurred => '||SQLERRM);