[Home] [Help]
256: -- -- bridgway 06/20/01
257:
258: if (h_mrc_sob_type_code = 'R') then
259: FOR h_i in 1..h_num_rows LOOP
260: INSERT INTO FA_ADJUSTMENTS_MRC_V
261: (transaction_header_id,
262: asset_invoice_id,
263: source_type_code,
264: adjustment_type,
296: adj_table(h_i).last_update_date,
297: h_last_updated_by,
298: h_last_update_login,
299: adj_table(h_i).track_member_flag,
300: fa_adjustments_s.nextval, --adjustment_line_id,
301: adj_table(h_i).source_dest_code,
302: adj_table(h_i).source_line_id);
303: h_j := h_i;
304: END LOOP;
303: h_j := h_i;
304: END LOOP;
305: else
306: FOR h_i in 1..h_num_rows LOOP
307: INSERT INTO FA_ADJUSTMENTS
308: (transaction_header_id,
309: asset_invoice_id,
310: source_type_code,
311: adjustment_type,
343: adj_table(h_i).last_update_date,
344: h_last_updated_by,
345: h_last_update_login,
346: adj_table(h_i).track_member_flag,
347: fa_adjustments_s.nextval, --adjustment_line_id,
348: adj_table(h_i).source_dest_code,
349: adj_table(h_i).source_line_id);
350: h_j := h_i;
351: END LOOP;
493: -- -- bridgway 06/20/01
494:
495: if (h_mrc_sob_type_code ='R') then
496: FOR h_i in 1..h_num_rows LOOP
497: INSERT INTO FA_ADJUSTMENTS_MRC_V
498: (transaction_header_id,
499: asset_invoice_id,
500: source_type_code,
501: adjustment_type,
533: adj_table(h_i).last_update_date,
534: h_last_updated_by,
535: h_last_update_login,
536: adj_table(h_i).track_member_flag, -- Added for Track Member
537: fa_adjustments_s.nextval, -- adjustment_line_id,
538: adj_table(h_i).source_dest_code,
539: adj_table(h_i).source_line_id);
540: h_j := h_i;
541: END LOOP;
540: h_j := h_i;
541: END LOOP;
542: else
543: FOR h_i in 1..h_num_rows LOOP
544: INSERT INTO FA_ADJUSTMENTS
545: (transaction_header_id,
546: asset_invoice_id,
547: source_type_code,
548: adjustment_type,
580: adj_table(h_i).last_update_date,
581: h_last_updated_by,
582: h_last_update_login,
583: adj_table(h_i).track_member_flag, -- Track Member
584: fa_adjustments_s.nextval, -- adjustment_line_id,
585: adj_table(h_i).source_dest_code,
586: adj_table(h_i).source_line_id);
587: h_j := h_i;
588: END LOOP;
912: return FALSE;
913: end if;
914:
915: -- Call the function fainajc, which performs the insert into
916: -- FA_ADJUSTMENTS, caching the inserts if appropiate
917: if adj_ptr.account_type='CIP_COST_ACCT' then
918: h_adj_type:='CIP COST';
919: else
920: h_adj_type:=adj_ptr.adjustment_type;
1149: h_adj_type := adj_ptr.adjustment_type;
1150: end if;
1151:
1152: -- Call the function fainajc, which performs the insert into
1153: -- FA_ADJUSTMENTS, caching the inserts if appropiate
1154: adj_ptr.adjustment_type := h_adj_type;
1155: adj_ptr.code_combination_id := h_calculated_ccid;
1156: adj_ptr.distribution_id := h_distribution_id;
1157: if (not fainajc
1259:
1260: adj_ptr.code_combination_id := h_calculated_ccid;
1261: adj_ptr.adjustment_type := h_adj_type;
1262: -- Call the function fainajc which performs the insert into
1263: -- FA_ADJUSTMENTS, caching the inserts if appropiate
1264: if (not fainajc
1265: (X_flush_mode => FALSE,
1266: X_mode => FALSE,
1267: X_last_update_date => X_last_update_date,
1343: adj_ptr.code_combination_id := h_calculated_ccid;
1344: adj_ptr.adjustment_type := h_adj_type;
1345:
1346: -- Call the function fainajc which performs the insert into
1347: -- FA_ADJUSTMENTS, caching the inserts if appropiate
1348:
1349: if (not fainajc
1350: (X_flush_mode => FALSE,
1351: X_mode => FALSE,