285: INTO lv_after(1)
286: FROM fa_transaction_history_books_v
287: WHERE (key = v_row.transaction_header_id)
288: AND transaction_type = 'Addition';
289: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
290: ,pn_legal_entity_id);
291: ELSIF (v_row.transaction_type_code = 'UNIT ADJUSTMENT') --UNIT ADJUSTMENT
292: THEN
293: --get the total unit at the transaction time, before the unit adjustment
342: WHERE (fahv.key = v_row.transaction_header_id)
343: AND fahv.category_id = fcb.category_id
344: ORDER BY fahv.transaction_header_id_in DESC)
345: WHERE ROWNUM = 1;
346: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor_before
347: ,pn_legal_entity_id);
348: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
349: ,pn_legal_entity_id);
350: ELSIF (v_row.transaction_type_code = 'RECLASS') --RECLASS
344: ORDER BY fahv.transaction_header_id_in DESC)
345: WHERE ROWNUM = 1;
346: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor_before
347: ,pn_legal_entity_id);
348: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
349: ,pn_legal_entity_id);
350: ELSIF (v_row.transaction_type_code = 'RECLASS') --RECLASS
351: THEN
352: lv_change_reason := NVL(v_row.transaction_name, 'Reclass');
386: INTO lv_after(1)
387: FROM fa_retirements_v
388: WHERE 'REINSTATEMENT' = 'REINSTATEMENT'
389: AND transaction_header_id_out = v_row.transaction_header_id;
390: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
391: ,pn_legal_entity_id);
392: ELSIF (v_row.transaction_type_code = 'REVALUATION') --REVALUATION
393: THEN
394: lv_change_reason := NVL(v_row.transaction_name, 'Revaluation');
409: FROM fa_transaction_history_books_v
410: WHERE key = v_row.transaction_header_id
411: ORDER BY transaction_header_id_in DESC)
412: WHERE ROWNUM = 1;
413: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor
414: ,pn_legal_entity_id);
415: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
416: ,pn_legal_entity_id);
417: ELSIF (v_row.transaction_type_code = 'TRANSFER') --TRANSFER
411: ORDER BY transaction_header_id_in DESC)
412: WHERE ROWNUM = 1;
413: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor
414: ,pn_legal_entity_id);
415: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
416: ,pn_legal_entity_id);
417: ELSIF (v_row.transaction_type_code = 'TRANSFER') --TRANSFER
418: THEN
419: lv_change_reason := NVL(v_row.transaction_name, 'Transfer');
551: FROM fa_transaction_history_books_v
552: WHERE (key = v_row.transaction_header_id)
553: ORDER BY transaction_header_id_in DESC)
554: WHERE ROWNUM = 1;
555: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor
556: ,pn_legal_entity_id);
557: lv_before(2) := ja_cn_utility.get_rounding_value(to_number(lv_before(2)) * ln_factor
558: ,pn_legal_entity_id);
559: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
553: ORDER BY transaction_header_id_in DESC)
554: WHERE ROWNUM = 1;
555: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor
556: ,pn_legal_entity_id);
557: lv_before(2) := ja_cn_utility.get_rounding_value(to_number(lv_before(2)) * ln_factor
558: ,pn_legal_entity_id);
559: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
560: ,pn_legal_entity_id);
561: lv_after(2) := ja_cn_utility.get_rounding_value(to_number(lv_after(2)) * ln_factor
555: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor
556: ,pn_legal_entity_id);
557: lv_before(2) := ja_cn_utility.get_rounding_value(to_number(lv_before(2)) * ln_factor
558: ,pn_legal_entity_id);
559: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
560: ,pn_legal_entity_id);
561: lv_after(2) := ja_cn_utility.get_rounding_value(to_number(lv_after(2)) * ln_factor
562: ,pn_legal_entity_id);
563: ELSIF (v_row.transaction_type_code = 'ADJUSTMENT'
557: lv_before(2) := ja_cn_utility.get_rounding_value(to_number(lv_before(2)) * ln_factor
558: ,pn_legal_entity_id);
559: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
560: ,pn_legal_entity_id);
561: lv_after(2) := ja_cn_utility.get_rounding_value(to_number(lv_after(2)) * ln_factor
562: ,pn_legal_entity_id);
563: ELSIF (v_row.transaction_type_code = 'ADJUSTMENT'
564: AND v_row.transaction_key = 'IM') --ADJUSTMENT, IMPAIRMENT
565: THEN
583: WHERE asset_id = v_row.asset_id
584: AND book_type_code = v_row.book_type_code
585: AND period_counter < fdp.period_counter);
586:
587: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor
588: ,pn_legal_entity_id);
589: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
590: ,pn_legal_entity_id);
591: ELSIF (v_row.transaction_type_code = 'ADJUSTMENT' and v_row.transaction_key = 'UA') --ADJUSTMENT, Unplaned adjustment
585: AND period_counter < fdp.period_counter);
586:
587: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor
588: ,pn_legal_entity_id);
589: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
590: ,pn_legal_entity_id);
591: ELSIF (v_row.transaction_type_code = 'ADJUSTMENT' and v_row.transaction_key = 'UA') --ADJUSTMENT, Unplaned adjustment
592: THEN
593: lv_change_reason := NVL(v_row.transaction_name, 'Unplaned Depreciation');
597: INTO lv_after(1)
598: FROM fa_financial_inquiry_upl_v
599: WHERE (transaction_header_id = v_row.transaction_header_id)
600: AND ROWNUM = 1;
601: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
602: ,pn_legal_entity_id);
603: END IF; -- (v_row.transaction_type_code = 'ADDITION')
604: FOR i IN 1..lv_before.count LOOP
605: IF (lv_before(i) <> lv_after(i))
603: END IF; -- (v_row.transaction_type_code = 'ADDITION')
604: FOR i IN 1..lv_before.count LOOP
605: IF (lv_before(i) <> lv_after(i))
606: THEN
607: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
608: ,Ja_Cn_Utility.GV_TAG_TYPE_START
609: ,'FA');
610:
611: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
604: FOR i IN 1..lv_before.count LOOP
605: IF (lv_before(i) <> lv_after(i))
606: THEN
607: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
608: ,Ja_Cn_Utility.GV_TAG_TYPE_START
609: ,'FA');
610:
611: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
612: ,v_row.transaction_header_id
607: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
608: ,Ja_Cn_Utility.GV_TAG_TYPE_START
609: ,'FA');
610:
611: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
612: ,v_row.transaction_header_id
613: ,'VARCHAR2'
614: ,Ja_Cn_Utility.GV_REQUIRED_YES
615: ,Ja_Cn_Utility.GV_MODULE_FA);
610:
611: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
612: ,v_row.transaction_header_id
613: ,'VARCHAR2'
614: ,Ja_Cn_Utility.GV_REQUIRED_YES
615: ,Ja_Cn_Utility.GV_MODULE_FA);
616: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
617: ,to_char(v_row.transaction_date, 'YYYYMMDD')
618: ,8
611: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
612: ,v_row.transaction_header_id
613: ,'VARCHAR2'
614: ,Ja_Cn_Utility.GV_REQUIRED_YES
615: ,Ja_Cn_Utility.GV_MODULE_FA);
616: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
617: ,to_char(v_row.transaction_date, 'YYYYMMDD')
618: ,8
619: ,Ja_Cn_Utility.GV_REQUIRED_YES
612: ,v_row.transaction_header_id
613: ,'VARCHAR2'
614: ,Ja_Cn_Utility.GV_REQUIRED_YES
615: ,Ja_Cn_Utility.GV_MODULE_FA);
616: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
617: ,to_char(v_row.transaction_date, 'YYYYMMDD')
618: ,8
619: ,Ja_Cn_Utility.GV_REQUIRED_YES
620: ,Ja_Cn_Utility.GV_MODULE_FA);
615: ,Ja_Cn_Utility.GV_MODULE_FA);
616: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
617: ,to_char(v_row.transaction_date, 'YYYYMMDD')
618: ,8
619: ,Ja_Cn_Utility.GV_REQUIRED_YES
620: ,Ja_Cn_Utility.GV_MODULE_FA);
621: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
622: ,lv_period_name
623: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
616: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
617: ,to_char(v_row.transaction_date, 'YYYYMMDD')
618: ,8
619: ,Ja_Cn_Utility.GV_REQUIRED_YES
620: ,Ja_Cn_Utility.GV_MODULE_FA);
621: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
622: ,lv_period_name
623: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
624: ,Ja_Cn_Utility.GV_REQUIRED_YES
617: ,to_char(v_row.transaction_date, 'YYYYMMDD')
618: ,8
619: ,Ja_Cn_Utility.GV_REQUIRED_YES
620: ,Ja_Cn_Utility.GV_MODULE_FA);
621: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
622: ,lv_period_name
623: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
624: ,Ja_Cn_Utility.GV_REQUIRED_YES
625: ,Ja_Cn_Utility.GV_MODULE_FA);
619: ,Ja_Cn_Utility.GV_REQUIRED_YES
620: ,Ja_Cn_Utility.GV_MODULE_FA);
621: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
622: ,lv_period_name
623: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
624: ,Ja_Cn_Utility.GV_REQUIRED_YES
625: ,Ja_Cn_Utility.GV_MODULE_FA);
626: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
627: ,v_row.asset_number
620: ,Ja_Cn_Utility.GV_MODULE_FA);
621: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
622: ,lv_period_name
623: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
624: ,Ja_Cn_Utility.GV_REQUIRED_YES
625: ,Ja_Cn_Utility.GV_MODULE_FA);
626: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
627: ,v_row.asset_number
628: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
621: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
622: ,lv_period_name
623: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
624: ,Ja_Cn_Utility.GV_REQUIRED_YES
625: ,Ja_Cn_Utility.GV_MODULE_FA);
626: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
627: ,v_row.asset_number
628: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
629: ,Ja_Cn_Utility.GV_REQUIRED_YES
622: ,lv_period_name
623: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
624: ,Ja_Cn_Utility.GV_REQUIRED_YES
625: ,Ja_Cn_Utility.GV_MODULE_FA);
626: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
627: ,v_row.asset_number
628: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
629: ,Ja_Cn_Utility.GV_REQUIRED_YES
630: ,Ja_Cn_Utility.GV_MODULE_FA);
624: ,Ja_Cn_Utility.GV_REQUIRED_YES
625: ,Ja_Cn_Utility.GV_MODULE_FA);
626: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
627: ,v_row.asset_number
628: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
629: ,Ja_Cn_Utility.GV_REQUIRED_YES
630: ,Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
632: ,v_row.asset_number
625: ,Ja_Cn_Utility.GV_MODULE_FA);
626: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
627: ,v_row.asset_number
628: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
629: ,Ja_Cn_Utility.GV_REQUIRED_YES
630: ,Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
632: ,v_row.asset_number
633: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
626: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
627: ,v_row.asset_number
628: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
629: ,Ja_Cn_Utility.GV_REQUIRED_YES
630: ,Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
632: ,v_row.asset_number
633: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
627: ,v_row.asset_number
628: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
629: ,Ja_Cn_Utility.GV_REQUIRED_YES
630: ,Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
632: ,v_row.asset_number
633: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
635: ,Ja_Cn_Utility.GV_MODULE_FA);
629: ,Ja_Cn_Utility.GV_REQUIRED_YES
630: ,Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
632: ,v_row.asset_number
633: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
635: ,Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
637: ,v_row.description
630: ,Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
632: ,v_row.asset_number
633: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
635: ,Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
637: ,v_row.description
638: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
631: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
632: ,v_row.asset_number
633: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
635: ,Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
637: ,v_row.description
638: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
639: ,Ja_Cn_Utility.GV_REQUIRED_YES
632: ,v_row.asset_number
633: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
635: ,Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
637: ,v_row.description
638: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
639: ,Ja_Cn_Utility.GV_REQUIRED_YES
640: ,Ja_Cn_Utility.GV_MODULE_FA);
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
635: ,Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
637: ,v_row.description
638: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
639: ,Ja_Cn_Utility.GV_REQUIRED_YES
640: ,Ja_Cn_Utility.GV_MODULE_FA);
641:
642: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
635: ,Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
637: ,v_row.description
638: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
639: ,Ja_Cn_Utility.GV_REQUIRED_YES
640: ,Ja_Cn_Utility.GV_MODULE_FA);
641:
642: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
643: ,v_row.transaction_type_code
636: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
637: ,v_row.description
638: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
639: ,Ja_Cn_Utility.GV_REQUIRED_YES
640: ,Ja_Cn_Utility.GV_MODULE_FA);
641:
642: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
643: ,v_row.transaction_type_code
644: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
638: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
639: ,Ja_Cn_Utility.GV_REQUIRED_YES
640: ,Ja_Cn_Utility.GV_MODULE_FA);
641:
642: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
643: ,v_row.transaction_type_code
644: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
645: ,Ja_Cn_Utility.GV_REQUIRED_YES
646: ,Ja_Cn_Utility.GV_MODULE_FA);
640: ,Ja_Cn_Utility.GV_MODULE_FA);
641:
642: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
643: ,v_row.transaction_type_code
644: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
645: ,Ja_Cn_Utility.GV_REQUIRED_YES
646: ,Ja_Cn_Utility.GV_MODULE_FA);
647: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
648: ,v_row.tag_number
641:
642: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
643: ,v_row.transaction_type_code
644: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
645: ,Ja_Cn_Utility.GV_REQUIRED_YES
646: ,Ja_Cn_Utility.GV_MODULE_FA);
647: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
648: ,v_row.tag_number
649: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
642: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
643: ,v_row.transaction_type_code
644: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
645: ,Ja_Cn_Utility.GV_REQUIRED_YES
646: ,Ja_Cn_Utility.GV_MODULE_FA);
647: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
648: ,v_row.tag_number
649: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
643: ,v_row.transaction_type_code
644: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
645: ,Ja_Cn_Utility.GV_REQUIRED_YES
646: ,Ja_Cn_Utility.GV_MODULE_FA);
647: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
648: ,v_row.tag_number
649: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
651: ,Ja_Cn_Utility.GV_MODULE_FA);
645: ,Ja_Cn_Utility.GV_REQUIRED_YES
646: ,Ja_Cn_Utility.GV_MODULE_FA);
647: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
648: ,v_row.tag_number
649: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
651: ,Ja_Cn_Utility.GV_MODULE_FA);
652: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
653: ,lv_change_content(i) || lv_before(i)
646: ,Ja_Cn_Utility.GV_MODULE_FA);
647: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
648: ,v_row.tag_number
649: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
651: ,Ja_Cn_Utility.GV_MODULE_FA);
652: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
653: ,lv_change_content(i) || lv_before(i)
654: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
647: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
648: ,v_row.tag_number
649: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
651: ,Ja_Cn_Utility.GV_MODULE_FA);
652: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
653: ,lv_change_content(i) || lv_before(i)
654: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
655: ,Ja_Cn_Utility.GV_REQUIRED_YES
648: ,v_row.tag_number
649: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
651: ,Ja_Cn_Utility.GV_MODULE_FA);
652: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
653: ,lv_change_content(i) || lv_before(i)
654: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
655: ,Ja_Cn_Utility.GV_REQUIRED_YES
656: ,Ja_Cn_Utility.GV_MODULE_FA);
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
651: ,Ja_Cn_Utility.GV_MODULE_FA);
652: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
653: ,lv_change_content(i) || lv_before(i)
654: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
655: ,Ja_Cn_Utility.GV_REQUIRED_YES
656: ,Ja_Cn_Utility.GV_MODULE_FA);
657: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
658: ,lv_change_content(i) || lv_after(i)
651: ,Ja_Cn_Utility.GV_MODULE_FA);
652: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
653: ,lv_change_content(i) || lv_before(i)
654: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
655: ,Ja_Cn_Utility.GV_REQUIRED_YES
656: ,Ja_Cn_Utility.GV_MODULE_FA);
657: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
658: ,lv_change_content(i) || lv_after(i)
659: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
652: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
653: ,lv_change_content(i) || lv_before(i)
654: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
655: ,Ja_Cn_Utility.GV_REQUIRED_YES
656: ,Ja_Cn_Utility.GV_MODULE_FA);
657: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
658: ,lv_change_content(i) || lv_after(i)
659: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
660: ,Ja_Cn_Utility.GV_REQUIRED_YES
653: ,lv_change_content(i) || lv_before(i)
654: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
655: ,Ja_Cn_Utility.GV_REQUIRED_YES
656: ,Ja_Cn_Utility.GV_MODULE_FA);
657: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
658: ,lv_change_content(i) || lv_after(i)
659: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
660: ,Ja_Cn_Utility.GV_REQUIRED_YES
661: ,Ja_Cn_Utility.GV_MODULE_FA);
655: ,Ja_Cn_Utility.GV_REQUIRED_YES
656: ,Ja_Cn_Utility.GV_MODULE_FA);
657: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
658: ,lv_change_content(i) || lv_after(i)
659: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
660: ,Ja_Cn_Utility.GV_REQUIRED_YES
661: ,Ja_Cn_Utility.GV_MODULE_FA);
662: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
663: ,lv_change_reason
656: ,Ja_Cn_Utility.GV_MODULE_FA);
657: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
658: ,lv_change_content(i) || lv_after(i)
659: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
660: ,Ja_Cn_Utility.GV_REQUIRED_YES
661: ,Ja_Cn_Utility.GV_MODULE_FA);
662: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
663: ,lv_change_reason
664: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
657: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
658: ,lv_change_content(i) || lv_after(i)
659: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
660: ,Ja_Cn_Utility.GV_REQUIRED_YES
661: ,Ja_Cn_Utility.GV_MODULE_FA);
662: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
663: ,lv_change_reason
664: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
665: ,Ja_Cn_Utility.GV_REQUIRED_YES
658: ,lv_change_content(i) || lv_after(i)
659: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
660: ,Ja_Cn_Utility.GV_REQUIRED_YES
661: ,Ja_Cn_Utility.GV_MODULE_FA);
662: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
663: ,lv_change_reason
664: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
665: ,Ja_Cn_Utility.GV_REQUIRED_YES
666: ,Ja_Cn_Utility.GV_MODULE_FA);
660: ,Ja_Cn_Utility.GV_REQUIRED_YES
661: ,Ja_Cn_Utility.GV_MODULE_FA);
662: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
663: ,lv_change_reason
664: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
665: ,Ja_Cn_Utility.GV_REQUIRED_YES
666: ,Ja_Cn_Utility.GV_MODULE_FA);
667: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
668: ,Ja_Cn_Utility.GV_TAG_TYPE_END
661: ,Ja_Cn_Utility.GV_MODULE_FA);
662: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
663: ,lv_change_reason
664: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
665: ,Ja_Cn_Utility.GV_REQUIRED_YES
666: ,Ja_Cn_Utility.GV_MODULE_FA);
667: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
668: ,Ja_Cn_Utility.GV_TAG_TYPE_END
669: ,Ja_Cn_Utility.GV_MODULE_FA);
662: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
663: ,lv_change_reason
664: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
665: ,Ja_Cn_Utility.GV_REQUIRED_YES
666: ,Ja_Cn_Utility.GV_MODULE_FA);
667: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
668: ,Ja_Cn_Utility.GV_TAG_TYPE_END
669: ,Ja_Cn_Utility.GV_MODULE_FA);
670: END IF; --(lv_before(i) <> lv_after(i))
663: ,lv_change_reason
664: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
665: ,Ja_Cn_Utility.GV_REQUIRED_YES
666: ,Ja_Cn_Utility.GV_MODULE_FA);
667: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
668: ,Ja_Cn_Utility.GV_TAG_TYPE_END
669: ,Ja_Cn_Utility.GV_MODULE_FA);
670: END IF; --(lv_before(i) <> lv_after(i))
671: END LOOP; --FOR i IN 1..lv_before.count LOOP
664: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
665: ,Ja_Cn_Utility.GV_REQUIRED_YES
666: ,Ja_Cn_Utility.GV_MODULE_FA);
667: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
668: ,Ja_Cn_Utility.GV_TAG_TYPE_END
669: ,Ja_Cn_Utility.GV_MODULE_FA);
670: END IF; --(lv_before(i) <> lv_after(i))
671: END LOOP; --FOR i IN 1..lv_before.count LOOP
672: END LOOP; --v_row IN asset_modification_cur
665: ,Ja_Cn_Utility.GV_REQUIRED_YES
666: ,Ja_Cn_Utility.GV_MODULE_FA);
667: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
668: ,Ja_Cn_Utility.GV_TAG_TYPE_END
669: ,Ja_Cn_Utility.GV_MODULE_FA);
670: END IF; --(lv_before(i) <> lv_after(i))
671: END LOOP; --FOR i IN 1..lv_before.count LOOP
672: END LOOP; --v_row IN asset_modification_cur
673:
672: END LOOP; --v_row IN asset_modification_cur
673:
674: IF (ln_row_count = 0)
675: THEN
676: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_MODIFICATION_INFO'
677: ,Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
679: ,Ja_Cn_Utility.GV_TAG_TYPE_START
680: ,Ja_Cn_Utility.GV_MODULE_FA);
673:
674: IF (ln_row_count = 0)
675: THEN
676: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_MODIFICATION_INFO'
677: ,Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
679: ,Ja_Cn_Utility.GV_TAG_TYPE_START
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681:
674: IF (ln_row_count = 0)
675: THEN
676: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_MODIFICATION_INFO'
677: ,Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
679: ,Ja_Cn_Utility.GV_TAG_TYPE_START
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681:
682: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
675: THEN
676: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_MODIFICATION_INFO'
677: ,Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
679: ,Ja_Cn_Utility.GV_TAG_TYPE_START
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681:
682: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
683: ,NULL
676: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_MODIFICATION_INFO'
677: ,Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
679: ,Ja_Cn_Utility.GV_TAG_TYPE_START
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681:
682: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
683: ,NULL
684: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
678: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
679: ,Ja_Cn_Utility.GV_TAG_TYPE_START
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681:
682: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
683: ,NULL
684: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
685: ,Ja_Cn_Utility.GV_REQUIRED_YES
686: ,Ja_Cn_Utility.GV_MODULE_FA);
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681:
682: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
683: ,NULL
684: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
685: ,Ja_Cn_Utility.GV_REQUIRED_YES
686: ,Ja_Cn_Utility.GV_MODULE_FA);
687: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
688: ,NULL
681:
682: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
683: ,NULL
684: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
685: ,Ja_Cn_Utility.GV_REQUIRED_YES
686: ,Ja_Cn_Utility.GV_MODULE_FA);
687: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
688: ,NULL
689: ,8
682: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
683: ,NULL
684: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
685: ,Ja_Cn_Utility.GV_REQUIRED_YES
686: ,Ja_Cn_Utility.GV_MODULE_FA);
687: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
688: ,NULL
689: ,8
690: ,Ja_Cn_Utility.GV_REQUIRED_YES
683: ,NULL
684: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
685: ,Ja_Cn_Utility.GV_REQUIRED_YES
686: ,Ja_Cn_Utility.GV_MODULE_FA);
687: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
688: ,NULL
689: ,8
690: ,Ja_Cn_Utility.GV_REQUIRED_YES
691: ,Ja_Cn_Utility.GV_MODULE_FA);
686: ,Ja_Cn_Utility.GV_MODULE_FA);
687: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
688: ,NULL
689: ,8
690: ,Ja_Cn_Utility.GV_REQUIRED_YES
691: ,Ja_Cn_Utility.GV_MODULE_FA);
692: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
693: ,NULL
694: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
687: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
688: ,NULL
689: ,8
690: ,Ja_Cn_Utility.GV_REQUIRED_YES
691: ,Ja_Cn_Utility.GV_MODULE_FA);
692: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
693: ,NULL
694: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
695: ,Ja_Cn_Utility.GV_REQUIRED_YES
688: ,NULL
689: ,8
690: ,Ja_Cn_Utility.GV_REQUIRED_YES
691: ,Ja_Cn_Utility.GV_MODULE_FA);
692: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
693: ,NULL
694: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
695: ,Ja_Cn_Utility.GV_REQUIRED_YES
696: ,Ja_Cn_Utility.GV_MODULE_FA);
690: ,Ja_Cn_Utility.GV_REQUIRED_YES
691: ,Ja_Cn_Utility.GV_MODULE_FA);
692: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
693: ,NULL
694: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
695: ,Ja_Cn_Utility.GV_REQUIRED_YES
696: ,Ja_Cn_Utility.GV_MODULE_FA);
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
698: ,NULL
691: ,Ja_Cn_Utility.GV_MODULE_FA);
692: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
693: ,NULL
694: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
695: ,Ja_Cn_Utility.GV_REQUIRED_YES
696: ,Ja_Cn_Utility.GV_MODULE_FA);
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
698: ,NULL
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
692: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
693: ,NULL
694: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
695: ,Ja_Cn_Utility.GV_REQUIRED_YES
696: ,Ja_Cn_Utility.GV_MODULE_FA);
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
698: ,NULL
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
693: ,NULL
694: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
695: ,Ja_Cn_Utility.GV_REQUIRED_YES
696: ,Ja_Cn_Utility.GV_MODULE_FA);
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
698: ,NULL
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
695: ,Ja_Cn_Utility.GV_REQUIRED_YES
696: ,Ja_Cn_Utility.GV_MODULE_FA);
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
698: ,NULL
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
703: ,NULL
696: ,Ja_Cn_Utility.GV_MODULE_FA);
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
698: ,NULL
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
703: ,NULL
704: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
698: ,NULL
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
703: ,NULL
704: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
705: ,Ja_Cn_Utility.GV_REQUIRED_YES
698: ,NULL
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
703: ,NULL
704: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
705: ,Ja_Cn_Utility.GV_REQUIRED_YES
706: ,Ja_Cn_Utility.GV_MODULE_FA);
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
703: ,NULL
704: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
705: ,Ja_Cn_Utility.GV_REQUIRED_YES
706: ,Ja_Cn_Utility.GV_MODULE_FA);
707: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
708: ,NULL
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
703: ,NULL
704: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
705: ,Ja_Cn_Utility.GV_REQUIRED_YES
706: ,Ja_Cn_Utility.GV_MODULE_FA);
707: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
708: ,NULL
709: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
702: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
703: ,NULL
704: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
705: ,Ja_Cn_Utility.GV_REQUIRED_YES
706: ,Ja_Cn_Utility.GV_MODULE_FA);
707: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
708: ,NULL
709: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
710: ,Ja_Cn_Utility.GV_REQUIRED_YES
703: ,NULL
704: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
705: ,Ja_Cn_Utility.GV_REQUIRED_YES
706: ,Ja_Cn_Utility.GV_MODULE_FA);
707: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
708: ,NULL
709: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
710: ,Ja_Cn_Utility.GV_REQUIRED_YES
711: ,Ja_Cn_Utility.GV_MODULE_FA);
705: ,Ja_Cn_Utility.GV_REQUIRED_YES
706: ,Ja_Cn_Utility.GV_MODULE_FA);
707: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
708: ,NULL
709: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
710: ,Ja_Cn_Utility.GV_REQUIRED_YES
711: ,Ja_Cn_Utility.GV_MODULE_FA);
712:
713: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
706: ,Ja_Cn_Utility.GV_MODULE_FA);
707: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
708: ,NULL
709: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
710: ,Ja_Cn_Utility.GV_REQUIRED_YES
711: ,Ja_Cn_Utility.GV_MODULE_FA);
712:
713: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
714: ,NULL
707: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
708: ,NULL
709: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
710: ,Ja_Cn_Utility.GV_REQUIRED_YES
711: ,Ja_Cn_Utility.GV_MODULE_FA);
712:
713: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
714: ,NULL
715: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
709: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
710: ,Ja_Cn_Utility.GV_REQUIRED_YES
711: ,Ja_Cn_Utility.GV_MODULE_FA);
712:
713: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
714: ,NULL
715: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: ,Ja_Cn_Utility.GV_REQUIRED_YES
717: ,Ja_Cn_Utility.GV_MODULE_FA);
711: ,Ja_Cn_Utility.GV_MODULE_FA);
712:
713: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
714: ,NULL
715: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: ,Ja_Cn_Utility.GV_REQUIRED_YES
717: ,Ja_Cn_Utility.GV_MODULE_FA);
718: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
719: ,NULL,Ja_Cn_Utility.GV_TYPE_VARCHAR2
712:
713: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
714: ,NULL
715: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: ,Ja_Cn_Utility.GV_REQUIRED_YES
717: ,Ja_Cn_Utility.GV_MODULE_FA);
718: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
719: ,NULL,Ja_Cn_Utility.GV_TYPE_VARCHAR2
720: ,Ja_Cn_Utility.GV_REQUIRED_YES
713: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
714: ,NULL
715: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: ,Ja_Cn_Utility.GV_REQUIRED_YES
717: ,Ja_Cn_Utility.GV_MODULE_FA);
718: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
719: ,NULL,Ja_Cn_Utility.GV_TYPE_VARCHAR2
720: ,Ja_Cn_Utility.GV_REQUIRED_YES
721: ,Ja_Cn_Utility.GV_MODULE_FA);
714: ,NULL
715: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: ,Ja_Cn_Utility.GV_REQUIRED_YES
717: ,Ja_Cn_Utility.GV_MODULE_FA);
718: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
719: ,NULL,Ja_Cn_Utility.GV_TYPE_VARCHAR2
720: ,Ja_Cn_Utility.GV_REQUIRED_YES
721: ,Ja_Cn_Utility.GV_MODULE_FA);
722: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
715: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: ,Ja_Cn_Utility.GV_REQUIRED_YES
717: ,Ja_Cn_Utility.GV_MODULE_FA);
718: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
719: ,NULL,Ja_Cn_Utility.GV_TYPE_VARCHAR2
720: ,Ja_Cn_Utility.GV_REQUIRED_YES
721: ,Ja_Cn_Utility.GV_MODULE_FA);
722: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
723: ,NULL
716: ,Ja_Cn_Utility.GV_REQUIRED_YES
717: ,Ja_Cn_Utility.GV_MODULE_FA);
718: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
719: ,NULL,Ja_Cn_Utility.GV_TYPE_VARCHAR2
720: ,Ja_Cn_Utility.GV_REQUIRED_YES
721: ,Ja_Cn_Utility.GV_MODULE_FA);
722: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
723: ,NULL
724: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
717: ,Ja_Cn_Utility.GV_MODULE_FA);
718: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
719: ,NULL,Ja_Cn_Utility.GV_TYPE_VARCHAR2
720: ,Ja_Cn_Utility.GV_REQUIRED_YES
721: ,Ja_Cn_Utility.GV_MODULE_FA);
722: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
723: ,NULL
724: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
725: ,Ja_Cn_Utility.GV_REQUIRED_YES
718: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
719: ,NULL,Ja_Cn_Utility.GV_TYPE_VARCHAR2
720: ,Ja_Cn_Utility.GV_REQUIRED_YES
721: ,Ja_Cn_Utility.GV_MODULE_FA);
722: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
723: ,NULL
724: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
725: ,Ja_Cn_Utility.GV_REQUIRED_YES
726: ,Ja_Cn_Utility.GV_MODULE_FA);
720: ,Ja_Cn_Utility.GV_REQUIRED_YES
721: ,Ja_Cn_Utility.GV_MODULE_FA);
722: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
723: ,NULL
724: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
725: ,Ja_Cn_Utility.GV_REQUIRED_YES
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
728: ,NULL
721: ,Ja_Cn_Utility.GV_MODULE_FA);
722: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
723: ,NULL
724: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
725: ,Ja_Cn_Utility.GV_REQUIRED_YES
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
728: ,NULL
729: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
722: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
723: ,NULL
724: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
725: ,Ja_Cn_Utility.GV_REQUIRED_YES
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
728: ,NULL
729: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: ,Ja_Cn_Utility.GV_REQUIRED_YES
723: ,NULL
724: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
725: ,Ja_Cn_Utility.GV_REQUIRED_YES
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
728: ,NULL
729: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: ,Ja_Cn_Utility.GV_REQUIRED_YES
731: ,Ja_Cn_Utility.GV_MODULE_FA);
725: ,Ja_Cn_Utility.GV_REQUIRED_YES
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
728: ,NULL
729: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: ,Ja_Cn_Utility.GV_REQUIRED_YES
731: ,Ja_Cn_Utility.GV_MODULE_FA);
732: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
733: ,NULL
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
728: ,NULL
729: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: ,Ja_Cn_Utility.GV_REQUIRED_YES
731: ,Ja_Cn_Utility.GV_MODULE_FA);
732: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
733: ,NULL
734: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
727: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
728: ,NULL
729: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: ,Ja_Cn_Utility.GV_REQUIRED_YES
731: ,Ja_Cn_Utility.GV_MODULE_FA);
732: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
733: ,NULL
734: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
735: ,Ja_Cn_Utility.GV_REQUIRED_YES
728: ,NULL
729: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: ,Ja_Cn_Utility.GV_REQUIRED_YES
731: ,Ja_Cn_Utility.GV_MODULE_FA);
732: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
733: ,NULL
734: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
735: ,Ja_Cn_Utility.GV_REQUIRED_YES
736: ,Ja_Cn_Utility.GV_MODULE_FA);
730: ,Ja_Cn_Utility.GV_REQUIRED_YES
731: ,Ja_Cn_Utility.GV_MODULE_FA);
732: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
733: ,NULL
734: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
735: ,Ja_Cn_Utility.GV_REQUIRED_YES
736: ,Ja_Cn_Utility.GV_MODULE_FA);
737: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
738: ,Ja_Cn_Utility.GV_TAG_TYPE_END
731: ,Ja_Cn_Utility.GV_MODULE_FA);
732: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
733: ,NULL
734: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
735: ,Ja_Cn_Utility.GV_REQUIRED_YES
736: ,Ja_Cn_Utility.GV_MODULE_FA);
737: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
738: ,Ja_Cn_Utility.GV_TAG_TYPE_END
739: ,Ja_Cn_Utility.GV_MODULE_FA);
732: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
733: ,NULL
734: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
735: ,Ja_Cn_Utility.GV_REQUIRED_YES
736: ,Ja_Cn_Utility.GV_MODULE_FA);
737: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
738: ,Ja_Cn_Utility.GV_TAG_TYPE_END
739: ,Ja_Cn_Utility.GV_MODULE_FA);
740: END IF; --ln_row_count = 0
733: ,NULL
734: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
735: ,Ja_Cn_Utility.GV_REQUIRED_YES
736: ,Ja_Cn_Utility.GV_MODULE_FA);
737: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
738: ,Ja_Cn_Utility.GV_TAG_TYPE_END
739: ,Ja_Cn_Utility.GV_MODULE_FA);
740: END IF; --ln_row_count = 0
741:
734: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
735: ,Ja_Cn_Utility.GV_REQUIRED_YES
736: ,Ja_Cn_Utility.GV_MODULE_FA);
737: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
738: ,Ja_Cn_Utility.GV_TAG_TYPE_END
739: ,Ja_Cn_Utility.GV_MODULE_FA);
740: END IF; --ln_row_count = 0
741:
742: --logging for debug
735: ,Ja_Cn_Utility.GV_REQUIRED_YES
736: ,Ja_Cn_Utility.GV_MODULE_FA);
737: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
738: ,Ja_Cn_Utility.GV_TAG_TYPE_END
739: ,Ja_Cn_Utility.GV_MODULE_FA);
740: END IF; --ln_row_count = 0
741:
742: --logging for debug
743: IF (ln_proc_level >= ln_dbg_level) THEN