86: ln_row_count := 0;
87: FOR v_row IN accounting_periods_cur(pn_accounting_year, pn_ledger_id)
88: LOOP
89: ln_row_count := ln_row_count + 1;
90: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD',
91: Ja_Cn_Utility.GV_TAG_TYPE_START);
92: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
93: ,v_row.period_year
94: ,4);
87: FOR v_row IN accounting_periods_cur(pn_accounting_year, pn_ledger_id)
88: LOOP
89: ln_row_count := ln_row_count + 1;
90: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD',
91: Ja_Cn_Utility.GV_TAG_TYPE_START);
92: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
93: ,v_row.period_year
94: ,4);
95: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
88: LOOP
89: ln_row_count := ln_row_count + 1;
90: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD',
91: Ja_Cn_Utility.GV_TAG_TYPE_START);
92: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
93: ,v_row.period_year
94: ,4);
95: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
96: ,v_row.period_num);
91: Ja_Cn_Utility.GV_TAG_TYPE_START);
92: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
93: ,v_row.period_year
94: ,4);
95: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
96: ,v_row.period_num);
97: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
98: ,to_char(v_row.start_date
99: ,'YYYYMMDD')
93: ,v_row.period_year
94: ,4);
95: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
96: ,v_row.period_num);
97: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
98: ,to_char(v_row.start_date
99: ,'YYYYMMDD')
100: ,8);
101: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
97: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
98: ,to_char(v_row.start_date
99: ,'YYYYMMDD')
100: ,8);
101: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
102: ,to_char(v_row.end_date, 'YYYYMMDD')
103: ,8);
104: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
105: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
100: ,8);
101: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
102: ,to_char(v_row.end_date, 'YYYYMMDD')
103: ,8);
104: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
105: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
106:
107: END LOOP;
108:
101: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
102: ,to_char(v_row.end_date, 'YYYYMMDD')
103: ,8);
104: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
105: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
106:
107: END LOOP;
108:
109: IF (ln_row_count = 0)
107: END LOOP;
108:
109: IF (ln_row_count = 0)
110: THEN
111: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ACCOUNTING_PERIOD');
112: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL
108:
109: IF (ln_row_count = 0)
110: THEN
111: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ACCOUNTING_PERIOD');
112: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL
116: ,4);
109: IF (ln_row_count = 0)
110: THEN
111: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ACCOUNTING_PERIOD');
112: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL
116: ,4);
117: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
110: THEN
111: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ACCOUNTING_PERIOD');
112: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL
116: ,4);
117: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
118: ,NULL);
113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL
116: ,4);
117: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
118: ,NULL);
119: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
120: ,NULL
121: ,8);
115: ,NULL
116: ,4);
117: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
118: ,NULL);
119: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
120: ,NULL
121: ,8);
122: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
123: ,NULL
118: ,NULL);
119: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
120: ,NULL
121: ,8);
122: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
123: ,NULL
124: ,8);
125: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
126: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
121: ,8);
122: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
123: ,NULL
124: ,8);
125: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
126: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
127: END IF; --ln_row_count = 0
128:
129: --logging for debug
122: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
123: ,NULL
124: ,8);
125: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
126: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
127: END IF; --ln_row_count = 0
128:
129: --logging for debug
130: IF (ln_proc_level >= ln_dbg_level)