98: FOR v_row IN electronic_accounting_book_cur(pn_legal_entity_id,
99: pn_ledger_id)
100: LOOP
101: ln_row_count := ln_row_count + 1;
102: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
103: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
104:
105: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
106: ,v_row.book_num);
99: pn_ledger_id)
100: LOOP
101: ln_row_count := ln_row_count + 1;
102: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
103: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
104:
105: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
106: ,v_row.book_num);
107: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
101: ln_row_count := ln_row_count + 1;
102: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
103: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
104:
105: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
106: ,v_row.book_num);
107: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
108: ,v_row.book_name);
109: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
103: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
104:
105: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
106: ,v_row.book_num);
107: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
108: ,v_row.book_name);
109: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
110: ,v_row.company_name);
111: Ja_Cn_Utility.Add_Child_Node('ORGANIZATION_NUMBER'
105: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
106: ,v_row.book_num);
107: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
108: ,v_row.book_name);
109: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
110: ,v_row.company_name);
111: Ja_Cn_Utility.Add_Child_Node('ORGANIZATION_NUMBER'
112: ,v_row.organization_id);
113: Ja_Cn_Utility.Add_Fixed_Child_Node('ENTERPRISE_QUALITY'
107: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
108: ,v_row.book_name);
109: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
110: ,v_row.company_name);
111: Ja_Cn_Utility.Add_Child_Node('ORGANIZATION_NUMBER'
112: ,v_row.organization_id);
113: Ja_Cn_Utility.Add_Fixed_Child_Node('ENTERPRISE_QUALITY'
114: ,v_row.ent_quality
115: ,4);
109: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
110: ,v_row.company_name);
111: Ja_Cn_Utility.Add_Child_Node('ORGANIZATION_NUMBER'
112: ,v_row.organization_id);
113: Ja_Cn_Utility.Add_Fixed_Child_Node('ENTERPRISE_QUALITY'
114: ,v_row.ent_quality
115: ,4);
116: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_INDUSTRY'
117: ,v_row.ent_industry);
112: ,v_row.organization_id);
113: Ja_Cn_Utility.Add_Fixed_Child_Node('ENTERPRISE_QUALITY'
114: ,v_row.ent_quality
115: ,4);
116: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_INDUSTRY'
117: ,v_row.ent_industry);
118: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VENDOR'
119: ,'ORACLE');
120: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
114: ,v_row.ent_quality
115: ,4);
116: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_INDUSTRY'
117: ,v_row.ent_industry);
118: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VENDOR'
119: ,'ORACLE');
120: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
121: ,v_row.software_version);
122: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
116: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_INDUSTRY'
117: ,v_row.ent_industry);
118: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VENDOR'
119: ,'ORACLE');
120: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
121: ,v_row.software_version);
122: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
123: ,v_row.name);
124: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
118: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VENDOR'
119: ,'ORACLE');
120: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
121: ,v_row.software_version);
122: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
123: ,v_row.name);
124: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
125: ,pn_accounting_year);
126: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
120: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
121: ,v_row.software_version);
122: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
123: ,v_row.name);
124: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
125: ,pn_accounting_year);
126: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
127: ,v_row.cnao_stand_ver);
128: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
122: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
123: ,v_row.name);
124: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
125: ,pn_accounting_year);
126: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
127: ,v_row.cnao_stand_ver);
128: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
129: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
130:
124: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
125: ,pn_accounting_year);
126: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
127: ,v_row.cnao_stand_ver);
128: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
129: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
130:
131: END LOOP;
132:
125: ,pn_accounting_year);
126: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
127: ,v_row.cnao_stand_ver);
128: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
129: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
130:
131: END LOOP;
132:
133: IF (ln_row_count = 0)
131: END LOOP;
132:
133: IF (ln_row_count = 0)
134: THEN
135: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ELECTRONIC_ACCOUNTING_BOOK');
136: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
137: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
138:
139: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
132:
133: IF (ln_row_count = 0)
134: THEN
135: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ELECTRONIC_ACCOUNTING_BOOK');
136: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
137: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
138:
139: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
140: ,NULL);
133: IF (ln_row_count = 0)
134: THEN
135: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ELECTRONIC_ACCOUNTING_BOOK');
136: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
137: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
138:
139: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
140: ,NULL);
141: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
135: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ELECTRONIC_ACCOUNTING_BOOK');
136: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
137: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
138:
139: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
140: ,NULL);
141: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
142: ,NULL);
143: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
137: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
138:
139: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
140: ,NULL);
141: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
142: ,NULL);
143: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
144: ,NULL);
145: Ja_Cn_Utility.Add_Child_Node('ORGANIZATION_NUMBER'
139: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NUMBER'
140: ,NULL);
141: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
142: ,NULL);
143: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
144: ,NULL);
145: Ja_Cn_Utility.Add_Child_Node('ORGANIZATION_NUMBER'
146: ,NULL);
147: Ja_Cn_Utility.Add_Fixed_Child_Node('ENTERPRISE_QUALITY'
141: Ja_Cn_Utility.Add_Child_Node('ELECTRONIC_BOOK_NAME'
142: ,NULL);
143: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
144: ,NULL);
145: Ja_Cn_Utility.Add_Child_Node('ORGANIZATION_NUMBER'
146: ,NULL);
147: Ja_Cn_Utility.Add_Fixed_Child_Node('ENTERPRISE_QUALITY'
148: ,NULL
149: ,4);
143: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_NAME'
144: ,NULL);
145: Ja_Cn_Utility.Add_Child_Node('ORGANIZATION_NUMBER'
146: ,NULL);
147: Ja_Cn_Utility.Add_Fixed_Child_Node('ENTERPRISE_QUALITY'
148: ,NULL
149: ,4);
150: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_INDUSTRY'
151: ,NULL);
146: ,NULL);
147: Ja_Cn_Utility.Add_Fixed_Child_Node('ENTERPRISE_QUALITY'
148: ,NULL
149: ,4);
150: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_INDUSTRY'
151: ,NULL);
152: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VENDOR'
153: ,NULL);
154: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
148: ,NULL
149: ,4);
150: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_INDUSTRY'
151: ,NULL);
152: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VENDOR'
153: ,NULL);
154: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
155: ,NULL);
156: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
150: Ja_Cn_Utility.Add_Child_Node('ENTERPRISE_INDUSTRY'
151: ,NULL);
152: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VENDOR'
153: ,NULL);
154: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
155: ,NULL);
156: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
157: ,NULL);
158: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
152: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VENDOR'
153: ,NULL);
154: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
155: ,NULL);
156: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
157: ,NULL);
158: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
159: ,NULL);
160: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
154: Ja_Cn_Utility.Add_Child_Node('ERP_SOFTWARE_VERSION'
155: ,NULL);
156: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
157: ,NULL);
158: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
159: ,NULL);
160: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
161: ,NULL);
162: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
156: Ja_Cn_Utility.Add_Child_Node('FUNCTIONAL_CURRENCY'
157: ,NULL);
158: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
159: ,NULL);
160: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
161: ,NULL);
162: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
163: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
164: END IF; --ln_row_count = 0
158: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
159: ,NULL);
160: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
161: ,NULL);
162: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
163: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
164: END IF; --ln_row_count = 0
165:
166: --logging for debug
159: ,NULL);
160: Ja_Cn_Utility.Add_Child_Node('CNAO_STANDARD_VERSION'
161: ,NULL);
162: Ja_Cn_Utility.Add_Sub_Root_Node('ELECTRONIC_ACCOUNTING_BOOK'
163: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
164: END IF; --ln_row_count = 0
165:
166: --logging for debug
167: IF (ln_proc_level >= ln_dbg_level) THEN