17: -----------------------------------------------------------------------------
18: -- Variables corresponding to Who columns --
19: -----------------------------------------------------------------------------
20:
21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;
18: -- Variables corresponding to Who columns --
19: -----------------------------------------------------------------------------
20:
21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;
26: x_sysdate date;
19: -----------------------------------------------------------------------------
20:
21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;
26: x_sysdate date;
27:
20:
21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;
26: x_sysdate date;
27:
28: -----------------------------------------------------------------------------
21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;
26: x_sysdate date;
27:
28: -----------------------------------------------------------------------------
29: -- PROCEDURE --
174: x_concat_segs VARCHAR2(240);
175: x_return_value NUMBER;
176:
177: -----------------------------------------------------------------------------
178: -- Name of the accounts used in JL_CO_FA_ADJUSTMENTS.ADJUSTMENT_TYPE --
179: -----------------------------------------------------------------------------
180:
181: x_cost_name fa_adjustments.adjustment_type%TYPE := 'COST';
182: x_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'CIP COST';
4099: -----------------------------------------------------------------------------
4100: -- Rows to add due to inflation adjustments --
4101: -- Calculate amount --
4102: -- Built accounting flexfield --
4103: -- Insert row in JL_CO_FA_ADJUSTMENTS --
4104: -----------------------------------------------------------------------------
4105:
4106: IF (x_retirement_type = 'O') THEN
4107: x_adjustment_amount := ra.adjustment_amount;
4294: -- Change Gain/Loss. Reverse the standard rows and create new rows with --
4295: -- the right account. --
4296: -- Get the standard row --
4297: -- Insert row reversing it --
4298: -- Insert new row with right account in JL_CO_FA_ADJUSTMENTS --
4299: -----------------------------------------------------------------------------
4300:
4301: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4302: x_char := ra.adjustment_type;
4996: -- p_reference --
4997: -- p_posting_flag --
4998: ----------------------------------------------------------------------------
4999:
5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
4997: -- p_posting_flag --
4998: ----------------------------------------------------------------------------
4999:
5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
4998: ----------------------------------------------------------------------------
4999:
5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
4999:
5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE
5018: )
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE
5018: )
5019: IS
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE
5018: )
5019: IS
5020:
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE
5018: )
5019: IS
5020:
5021: x_adjustment_amount NUMBER;
5065: x_debit_credit_flag := p_debit_credit_flag;
5066: END IF;
5067:
5068: IF p_code_combination_id IS NOT NULL THEN
5069: INSERT INTO jl_co_fa_adjustments
5070: (transaction_header_id,
5071: source_type_code,
5072: je_category_name,
5073: adjustment_type,