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.JL_CO_FA_ACCOUNTING_PKG dependencies on JL_CO_FA_ADJUSTMENTS

Line 21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;

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;

Line 22: x_last_update_login jl_co_fa_adjustments.last_update_login%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;

Line 23: x_request_id jl_co_fa_adjustments.request_id%TYPE;

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:

Line 24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;

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: -----------------------------------------------------------------------------

Line 25: x_program_id jl_co_fa_adjustments.program_id%TYPE;

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 --

Line 178: -- Name of the accounts used in JL_CO_FA_ADJUSTMENTS.ADJUSTMENT_TYPE --

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';

Line 4103: -- Insert row in JL_CO_FA_ADJUSTMENTS --

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;

Line 4298: -- Insert new row with right account in JL_CO_FA_ADJUSTMENTS --

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;

Line 5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%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,

Line 5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%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,

Line 5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%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,

Line 5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%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,

Line 5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%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,

Line 5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_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,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,

Line 5006: p_book_type_code IN jl_co_fa_adjustments.book_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,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,

Line 5007: p_asset_id IN jl_co_fa_adjustments.asset_id%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,

Line 5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%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,

Line 5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%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,

Line 5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%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,

Line 5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%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,

Line 5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%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,

Line 5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%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

Line 5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%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: )

Line 5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%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: )
5019: IS

Line 5016: p_reference IN jl_co_fa_adjustments.reference%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
5020:

Line 5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%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:
5021: x_adjustment_amount NUMBER;

Line 5069: INSERT INTO jl_co_fa_adjustments

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,