312: LOOP
313: FETCH coa_value_name_desc_cur INTO lv_record_value_number,lv_record_value_desc;
314: EXIT WHEN coa_value_name_desc_cur%NOTFOUND;
315:
316: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
317: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
318: );
319: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_NUMBER'
320: , pv_text_node_value => ln_record_number
313: FETCH coa_value_name_desc_cur INTO lv_record_value_number,lv_record_value_desc;
314: EXIT WHEN coa_value_name_desc_cur%NOTFOUND;
315:
316: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
317: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
318: );
319: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_NUMBER'
320: , pv_text_node_value => ln_record_number
321: );
315:
316: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
317: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
318: );
319: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_NUMBER'
320: , pv_text_node_value => ln_record_number
321: );
322: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NUMBER'
323: , pv_text_node_value => lv_record_value_number
318: );
319: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_NUMBER'
320: , pv_text_node_value => ln_record_number
321: );
322: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NUMBER'
323: , pv_text_node_value => lv_record_value_number
324: );
325: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NAME'
326: , pv_text_node_value => lv_record_value_number
321: );
322: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NUMBER'
323: , pv_text_node_value => lv_record_value_number
324: );
325: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NAME'
326: , pv_text_node_value => lv_record_value_number
327: );
328: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_DESCRIPTION'
329: , pv_text_node_value => lv_record_value_desc
324: );
325: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NAME'
326: , pv_text_node_value => lv_record_value_number
327: );
328: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_DESCRIPTION'
329: , pv_text_node_value => lv_record_value_desc
330: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
331: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
332: );
326: , pv_text_node_value => lv_record_value_number
327: );
328: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_DESCRIPTION'
329: , pv_text_node_value => lv_record_value_desc
330: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
331: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
332: );
333: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
334: , pv_text_node_value => null
327: );
328: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_DESCRIPTION'
329: , pv_text_node_value => lv_record_value_desc
330: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
331: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
332: );
333: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
334: , pv_text_node_value => null
335: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
329: , pv_text_node_value => lv_record_value_desc
330: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
331: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
332: );
333: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
334: , pv_text_node_value => null
335: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
336: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
337: );
331: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
332: );
333: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
334: , pv_text_node_value => null
335: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
336: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
337: );
338: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'LEVEL'
339: , pv_text_node_value => '1'
332: );
333: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
334: , pv_text_node_value => null
335: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
336: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
337: );
338: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'LEVEL'
339: , pv_text_node_value => '1'
340: );
334: , pv_text_node_value => null
335: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
336: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
337: );
338: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'LEVEL'
339: , pv_text_node_value => '1'
340: );
341:
342: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
338: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'LEVEL'
339: , pv_text_node_value => '1'
340: );
341:
342: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
343: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
344: );
345:
346: END LOOP;
339: , pv_text_node_value => '1'
340: );
341:
342: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
343: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
344: );
345:
346: END LOOP;
347: CLOSE coa_value_name_desc_cur;
357: LOOP
358: FETCH project_value_name_desc_cur INTO lv_record_value_number,lv_record_value_name,lv_record_value_desc;
359: EXIT WHEN project_value_name_desc_cur%NOTFOUND;
360:
361: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
362: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
363: );
364: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_NUMBER'
365: , pv_text_node_value => ln_record_number
358: FETCH project_value_name_desc_cur INTO lv_record_value_number,lv_record_value_name,lv_record_value_desc;
359: EXIT WHEN project_value_name_desc_cur%NOTFOUND;
360:
361: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
362: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
363: );
364: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_NUMBER'
365: , pv_text_node_value => ln_record_number
366: );
360:
361: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
362: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
363: );
364: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_NUMBER'
365: , pv_text_node_value => ln_record_number
366: );
367: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NUMBER'
368: , pv_text_node_value => lv_record_value_number
363: );
364: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_NUMBER'
365: , pv_text_node_value => ln_record_number
366: );
367: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NUMBER'
368: , pv_text_node_value => lv_record_value_number
369: );
370: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NAME'
371: , pv_text_node_value => lv_record_value_name
366: );
367: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NUMBER'
368: , pv_text_node_value => lv_record_value_number
369: );
370: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NAME'
371: , pv_text_node_value => lv_record_value_name
372: );
373: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_DESCRIPTION'
374: , pv_text_node_value => lv_record_value_desc
369: );
370: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_NAME'
371: , pv_text_node_value => lv_record_value_name
372: );
373: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_DESCRIPTION'
374: , pv_text_node_value => lv_record_value_desc
375: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
376: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
377: );
371: , pv_text_node_value => lv_record_value_name
372: );
373: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_DESCRIPTION'
374: , pv_text_node_value => lv_record_value_desc
375: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
376: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
377: );
378: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
379: , pv_text_node_value => null
372: );
373: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'RECORD_VALUE_DESCRIPTION'
374: , pv_text_node_value => lv_record_value_desc
375: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
376: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
377: );
378: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
379: , pv_text_node_value => null
380: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
374: , pv_text_node_value => lv_record_value_desc
375: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
376: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
377: );
378: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
379: , pv_text_node_value => null
380: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
381: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
382: );
376: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
377: );
378: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
379: , pv_text_node_value => null
380: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
381: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
382: );
383: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'LEVEL'
384: , pv_text_node_value => '1'
377: );
378: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'PARENT_RECORD_VALUE_NUMBER'
379: , pv_text_node_value => null
380: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
381: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
382: );
383: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'LEVEL'
384: , pv_text_node_value => '1'
385: );
379: , pv_text_node_value => null
380: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
381: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
382: );
383: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'LEVEL'
384: , pv_text_node_value => '1'
385: );
386: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
387: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
382: );
383: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'LEVEL'
384: , pv_text_node_value => '1'
385: );
386: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
387: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
388: );
389: END LOOP;
390: CLOSE project_value_name_desc_cur;
383: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'LEVEL'
384: , pv_text_node_value => '1'
385: );
386: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'USER_DEFINED_RECORD_VALUE'
387: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
388: );
389: END LOOP;
390: CLOSE project_value_name_desc_cur;
391: END IF; --(lv_source_code = 'Project Module')