DBA Data[Home] [Help]

APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on JL_CO_GL_MG_LINES_S

Line 18: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;

14: x_literal_code jl_co_gl_mg_literals.literal_code%TYPE;
15:
16: x_reported_flag jl_co_gl_mg_lines.reported_flag%TYPE;
17: x_first_value jl_co_gl_mg_lines.first_reported_value%TYPE;
18: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;
19: x_mg_header_id jl_co_gl_mg_headers.mg_header_id%TYPE;
20:
21: count_process_flag NUMBER := 0;
22: count_status NUMBER := 0;

Line 38: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,

34: nit_id jl_co_gl_nits.nit_id%TYPE,
35: config_id jl_co_gl_mg_configs.config_id%TYPE,
36: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
37: range_id jl_co_gl_mg_ranges.range_id%TYPE,
38: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,
39: origin jl_co_gl_mg_lines.origin%TYPE,
40: amount jl_co_gl_mg_lines.first_reported_value%TYPE
41: );
42:

Line 835: SELECT jl_co_gl_mg_lines_s.NEXTVAL

831:
832: get_move_rec.nit_id := trx_rec.nit_id;
833: get_move_rec.amount := trx_rec.amount;
834:
835: SELECT jl_co_gl_mg_lines_s.NEXTVAL
836: INTO get_move_rec.mg_line_id
837: FROM SYS.DUAL;
838:
839: get_movement_insert (get_move_rec);

Line 859: SELECT jl_co_gl_mg_lines_s.NEXTVAL

855:
856: get_move_rec.nit_id := bal_rec.nit_id;
857: get_move_rec.amount := bal_rec.amount;
858:
859: SELECT jl_co_gl_mg_lines_s.NEXTVAL
860: INTO get_move_rec.mg_line_id
861: FROM SYS.DUAL;
862:
863: get_movement_insert (get_move_rec);