APPS.JA_CN_PS_FA_MI_EXP_PKG dependencies on JA_CN_UTILITY

Line 128: WHERE Ja_Cn_Utility.get_balancing_segment

124: fdh.date_ineffective IS NULL)
125: AND EXISTS
126: (SELECT jclllbg.bal_seg_value
127: FROM ja_cn_ledger_le_bsv_gt jclllbg
128: WHERE Ja_Cn_Utility.get_balancing_segment
129: (fdh.code_combination_id) = jclllbg.bal_seg_value
130: AND jclllbg.Ledger_Id = ln_ledger_id
131: AND jclllbg.Legal_Entity_Id = ln_legal_entity_id)
132: AND fbcs.set_of_books_id = ln_ledger_id

Line 315: lv_after(1) := ja_cn_utility.

311: INTO lv_after(1)
312: FROM fa_transaction_history_books_v
313: WHERE (key = v_row.transaction_header_id)
314: AND transaction_type = 'Addition';
315: lv_after(1) := ja_cn_utility.
316: get_rounding_value( to_number(lv_after(1)) * ln_factor
317: , pn_legal_entity_id);
318: --UNIT ADJUSTMENT
319: ELSIF (v_row.transaction_type_code = 'UNIT ADJUSTMENT')

Line 343: WHERE JA_CN_UTILITY.get_balancing_segment

339: fdh.date_ineffective IS NULL)
340: AND EXISTS
341: (SELECT jclllbg.bal_seg_value
342: FROM ja_cn_ledger_le_bsv_gt jclllbg
343: WHERE JA_CN_UTILITY.get_balancing_segment
344: (fdh.code_combination_id)= jclllbg.bal_seg_value
345: AND jclllbg.Ledger_Id = pn_ledger_id
346: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id);
347: -- calculate the assignment factor, before the unit adjustment

Line 375: lv_before(1) := ja_cn_utility.get_rounding_value

371: WHERE (fahv.key = v_row.transaction_header_id)
372: AND fahv.category_id = fcb.category_id
373: ORDER BY fahv.transaction_header_id_in DESC)
374: WHERE ROWNUM = 1;
375: lv_before(1) := ja_cn_utility.get_rounding_value
376: ( to_number(lv_before(1)) * ln_factor_before
377: , pn_legal_entity_id);
378: lv_after(1) := ja_cn_utility.get_rounding_value
379: ( to_number(lv_after(1)) * ln_factor

Line 378: lv_after(1) := ja_cn_utility.get_rounding_value

374: WHERE ROWNUM = 1;
375: lv_before(1) := ja_cn_utility.get_rounding_value
376: ( to_number(lv_before(1)) * ln_factor_before
377: , pn_legal_entity_id);
378: lv_after(1) := ja_cn_utility.get_rounding_value
379: ( to_number(lv_after(1)) * ln_factor
380: , pn_legal_entity_id);
381: ELSIF (v_row.transaction_type_code = 'RECLASS') --RECLASS
382: THEN

Line 421: lv_after(1) := ja_cn_utility.get_rounding_value

417: INTO lv_after(1)
418: FROM fa_retirements_v
419: WHERE 'REINSTATEMENT' = 'REINSTATEMENT'
420: AND transaction_header_id_out = v_row.transaction_header_id;
421: lv_after(1) := ja_cn_utility.get_rounding_value
422: ( to_number(lv_after(1)) * ln_factor
423: , pn_legal_entity_id);
424: ELSIF (v_row.transaction_type_code = 'REVALUATION') --REVALUATION
425: THEN

Line 445: lv_before(1) := ja_cn_utility.get_rounding_value

441: FROM fa_transaction_history_books_v
442: WHERE key = v_row.transaction_header_id
443: ORDER BY transaction_header_id_in DESC)
444: WHERE ROWNUM = 1;
445: lv_before(1) := ja_cn_utility.get_rounding_value
446: ( to_number(lv_before(1)) * ln_factor
447: , pn_legal_entity_id);
448: lv_after(1) := ja_cn_utility.get_rounding_value
449: ( to_number(lv_after(1)) * ln_factor

Line 448: lv_after(1) := ja_cn_utility.get_rounding_value

444: WHERE ROWNUM = 1;
445: lv_before(1) := ja_cn_utility.get_rounding_value
446: ( to_number(lv_before(1)) * ln_factor
447: , pn_legal_entity_id);
448: lv_after(1) := ja_cn_utility.get_rounding_value
449: ( to_number(lv_after(1)) * ln_factor
450: , pn_legal_entity_id);
451: ELSIF (v_row.transaction_type_code = 'TRANSFER') --TRANSFER
452: THEN

Line 590: lv_before(1) := Ja_Cn_Utility.get_rounding_value

586: FROM fa_transaction_history_books_v
587: WHERE (key = v_row.transaction_header_id)
588: ORDER BY transaction_header_id_in DESC)
589: WHERE ROWNUM = 1;
590: lv_before(1) := Ja_Cn_Utility.get_rounding_value
591: ( to_number(lv_before(1)) * ln_factor
592: , pn_legal_entity_id
593: );
594: lv_before(2) := Ja_Cn_Utility.get_rounding_value

Line 594: lv_before(2) := Ja_Cn_Utility.get_rounding_value

590: lv_before(1) := Ja_Cn_Utility.get_rounding_value
591: ( to_number(lv_before(1)) * ln_factor
592: , pn_legal_entity_id
593: );
594: lv_before(2) := Ja_Cn_Utility.get_rounding_value
595: ( to_number(lv_before(2)) * ln_factor
596: , pn_legal_entity_id
597: );
598: lv_after(1) := Ja_Cn_Utility.get_rounding_value

Line 598: lv_after(1) := Ja_Cn_Utility.get_rounding_value

594: lv_before(2) := Ja_Cn_Utility.get_rounding_value
595: ( to_number(lv_before(2)) * ln_factor
596: , pn_legal_entity_id
597: );
598: lv_after(1) := Ja_Cn_Utility.get_rounding_value
599: ( to_number(lv_after(1)) * ln_factor
600: , pn_legal_entity_id
601: );
602: lv_after(2) := Ja_Cn_Utility.get_rounding_value

Line 602: lv_after(2) := Ja_Cn_Utility.get_rounding_value

598: lv_after(1) := Ja_Cn_Utility.get_rounding_value
599: ( to_number(lv_after(1)) * ln_factor
600: , pn_legal_entity_id
601: );
602: lv_after(2) := Ja_Cn_Utility.get_rounding_value
603: ( to_number(lv_after(2)) * ln_factor
604: , pn_legal_entity_id
605: );
606: ELSIF (v_row.transaction_type_code = 'ADJUSTMENT'

Line 633: lv_before(1) := ja_cn_utility.get_rounding_value

629: FROM fa_deprn_summary
630: WHERE asset_id = v_row.asset_id
631: AND book_type_code = v_row.book_type_code
632: AND period_counter < fdp.period_counter);
633: lv_before(1) := ja_cn_utility.get_rounding_value
634: ( to_number(lv_before(1)) * ln_factor
635: , pn_legal_entity_id
636: );
637: lv_after(1) := ja_cn_utility.get_rounding_value

Line 637: lv_after(1) := ja_cn_utility.get_rounding_value

633: lv_before(1) := ja_cn_utility.get_rounding_value
634: ( to_number(lv_before(1)) * ln_factor
635: , pn_legal_entity_id
636: );
637: lv_after(1) := ja_cn_utility.get_rounding_value
638: ( to_number(lv_after(1)) * ln_factor
639: , pn_legal_entity_id
640: );
641: ELSIF ( v_row.transaction_type_code = 'ADJUSTMENT'

Line 654: lv_after(1) := ja_cn_utility.get_rounding_value

650: INTO lv_after(1)
651: FROM fa_financial_inquiry_upl_v
652: WHERE (transaction_header_id = v_row.transaction_header_id)
653: AND ROWNUM = 1;
654: lv_after(1) := ja_cn_utility.get_rounding_value
655: ( to_number(lv_after(1)) * ln_factor
656: , pn_legal_entity_id
657: );
658: END IF; -- (v_row.transaction_type_code = 'ADDITION')

Line 663: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'

659: FOR i IN 1..lv_before.count LOOP
660: IF (lv_before(i) <> lv_after(i))
661: THEN
662: ln_row_count := ln_row_count + 1;
663: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
664: ,Ja_Cn_Utility.GV_TAG_TYPE_START
665: ,'FA');
666: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
667: ,v_row.transaction_header_id

Line 664: ,Ja_Cn_Utility.GV_TAG_TYPE_START

660: IF (lv_before(i) <> lv_after(i))
661: THEN
662: ln_row_count := ln_row_count + 1;
663: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
664: ,Ja_Cn_Utility.GV_TAG_TYPE_START
665: ,'FA');
666: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
667: ,v_row.transaction_header_id
668: ,'VARCHAR2'

Line 666: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'

662: ln_row_count := ln_row_count + 1;
663: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
664: ,Ja_Cn_Utility.GV_TAG_TYPE_START
665: ,'FA');
666: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
667: ,v_row.transaction_header_id
668: ,'VARCHAR2'
669: ,Ja_Cn_Utility.GV_REQUIRED_YES
670: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 669: ,Ja_Cn_Utility.GV_REQUIRED_YES

665: ,'FA');
666: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
667: ,v_row.transaction_header_id
668: ,'VARCHAR2'
669: ,Ja_Cn_Utility.GV_REQUIRED_YES
670: ,Ja_Cn_Utility.GV_MODULE_FA);
671: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
672: ,lv_period_name
673: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 670: ,Ja_Cn_Utility.GV_MODULE_FA);

666: Ja_Cn_Utility.Add_Child_Node('MODIFI_TRANSACTION_NUMBER'
667: ,v_row.transaction_header_id
668: ,'VARCHAR2'
669: ,Ja_Cn_Utility.GV_REQUIRED_YES
670: ,Ja_Cn_Utility.GV_MODULE_FA);
671: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
672: ,lv_period_name
673: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: ,Ja_Cn_Utility.GV_REQUIRED_YES

Line 671: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'

667: ,v_row.transaction_header_id
668: ,'VARCHAR2'
669: ,Ja_Cn_Utility.GV_REQUIRED_YES
670: ,Ja_Cn_Utility.GV_MODULE_FA);
671: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
672: ,lv_period_name
673: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: ,Ja_Cn_Utility.GV_REQUIRED_YES
675: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 673: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

669: ,Ja_Cn_Utility.GV_REQUIRED_YES
670: ,Ja_Cn_Utility.GV_MODULE_FA);
671: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
672: ,lv_period_name
673: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: ,Ja_Cn_Utility.GV_REQUIRED_YES
675: ,Ja_Cn_Utility.GV_MODULE_FA);
676: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
677: ,v_row.asset_number

Line 674: ,Ja_Cn_Utility.GV_REQUIRED_YES

670: ,Ja_Cn_Utility.GV_MODULE_FA);
671: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
672: ,lv_period_name
673: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: ,Ja_Cn_Utility.GV_REQUIRED_YES
675: ,Ja_Cn_Utility.GV_MODULE_FA);
676: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
677: ,v_row.asset_number
678: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 675: ,Ja_Cn_Utility.GV_MODULE_FA);

671: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD'
672: ,lv_period_name
673: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: ,Ja_Cn_Utility.GV_REQUIRED_YES
675: ,Ja_Cn_Utility.GV_MODULE_FA);
676: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
677: ,v_row.asset_number
678: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
679: ,Ja_Cn_Utility.GV_REQUIRED_YES

Line 676: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'

672: ,lv_period_name
673: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: ,Ja_Cn_Utility.GV_REQUIRED_YES
675: ,Ja_Cn_Utility.GV_MODULE_FA);
676: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
677: ,v_row.asset_number
678: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
679: ,Ja_Cn_Utility.GV_REQUIRED_YES
680: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 678: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

674: ,Ja_Cn_Utility.GV_REQUIRED_YES
675: ,Ja_Cn_Utility.GV_MODULE_FA);
676: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
677: ,v_row.asset_number
678: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
679: ,Ja_Cn_Utility.GV_REQUIRED_YES
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
682: ,v_row.asset_number

Line 679: ,Ja_Cn_Utility.GV_REQUIRED_YES

675: ,Ja_Cn_Utility.GV_MODULE_FA);
676: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
677: ,v_row.asset_number
678: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
679: ,Ja_Cn_Utility.GV_REQUIRED_YES
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
682: ,v_row.asset_number
683: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 680: ,Ja_Cn_Utility.GV_MODULE_FA);

676: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_CARD_NUMBER'
677: ,v_row.asset_number
678: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
679: ,Ja_Cn_Utility.GV_REQUIRED_YES
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
682: ,v_row.asset_number
683: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
684: ,Ja_Cn_Utility.GV_REQUIRED_YES

Line 681: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'

677: ,v_row.asset_number
678: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
679: ,Ja_Cn_Utility.GV_REQUIRED_YES
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
682: ,v_row.asset_number
683: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
684: ,Ja_Cn_Utility.GV_REQUIRED_YES
685: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 683: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

679: ,Ja_Cn_Utility.GV_REQUIRED_YES
680: ,Ja_Cn_Utility.GV_MODULE_FA);
681: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
682: ,v_row.asset_number
683: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
684: ,Ja_Cn_Utility.GV_REQUIRED_YES
685: ,Ja_Cn_Utility.GV_MODULE_FA);
686: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
687: ,v_row.description

Line 684: ,Ja_Cn_Utility.GV_REQUIRED_YES

680: ,Ja_Cn_Utility.GV_MODULE_FA);
681: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
682: ,v_row.asset_number
683: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
684: ,Ja_Cn_Utility.GV_REQUIRED_YES
685: ,Ja_Cn_Utility.GV_MODULE_FA);
686: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
687: ,v_row.description
688: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 685: ,Ja_Cn_Utility.GV_MODULE_FA);

681: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NUMBER'
682: ,v_row.asset_number
683: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
684: ,Ja_Cn_Utility.GV_REQUIRED_YES
685: ,Ja_Cn_Utility.GV_MODULE_FA);
686: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
687: ,v_row.description
688: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
689: ,Ja_Cn_Utility.GV_REQUIRED_YES

Line 686: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'

682: ,v_row.asset_number
683: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
684: ,Ja_Cn_Utility.GV_REQUIRED_YES
685: ,Ja_Cn_Utility.GV_MODULE_FA);
686: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
687: ,v_row.description
688: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
689: ,Ja_Cn_Utility.GV_REQUIRED_YES
690: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 688: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

684: ,Ja_Cn_Utility.GV_REQUIRED_YES
685: ,Ja_Cn_Utility.GV_MODULE_FA);
686: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
687: ,v_row.description
688: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
689: ,Ja_Cn_Utility.GV_REQUIRED_YES
690: ,Ja_Cn_Utility.GV_MODULE_FA);
691: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
692: ,v_row.transaction_type_code

Line 689: ,Ja_Cn_Utility.GV_REQUIRED_YES

685: ,Ja_Cn_Utility.GV_MODULE_FA);
686: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
687: ,v_row.description
688: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
689: ,Ja_Cn_Utility.GV_REQUIRED_YES
690: ,Ja_Cn_Utility.GV_MODULE_FA);
691: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
692: ,v_row.transaction_type_code
693: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 690: ,Ja_Cn_Utility.GV_MODULE_FA);

686: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_NAME'
687: ,v_row.description
688: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
689: ,Ja_Cn_Utility.GV_REQUIRED_YES
690: ,Ja_Cn_Utility.GV_MODULE_FA);
691: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
692: ,v_row.transaction_type_code
693: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
694: ,Ja_Cn_Utility.GV_REQUIRED_YES

Line 691: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'

687: ,v_row.description
688: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
689: ,Ja_Cn_Utility.GV_REQUIRED_YES
690: ,Ja_Cn_Utility.GV_MODULE_FA);
691: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
692: ,v_row.transaction_type_code
693: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
694: ,Ja_Cn_Utility.GV_REQUIRED_YES
695: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 693: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

689: ,Ja_Cn_Utility.GV_REQUIRED_YES
690: ,Ja_Cn_Utility.GV_MODULE_FA);
691: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
692: ,v_row.transaction_type_code
693: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
694: ,Ja_Cn_Utility.GV_REQUIRED_YES
695: ,Ja_Cn_Utility.GV_MODULE_FA);
696: /** bug#10114509 remove the fixed_asset_tag_number sector
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'

Line 694: ,Ja_Cn_Utility.GV_REQUIRED_YES

690: ,Ja_Cn_Utility.GV_MODULE_FA);
691: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
692: ,v_row.transaction_type_code
693: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
694: ,Ja_Cn_Utility.GV_REQUIRED_YES
695: ,Ja_Cn_Utility.GV_MODULE_FA);
696: /** bug#10114509 remove the fixed_asset_tag_number sector
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
698: ,v_row.tag_number

Line 695: ,Ja_Cn_Utility.GV_MODULE_FA);

691: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_METHOD_CODE'
692: ,v_row.transaction_type_code
693: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
694: ,Ja_Cn_Utility.GV_REQUIRED_YES
695: ,Ja_Cn_Utility.GV_MODULE_FA);
696: /** bug#10114509 remove the fixed_asset_tag_number sector
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
698: ,v_row.tag_number
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'

693: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
694: ,Ja_Cn_Utility.GV_REQUIRED_YES
695: ,Ja_Cn_Utility.GV_MODULE_FA);
696: /** bug#10114509 remove the fixed_asset_tag_number sector
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
698: ,v_row.tag_number
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

695: ,Ja_Cn_Utility.GV_MODULE_FA);
696: /** bug#10114509 remove the fixed_asset_tag_number sector
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
698: ,v_row.tag_number
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: **/
703: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'

Line 700: ,Ja_Cn_Utility.GV_REQUIRED_YES

696: /** bug#10114509 remove the fixed_asset_tag_number sector
697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
698: ,v_row.tag_number
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: **/
703: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
704: ,TO_CHAR( v_row.transaction_date

Line 701: ,Ja_Cn_Utility.GV_MODULE_FA);

697: Ja_Cn_Utility.Add_Child_Node('FIXED_ASSET_TAG_NUMBER'
698: ,v_row.tag_number
699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: **/
703: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
704: ,TO_CHAR( v_row.transaction_date
705: , 'YYYYMMDD')

Line 703: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'

699: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
700: ,Ja_Cn_Utility.GV_REQUIRED_YES
701: ,Ja_Cn_Utility.GV_MODULE_FA);
702: **/
703: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
704: ,TO_CHAR( v_row.transaction_date
705: , 'YYYYMMDD')
706: ,8
707: ,Ja_Cn_Utility.GV_REQUIRED_YES

Line 707: ,Ja_Cn_Utility.GV_REQUIRED_YES

703: Ja_Cn_Utility.Add_Fixed_Child_Node('MODIFICATION_DATE'
704: ,TO_CHAR( v_row.transaction_date
705: , 'YYYYMMDD')
706: ,8
707: ,Ja_Cn_Utility.GV_REQUIRED_YES
708: ,Ja_Cn_Utility.GV_MODULE_FA);
709: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
710: ,lv_change_content(i) || lv_before(i)
711: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 708: ,Ja_Cn_Utility.GV_MODULE_FA);

704: ,TO_CHAR( v_row.transaction_date
705: , 'YYYYMMDD')
706: ,8
707: ,Ja_Cn_Utility.GV_REQUIRED_YES
708: ,Ja_Cn_Utility.GV_MODULE_FA);
709: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
710: ,lv_change_content(i) || lv_before(i)
711: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
712: ,Ja_Cn_Utility.GV_REQUIRED_YES

Line 709: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'

705: , 'YYYYMMDD')
706: ,8
707: ,Ja_Cn_Utility.GV_REQUIRED_YES
708: ,Ja_Cn_Utility.GV_MODULE_FA);
709: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
710: ,lv_change_content(i) || lv_before(i)
711: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
712: ,Ja_Cn_Utility.GV_REQUIRED_YES
713: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 711: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

707: ,Ja_Cn_Utility.GV_REQUIRED_YES
708: ,Ja_Cn_Utility.GV_MODULE_FA);
709: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
710: ,lv_change_content(i) || lv_before(i)
711: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
712: ,Ja_Cn_Utility.GV_REQUIRED_YES
713: ,Ja_Cn_Utility.GV_MODULE_FA);
714: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
715: ,lv_change_content(i) || lv_after(i)

Line 712: ,Ja_Cn_Utility.GV_REQUIRED_YES

708: ,Ja_Cn_Utility.GV_MODULE_FA);
709: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
710: ,lv_change_content(i) || lv_before(i)
711: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
712: ,Ja_Cn_Utility.GV_REQUIRED_YES
713: ,Ja_Cn_Utility.GV_MODULE_FA);
714: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
715: ,lv_change_content(i) || lv_after(i)
716: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 713: ,Ja_Cn_Utility.GV_MODULE_FA);

709: Ja_Cn_Utility.Add_Child_Node('PRE-MODIFI_CONTENT_AND_AMOUNT'
710: ,lv_change_content(i) || lv_before(i)
711: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
712: ,Ja_Cn_Utility.GV_REQUIRED_YES
713: ,Ja_Cn_Utility.GV_MODULE_FA);
714: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
715: ,lv_change_content(i) || lv_after(i)
716: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
717: ,Ja_Cn_Utility.GV_REQUIRED_YES

Line 714: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'

710: ,lv_change_content(i) || lv_before(i)
711: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
712: ,Ja_Cn_Utility.GV_REQUIRED_YES
713: ,Ja_Cn_Utility.GV_MODULE_FA);
714: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
715: ,lv_change_content(i) || lv_after(i)
716: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
717: ,Ja_Cn_Utility.GV_REQUIRED_YES
718: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 716: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

712: ,Ja_Cn_Utility.GV_REQUIRED_YES
713: ,Ja_Cn_Utility.GV_MODULE_FA);
714: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
715: ,lv_change_content(i) || lv_after(i)
716: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
717: ,Ja_Cn_Utility.GV_REQUIRED_YES
718: ,Ja_Cn_Utility.GV_MODULE_FA);
719: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
720: ,lv_change_reason

Line 717: ,Ja_Cn_Utility.GV_REQUIRED_YES

713: ,Ja_Cn_Utility.GV_MODULE_FA);
714: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
715: ,lv_change_content(i) || lv_after(i)
716: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
717: ,Ja_Cn_Utility.GV_REQUIRED_YES
718: ,Ja_Cn_Utility.GV_MODULE_FA);
719: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
720: ,lv_change_reason
721: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 718: ,Ja_Cn_Utility.GV_MODULE_FA);

714: Ja_Cn_Utility.Add_Child_Node('POST-MODIFI_CONTENT_AND_AMOUNT'
715: ,lv_change_content(i) || lv_after(i)
716: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
717: ,Ja_Cn_Utility.GV_REQUIRED_YES
718: ,Ja_Cn_Utility.GV_MODULE_FA);
719: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
720: ,lv_change_reason
721: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
722: ,Ja_Cn_Utility.GV_REQUIRED_YES

Line 719: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'

715: ,lv_change_content(i) || lv_after(i)
716: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
717: ,Ja_Cn_Utility.GV_REQUIRED_YES
718: ,Ja_Cn_Utility.GV_MODULE_FA);
719: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
720: ,lv_change_reason
721: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
722: ,Ja_Cn_Utility.GV_REQUIRED_YES
723: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 721: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

717: ,Ja_Cn_Utility.GV_REQUIRED_YES
718: ,Ja_Cn_Utility.GV_MODULE_FA);
719: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
720: ,lv_change_reason
721: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
722: ,Ja_Cn_Utility.GV_REQUIRED_YES
723: ,Ja_Cn_Utility.GV_MODULE_FA);
724: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
725: ,Ja_Cn_Utility.GV_TAG_TYPE_END

Line 722: ,Ja_Cn_Utility.GV_REQUIRED_YES

718: ,Ja_Cn_Utility.GV_MODULE_FA);
719: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
720: ,lv_change_reason
721: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
722: ,Ja_Cn_Utility.GV_REQUIRED_YES
723: ,Ja_Cn_Utility.GV_MODULE_FA);
724: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
725: ,Ja_Cn_Utility.GV_TAG_TYPE_END
726: ,Ja_Cn_Utility.GV_MODULE_FA);

Line 723: ,Ja_Cn_Utility.GV_MODULE_FA);

719: Ja_Cn_Utility.Add_Child_Node('MODIFICATION_REASON'
720: ,lv_change_reason
721: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
722: ,Ja_Cn_Utility.GV_REQUIRED_YES
723: ,Ja_Cn_Utility.GV_MODULE_FA);
724: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
725: ,Ja_Cn_Utility.GV_TAG_TYPE_END
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: END IF; --(lv_before(i) <> lv_after(i))

Line 724: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'

720: ,lv_change_reason
721: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
722: ,Ja_Cn_Utility.GV_REQUIRED_YES
723: ,Ja_Cn_Utility.GV_MODULE_FA);
724: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
725: ,Ja_Cn_Utility.GV_TAG_TYPE_END
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: END IF; --(lv_before(i) <> lv_after(i))
728: END LOOP; --FOR i IN 1..lv_before.count LOOP

Line 725: ,Ja_Cn_Utility.GV_TAG_TYPE_END

721: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
722: ,Ja_Cn_Utility.GV_REQUIRED_YES
723: ,Ja_Cn_Utility.GV_MODULE_FA);
724: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
725: ,Ja_Cn_Utility.GV_TAG_TYPE_END
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: END IF; --(lv_before(i) <> lv_after(i))
728: END LOOP; --FOR i IN 1..lv_before.count LOOP
729: END LOOP; --v_row IN asset_modification_cur

Line 726: ,Ja_Cn_Utility.GV_MODULE_FA);

722: ,Ja_Cn_Utility.GV_REQUIRED_YES
723: ,Ja_Cn_Utility.GV_MODULE_FA);
724: Ja_Cn_Utility.Add_Sub_Root_Node('FIXED_ASSET_MODIFICATION_INFO'
725: ,Ja_Cn_Utility.GV_TAG_TYPE_END
726: ,Ja_Cn_Utility.GV_MODULE_FA);
727: END IF; --(lv_before(i) <> lv_after(i))
728: END LOOP; --FOR i IN 1..lv_before.count LOOP
729: END LOOP; --v_row IN asset_modification_cur
730:

Line 733: Ja_Cn_Utility.Print_No_Data_Found_For_Log

729: END LOOP; --v_row IN asset_modification_cur
730:
731: IF (ln_row_count = 0)
732: THEN
733: Ja_Cn_Utility.Print_No_Data_Found_For_Log
734: ( 'FIXED_ASSET_MODIFICATION_INFO'
735: , Ja_Cn_Utility.GV_MODULE_FA
736: );
737: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'

Line 735: , Ja_Cn_Utility.GV_MODULE_FA

731: IF (ln_row_count = 0)
732: THEN
733: Ja_Cn_Utility.Print_No_Data_Found_For_Log
734: ( 'FIXED_ASSET_MODIFICATION_INFO'
735: , Ja_Cn_Utility.GV_MODULE_FA
736: );
737: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
738: , Ja_Cn_Utility.GV_TAG_TYPE_START
739: , Ja_Cn_Utility.GV_MODULE_FA

Line 737: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'

733: Ja_Cn_Utility.Print_No_Data_Found_For_Log
734: ( 'FIXED_ASSET_MODIFICATION_INFO'
735: , Ja_Cn_Utility.GV_MODULE_FA
736: );
737: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
738: , Ja_Cn_Utility.GV_TAG_TYPE_START
739: , Ja_Cn_Utility.GV_MODULE_FA
740: );
741: Ja_Cn_Utility.Add_Child_Node( 'MODIFI_TRANSACTION_NUMBER'

Line 738: , Ja_Cn_Utility.GV_TAG_TYPE_START

734: ( 'FIXED_ASSET_MODIFICATION_INFO'
735: , Ja_Cn_Utility.GV_MODULE_FA
736: );
737: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
738: , Ja_Cn_Utility.GV_TAG_TYPE_START
739: , Ja_Cn_Utility.GV_MODULE_FA
740: );
741: Ja_Cn_Utility.Add_Child_Node( 'MODIFI_TRANSACTION_NUMBER'
742: , NULL

Line 739: , Ja_Cn_Utility.GV_MODULE_FA

735: , Ja_Cn_Utility.GV_MODULE_FA
736: );
737: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
738: , Ja_Cn_Utility.GV_TAG_TYPE_START
739: , Ja_Cn_Utility.GV_MODULE_FA
740: );
741: Ja_Cn_Utility.Add_Child_Node( 'MODIFI_TRANSACTION_NUMBER'
742: , NULL
743: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 741: Ja_Cn_Utility.Add_Child_Node( 'MODIFI_TRANSACTION_NUMBER'

737: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
738: , Ja_Cn_Utility.GV_TAG_TYPE_START
739: , Ja_Cn_Utility.GV_MODULE_FA
740: );
741: Ja_Cn_Utility.Add_Child_Node( 'MODIFI_TRANSACTION_NUMBER'
742: , NULL
743: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
744: , Ja_Cn_Utility.GV_REQUIRED_YES
745: , Ja_Cn_Utility.GV_MODULE_FA

Line 743: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

739: , Ja_Cn_Utility.GV_MODULE_FA
740: );
741: Ja_Cn_Utility.Add_Child_Node( 'MODIFI_TRANSACTION_NUMBER'
742: , NULL
743: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
744: , Ja_Cn_Utility.GV_REQUIRED_YES
745: , Ja_Cn_Utility.GV_MODULE_FA
746: );
747: Ja_Cn_Utility.Add_Child_Node( 'ACCOUNTING_PERIOD'

Line 744: , Ja_Cn_Utility.GV_REQUIRED_YES

740: );
741: Ja_Cn_Utility.Add_Child_Node( 'MODIFI_TRANSACTION_NUMBER'
742: , NULL
743: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
744: , Ja_Cn_Utility.GV_REQUIRED_YES
745: , Ja_Cn_Utility.GV_MODULE_FA
746: );
747: Ja_Cn_Utility.Add_Child_Node( 'ACCOUNTING_PERIOD'
748: , NULL

Line 745: , Ja_Cn_Utility.GV_MODULE_FA

741: Ja_Cn_Utility.Add_Child_Node( 'MODIFI_TRANSACTION_NUMBER'
742: , NULL
743: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
744: , Ja_Cn_Utility.GV_REQUIRED_YES
745: , Ja_Cn_Utility.GV_MODULE_FA
746: );
747: Ja_Cn_Utility.Add_Child_Node( 'ACCOUNTING_PERIOD'
748: , NULL
749: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 747: Ja_Cn_Utility.Add_Child_Node( 'ACCOUNTING_PERIOD'

743: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
744: , Ja_Cn_Utility.GV_REQUIRED_YES
745: , Ja_Cn_Utility.GV_MODULE_FA
746: );
747: Ja_Cn_Utility.Add_Child_Node( 'ACCOUNTING_PERIOD'
748: , NULL
749: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
750: , Ja_Cn_Utility.GV_REQUIRED_YES
751: , Ja_Cn_Utility.GV_MODULE_FA

Line 749: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

745: , Ja_Cn_Utility.GV_MODULE_FA
746: );
747: Ja_Cn_Utility.Add_Child_Node( 'ACCOUNTING_PERIOD'
748: , NULL
749: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
750: , Ja_Cn_Utility.GV_REQUIRED_YES
751: , Ja_Cn_Utility.GV_MODULE_FA
752: );
753: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_CARD_NUMBER'

Line 750: , Ja_Cn_Utility.GV_REQUIRED_YES

746: );
747: Ja_Cn_Utility.Add_Child_Node( 'ACCOUNTING_PERIOD'
748: , NULL
749: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
750: , Ja_Cn_Utility.GV_REQUIRED_YES
751: , Ja_Cn_Utility.GV_MODULE_FA
752: );
753: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_CARD_NUMBER'
754: , NULL

Line 751: , Ja_Cn_Utility.GV_MODULE_FA

747: Ja_Cn_Utility.Add_Child_Node( 'ACCOUNTING_PERIOD'
748: , NULL
749: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
750: , Ja_Cn_Utility.GV_REQUIRED_YES
751: , Ja_Cn_Utility.GV_MODULE_FA
752: );
753: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_CARD_NUMBER'
754: , NULL
755: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 753: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_CARD_NUMBER'

749: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
750: , Ja_Cn_Utility.GV_REQUIRED_YES
751: , Ja_Cn_Utility.GV_MODULE_FA
752: );
753: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_CARD_NUMBER'
754: , NULL
755: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
756: , Ja_Cn_Utility.GV_REQUIRED_YES
757: , Ja_Cn_Utility.GV_MODULE_FA

Line 755: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

751: , Ja_Cn_Utility.GV_MODULE_FA
752: );
753: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_CARD_NUMBER'
754: , NULL
755: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
756: , Ja_Cn_Utility.GV_REQUIRED_YES
757: , Ja_Cn_Utility.GV_MODULE_FA
758: );
759: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NUMBER'

Line 756: , Ja_Cn_Utility.GV_REQUIRED_YES

752: );
753: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_CARD_NUMBER'
754: , NULL
755: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
756: , Ja_Cn_Utility.GV_REQUIRED_YES
757: , Ja_Cn_Utility.GV_MODULE_FA
758: );
759: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NUMBER'
760: , NULL

Line 757: , Ja_Cn_Utility.GV_MODULE_FA

753: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_CARD_NUMBER'
754: , NULL
755: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
756: , Ja_Cn_Utility.GV_REQUIRED_YES
757: , Ja_Cn_Utility.GV_MODULE_FA
758: );
759: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NUMBER'
760: , NULL
761: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 759: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NUMBER'

755: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
756: , Ja_Cn_Utility.GV_REQUIRED_YES
757: , Ja_Cn_Utility.GV_MODULE_FA
758: );
759: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NUMBER'
760: , NULL
761: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
762: , Ja_Cn_Utility.GV_REQUIRED_YES
763: , Ja_Cn_Utility.GV_MODULE_FA

Line 761: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

757: , Ja_Cn_Utility.GV_MODULE_FA
758: );
759: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NUMBER'
760: , NULL
761: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
762: , Ja_Cn_Utility.GV_REQUIRED_YES
763: , Ja_Cn_Utility.GV_MODULE_FA
764: );
765: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NAME'

Line 762: , Ja_Cn_Utility.GV_REQUIRED_YES

758: );
759: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NUMBER'
760: , NULL
761: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
762: , Ja_Cn_Utility.GV_REQUIRED_YES
763: , Ja_Cn_Utility.GV_MODULE_FA
764: );
765: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NAME'
766: , NULL

Line 763: , Ja_Cn_Utility.GV_MODULE_FA

759: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NUMBER'
760: , NULL
761: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
762: , Ja_Cn_Utility.GV_REQUIRED_YES
763: , Ja_Cn_Utility.GV_MODULE_FA
764: );
765: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NAME'
766: , NULL
767: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 765: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NAME'

761: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
762: , Ja_Cn_Utility.GV_REQUIRED_YES
763: , Ja_Cn_Utility.GV_MODULE_FA
764: );
765: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NAME'
766: , NULL
767: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
768: , Ja_Cn_Utility.GV_REQUIRED_YES
769: , Ja_Cn_Utility.GV_MODULE_FA

Line 767: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

763: , Ja_Cn_Utility.GV_MODULE_FA
764: );
765: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NAME'
766: , NULL
767: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
768: , Ja_Cn_Utility.GV_REQUIRED_YES
769: , Ja_Cn_Utility.GV_MODULE_FA
770: );
771: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_METHOD_CODE'

Line 768: , Ja_Cn_Utility.GV_REQUIRED_YES

764: );
765: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NAME'
766: , NULL
767: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
768: , Ja_Cn_Utility.GV_REQUIRED_YES
769: , Ja_Cn_Utility.GV_MODULE_FA
770: );
771: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_METHOD_CODE'
772: , NULL

Line 769: , Ja_Cn_Utility.GV_MODULE_FA

765: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_NAME'
766: , NULL
767: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
768: , Ja_Cn_Utility.GV_REQUIRED_YES
769: , Ja_Cn_Utility.GV_MODULE_FA
770: );
771: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_METHOD_CODE'
772: , NULL
773: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 771: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_METHOD_CODE'

767: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
768: , Ja_Cn_Utility.GV_REQUIRED_YES
769: , Ja_Cn_Utility.GV_MODULE_FA
770: );
771: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_METHOD_CODE'
772: , NULL
773: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
774: , Ja_Cn_Utility.GV_REQUIRED_YES
775: , Ja_Cn_Utility.GV_MODULE_FA

Line 773: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

769: , Ja_Cn_Utility.GV_MODULE_FA
770: );
771: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_METHOD_CODE'
772: , NULL
773: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
774: , Ja_Cn_Utility.GV_REQUIRED_YES
775: , Ja_Cn_Utility.GV_MODULE_FA
776: );
777: /**bug#10114509 remove the fixed_asset_tag_number sector

Line 774: , Ja_Cn_Utility.GV_REQUIRED_YES

770: );
771: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_METHOD_CODE'
772: , NULL
773: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
774: , Ja_Cn_Utility.GV_REQUIRED_YES
775: , Ja_Cn_Utility.GV_MODULE_FA
776: );
777: /**bug#10114509 remove the fixed_asset_tag_number sector
778: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_TAG_NUMBER'

Line 775: , Ja_Cn_Utility.GV_MODULE_FA

771: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_METHOD_CODE'
772: , NULL
773: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
774: , Ja_Cn_Utility.GV_REQUIRED_YES
775: , Ja_Cn_Utility.GV_MODULE_FA
776: );
777: /**bug#10114509 remove the fixed_asset_tag_number sector
778: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_TAG_NUMBER'
779: , NULL

Line 778: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_TAG_NUMBER'

774: , Ja_Cn_Utility.GV_REQUIRED_YES
775: , Ja_Cn_Utility.GV_MODULE_FA
776: );
777: /**bug#10114509 remove the fixed_asset_tag_number sector
778: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_TAG_NUMBER'
779: , NULL
780: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
781: , Ja_Cn_Utility.GV_REQUIRED_YES
782: , Ja_Cn_Utility.GV_MODULE_FA

Line 780: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

776: );
777: /**bug#10114509 remove the fixed_asset_tag_number sector
778: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_TAG_NUMBER'
779: , NULL
780: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
781: , Ja_Cn_Utility.GV_REQUIRED_YES
782: , Ja_Cn_Utility.GV_MODULE_FA
783: );
784: **/

Line 781: , Ja_Cn_Utility.GV_REQUIRED_YES

777: /**bug#10114509 remove the fixed_asset_tag_number sector
778: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_TAG_NUMBER'
779: , NULL
780: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
781: , Ja_Cn_Utility.GV_REQUIRED_YES
782: , Ja_Cn_Utility.GV_MODULE_FA
783: );
784: **/
785: Ja_Cn_Utility.Add_Fixed_Child_Node( 'MODIFICATION_DATE'

Line 782: , Ja_Cn_Utility.GV_MODULE_FA

778: Ja_Cn_Utility.Add_Child_Node( 'FIXED_ASSET_TAG_NUMBER'
779: , NULL
780: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
781: , Ja_Cn_Utility.GV_REQUIRED_YES
782: , Ja_Cn_Utility.GV_MODULE_FA
783: );
784: **/
785: Ja_Cn_Utility.Add_Fixed_Child_Node( 'MODIFICATION_DATE'
786: , NULL

Line 785: Ja_Cn_Utility.Add_Fixed_Child_Node( 'MODIFICATION_DATE'

781: , Ja_Cn_Utility.GV_REQUIRED_YES
782: , Ja_Cn_Utility.GV_MODULE_FA
783: );
784: **/
785: Ja_Cn_Utility.Add_Fixed_Child_Node( 'MODIFICATION_DATE'
786: , NULL
787: , 8
788: , Ja_Cn_Utility.GV_REQUIRED_YES
789: , Ja_Cn_Utility.GV_MODULE_FA

Line 788: , Ja_Cn_Utility.GV_REQUIRED_YES

784: **/
785: Ja_Cn_Utility.Add_Fixed_Child_Node( 'MODIFICATION_DATE'
786: , NULL
787: , 8
788: , Ja_Cn_Utility.GV_REQUIRED_YES
789: , Ja_Cn_Utility.GV_MODULE_FA
790: );
791: Ja_Cn_Utility.Add_Child_Node( 'PRE-MODIFI_CONTENT_AND_AMOUNT'
792: , NULL

Line 789: , Ja_Cn_Utility.GV_MODULE_FA

785: Ja_Cn_Utility.Add_Fixed_Child_Node( 'MODIFICATION_DATE'
786: , NULL
787: , 8
788: , Ja_Cn_Utility.GV_REQUIRED_YES
789: , Ja_Cn_Utility.GV_MODULE_FA
790: );
791: Ja_Cn_Utility.Add_Child_Node( 'PRE-MODIFI_CONTENT_AND_AMOUNT'
792: , NULL
793: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 791: Ja_Cn_Utility.Add_Child_Node( 'PRE-MODIFI_CONTENT_AND_AMOUNT'

787: , 8
788: , Ja_Cn_Utility.GV_REQUIRED_YES
789: , Ja_Cn_Utility.GV_MODULE_FA
790: );
791: Ja_Cn_Utility.Add_Child_Node( 'PRE-MODIFI_CONTENT_AND_AMOUNT'
792: , NULL
793: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
794: , Ja_Cn_Utility.GV_REQUIRED_YES
795: , Ja_Cn_Utility.GV_MODULE_FA

Line 793: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

789: , Ja_Cn_Utility.GV_MODULE_FA
790: );
791: Ja_Cn_Utility.Add_Child_Node( 'PRE-MODIFI_CONTENT_AND_AMOUNT'
792: , NULL
793: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
794: , Ja_Cn_Utility.GV_REQUIRED_YES
795: , Ja_Cn_Utility.GV_MODULE_FA
796: );
797: Ja_Cn_Utility.Add_Child_Node( 'POST-MODIFI_CONTENT_AND_AMOUNT'

Line 794: , Ja_Cn_Utility.GV_REQUIRED_YES

790: );
791: Ja_Cn_Utility.Add_Child_Node( 'PRE-MODIFI_CONTENT_AND_AMOUNT'
792: , NULL
793: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
794: , Ja_Cn_Utility.GV_REQUIRED_YES
795: , Ja_Cn_Utility.GV_MODULE_FA
796: );
797: Ja_Cn_Utility.Add_Child_Node( 'POST-MODIFI_CONTENT_AND_AMOUNT'
798: , NULL

Line 795: , Ja_Cn_Utility.GV_MODULE_FA

791: Ja_Cn_Utility.Add_Child_Node( 'PRE-MODIFI_CONTENT_AND_AMOUNT'
792: , NULL
793: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
794: , Ja_Cn_Utility.GV_REQUIRED_YES
795: , Ja_Cn_Utility.GV_MODULE_FA
796: );
797: Ja_Cn_Utility.Add_Child_Node( 'POST-MODIFI_CONTENT_AND_AMOUNT'
798: , NULL
799: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 797: Ja_Cn_Utility.Add_Child_Node( 'POST-MODIFI_CONTENT_AND_AMOUNT'

793: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
794: , Ja_Cn_Utility.GV_REQUIRED_YES
795: , Ja_Cn_Utility.GV_MODULE_FA
796: );
797: Ja_Cn_Utility.Add_Child_Node( 'POST-MODIFI_CONTENT_AND_AMOUNT'
798: , NULL
799: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
800: , Ja_Cn_Utility.GV_REQUIRED_YES
801: , Ja_Cn_Utility.GV_MODULE_FA

Line 799: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

795: , Ja_Cn_Utility.GV_MODULE_FA
796: );
797: Ja_Cn_Utility.Add_Child_Node( 'POST-MODIFI_CONTENT_AND_AMOUNT'
798: , NULL
799: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
800: , Ja_Cn_Utility.GV_REQUIRED_YES
801: , Ja_Cn_Utility.GV_MODULE_FA
802: );
803: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_REASON'

Line 800: , Ja_Cn_Utility.GV_REQUIRED_YES

796: );
797: Ja_Cn_Utility.Add_Child_Node( 'POST-MODIFI_CONTENT_AND_AMOUNT'
798: , NULL
799: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
800: , Ja_Cn_Utility.GV_REQUIRED_YES
801: , Ja_Cn_Utility.GV_MODULE_FA
802: );
803: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_REASON'
804: , NULL

Line 801: , Ja_Cn_Utility.GV_MODULE_FA

797: Ja_Cn_Utility.Add_Child_Node( 'POST-MODIFI_CONTENT_AND_AMOUNT'
798: , NULL
799: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
800: , Ja_Cn_Utility.GV_REQUIRED_YES
801: , Ja_Cn_Utility.GV_MODULE_FA
802: );
803: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_REASON'
804: , NULL
805: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 803: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_REASON'

799: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
800: , Ja_Cn_Utility.GV_REQUIRED_YES
801: , Ja_Cn_Utility.GV_MODULE_FA
802: );
803: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_REASON'
804: , NULL
805: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
806: , Ja_Cn_Utility.GV_REQUIRED_YES
807: , Ja_Cn_Utility.GV_MODULE_FA

Line 805: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

801: , Ja_Cn_Utility.GV_MODULE_FA
802: );
803: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_REASON'
804: , NULL
805: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
806: , Ja_Cn_Utility.GV_REQUIRED_YES
807: , Ja_Cn_Utility.GV_MODULE_FA
808: );
809: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'

Line 806: , Ja_Cn_Utility.GV_REQUIRED_YES

802: );
803: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_REASON'
804: , NULL
805: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
806: , Ja_Cn_Utility.GV_REQUIRED_YES
807: , Ja_Cn_Utility.GV_MODULE_FA
808: );
809: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
810: , Ja_Cn_Utility.GV_TAG_TYPE_END

Line 807: , Ja_Cn_Utility.GV_MODULE_FA

803: Ja_Cn_Utility.Add_Child_Node( 'MODIFICATION_REASON'
804: , NULL
805: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
806: , Ja_Cn_Utility.GV_REQUIRED_YES
807: , Ja_Cn_Utility.GV_MODULE_FA
808: );
809: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
810: , Ja_Cn_Utility.GV_TAG_TYPE_END
811: , Ja_Cn_Utility.GV_MODULE_FA

Line 809: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'

805: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
806: , Ja_Cn_Utility.GV_REQUIRED_YES
807: , Ja_Cn_Utility.GV_MODULE_FA
808: );
809: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
810: , Ja_Cn_Utility.GV_TAG_TYPE_END
811: , Ja_Cn_Utility.GV_MODULE_FA
812: );
813: END IF; --ln_row_count = 0

Line 810: , Ja_Cn_Utility.GV_TAG_TYPE_END

806: , Ja_Cn_Utility.GV_REQUIRED_YES
807: , Ja_Cn_Utility.GV_MODULE_FA
808: );
809: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
810: , Ja_Cn_Utility.GV_TAG_TYPE_END
811: , Ja_Cn_Utility.GV_MODULE_FA
812: );
813: END IF; --ln_row_count = 0
814:

Line 811: , Ja_Cn_Utility.GV_MODULE_FA

807: , Ja_Cn_Utility.GV_MODULE_FA
808: );
809: Ja_Cn_Utility.Add_Sub_Root_Node( 'FIXED_ASSET_MODIFICATION_INFO'
810: , Ja_Cn_Utility.GV_TAG_TYPE_END
811: , Ja_Cn_Utility.GV_MODULE_FA
812: );
813: END IF; --ln_row_count = 0
814:
815: --logging for debug