APPS.JL_CO_FA_POST_PKG dependencies on JL_CO_FA_ADJUSTMENTS

Line 32: -- Use this procedure for posting from jl_co_fa_adjustments table to --

28: -- PROCEDURE --
29: -- purge_adjustment --
30: -- --
31: -- DESCRIPTION --
32: -- Use this procedure for posting from jl_co_fa_adjustments table to --
33: -- gl_interface table. --
34: -- PURPOSE: --
35: -- Oracle Applications Rel 11.0 --
36: -- --

Line 109: FROM jl_co_fa_adjustments

105: SELECT source_type_code,
106: debit_credit_flag,
107: code_combination_id,
108: sum(adjustment_amount) x_amount
109: FROM jl_co_fa_adjustments
110: WHERE book_type_code = p_book
111: AND period_counter_created = p_counter
112: AND je_category_name = p_je_category_name
113: AND NVL(posting_flag, 'E') <> 'C'

Line 407: -- Update jl_co_fa_adjustments --

403: END IF;
404:
405:
406: ---------------------------------------------------------
407: -- Update jl_co_fa_adjustments --
408: ---------------------------------------------------------
409:
410: UPDATE jl_co_fa_adjustments
411: SET sequence_line = jl_co_fa_adj_je_header_s.CURRVAL,

Line 410: UPDATE jl_co_fa_adjustments

406: ---------------------------------------------------------
407: -- Update jl_co_fa_adjustments --
408: ---------------------------------------------------------
409:
410: UPDATE jl_co_fa_adjustments
411: SET sequence_line = jl_co_fa_adj_je_header_s.CURRVAL,
412: posting_flag = 'C',
413: last_update_date = x_sysdate,
414: last_updated_by = x_last_updated_by,