eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on JA_CN_CFS_ACTIVITIES_ALL

Line 250: L_GL_date ja_cn_cfs_activities_all.gl_date%type;

246: p_ccid In VARCHAR2,--Fix bug#7334017 add
247: p_cash_ae_header_id in NUMBER,
248: p_cash_ae_line_number in NUMBER, --Added by Chaoqun for fixing bug 8969631
249: P_event_type_code in varchar2) AS
250: L_GL_date ja_cn_cfs_activities_all.gl_date%type;
251: l_func_amount ja_cn_cfs_activities_all.func_amount%type;
252: l_orig_amount ja_cn_cfs_activities_all.original_amount%type;
253: l_detailed_item_desc varchar2(240);
254: l_period_name gl_periods.period_name%TYPE;

Line 251: l_func_amount ja_cn_cfs_activities_all.func_amount%type;

247: p_cash_ae_header_id in NUMBER,
248: p_cash_ae_line_number in NUMBER, --Added by Chaoqun for fixing bug 8969631
249: P_event_type_code in varchar2) AS
250: L_GL_date ja_cn_cfs_activities_all.gl_date%type;
251: l_func_amount ja_cn_cfs_activities_all.func_amount%type;
252: l_orig_amount ja_cn_cfs_activities_all.original_amount%type;
253: l_detailed_item_desc varchar2(240);
254: l_period_name gl_periods.period_name%TYPE;
255: l_application_source fnd_application.application_short_name%TYPE;

Line 252: l_orig_amount ja_cn_cfs_activities_all.original_amount%type;

248: p_cash_ae_line_number in NUMBER, --Added by Chaoqun for fixing bug 8969631
249: P_event_type_code in varchar2) AS
250: L_GL_date ja_cn_cfs_activities_all.gl_date%type;
251: l_func_amount ja_cn_cfs_activities_all.func_amount%type;
252: l_orig_amount ja_cn_cfs_activities_all.original_amount%type;
253: l_detailed_item_desc varchar2(240);
254: l_period_name gl_periods.period_name%TYPE;
255: l_application_source fnd_application.application_short_name%TYPE;
256: l_status ar_cash_receipt_history_all.status%TYPE;

Line 392: INSERT INTO ja_cn_cfs_activities_all(CFS_ACTIVITY_ID,

388: l_je_header_id := '';
389: l_je_line_num :='';
390: END;
391:
392: INSERT INTO ja_cn_cfs_activities_all(CFS_ACTIVITY_ID,
393: LEGAL_ENTITY_ID,
394: LEDGER_ID,
395: ORG_ID,
396: TRX_ID,

Line 524: l_detailed_cfs_item ja_cn_cfs_activities_all.detailed_cfs_item%type;

520:
521: -- the interim variables for activities all table
522: l_line_org_id xla_transaction_entities.security_id_int_1%TYPE;
523: l_mapping_org_id NUMBER;
524: l_detailed_cfs_item ja_cn_cfs_activities_all.detailed_cfs_item%type;
525: l_event_class_code ja_cn_cfs_item_mapping_hdrs.event_class_code%TYPE;
526:
527: --the analytical criterion variables
528: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;

Line 761: DELETE ja_cn_cfs_activities_all ca

757: END;
758:
759: -- delete the record calculated before
760: IF p_source = 'ALL' THEN
761: DELETE ja_cn_cfs_activities_all ca
762: WHERE ca.legal_entity_id = P_LE_ID
763: AND ledger_id = p_ledger_id
764: AND ca.SOURCE_application_id NOT IN (101, 435)
765: AND ca.period_name IN

Line 787: DELETE ja_cn_cfs_activities_all ca

783: INTO l_source_id
784: FROM fnd_application
785: WHERE application_short_name = p_source;
786:
787: DELETE ja_cn_cfs_activities_all ca
788: WHERE ca.legal_entity_id = P_LE_ID
789: AND ledger_id = p_ledger_id
790: AND ca.SOURCE_application_id = l_source_id
791: AND ca.period_name IN