APPS.JA_CN_CFS_INT_PKG dependencies on JA_CN_CFS_ACTIVITIES_INTERFACE

Line 76: -- ja_cn_cfs_activities_all from ja_cn_cfs_activities_interface

72: -- insert_sla_data Public
73: --
74: -- DESCRIPTION:
75: -- This procedure is used to insert the record into
76: -- ja_cn_cfs_activities_all from ja_cn_cfs_activities_interface
77: --
78: -- PARAMETERS:
79: -- In: p_coa_id Chart of Accounts id
80: -- p_ledger_id Ledger ID

Line 169: FROM ja_cn_cfs_activities_interface

165: fnd_global.user_id,
166: SYSDATE,
167: fnd_global.user_id,
168: fnd_global.LOGIN_ID
169: FROM ja_cn_cfs_activities_interface
170: WHERE legal_entity_id = p_legal_entity_id
171: AND ledger_id = p_ledger_id
172: AND status = 'S';
173: END;

Line 199: l_period_name ja_cn_cfs_activities_interface.period_name%TYPE;

195: P_LEDGER_ID IN NUMBER,
196: P_legal_entity_ID IN NUMBER) AS
197: l_procedure_name VARCHAR2(30) := 'import_CFS_data';
198: l_rowid VARCHAR2(300);
199: l_period_name ja_cn_cfs_activities_interface.period_name%TYPE;
200: l_func_curr_code ja_cn_cfs_activities_interface.func_curr_code%TYPE;
201: l_detailed_cfs_item ja_cn_cfs_activities_interface.detailed_cfs_item%TYPE;
202: l_flag VARCHAR2(1);
203: l_number NUMBER;

Line 200: l_func_curr_code ja_cn_cfs_activities_interface.func_curr_code%TYPE;

196: P_legal_entity_ID IN NUMBER) AS
197: l_procedure_name VARCHAR2(30) := 'import_CFS_data';
198: l_rowid VARCHAR2(300);
199: l_period_name ja_cn_cfs_activities_interface.period_name%TYPE;
200: l_func_curr_code ja_cn_cfs_activities_interface.func_curr_code%TYPE;
201: l_detailed_cfs_item ja_cn_cfs_activities_interface.detailed_cfs_item%TYPE;
202: l_flag VARCHAR2(1);
203: l_number NUMBER;
204: l_trx_number ja_cn_cfs_activities_interface.trx_number%TYPE;

Line 201: l_detailed_cfs_item ja_cn_cfs_activities_interface.detailed_cfs_item%TYPE;

197: l_procedure_name VARCHAR2(30) := 'import_CFS_data';
198: l_rowid VARCHAR2(300);
199: l_period_name ja_cn_cfs_activities_interface.period_name%TYPE;
200: l_func_curr_code ja_cn_cfs_activities_interface.func_curr_code%TYPE;
201: l_detailed_cfs_item ja_cn_cfs_activities_interface.detailed_cfs_item%TYPE;
202: l_flag VARCHAR2(1);
203: l_number NUMBER;
204: l_trx_number ja_cn_cfs_activities_interface.trx_number%TYPE;
205: l_trx_date ja_cn_cfs_activities_interface.transaction_date%TYPE;

Line 204: l_trx_number ja_cn_cfs_activities_interface.trx_number%TYPE;

200: l_func_curr_code ja_cn_cfs_activities_interface.func_curr_code%TYPE;
201: l_detailed_cfs_item ja_cn_cfs_activities_interface.detailed_cfs_item%TYPE;
202: l_flag VARCHAR2(1);
203: l_number NUMBER;
204: l_trx_number ja_cn_cfs_activities_interface.trx_number%TYPE;
205: l_trx_date ja_cn_cfs_activities_interface.transaction_date%TYPE;
206: l_msg varchar2(2000);
207:
208: CURSOR c_activities IS

Line 205: l_trx_date ja_cn_cfs_activities_interface.transaction_date%TYPE;

201: l_detailed_cfs_item ja_cn_cfs_activities_interface.detailed_cfs_item%TYPE;
202: l_flag VARCHAR2(1);
203: l_number NUMBER;
204: l_trx_number ja_cn_cfs_activities_interface.trx_number%TYPE;
205: l_trx_date ja_cn_cfs_activities_interface.transaction_date%TYPE;
206: l_msg varchar2(2000);
207:
208: CURSOR c_activities IS
209: SELECT ROWID,

Line 215: FROM ja_cn_cfs_activities_interface

211: func_curr_code,
212: detailed_cfs_item,
213: trx_number,
214: transaction_date
215: FROM ja_cn_cfs_activities_interface
216: WHERE ledger_id = p_ledger_id
217: AND legal_entity_id = p_legal_entity_id;
218:
219: BEGIN

Line 222: DELETE FROM ja_cn_cfs_activities_interface

218:
219: BEGIN
220:
221: --Delete the data whose status is 'Error' and 'Success' in interface table
222: DELETE FROM ja_cn_cfs_activities_interface
223: WHERE ledger_id = p_ledger_id
224: AND legal_entity_id = p_legal_entity_id
225: AND (status = 'E' OR status = 'S');
226:

Line 304: UPDATE ja_cn_cfs_activities_interface

300: RETCODE := 1;
301: END IF;
302:
303: IF l_flag = 'S' THEN
304: UPDATE ja_cn_cfs_activities_interface
305: SET status = 'S'
306: WHERE ROWID = l_rowid;
307: END IF;
308:

Line 310: UPDATE ja_cn_cfs_activities_interface

306: WHERE ROWID = l_rowid;
307: END IF;
308:
309: IF l_flag = 'E' THEN
310: UPDATE ja_cn_cfs_activities_interface
311: SET status = 'E'
312: WHERE ROWID = l_rowid;
313: END IF;
314: END LOOP;