109: ln_row_count := 0;
110: FOR v_row IN journal_categories_cur(pn_legal_entity_id,
111: pn_accounting_year) LOOP
112: ln_row_count := ln_row_count + 1;
113: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
114: Ja_Cn_Utility.GV_TAG_TYPE_START);
115: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
116: v_row.je_category_name);
117: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME',
110: FOR v_row IN journal_categories_cur(pn_legal_entity_id,
111: pn_accounting_year) LOOP
112: ln_row_count := ln_row_count + 1;
113: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
114: Ja_Cn_Utility.GV_TAG_TYPE_START);
115: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
116: v_row.je_category_name);
117: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME',
118: v_row.User_Je_Category_Name);
111: pn_accounting_year) LOOP
112: ln_row_count := ln_row_count + 1;
113: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
114: Ja_Cn_Utility.GV_TAG_TYPE_START);
115: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
116: v_row.je_category_name);
117: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME',
118: v_row.User_Je_Category_Name);
119: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME',
113: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
114: Ja_Cn_Utility.GV_TAG_TYPE_START);
115: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
116: v_row.je_category_name);
117: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME',
118: v_row.User_Je_Category_Name);
119: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME',
120: v_row.Je_Category_Key);
121: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
115: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER',
116: v_row.je_category_name);
117: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME',
118: v_row.User_Je_Category_Name);
119: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME',
120: v_row.Je_Category_Key);
121: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
122: Ja_Cn_Utility.GV_TAG_TYPE_END);
123: END LOOP;
117: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME',
118: v_row.User_Je_Category_Name);
119: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME',
120: v_row.Je_Category_Key);
121: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
122: Ja_Cn_Utility.GV_TAG_TYPE_END);
123: END LOOP;
124:
125: IF (ln_row_count = 0) THEN
118: v_row.User_Je_Category_Name);
119: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME',
120: v_row.Je_Category_Key);
121: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
122: Ja_Cn_Utility.GV_TAG_TYPE_END);
123: END LOOP;
124:
125: IF (ln_row_count = 0) THEN
126: Ja_Cn_Utility.Print_No_Data_Found_For_Log('JOURNAL_CATEGORY');
122: Ja_Cn_Utility.GV_TAG_TYPE_END);
123: END LOOP;
124:
125: IF (ln_row_count = 0) THEN
126: Ja_Cn_Utility.Print_No_Data_Found_For_Log('JOURNAL_CATEGORY');
127: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
128: Ja_Cn_Utility.GV_TAG_TYPE_START);
129: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
130: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME', NULL);
123: END LOOP;
124:
125: IF (ln_row_count = 0) THEN
126: Ja_Cn_Utility.Print_No_Data_Found_For_Log('JOURNAL_CATEGORY');
127: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
128: Ja_Cn_Utility.GV_TAG_TYPE_START);
129: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
130: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME', NULL);
131: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME', NULL);
124:
125: IF (ln_row_count = 0) THEN
126: Ja_Cn_Utility.Print_No_Data_Found_For_Log('JOURNAL_CATEGORY');
127: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
128: Ja_Cn_Utility.GV_TAG_TYPE_START);
129: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
130: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME', NULL);
131: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME', NULL);
132: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
125: IF (ln_row_count = 0) THEN
126: Ja_Cn_Utility.Print_No_Data_Found_For_Log('JOURNAL_CATEGORY');
127: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
128: Ja_Cn_Utility.GV_TAG_TYPE_START);
129: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
130: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME', NULL);
131: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME', NULL);
132: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
133: Ja_Cn_Utility.GV_TAG_TYPE_END);
126: Ja_Cn_Utility.Print_No_Data_Found_For_Log('JOURNAL_CATEGORY');
127: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
128: Ja_Cn_Utility.GV_TAG_TYPE_START);
129: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
130: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME', NULL);
131: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME', NULL);
132: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
133: Ja_Cn_Utility.GV_TAG_TYPE_END);
134: END IF; --ln_row_count = 0
127: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
128: Ja_Cn_Utility.GV_TAG_TYPE_START);
129: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
130: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME', NULL);
131: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME', NULL);
132: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
133: Ja_Cn_Utility.GV_TAG_TYPE_END);
134: END IF; --ln_row_count = 0
135:
128: Ja_Cn_Utility.GV_TAG_TYPE_START);
129: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
130: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME', NULL);
131: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME', NULL);
132: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
133: Ja_Cn_Utility.GV_TAG_TYPE_END);
134: END IF; --ln_row_count = 0
135:
136: --logging for debug
129: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NUMBER', NULL);
130: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_NAME', NULL);
131: Ja_Cn_Utility.Add_Child_Node('JOURNAL_CATEGORY_SHORT_NAME', NULL);
132: Ja_Cn_Utility.Add_Sub_Root_Node('JOURNAL_CATEGORY',
133: Ja_Cn_Utility.GV_TAG_TYPE_END);
134: END IF; --ln_row_count = 0
135:
136: --logging for debug
137: IF (ln_proc_level >= ln_dbg_level) THEN