APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on JL_CO_GL_CONC_CTRL

Line 107: cid jl_co_gl_conc_ctrl.process_id%type,

103: AND gljh.actual_flag = 'A'
104: AND gljh.currency_code <> 'STAT';
105:
106: TYPE t_parameters IS RECORD (
107: cid jl_co_gl_conc_ctrl.process_id%type,
108: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,
109: user_id jl_co_gl_conc_ctrl.created_by%type,
110: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
111:

Line 108: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,

104: AND gljh.currency_code <> 'STAT';
105:
106: TYPE t_parameters IS RECORD (
107: cid jl_co_gl_conc_ctrl.process_id%type,
108: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,
109: user_id jl_co_gl_conc_ctrl.created_by%type,
110: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
111:
112: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,

Line 109: user_id jl_co_gl_conc_ctrl.created_by%type,

105:
106: TYPE t_parameters IS RECORD (
107: cid jl_co_gl_conc_ctrl.process_id%type,
108: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,
109: user_id jl_co_gl_conc_ctrl.created_by%type,
110: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
111:
112: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,
113: nit jl_co_gl_nits.nit%type,

Line 110: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);

106: TYPE t_parameters IS RECORD (
107: cid jl_co_gl_conc_ctrl.process_id%type,
108: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,
109: user_id jl_co_gl_conc_ctrl.created_by%type,
110: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
111:
112: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,
113: nit jl_co_gl_nits.nit%type,
114: nit_name jl_co_gl_nits.name%type,

Line 1783: FROM jl_co_gl_conc_ctrl

1779: NVL(sum(jlcgt.accounted_dr),0) acc_dr,
1780: NVL(sum(jlcgt.accounted_cr),0) acc_cr
1781: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt
1782: WHERE jlcgt.process_id IN ( SELECT process_id
1783: FROM jl_co_gl_conc_ctrl
1784: WHERE NVL(balance_calculated,'N') <> 'Y'
1785: AND set_of_books_id
1786: = g_parameter_rec.set_of_books_id)
1787: AND jlcgt.code_combination_id = glcc.code_combination_id

Line 1970: UPDATE jl_co_gl_conc_ctrl

1966: trx.peryear * 100);
1967:
1968: END LOOP;
1969:
1970: UPDATE jl_co_gl_conc_ctrl
1971: SET status = DECODE(process_id,p_cid,'P',status),
1972: balance_calculated = 'Y',
1973: last_update_date = sysdate,
1974: last_updated_by = p_userid,

Line 2094: UPDATE jl_co_gl_conc_ctrl

2090:
2091: DELETE FROM jl_co_gl_trx
2092: WHERE process_id = p_rcid ;
2093:
2094: UPDATE jl_co_gl_conc_ctrl
2095: SET status = 'P',
2096: reversed_process_id = p_rcid,
2097: last_update_date = sysdate,
2098: last_updated_by = p_userid,

Line 2102: UPDATE jl_co_gl_conc_ctrl

2098: last_updated_by = p_userid,
2099: last_update_login = g_login_id
2100: WHERE process_id = p_cid;
2101:
2102: UPDATE jl_co_gl_conc_ctrl
2103: SET status = 'R',
2104: last_update_date = sysdate,
2105: last_updated_by = p_userid,
2106: last_update_login = g_login_id

Line 2161: SELECT jl_co_gl_conc_ctrl_s.nextval,

2157: SELECT TO_NUMBER(NVL(fnd_profile.value('LOGIN_ID'),-1))
2158: INTO g_login_id
2159: FROM DUAL;
2160:
2161: SELECT jl_co_gl_conc_ctrl_s.nextval,
2162: p_sobid,
2163: TO_NUMBER(NVL(fnd_profile.value('USER_ID') ,-1)),
2164: p_rcid
2165: INTO g_parameter_rec

Line 2168: INSERT INTO jl_co_gl_conc_ctrl (

2164: p_rcid
2165: INTO g_parameter_rec
2166: FROM dual;
2167:
2168: INSERT INTO jl_co_gl_conc_ctrl (
2169: process_id,
2170: set_of_books_id,
2171: period_name,
2172: reversed_process_id,

Line 2180: VALUES ( jl_co_gl_conc_ctrl_s.currval,

2176: last_update_date,
2177: last_updated_by,
2178: last_update_login,
2179: balance_calculated)
2180: VALUES ( jl_co_gl_conc_ctrl_s.currval,
2181: p_sobid,
2182: DECODE(p_rcid,NULL,p_period,NULL),
2183: p_rcid,
2184: 'E',