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_PS_SI_PRJ_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 94: lv_prj_seg := JA_CN_UTILITY.Get_Attribute_Column

90: || '.parameters '
91: || 'pn_coa_id=' || pn_coa_id || ','
92: || 'pv_accounting_year=' || pn_accounting_year);
93:
94: lv_prj_seg := JA_CN_UTILITY.Get_Attribute_Column
95: ( 'CPRO'
96: , 101
97: , pn_coa_id
98: );

Line 101: lv_prj_level_attr := JA_CN_UTILITY.Get_Attribute_Column

97: , pn_coa_id
98: );
99: lv_prj_id_seg := 'FLEX_VALUE';
100: lv_prj_name_seg := 'DESCRIPTION';
101: lv_prj_level_attr := JA_CN_UTILITY.Get_Attribute_Column
102: ( 'APLE'
103: , 0
104: , pn_coa_id
105: );

Line 106: lv_prj_type_attr := JA_CN_UTILITY.Get_Attribute_Column

102: ( 'APLE'
103: , 0
104: , pn_coa_id
105: );
106: lv_prj_type_attr := JA_CN_UTILITY.Get_Attribute_Column
107: ( 'APTY'
108: , 0
109: , pn_coa_id
110: );

Line 111: lv_prj_category_attr := JA_CN_UTILITY.Get_Attribute_Column

107: ( 'APTY'
108: , 0
109: , pn_coa_id
110: );
111: lv_prj_category_attr := JA_CN_UTILITY.Get_Attribute_Column
112: ( 'APCA'
113: , 0
114: , pn_coa_id
115: );

Line 116: lv_prj_attribute_attr := JA_CN_UTILITY.Get_Attribute_Column

112: ( 'APCA'
113: , 0
114: , pn_coa_id
115: );
116: lv_prj_attribute_attr := JA_CN_UTILITY.Get_Attribute_Column
117: ( 'APAT'
118: , 0
119: , pn_coa_id
120: );

Line 121: lv_prj_start_date_attr := JA_CN_UTILITY.Get_Attribute_Column

117: ( 'APAT'
118: , 0
119: , pn_coa_id
120: );
121: lv_prj_start_date_attr := JA_CN_UTILITY.Get_Attribute_Column
122: ( 'APSD'
123: , 0
124: , pn_coa_id
125: );

Line 126: lv_prj_end_date_attr := JA_CN_UTILITY.Get_Attribute_Column

122: ( 'APSD'
123: , 0
124: , pn_coa_id
125: );
126: lv_prj_end_date_attr := JA_CN_UTILITY.Get_Attribute_Column
127: ( 'APED'
128: , 0
129: , pn_coa_id
130: );

Line 233: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'

229: , lv_project_start_date
230: , lv_project_end_date;
231: EXIT WHEN v_row%NOTFOUND;
232: ln_row_count := ln_row_count + 1;
233: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
234: , JA_CN_UTILITY.GV_TAG_TYPE_START
235: );
236: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'
237: , lv_project_id

Line 234: , JA_CN_UTILITY.GV_TAG_TYPE_START

230: , lv_project_end_date;
231: EXIT WHEN v_row%NOTFOUND;
232: ln_row_count := ln_row_count + 1;
233: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
234: , JA_CN_UTILITY.GV_TAG_TYPE_START
235: );
236: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'
237: , lv_project_id
238: );

Line 236: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'

232: ln_row_count := ln_row_count + 1;
233: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
234: , JA_CN_UTILITY.GV_TAG_TYPE_START
235: );
236: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'
237: , lv_project_id
238: );
239: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_NAME'
240: , lv_project_name

Line 239: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_NAME'

235: );
236: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'
237: , lv_project_id
238: );
239: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_NAME'
240: , lv_project_name
241: );
242: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'
243: , lv_project_level

Line 242: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'

238: );
239: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_NAME'
240: , lv_project_name
241: );
242: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'
243: , lv_project_level
244: , JA_CN_UTILITY.GV_TYPE_NUMBER
245: );
246: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'

Line 244: , JA_CN_UTILITY.GV_TYPE_NUMBER

240: , lv_project_name
241: );
242: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'
243: , lv_project_level
244: , JA_CN_UTILITY.GV_TYPE_NUMBER
245: );
246: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'
247: , lv_project_type
248: );

Line 246: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'

242: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'
243: , lv_project_level
244: , JA_CN_UTILITY.GV_TYPE_NUMBER
245: );
246: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'
247: , lv_project_type
248: );
249: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_CATEGORY'
250: , lv_project_category

Line 249: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_CATEGORY'

245: );
246: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'
247: , lv_project_type
248: );
249: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_CATEGORY'
250: , lv_project_category
251: );
252: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ATTRIBUTE'
253: , lv_project_attribute

Line 252: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ATTRIBUTE'

248: );
249: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_CATEGORY'
250: , lv_project_category
251: );
252: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ATTRIBUTE'
253: , lv_project_attribute
254: );
255: IF(lv_project_start_date IS NOT NULL)
256: THEN

Line 264: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_STARTING_DATE'

260: );
261: ELSE
262: lv_project_start_date := '';
263: END IF; --(lv_project_starting_date IS NOT NULL)
264: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_STARTING_DATE'
265: , lv_project_start_date
266: , 8
267: );
268: IF(lv_project_end_date IS NOT NULL)

Line 277: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_ENDING_DATE'

273: );
274: ELSE
275: lv_project_end_date := '';
276: END IF; --(lv_project_date IS NOT NULL)
277: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_ENDING_DATE'
278: , lv_project_end_date
279: , 8
280: );
281: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'

Line 281: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'

277: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_ENDING_DATE'
278: , lv_project_end_date
279: , 8
280: );
281: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
282: , JA_CN_UTILITY.GV_TAG_TYPE_END
283: );
284: END LOOP; -- v_row LOOP
285: CLOSE v_row;

Line 282: , JA_CN_UTILITY.GV_TAG_TYPE_END

278: , lv_project_end_date
279: , 8
280: );
281: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
282: , JA_CN_UTILITY.GV_TAG_TYPE_END
283: );
284: END LOOP; -- v_row LOOP
285: CLOSE v_row;
286:

Line 290: JA_CN_UTILITY.Print_No_Data_Found_For_Log( 'PROJECT'

286:
287: --Add empty content
288: IF (ln_row_count = 0)
289: THEN
290: JA_CN_UTILITY.Print_No_Data_Found_For_Log( 'PROJECT'
291: , JA_CN_UTILITY.GV_MODULE_GLSI
292: );
293: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
294: , JA_CN_UTILITY.GV_TAG_TYPE_START

Line 291: , JA_CN_UTILITY.GV_MODULE_GLSI

287: --Add empty content
288: IF (ln_row_count = 0)
289: THEN
290: JA_CN_UTILITY.Print_No_Data_Found_For_Log( 'PROJECT'
291: , JA_CN_UTILITY.GV_MODULE_GLSI
292: );
293: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
294: , JA_CN_UTILITY.GV_TAG_TYPE_START
295: );

Line 293: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'

289: THEN
290: JA_CN_UTILITY.Print_No_Data_Found_For_Log( 'PROJECT'
291: , JA_CN_UTILITY.GV_MODULE_GLSI
292: );
293: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
294: , JA_CN_UTILITY.GV_TAG_TYPE_START
295: );
296: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'
297: , NULL

Line 294: , JA_CN_UTILITY.GV_TAG_TYPE_START

290: JA_CN_UTILITY.Print_No_Data_Found_For_Log( 'PROJECT'
291: , JA_CN_UTILITY.GV_MODULE_GLSI
292: );
293: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
294: , JA_CN_UTILITY.GV_TAG_TYPE_START
295: );
296: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'
297: , NULL
298: );

Line 296: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'

292: );
293: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
294: , JA_CN_UTILITY.GV_TAG_TYPE_START
295: );
296: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'
297: , NULL
298: );
299: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_NAME'
300: , NULL

Line 299: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_NAME'

295: );
296: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ID'
297: , NULL
298: );
299: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_NAME'
300: , NULL
301: );
302: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'
303: , NULL

Line 302: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'

298: );
299: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_NAME'
300: , NULL
301: );
302: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'
303: , NULL
304: , JA_CN_UTILITY.GV_TYPE_NUMBER
305: );
306: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'

Line 304: , JA_CN_UTILITY.GV_TYPE_NUMBER

300: , NULL
301: );
302: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'
303: , NULL
304: , JA_CN_UTILITY.GV_TYPE_NUMBER
305: );
306: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'
307: , NULL
308: );

Line 306: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'

302: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_LEVEL'
303: , NULL
304: , JA_CN_UTILITY.GV_TYPE_NUMBER
305: );
306: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'
307: , NULL
308: );
309: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_CATEGORY'
310: , NULL

Line 309: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_CATEGORY'

305: );
306: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_TYPE'
307: , NULL
308: );
309: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_CATEGORY'
310: , NULL
311: );
312: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ATTRIBUTE'
313: , NULL

Line 312: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ATTRIBUTE'

308: );
309: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_CATEGORY'
310: , NULL
311: );
312: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ATTRIBUTE'
313: , NULL
314: );
315: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_STARTING_DATE'
316: , NULL

Line 315: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_STARTING_DATE'

311: );
312: JA_CN_UTILITY.Add_Child_Node( 'PROJECT_ATTRIBUTE'
313: , NULL
314: );
315: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_STARTING_DATE'
316: , NULL
317: , 8
318: );
319: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_ENDING_DATE'

Line 319: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_ENDING_DATE'

315: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_STARTING_DATE'
316: , NULL
317: , 8
318: );
319: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_ENDING_DATE'
320: , NULL
321: , 8
322: );
323: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'

Line 323: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'

319: JA_CN_UTILITY.Add_Fixed_Child_Node( 'PROJECT_ENDING_DATE'
320: , NULL
321: , 8
322: );
323: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
324: , JA_CN_UTILITY.GV_TAG_TYPE_END
325: );
326: END IF; -- (ln_row_count = 0)
327: --logging for debug

Line 324: , JA_CN_UTILITY.GV_TAG_TYPE_END

320: , NULL
321: , 8
322: );
323: JA_CN_UTILITY.Add_Sub_Root_Node( 'PROJECT'
324: , JA_CN_UTILITY.GV_TAG_TYPE_END
325: );
326: END IF; -- (ln_row_count = 0)
327: --logging for debug
328: IF (ln_proc_level >= ln_dbg_level)