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_IMA_PKG dependencies on JA_CN_CFS_ITEM_MAPPING_HDRS

Line 66: l_Application_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Application_Id%type:=P_APLICATION_ID;

62: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
63: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
64: l_proc_name VARCHAR2(100) :='Cash Flow Item Mappings Report';
65:
66: l_Application_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Application_Id%type:=P_APLICATION_ID;
67: l_Event_Class_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Event_Class_Code%type:=P_EVENT_CLASS_CODE;
68: l_Analyciatl_Criterion_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Analytical_Criterion_Code%type:=P_SUPPORTING_REFERENCE_CODE;
69: l_Chart_Of_Accounts_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Chart_Of_Accounts_Id%type:=P_CHART_OF_ACCOUNTS_ID;
70: l_Mapping_Header_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Mapping_Header_Id%type;

Line 67: l_Event_Class_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Event_Class_Code%type:=P_EVENT_CLASS_CODE;

63: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
64: l_proc_name VARCHAR2(100) :='Cash Flow Item Mappings Report';
65:
66: l_Application_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Application_Id%type:=P_APLICATION_ID;
67: l_Event_Class_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Event_Class_Code%type:=P_EVENT_CLASS_CODE;
68: l_Analyciatl_Criterion_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Analytical_Criterion_Code%type:=P_SUPPORTING_REFERENCE_CODE;
69: l_Chart_Of_Accounts_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Chart_Of_Accounts_Id%type:=P_CHART_OF_ACCOUNTS_ID;
70: l_Mapping_Header_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Mapping_Header_Id%type;
71: l_h_effective_start_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_Start_Date%type;

Line 68: l_Analyciatl_Criterion_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Analytical_Criterion_Code%type:=P_SUPPORTING_REFERENCE_CODE;

64: l_proc_name VARCHAR2(100) :='Cash Flow Item Mappings Report';
65:
66: l_Application_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Application_Id%type:=P_APLICATION_ID;
67: l_Event_Class_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Event_Class_Code%type:=P_EVENT_CLASS_CODE;
68: l_Analyciatl_Criterion_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Analytical_Criterion_Code%type:=P_SUPPORTING_REFERENCE_CODE;
69: l_Chart_Of_Accounts_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Chart_Of_Accounts_Id%type:=P_CHART_OF_ACCOUNTS_ID;
70: l_Mapping_Header_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Mapping_Header_Id%type;
71: l_h_effective_start_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_Start_Date%type;
72: l_h_effective_end_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_End_Date%type;

Line 69: l_Chart_Of_Accounts_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Chart_Of_Accounts_Id%type:=P_CHART_OF_ACCOUNTS_ID;

65:
66: l_Application_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Application_Id%type:=P_APLICATION_ID;
67: l_Event_Class_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Event_Class_Code%type:=P_EVENT_CLASS_CODE;
68: l_Analyciatl_Criterion_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Analytical_Criterion_Code%type:=P_SUPPORTING_REFERENCE_CODE;
69: l_Chart_Of_Accounts_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Chart_Of_Accounts_Id%type:=P_CHART_OF_ACCOUNTS_ID;
70: l_Mapping_Header_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Mapping_Header_Id%type;
71: l_h_effective_start_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_Start_Date%type;
72: l_h_effective_end_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_End_Date%type;
73: l_Application_Name FND_APPLICATION_TL.Application_Name%type;

Line 70: l_Mapping_Header_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Mapping_Header_Id%type;

66: l_Application_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Application_Id%type:=P_APLICATION_ID;
67: l_Event_Class_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Event_Class_Code%type:=P_EVENT_CLASS_CODE;
68: l_Analyciatl_Criterion_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Analytical_Criterion_Code%type:=P_SUPPORTING_REFERENCE_CODE;
69: l_Chart_Of_Accounts_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Chart_Of_Accounts_Id%type:=P_CHART_OF_ACCOUNTS_ID;
70: l_Mapping_Header_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Mapping_Header_Id%type;
71: l_h_effective_start_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_Start_Date%type;
72: l_h_effective_end_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_End_Date%type;
73: l_Application_Name FND_APPLICATION_TL.Application_Name%type;
74: l_Event_Class_Name xla_event_classes_TL.Name%type;

Line 71: l_h_effective_start_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_Start_Date%type;

67: l_Event_Class_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Event_Class_Code%type:=P_EVENT_CLASS_CODE;
68: l_Analyciatl_Criterion_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Analytical_Criterion_Code%type:=P_SUPPORTING_REFERENCE_CODE;
69: l_Chart_Of_Accounts_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Chart_Of_Accounts_Id%type:=P_CHART_OF_ACCOUNTS_ID;
70: l_Mapping_Header_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Mapping_Header_Id%type;
71: l_h_effective_start_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_Start_Date%type;
72: l_h_effective_end_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_End_Date%type;
73: l_Application_Name FND_APPLICATION_TL.Application_Name%type;
74: l_Event_Class_Name xla_event_classes_TL.Name%type;
75: l_source_name Xla_Sources_tl.Name%type;

Line 72: l_h_effective_end_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_End_Date%type;

68: l_Analyciatl_Criterion_Code Ja_Cn_Cfs_Item_Mapping_Hdrs.Analytical_Criterion_Code%type:=P_SUPPORTING_REFERENCE_CODE;
69: l_Chart_Of_Accounts_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Chart_Of_Accounts_Id%type:=P_CHART_OF_ACCOUNTS_ID;
70: l_Mapping_Header_Id Ja_Cn_Cfs_Item_Mapping_Hdrs.Mapping_Header_Id%type;
71: l_h_effective_start_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_Start_Date%type;
72: l_h_effective_end_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_End_Date%type;
73: l_Application_Name FND_APPLICATION_TL.Application_Name%type;
74: l_Event_Class_Name xla_event_classes_TL.Name%type;
75: l_source_name Xla_Sources_tl.Name%type;
76: l_org_id ja_cn_cfs_item_mapping_lines.org_id%type;

Line 105: FROM Ja_Cn_Cfs_Item_Mapping_Hdrs Hdr

101: hdr.effective_end_date,
102: hdr.application_id,
103: hdr.event_class_code,
104: hdr.analytical_criterion_code
105: FROM Ja_Cn_Cfs_Item_Mapping_Hdrs Hdr
106: WHERE Hdr.Application_Id = nvl(l_Application_Id,Hdr.Application_Id)
107: AND Hdr.Event_Class_Code = nvl(l_Event_Class_Code,Hdr.Event_Class_Code)
108: AND Hdr.Analytical_Criterion_Code = nvl(l_Analyciatl_Criterion_Code,Hdr.Analytical_Criterion_Code)
109: AND Hdr.Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;

Line 169: FROM Ja_Cn_Cfs_Item_Mapping_Hdrs Cim,

165:
166: --get source name
167: CURSOR c_source_name is
168: SELECT St.Name
169: FROM Ja_Cn_Cfs_Item_Mapping_Hdrs Cim,
170: Xla_Analytical_Hdrs_Tl Ah,
171: Xla_Analytical_Dtls_Tl Ad,
172: Xla_Analytical_Dtls_b Adl,
173: Xla_Analytical_Sources Sur,