APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on JL_CO_GL_CONC_CTRL

Line 127: cid jl_co_gl_conc_ctrl.process_id%type,

123: and ael.accounting_class_code in ('INTER','INTRA')) --End of bug10084267 fix
124: ORDER BY gljh.je_header_id, nvl(gljh.reversed_je_header_id,0); --bug 8391172
125:
126: TYPE t_parameters IS RECORD (
127: cid jl_co_gl_conc_ctrl.process_id%type,
128: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,
129: user_id jl_co_gl_conc_ctrl.created_by%type,
130: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
131:

Line 128: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,

124: ORDER BY gljh.je_header_id, nvl(gljh.reversed_je_header_id,0); --bug 8391172
125:
126: TYPE t_parameters IS RECORD (
127: cid jl_co_gl_conc_ctrl.process_id%type,
128: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,
129: user_id jl_co_gl_conc_ctrl.created_by%type,
130: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
131:
132: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,

Line 129: user_id jl_co_gl_conc_ctrl.created_by%type,

125:
126: TYPE t_parameters IS RECORD (
127: cid jl_co_gl_conc_ctrl.process_id%type,
128: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,
129: user_id jl_co_gl_conc_ctrl.created_by%type,
130: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
131:
132: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,
133: nit jl_co_gl_nits.nit%type,

Line 130: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);

126: TYPE t_parameters IS RECORD (
127: cid jl_co_gl_conc_ctrl.process_id%type,
128: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,
129: user_id jl_co_gl_conc_ctrl.created_by%type,
130: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
131:
132: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,
133: nit jl_co_gl_nits.nit%type,
134: nit_name jl_co_gl_nits.name%type,

Line 2644: FROM jl_co_gl_conc_ctrl

2640: sum(nvl(jlcgt.accounted_dr,0)) acc_dr, --bug 10207969
2641: sum(nvl(jlcgt.accounted_cr,0)) acc_cr --bug 10207969
2642: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt
2643: WHERE jlcgt.process_id IN ( SELECT process_id
2644: FROM jl_co_gl_conc_ctrl
2645: WHERE NVL(balance_calculated,'N') <> 'Y'
2646: AND set_of_books_id
2647: = g_parameter_rec.set_of_books_id)
2648: AND jlcgt.code_combination_id = glcc.code_combination_id

Line 2830: UPDATE jl_co_gl_conc_ctrl

2826: trx.peryear * 100);
2827:
2828: END LOOP;
2829:
2830: UPDATE jl_co_gl_conc_ctrl
2831: SET status = DECODE(process_id,p_cid,'P',status),
2832: balance_calculated = 'Y',
2833: last_update_date = sysdate,
2834: last_updated_by = p_userid,

Line 2961: UPDATE jl_co_gl_conc_ctrl

2957:
2958: DELETE FROM jl_co_gl_trx
2959: WHERE process_id = p_rcid ;
2960:
2961: UPDATE jl_co_gl_conc_ctrl
2962: SET status = 'P',
2963: reversed_process_id = p_rcid,
2964: last_update_date = sysdate,
2965: last_updated_by = p_userid,

Line 2969: UPDATE jl_co_gl_conc_ctrl

2965: last_updated_by = p_userid,
2966: last_update_login = g_login_id
2967: WHERE process_id = p_cid;
2968:
2969: UPDATE jl_co_gl_conc_ctrl
2970: SET status = 'R',
2971: last_update_date = sysdate,
2972: last_updated_by = p_userid,
2973: last_update_login = g_login_id

Line 3033: SELECT jl_co_gl_conc_ctrl_s.nextval,

3029: SELECT TO_NUMBER(NVL(fnd_profile.value('LOGIN_ID'),-1))
3030: INTO g_login_id
3031: FROM DUAL;
3032:
3033: SELECT jl_co_gl_conc_ctrl_s.nextval,
3034: p_sobid,
3035: TO_NUMBER(NVL(fnd_profile.value('USER_ID') ,-1)),
3036: p_rcid
3037: INTO g_parameter_rec

Line 3040: INSERT INTO jl_co_gl_conc_ctrl (

3036: p_rcid
3037: INTO g_parameter_rec
3038: FROM dual;
3039:
3040: INSERT INTO jl_co_gl_conc_ctrl (
3041: process_id,
3042: set_of_books_id,
3043: period_name,
3044: reversed_process_id,

Line 3052: VALUES ( jl_co_gl_conc_ctrl_s.currval,

3048: last_update_date,
3049: last_updated_by,
3050: last_update_login,
3051: balance_calculated)
3052: VALUES ( jl_co_gl_conc_ctrl_s.currval,
3053: p_sobid,
3054: DECODE(p_rcid,NULL,p_period,NULL),
3055: p_rcid,
3056: 'E',