69: END IF; --ln_proc_level>=ln_dbg_level
70:
71: FOR v_row IN doc_type_cur
72: LOOP
73: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
74: ,Ja_Cn_Utility.GV_TAG_TYPE_START
75: ,Ja_Cn_Utility.GV_MODULE_APAR
76: );
77: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE_NUMBER'
70:
71: FOR v_row IN doc_type_cur
72: LOOP
73: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
74: ,Ja_Cn_Utility.GV_TAG_TYPE_START
75: ,Ja_Cn_Utility.GV_MODULE_APAR
76: );
77: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE_NUMBER'
78: ,v_row.Doc_Type_Num
71: FOR v_row IN doc_type_cur
72: LOOP
73: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
74: ,Ja_Cn_Utility.GV_TAG_TYPE_START
75: ,Ja_Cn_Utility.GV_MODULE_APAR
76: );
77: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE_NUMBER'
78: ,v_row.Doc_Type_Num
79: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
73: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
74: ,Ja_Cn_Utility.GV_TAG_TYPE_START
75: ,Ja_Cn_Utility.GV_MODULE_APAR
76: );
77: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE_NUMBER'
78: ,v_row.Doc_Type_Num
79: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
80: ,Ja_Cn_Utility.GV_REQUIRED_YES
81: ,Ja_Cn_Utility.GV_MODULE_APAR
75: ,Ja_Cn_Utility.GV_MODULE_APAR
76: );
77: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE_NUMBER'
78: ,v_row.Doc_Type_Num
79: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
80: ,Ja_Cn_Utility.GV_REQUIRED_YES
81: ,Ja_Cn_Utility.GV_MODULE_APAR
82: );
83: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
76: );
77: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE_NUMBER'
78: ,v_row.Doc_Type_Num
79: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
80: ,Ja_Cn_Utility.GV_REQUIRED_YES
81: ,Ja_Cn_Utility.GV_MODULE_APAR
82: );
83: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
84: ,v_row.Doc_Num
77: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE_NUMBER'
78: ,v_row.Doc_Type_Num
79: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
80: ,Ja_Cn_Utility.GV_REQUIRED_YES
81: ,Ja_Cn_Utility.GV_MODULE_APAR
82: );
83: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
84: ,v_row.Doc_Num
85: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
79: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
80: ,Ja_Cn_Utility.GV_REQUIRED_YES
81: ,Ja_Cn_Utility.GV_MODULE_APAR
82: );
83: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
84: ,v_row.Doc_Num
85: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
86: ,Ja_Cn_Utility.GV_REQUIRED_YES
87: ,Ja_Cn_Utility.GV_MODULE_APAR
81: ,Ja_Cn_Utility.GV_MODULE_APAR
82: );
83: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
84: ,v_row.Doc_Num
85: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
86: ,Ja_Cn_Utility.GV_REQUIRED_YES
87: ,Ja_Cn_Utility.GV_MODULE_APAR
88: );
89: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
82: );
83: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
84: ,v_row.Doc_Num
85: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
86: ,Ja_Cn_Utility.GV_REQUIRED_YES
87: ,Ja_Cn_Utility.GV_MODULE_APAR
88: );
89: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
90: ,Ja_Cn_Utility.GV_TAG_TYPE_END
83: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
84: ,v_row.Doc_Num
85: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
86: ,Ja_Cn_Utility.GV_REQUIRED_YES
87: ,Ja_Cn_Utility.GV_MODULE_APAR
88: );
89: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
90: ,Ja_Cn_Utility.GV_TAG_TYPE_END
91: ,Ja_Cn_Utility.GV_MODULE_APAR
85: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
86: ,Ja_Cn_Utility.GV_REQUIRED_YES
87: ,Ja_Cn_Utility.GV_MODULE_APAR
88: );
89: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
90: ,Ja_Cn_Utility.GV_TAG_TYPE_END
91: ,Ja_Cn_Utility.GV_MODULE_APAR
92: );
93: END LOOP;
86: ,Ja_Cn_Utility.GV_REQUIRED_YES
87: ,Ja_Cn_Utility.GV_MODULE_APAR
88: );
89: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
90: ,Ja_Cn_Utility.GV_TAG_TYPE_END
91: ,Ja_Cn_Utility.GV_MODULE_APAR
92: );
93: END LOOP;
94:
87: ,Ja_Cn_Utility.GV_MODULE_APAR
88: );
89: Ja_Cn_Utility.Add_Sub_Root_Node('DOCUMENT_TYPE'
90: ,Ja_Cn_Utility.GV_TAG_TYPE_END
91: ,Ja_Cn_Utility.GV_MODULE_APAR
92: );
93: END LOOP;
94:
95: --logging for debug
223: END IF; --ln_proc_level>=ln_dbg_level
224:
225: FOR v_row IN tran_type_cur
226: LOOP
227: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
228: ,Ja_Cn_Utility.GV_TAG_TYPE_START
229: ,Ja_Cn_Utility.GV_MODULE_APAR
230: );
231: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NUMBER'
224:
225: FOR v_row IN tran_type_cur
226: LOOP
227: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
228: ,Ja_Cn_Utility.GV_TAG_TYPE_START
229: ,Ja_Cn_Utility.GV_MODULE_APAR
230: );
231: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NUMBER'
232: ,v_row.Tran_Type_Num
225: FOR v_row IN tran_type_cur
226: LOOP
227: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
228: ,Ja_Cn_Utility.GV_TAG_TYPE_START
229: ,Ja_Cn_Utility.GV_MODULE_APAR
230: );
231: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NUMBER'
232: ,v_row.Tran_Type_Num
233: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
227: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
228: ,Ja_Cn_Utility.GV_TAG_TYPE_START
229: ,Ja_Cn_Utility.GV_MODULE_APAR
230: );
231: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NUMBER'
232: ,v_row.Tran_Type_Num
233: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
234: ,Ja_Cn_Utility.GV_REQUIRED_YES
235: ,Ja_Cn_Utility.GV_MODULE_APAR
229: ,Ja_Cn_Utility.GV_MODULE_APAR
230: );
231: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NUMBER'
232: ,v_row.Tran_Type_Num
233: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
234: ,Ja_Cn_Utility.GV_REQUIRED_YES
235: ,Ja_Cn_Utility.GV_MODULE_APAR
236: );
237: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NAME'
230: );
231: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NUMBER'
232: ,v_row.Tran_Type_Num
233: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
234: ,Ja_Cn_Utility.GV_REQUIRED_YES
235: ,Ja_Cn_Utility.GV_MODULE_APAR
236: );
237: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NAME'
238: ,v_row.Tran_Type_Name
231: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NUMBER'
232: ,v_row.Tran_Type_Num
233: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
234: ,Ja_Cn_Utility.GV_REQUIRED_YES
235: ,Ja_Cn_Utility.GV_MODULE_APAR
236: );
237: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NAME'
238: ,v_row.Tran_Type_Name
239: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
233: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
234: ,Ja_Cn_Utility.GV_REQUIRED_YES
235: ,Ja_Cn_Utility.GV_MODULE_APAR
236: );
237: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NAME'
238: ,v_row.Tran_Type_Name
239: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
240: ,Ja_Cn_Utility.GV_REQUIRED_YES
241: ,Ja_Cn_Utility.GV_MODULE_APAR
235: ,Ja_Cn_Utility.GV_MODULE_APAR
236: );
237: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NAME'
238: ,v_row.Tran_Type_Name
239: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
240: ,Ja_Cn_Utility.GV_REQUIRED_YES
241: ,Ja_Cn_Utility.GV_MODULE_APAR
242: );
243: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
236: );
237: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NAME'
238: ,v_row.Tran_Type_Name
239: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
240: ,Ja_Cn_Utility.GV_REQUIRED_YES
241: ,Ja_Cn_Utility.GV_MODULE_APAR
242: );
243: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
244: ,Ja_Cn_Utility.GV_TAG_TYPE_END
237: Ja_Cn_Utility.Add_Child_Node('TRANSACTION_TYPE_NAME'
238: ,v_row.Tran_Type_Name
239: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
240: ,Ja_Cn_Utility.GV_REQUIRED_YES
241: ,Ja_Cn_Utility.GV_MODULE_APAR
242: );
243: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
244: ,Ja_Cn_Utility.GV_TAG_TYPE_END
245: ,Ja_Cn_Utility.GV_MODULE_APAR
239: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
240: ,Ja_Cn_Utility.GV_REQUIRED_YES
241: ,Ja_Cn_Utility.GV_MODULE_APAR
242: );
243: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
244: ,Ja_Cn_Utility.GV_TAG_TYPE_END
245: ,Ja_Cn_Utility.GV_MODULE_APAR
246: );
247: END LOOP;
240: ,Ja_Cn_Utility.GV_REQUIRED_YES
241: ,Ja_Cn_Utility.GV_MODULE_APAR
242: );
243: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
244: ,Ja_Cn_Utility.GV_TAG_TYPE_END
245: ,Ja_Cn_Utility.GV_MODULE_APAR
246: );
247: END LOOP;
248:
241: ,Ja_Cn_Utility.GV_MODULE_APAR
242: );
243: Ja_Cn_Utility.Add_Sub_Root_Node('TRANSACTION_TYPE'
244: ,Ja_Cn_Utility.GV_TAG_TYPE_END
245: ,Ja_Cn_Utility.GV_MODULE_APAR
246: );
247: END LOOP;
248:
249: --logging for debug