[Home] [Help]
397: adj_table(h_i).last_update_date,
398: h_last_updated_by,
399: h_last_update_login,
400: adj_table(h_i).track_member_flag,
401: fa_adjustments_s.nextval, --adjustment_line_id
402: adj_table(h_i).source_dest_code,
403: adj_table(h_i).source_line_id,
404: 'C',
405: adj_table(h_i).insertion_order);
406: h_j := h_i;
407: END LOOP;
408: else
409: FOR h_i in 1..h_num_rows LOOP
410: INSERT INTO FA_ADJUSTMENTS
411: (transaction_header_id,
412: asset_invoice_id,
413: source_type_code,
414: adjustment_type,
447: adj_table(h_i).last_update_date,
448: h_last_updated_by,
449: h_last_update_login,
450: adj_table(h_i).track_member_flag,
451: fa_adjustments_s.nextval, --adjustment_line_id
452: adj_table(h_i).source_dest_code,
453: adj_table(h_i).source_line_id,
454: adj_table(h_i).insertion_order);
455: h_j := h_i;
648: adj_table(h_i).last_update_date,
649: h_last_updated_by,
650: h_last_update_login,
651: adj_table(h_i).track_member_flag,
652: fa_adjustments_s.nextval, -- adjustment_line_id,
653: adj_table(h_i).source_dest_code,
654: adj_table(h_i).source_line_id,
655: 'C',
656: adj_table(h_i).insertion_order);
657: h_j := h_i;
658: END LOOP;
659: else
660: FOR h_i in 1..h_num_rows LOOP
661: INSERT INTO FA_ADJUSTMENTS
662: (transaction_header_id,
663: asset_invoice_id,
664: source_type_code,
665: adjustment_type,
698: adj_table(h_i).last_update_date,
699: h_last_updated_by,
700: h_last_update_login,
701: adj_table(h_i).track_member_flag,
702: fa_adjustments_s.nextval, -- adjustment_line_id,
703: adj_table(h_i).source_dest_code,
704: adj_table(h_i).source_line_id,
705: adj_table(h_i).insertion_order);
706: h_j := h_i;
872: select nvl(sum(decode(debit_credit_flag,
873: 'DR', adjustment_amount,
874: adjustment_amount * -1)), 0),count(*)
875: into h_tot_cost,h_adj_no_rows
876: from fa_adjustments
877: where asset_id = adj_ptr.asset_id
878: and book_type_code = adj_ptr.book_type_code
879: and adjustment_type = 'COST'
880: and distribution_id in (select distribution_id from fa_distribution_history where asset_id = adj_ptr.asset_id and book_type_code = adj_ptr.book_type_code and date_ineffective is null);
1259: return FALSE;
1260: end if;
1261:
1262: -- Call the function fainajc, which performs the insert into
1263: -- FA_ADJUSTMENTS, caching the inserts if appropiate
1264: if adj_ptr.account_type='CIP_COST_ACCT' then
1265: h_adj_type:='CIP COST';
1266: else
1267: h_adj_type:=adj_ptr.adjustment_type;
1501: h_adj_type := adj_ptr.adjustment_type;
1502: end if;
1503:
1504: -- Call the function fainajc, which performs the insert into
1505: -- FA_ADJUSTMENTS, caching the inserts if appropiate
1506: adj_ptr.adjustment_type := h_adj_type;
1507: adj_ptr.code_combination_id := h_calculated_ccid;
1508: adj_ptr.distribution_id := h_distribution_id;
1509: if (not fainajc
1614:
1615: adj_ptr.code_combination_id := h_calculated_ccid;
1616: adj_ptr.adjustment_type := h_adj_type;
1617: -- Call the function fainajc which performs the insert into
1618: -- FA_ADJUSTMENTS, caching the inserts if appropiate
1619: if (not fainajc
1620: (X_flush_mode => FALSE,
1621: X_mode => FALSE,
1622: X_last_update_date => X_last_update_date,
1703: adj_ptr.code_combination_id := h_calculated_ccid;
1704: adj_ptr.adjustment_type := h_adj_type;
1705:
1706: -- Call the function fainajc which performs the insert into
1707: -- FA_ADJUSTMENTS, caching the inserts if appropiate
1708:
1709: if (not fainajc
1710: (X_flush_mode => FALSE,
1711: X_mode => FALSE,