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

Line 281: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

277: -- l_src_cat_book_rec := fa_cache_pkg.fazccb_record;
278:
279:
280: -- get each balancing segment and the sum of the amounts
281: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
282:
283: -- bug# 5383699
284: if (p_calling_fn = 'fa_group_reclass_pvt.do_grp_reclass' or
285: p_calling_fn = 'fa_group_process_groups_pkg.do_rcl') then

Line 357: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);

353: group by nvl(glcc1.' || l_column_name || ', glcc2.' || l_column_name || ')';
354:
355: end if;
356:
357: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
358:
359: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
360: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_src_asset_hdr_rec.book_type_code);
361: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

Line 359: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);

355: end if;
356:
357: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
358:
359: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
360: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_src_asset_hdr_rec.book_type_code);
361: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
362: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
363:

Line 360: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_src_asset_hdr_rec.book_type_code);

356:
357: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
358:
359: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
360: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_src_asset_hdr_rec.book_type_code);
361: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
362: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
363:
364:

Line 361: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

357: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
358:
359: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
360: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_src_asset_hdr_rec.book_type_code);
361: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
362: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
363:
364:
365: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);

Line 362: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);

358:
359: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
360: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_src_asset_hdr_rec.book_type_code);
361: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
362: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
363:
364:
365: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
366: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);

Line 365: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);

361: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
362: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
363:
364:
365: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
366: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);
367:
368: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
369:

Line 366: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);

362: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
363:
364:
365: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
366: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);
367:
368: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
369:
370: loop

Line 368: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

364:
365: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
366: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);
367:
368: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
369:
370: loop
371:
372: l_src_count := l_src_tbl.count;

Line 374: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then

370: loop
371:
372: l_src_count := l_src_tbl.count;
373:
374: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
375: exit;
376: end if;
377:
378: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

Line 378: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

374: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
375: exit;
376: end if;
377:
378: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);
379: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_sum_amount);
380:
381: if (p_log_level_rec.statement_level) then
382: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first source tbl: ', l_balancing_seg

Line 379: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_sum_amount);

375: exit;
376: end if;
377:
378: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);
379: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_sum_amount);
380:
381: if (p_log_level_rec.statement_level) then
382: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first source tbl: ', l_balancing_seg
383: ,p_log_level_rec => p_log_level_rec);

Line 395: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

391: l_src_tbl(l_src_count + 1).amount := l_sum_amount;
392:
393: end loop;
394:
395: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
396:
397:
398: if (p_log_level_rec.statement_level) then
399: fa_debug_pkg.add(l_calling_fn, 'source table count', l_src_tbl.count

Line 428: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

424: -- l_dest_cat_book_rec := fa_cache_pkg.fazccb_record;
425:
426:
427: -- get each balancing segment and the sum of the amounts
428: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
429:
430: -- bug# 5383699
431: if (p_calling_fn = 'fa_group_reclass_pvt.do_grp_reclass' or
432: p_calling_fn = 'fa_group_process_groups_pkg.do_rcl') then

Line 503: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);

499: group by nvl(glcc1.' || l_column_name || ', glcc2.' || l_column_name || ')';
500: end if;
501:
502:
503: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
504:
505: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_dest_asset_hdr_rec.asset_id);
506: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_dest_asset_hdr_rec.book_type_code);
507: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

Line 505: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_dest_asset_hdr_rec.asset_id);

501:
502:
503: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
504:
505: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_dest_asset_hdr_rec.asset_id);
506: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_dest_asset_hdr_rec.book_type_code);
507: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
508: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_dest_trans_rec.transaction_header_Id);
509:

Line 506: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_dest_asset_hdr_rec.book_type_code);

502:
503: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
504:
505: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_dest_asset_hdr_rec.asset_id);
506: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_dest_asset_hdr_rec.book_type_code);
507: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
508: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_dest_trans_rec.transaction_header_Id);
509:
510: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);

Line 507: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

503: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
504:
505: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_dest_asset_hdr_rec.asset_id);
506: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_dest_asset_hdr_rec.book_type_code);
507: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
508: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_dest_trans_rec.transaction_header_Id);
509:
510: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
511: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);

Line 508: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_dest_trans_rec.transaction_header_Id);

504:
505: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_dest_asset_hdr_rec.asset_id);
506: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_dest_asset_hdr_rec.book_type_code);
507: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
508: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_dest_trans_rec.transaction_header_Id);
509:
510: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
511: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);
512:

Line 510: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);

506: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_dest_asset_hdr_rec.book_type_code);
507: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
508: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_dest_trans_rec.transaction_header_Id);
509:
510: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
511: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);
512:
513: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
514:

Line 511: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);

507: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
508: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_dest_trans_rec.transaction_header_Id);
509:
510: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
511: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);
512:
513: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
514:
515: loop

Line 513: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

509:
510: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
511: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_sum_amount);
512:
513: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
514:
515: loop
516:
517: l_dest_count := l_dest_tbl.count;

Line 519: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then

515: loop
516:
517: l_dest_count := l_dest_tbl.count;
518:
519: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
520: exit;
521: end if;
522:
523: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

Line 523: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

519: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
520: exit;
521: end if;
522:
523: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);
524: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_sum_amount);
525:
526: if (p_log_level_rec.statement_level) then
527: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first dest tbl: ', l_balancing_seg

Line 524: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_sum_amount);

520: exit;
521: end if;
522:
523: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);
524: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_sum_amount);
525:
526: if (p_log_level_rec.statement_level) then
527: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first dest tbl: ', l_balancing_seg
528: ,p_log_level_rec => p_log_level_rec);

Line 539: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

535: l_dest_tbl(l_dest_count + 1).amount := l_sum_amount;
536:
537: end loop;
538:
539: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
540:
541: if (p_log_level_rec.statement_level) then
542: fa_debug_pkg.add(l_calling_fn, 'dest table count', l_dest_tbl.count
543: ,p_log_level_rec => p_log_level_rec);

Line 1048: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1044: l_total_prorated_amount := 0;
1045:
1046:
1047: -- get each balancing segment and the sum of the amounts
1048: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1049:
1050: l_statement :=
1051: ' select distinct
1052: dh.distribution_id,

Line 1067: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);

1063: and dh.asset_id = :p_asset_id
1064: and dh.code_combination_id = glcc.code_combination_id
1065: and glcc. ' || l_column_name || ' = :p_balancing_segment ';
1066:
1067: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1068:
1069: -- need to use local for dest variable for intra-asset trxs
1070: if (l_summary_tbl(l_summary_count).type = 'SRC') then
1071: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);

Line 1071: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);

1067: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1068:
1069: -- need to use local for dest variable for intra-asset trxs
1070: if (l_summary_tbl(l_summary_count).type = 'SRC') then
1071: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
1072: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', p_src_asset_hdr_rec.book_type_code);
1073: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1074: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
1075: else

Line 1072: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', p_src_asset_hdr_rec.book_type_code);

1068:
1069: -- need to use local for dest variable for intra-asset trxs
1070: if (l_summary_tbl(l_summary_count).type = 'SRC') then
1071: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
1072: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', p_src_asset_hdr_rec.book_type_code);
1073: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1074: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
1075: else
1076: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);

Line 1073: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

1069: -- need to use local for dest variable for intra-asset trxs
1070: if (l_summary_tbl(l_summary_count).type = 'SRC') then
1071: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
1072: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', p_src_asset_hdr_rec.book_type_code);
1073: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1074: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
1075: else
1076: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);
1077: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', l_dest_asset_hdr_rec.book_type_code);

Line 1074: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);

1070: if (l_summary_tbl(l_summary_count).type = 'SRC') then
1071: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
1072: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', p_src_asset_hdr_rec.book_type_code);
1073: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1074: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
1075: else
1076: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);
1077: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', l_dest_asset_hdr_rec.book_type_code);
1078: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

Line 1076: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);

1072: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', p_src_asset_hdr_rec.book_type_code);
1073: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1074: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
1075: else
1076: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);
1077: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', l_dest_asset_hdr_rec.book_type_code);
1078: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1079: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', l_dest_trans_rec.transaction_header_id);
1080: end if;

Line 1077: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', l_dest_asset_hdr_rec.book_type_code);

1073: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1074: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
1075: else
1076: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);
1077: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', l_dest_asset_hdr_rec.book_type_code);
1078: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1079: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', l_dest_trans_rec.transaction_header_id);
1080: end if;
1081:

Line 1078: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

1074: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
1075: else
1076: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);
1077: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', l_dest_asset_hdr_rec.book_type_code);
1078: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1079: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', l_dest_trans_rec.transaction_header_id);
1080: end if;
1081:
1082: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_balancing_segment', l_summary_tbl(l_summary_count).balancing_segment);

Line 1079: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', l_dest_trans_rec.transaction_header_id);

1075: else
1076: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);
1077: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', l_dest_asset_hdr_rec.book_type_code);
1078: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1079: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', l_dest_trans_rec.transaction_header_id);
1080: end if;
1081:
1082: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_balancing_segment', l_summary_tbl(l_summary_count).balancing_segment);
1083:

Line 1082: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_balancing_segment', l_summary_tbl(l_summary_count).balancing_segment);

1078: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
1079: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', l_dest_trans_rec.transaction_header_id);
1080: end if;
1081:
1082: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_balancing_segment', l_summary_tbl(l_summary_count).balancing_segment);
1083:
1084: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_distribution_id);
1085: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_code_combination_id);
1086: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 3, l_units);

Line 1084: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_distribution_id);

1080: end if;
1081:
1082: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_balancing_segment', l_summary_tbl(l_summary_count).balancing_segment);
1083:
1084: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_distribution_id);
1085: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_code_combination_id);
1086: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 3, l_units);
1087:
1088: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

Line 1085: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_code_combination_id);

1081:
1082: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_balancing_segment', l_summary_tbl(l_summary_count).balancing_segment);
1083:
1084: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_distribution_id);
1085: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_code_combination_id);
1086: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 3, l_units);
1087:
1088: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1089:

Line 1086: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 3, l_units);

1082: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_balancing_segment', l_summary_tbl(l_summary_count).balancing_segment);
1083:
1084: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_distribution_id);
1085: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_code_combination_id);
1086: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 3, l_units);
1087:
1088: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1089:
1090: loop

Line 1088: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

1084: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_distribution_id);
1085: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 2, l_code_combination_id);
1086: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 3, l_units);
1087:
1088: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1089:
1090: loop
1091:
1092: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then

Line 1092: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then

1088: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1089:
1090: loop
1091:
1092: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
1093:
1094:
1095: if (p_log_level_rec.statement_level) then
1096: fa_debug_pkg.add(l_calling_fn, 'dist cursor: ', 'no more rows fetched'

Line 1219: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_distribution_id);

1215: fa_debug_pkg.add(l_calling_fn, 'populating: ', 'values from dist cursor'
1216: ,p_log_level_rec => p_log_level_rec);
1217: end if;
1218:
1219: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_distribution_id);
1220: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_code_combination_id);
1221: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 3, l_units);
1222:
1223:

Line 1220: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_code_combination_id);

1216: ,p_log_level_rec => p_log_level_rec);
1217: end if;
1218:
1219: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_distribution_id);
1220: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_code_combination_id);
1221: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 3, l_units);
1222:
1223:
1224: -- add these values to the table

Line 1221: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 3, l_units);

1217: end if;
1218:
1219: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_distribution_id);
1220: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_code_combination_id);
1221: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 3, l_units);
1222:
1223:
1224: -- add these values to the table
1225: l_dist_tbl_count := l_dist_tbl.count + 1;

Line 1232: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

1228: l_dist_tbl(l_dist_tbl_count).units := l_units;
1229:
1230: end loop;
1231:
1232: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1233:
1234: end loop;
1235:
1236: raise done_exception;

Line 1435: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1431: end if;
1432:
1433:
1434: -- execute the statment
1435: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1436: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1437:
1438: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1439:

Line 1436: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);

1432:
1433:
1434: -- execute the statment
1435: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1436: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1437:
1438: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1439:
1440: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

Line 1438: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);

1434: -- execute the statment
1435: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1436: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1437:
1438: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1439:
1440: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1441:
1442: loop

Line 1440: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

1436: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1437:
1438: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1439:
1440: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1441:
1442: loop
1443:
1444: l_bal_count1 := l_bal_tbl1.count;

Line 1446: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then

1442: loop
1443:
1444: l_bal_count1 := l_bal_tbl1.count;
1445:
1446: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
1447: exit;
1448: end if;
1449:
1450: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

Line 1450: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

1446: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
1447: exit;
1448: end if;
1449:
1450: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);
1451:
1452: l_bal_tbl1(l_bal_count1 + 1) := l_balancing_seg;
1453:
1454: end loop;

Line 1456: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

1452: l_bal_tbl1(l_bal_count1 + 1) := l_balancing_seg;
1453:
1454: end loop;
1455:
1456: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1457:
1458:
1459:
1460: -- now for group, check all member distributions

Line 1555: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1551: end if;
1552:
1553:
1554: -- execute the statment
1555: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1556: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1557:
1558: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_asset_id);
1559: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_asset_hdr_rec.book_type_code);

Line 1556: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);

1552:
1553:
1554: -- execute the statment
1555: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1556: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1557:
1558: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_asset_id);
1559: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_asset_hdr_rec.book_type_code);
1560:

Line 1558: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_asset_id);

1554: -- execute the statment
1555: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1556: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1557:
1558: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_asset_id);
1559: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_asset_hdr_rec.book_type_code);
1560:
1561: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1562:

Line 1559: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_asset_hdr_rec.book_type_code);

1555: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1556: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1557:
1558: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_asset_id);
1559: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_asset_hdr_rec.book_type_code);
1560:
1561: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1562:
1563: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

Line 1561: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);

1557:
1558: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_asset_id);
1559: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_asset_hdr_rec.book_type_code);
1560:
1561: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1562:
1563: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1564:
1565: loop

Line 1563: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

1559: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_asset_hdr_rec.book_type_code);
1560:
1561: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1562:
1563: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1564:
1565: loop
1566:
1567: l_bal_count2 := l_bal_tbl2.count;

Line 1569: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then

1565: loop
1566:
1567: l_bal_count2 := l_bal_tbl2.count;
1568:
1569: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
1570: exit;
1571: end if;
1572:
1573: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

Line 1573: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

1569: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
1570: exit;
1571: end if;
1572:
1573: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);
1574:
1575: l_bal_tbl2(l_bal_count2 + 1) := l_balancing_seg;
1576:
1577: end loop;

Line 1579: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

1575: l_bal_tbl2(l_bal_count2 + 1) := l_balancing_seg;
1576:
1577: end loop;
1578:
1579: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1580:
1581:
1582: if (p_log_level_rec.statement_level) then
1583: fa_debug_pkg.add(l_calling_fn, 'looking', 'for mismatches'

Line 1789: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1785: ,p_log_level_rec => p_log_level_rec);
1786: end if;
1787:
1788: -- execute the statment
1789: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1790: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1791:
1792: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1793:

Line 1790: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);

1786: end if;
1787:
1788: -- execute the statment
1789: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1790: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1791:
1792: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1793:
1794: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

Line 1792: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);

1788: -- execute the statment
1789: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1790: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1791:
1792: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1793:
1794: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1795:
1796: loop

Line 1794: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

1790: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
1791:
1792: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, 1, l_balancing_seg, 30);
1793:
1794: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1795:
1796: loop
1797:
1798: l_bal_count1 := l_bal_tbl1.count;

Line 1800: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then

1796: loop
1797:
1798: l_bal_count1 := l_bal_tbl1.count;
1799:
1800: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
1801: exit;
1802: end if;
1803:
1804: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

Line 1804: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);

1800: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
1801: exit;
1802: end if;
1803:
1804: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);
1805:
1806: l_bal_tbl1(l_bal_count1 + 1) := l_balancing_seg;
1807:
1808: end loop;

Line 1810: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

1806: l_bal_tbl1(l_bal_count1 + 1) := l_balancing_seg;
1807:
1808: end loop;
1809:
1810: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1811:
1812: -- copy this table to the second array and delete the original
1813: if (i = 1) then
1814: l_bal_tbl2 := l_bal_tbl1;