eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_PS_HRMS_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 560: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'

556: || 'pd_acc_start_date=' || ld_acc_start_date || ','
557: || 'pd_acc_end_date=' || ld_acc_end_date);
558: FOR v_row IN department_cur
559: LOOP
560: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
561: , Ja_Cn_Utility.GV_TAG_TYPE_START
562: );
563: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
564: , v_row.department_id

Line 561: , Ja_Cn_Utility.GV_TAG_TYPE_START

557: || 'pd_acc_end_date=' || ld_acc_end_date);
558: FOR v_row IN department_cur
559: LOOP
560: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
561: , Ja_Cn_Utility.GV_TAG_TYPE_START
562: );
563: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
564: , v_row.department_id
565: );

Line 563: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'

559: LOOP
560: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
561: , Ja_Cn_Utility.GV_TAG_TYPE_START
562: );
563: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
564: , v_row.department_id
565: );
566: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_NAME'
567: , v_row.department_name

Line 566: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_NAME'

562: );
563: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
564: , v_row.department_id
565: );
566: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_NAME'
567: , v_row.department_name
568: );
569: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'
570: , Get_Parent_Org_ID(v_row.department_id)

Line 569: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'

565: );
566: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_NAME'
567: , v_row.department_name
568: );
569: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'
570: , Get_Parent_Org_ID(v_row.department_id)
571: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
572: , Ja_Cn_Utility.GV_REQUIRED_NO
573: );

Line 571: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

567: , v_row.department_name
568: );
569: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'
570: , Get_Parent_Org_ID(v_row.department_id)
571: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
572: , Ja_Cn_Utility.GV_REQUIRED_NO
573: );
574: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
575: , Ja_Cn_Utility.GV_TAG_TYPE_END

Line 572: , Ja_Cn_Utility.GV_REQUIRED_NO

568: );
569: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'
570: , Get_Parent_Org_ID(v_row.department_id)
571: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
572: , Ja_Cn_Utility.GV_REQUIRED_NO
573: );
574: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
575: , Ja_Cn_Utility.GV_TAG_TYPE_END
576: );

Line 574: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'

570: , Get_Parent_Org_ID(v_row.department_id)
571: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
572: , Ja_Cn_Utility.GV_REQUIRED_NO
573: );
574: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
575: , Ja_Cn_Utility.GV_TAG_TYPE_END
576: );
577: ln_rec_count := ln_rec_count + 1;
578: END LOOP; -- FOR v_row IN department_cur

Line 575: , Ja_Cn_Utility.GV_TAG_TYPE_END

571: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
572: , Ja_Cn_Utility.GV_REQUIRED_NO
573: );
574: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
575: , Ja_Cn_Utility.GV_TAG_TYPE_END
576: );
577: ln_rec_count := ln_rec_count + 1;
578: END LOOP; -- FOR v_row IN department_cur
579:

Line 593: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'INNER_ORGANIZATION_RECORDS');

589: || 'ln_rec_count=' || ln_rec_count);
590: -- There is no data found for department record
591: IF (ln_rec_count = 0)
592: THEN
593: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'INNER_ORGANIZATION_RECORDS');
594: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
595: , Ja_Cn_Utility.GV_TAG_TYPE_START
596: );
597: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'

Line 594: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'

590: -- There is no data found for department record
591: IF (ln_rec_count = 0)
592: THEN
593: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'INNER_ORGANIZATION_RECORDS');
594: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
595: , Ja_Cn_Utility.GV_TAG_TYPE_START
596: );
597: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
598: , NULL

Line 595: , Ja_Cn_Utility.GV_TAG_TYPE_START

591: IF (ln_rec_count = 0)
592: THEN
593: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'INNER_ORGANIZATION_RECORDS');
594: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
595: , Ja_Cn_Utility.GV_TAG_TYPE_START
596: );
597: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
598: , NULL
599: );

Line 597: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'

593: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'INNER_ORGANIZATION_RECORDS');
594: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
595: , Ja_Cn_Utility.GV_TAG_TYPE_START
596: );
597: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
598: , NULL
599: );
600: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_NAME'
601: , NULL

Line 600: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_NAME'

596: );
597: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
598: , NULL
599: );
600: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_NAME'
601: , NULL
602: );
603: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'
604: , NULL

Line 603: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'

599: );
600: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_NAME'
601: , NULL
602: );
603: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'
604: , NULL
605: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
606: , Ja_Cn_Utility.GV_REQUIRED_NO
607: );

Line 605: , Ja_Cn_Utility.GV_TYPE_VARCHAR2

601: , NULL
602: );
603: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'
604: , NULL
605: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
606: , Ja_Cn_Utility.GV_REQUIRED_NO
607: );
608: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
609: , Ja_Cn_Utility.GV_TAG_TYPE_END

Line 606: , Ja_Cn_Utility.GV_REQUIRED_NO

602: );
603: Ja_Cn_Utility.Add_Child_Node( 'PARENT_ORGANIZATION_ID'
604: , NULL
605: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
606: , Ja_Cn_Utility.GV_REQUIRED_NO
607: );
608: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
609: , Ja_Cn_Utility.GV_TAG_TYPE_END
610: );

Line 608: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'

604: , NULL
605: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
606: , Ja_Cn_Utility.GV_REQUIRED_NO
607: );
608: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
609: , Ja_Cn_Utility.GV_TAG_TYPE_END
610: );
611: END IF; -- (ln_rec_count = 0)
612: --logging for debug

Line 609: , Ja_Cn_Utility.GV_TAG_TYPE_END

605: , Ja_Cn_Utility.GV_TYPE_VARCHAR2
606: , Ja_Cn_Utility.GV_REQUIRED_NO
607: );
608: Ja_Cn_Utility.Add_Sub_Root_Node( 'INNER_ORGANIZATION_RECORDS'
609: , Ja_Cn_Utility.GV_TAG_TYPE_END
610: );
611: END IF; -- (ln_rec_count = 0)
612: --logging for debug
613: IF (ln_proc_level >= ln_dbg_level)

Line 773: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'

769: || 'pd_acc_start_date='||pd_acc_start_date || ','
770: || 'pd_acc_end_date='||pd_acc_end_date);
771: FOR v_row IN employee_cur
772: LOOP
773: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
774: , Ja_Cn_Utility.GV_TAG_TYPE_START
775: );
776: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'
777: , v_row.employee_id

Line 774: , Ja_Cn_Utility.GV_TAG_TYPE_START

770: || 'pd_acc_end_date='||pd_acc_end_date);
771: FOR v_row IN employee_cur
772: LOOP
773: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
774: , Ja_Cn_Utility.GV_TAG_TYPE_START
775: );
776: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'
777: , v_row.employee_id
778: );

Line 776: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'

772: LOOP
773: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
774: , Ja_Cn_Utility.GV_TAG_TYPE_START
775: );
776: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'
777: , v_row.employee_id
778: );
779: Ja_Cn_Utility.Add_Child_Node( 'STAFF_NAME'
780: , v_row.employee_name

Line 779: Ja_Cn_Utility.Add_Child_Node( 'STAFF_NAME'

775: );
776: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'
777: , v_row.employee_id
778: );
779: Ja_Cn_Utility.Add_Child_Node( 'STAFF_NAME'
780: , v_row.employee_name
781: );
782: Ja_Cn_Utility.
783: Add_Child_Node( 'DOCUMENT_TYPE'

Line 782: Ja_Cn_Utility.

778: );
779: Ja_Cn_Utility.Add_Child_Node( 'STAFF_NAME'
780: , v_row.employee_name
781: );
782: Ja_Cn_Utility.
783: Add_Child_Node( 'DOCUMENT_TYPE'
784: , Get_Doc_Details( v_row.person_id
785: , v_row.effective_start_date
786: , 'TYPE')

Line 788: Ja_Cn_Utility.

784: , Get_Doc_Details( v_row.person_id
785: , v_row.effective_start_date
786: , 'TYPE')
787: );
788: Ja_Cn_Utility.
789: Add_Child_Node( 'DOCUMENT_NUMBER'
790: , Get_Doc_Details( v_row.person_id
791: , v_row.effective_start_date
792: , 'NAME')

Line 794: Ja_Cn_Utility.

790: , Get_Doc_Details( v_row.person_id
791: , v_row.effective_start_date
792: , 'NAME')
793: );
794: Ja_Cn_Utility.
795: Add_Child_Node( 'GENDER'
796: , Get_Lookup_Meaning( v_row.gender
797: , 'SEX')
798: );

Line 799: Ja_Cn_Utility.Add_Child_Node( 'STAFF_RACE'

795: Add_Child_Node( 'GENDER'
796: , Get_Lookup_Meaning( v_row.gender
797: , 'SEX')
798: );
799: Ja_Cn_Utility.Add_Child_Node( 'STAFF_RACE'
800: , Get_Lookup_Meaning( v_row.race
801: , 'CN_RACE')
802: );
803: Ja_Cn_Utility.Add_Fixed_Child_Node( 'DATE_OF_BIRTH'

Line 803: Ja_Cn_Utility.Add_Fixed_Child_Node( 'DATE_OF_BIRTH'

799: Ja_Cn_Utility.Add_Child_Node( 'STAFF_RACE'
800: , Get_Lookup_Meaning( v_row.race
801: , 'CN_RACE')
802: );
803: Ja_Cn_Utility.Add_Fixed_Child_Node( 'DATE_OF_BIRTH'
804: , v_row.date_of_birth
805: , 8
806: );
807: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'

Line 807: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'

803: Ja_Cn_Utility.Add_Fixed_Child_Node( 'DATE_OF_BIRTH'
804: , v_row.date_of_birth
805: , 8
806: );
807: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
808: , v_row.employee_category
809: );
810: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
811: , v_row.department_id

Line 810: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'

806: );
807: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
808: , v_row.employee_category
809: );
810: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
811: , v_row.department_id
812: );
813: Ja_Cn_Utility.
814: Add_Child_Node( 'STAFF_POSITION_LEVEL'

Line 813: Ja_Cn_Utility.

809: );
810: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
811: , v_row.department_id
812: );
813: Ja_Cn_Utility.
814: Add_Child_Node( 'STAFF_POSITION_LEVEL'
815: , Get_Cadre_Job_Details( v_row.person_id
816: --v_row.effective_start_date
817: --bug#10146613

Line 821: Ja_Cn_Utility.

817: --bug#10146613
818: , pd_acc_end_date
819: )
820: );
821: Ja_Cn_Utility.
822: Add_Child_Node( 'STAFF_TECHNICAL_POSITION'
823: , Get_Tech_Post_Details( v_row.person_id
824: --v_row.effective_start_date
825: --bug#10146613

Line 829: Ja_Cn_Utility.Add_Child_Node( 'STAFF_HIGH_EDU_LEVEL'

825: --bug#10146613
826: , pd_acc_end_date
827: )
828: );
829: Ja_Cn_Utility.Add_Child_Node( 'STAFF_HIGH_EDU_LEVEL'
830: , Get_Lookup_Meaning( v_row.education_level
831: , 'CN_HIGH_EDU_LEVEL')
832: );
833: Ja_Cn_Utility.Add_Child_Node( 'STAFF_DEGREE'

Line 833: Ja_Cn_Utility.Add_Child_Node( 'STAFF_DEGREE'

829: Ja_Cn_Utility.Add_Child_Node( 'STAFF_HIGH_EDU_LEVEL'
830: , Get_Lookup_Meaning( v_row.education_level
831: , 'CN_HIGH_EDU_LEVEL')
832: );
833: Ja_Cn_Utility.Add_Child_Node( 'STAFF_DEGREE'
834: , Get_Lookup_Meaning( v_row.degree
835: , 'CN_DEGREE')
836: );
837: Ja_Cn_Utility.Add_Fixed_Child_Node( 'HIRE_DATE'

Line 837: Ja_Cn_Utility.Add_Fixed_Child_Node( 'HIRE_DATE'

833: Ja_Cn_Utility.Add_Child_Node( 'STAFF_DEGREE'
834: , Get_Lookup_Meaning( v_row.degree
835: , 'CN_DEGREE')
836: );
837: Ja_Cn_Utility.Add_Fixed_Child_Node( 'HIRE_DATE'
838: , v_row.date_of_hire
839: , 8
840: );
841: Ja_Cn_Utility.Add_Fixed_Child_Node( 'TERMINATION_DATE'

Line 841: Ja_Cn_Utility.Add_Fixed_Child_Node( 'TERMINATION_DATE'

837: Ja_Cn_Utility.Add_Fixed_Child_Node( 'HIRE_DATE'
838: , v_row.date_of_hire
839: , 8
840: );
841: Ja_Cn_Utility.Add_Fixed_Child_Node( 'TERMINATION_DATE'
842: , v_row.date_of_termination
843: , 8
844: , Ja_Cn_Utility.GV_REQUIRED_NO
845: );

Line 844: , Ja_Cn_Utility.GV_REQUIRED_NO

840: );
841: Ja_Cn_Utility.Add_Fixed_Child_Node( 'TERMINATION_DATE'
842: , v_row.date_of_termination
843: , 8
844: , Ja_Cn_Utility.GV_REQUIRED_NO
845: );
846: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
847: , Ja_Cn_Utility.GV_TAG_TYPE_END
848: );

Line 846: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'

842: , v_row.date_of_termination
843: , 8
844: , Ja_Cn_Utility.GV_REQUIRED_NO
845: );
846: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
847: , Ja_Cn_Utility.GV_TAG_TYPE_END
848: );
849: ln_rec_count := ln_rec_count + 1;
850:

Line 847: , Ja_Cn_Utility.GV_TAG_TYPE_END

843: , 8
844: , Ja_Cn_Utility.GV_REQUIRED_NO
845: );
846: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
847: , Ja_Cn_Utility.GV_TAG_TYPE_END
848: );
849: ln_rec_count := ln_rec_count + 1;
850:
851: END LOOP; --(v_row IN employee_cur)

Line 868: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'STAFF_RECORDS');

864: -- There is no data found for employee record
865: IF ln_rec_count = 0
866: THEN
867: --Begin: Added for bug# 9722570
868: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'STAFF_RECORDS');
869: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
870: , Ja_Cn_Utility.GV_TAG_TYPE_START
871: );
872: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'

Line 869: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'

865: IF ln_rec_count = 0
866: THEN
867: --Begin: Added for bug# 9722570
868: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'STAFF_RECORDS');
869: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
870: , Ja_Cn_Utility.GV_TAG_TYPE_START
871: );
872: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'
873: , NULL

Line 870: , Ja_Cn_Utility.GV_TAG_TYPE_START

866: THEN
867: --Begin: Added for bug# 9722570
868: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'STAFF_RECORDS');
869: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
870: , Ja_Cn_Utility.GV_TAG_TYPE_START
871: );
872: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'
873: , NULL
874: );

Line 872: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'

868: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'STAFF_RECORDS');
869: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
870: , Ja_Cn_Utility.GV_TAG_TYPE_START
871: );
872: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'
873: , NULL
874: );
875: Ja_Cn_Utility.Add_Child_Node( 'STAFF_NAME'
876: , NULL

Line 875: Ja_Cn_Utility.Add_Child_Node( 'STAFF_NAME'

871: );
872: Ja_Cn_Utility.Add_Child_Node( 'STAFF_ID'
873: , NULL
874: );
875: Ja_Cn_Utility.Add_Child_Node( 'STAFF_NAME'
876: , NULL
877: );
878: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'
879: , NULL

Line 878: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'

874: );
875: Ja_Cn_Utility.Add_Child_Node( 'STAFF_NAME'
876: , NULL
877: );
878: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'
879: , NULL
880: );
881: Ja_Cn_Utility.Add_Child_Node( 'DOCUMENT_NUMBER'
882: , NULL

Line 881: Ja_Cn_Utility.Add_Child_Node( 'DOCUMENT_NUMBER'

877: );
878: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'
879: , NULL
880: );
881: Ja_Cn_Utility.Add_Child_Node( 'DOCUMENT_NUMBER'
882: , NULL
883: );
884: Ja_Cn_Utility.Add_Child_Node( 'GENDER'
885: , NULL

Line 884: Ja_Cn_Utility.Add_Child_Node( 'GENDER'

880: );
881: Ja_Cn_Utility.Add_Child_Node( 'DOCUMENT_NUMBER'
882: , NULL
883: );
884: Ja_Cn_Utility.Add_Child_Node( 'GENDER'
885: , NULL
886: );
887: Ja_Cn_Utility.Add_Fixed_Child_Node( 'DATE_OF_BIRTH'
888: , NULL

Line 887: Ja_Cn_Utility.Add_Fixed_Child_Node( 'DATE_OF_BIRTH'

883: );
884: Ja_Cn_Utility.Add_Child_Node( 'GENDER'
885: , NULL
886: );
887: Ja_Cn_Utility.Add_Fixed_Child_Node( 'DATE_OF_BIRTH'
888: , NULL
889: , 8
890: );
891: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'

Line 891: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'

887: Ja_Cn_Utility.Add_Fixed_Child_Node( 'DATE_OF_BIRTH'
888: , NULL
889: , 8
890: );
891: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
892: , NULL
893: );
894: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
895: , NULL);

Line 894: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'

890: );
891: Ja_Cn_Utility.Add_Child_Node( 'INNER_ORGANIZATION_ID'
892: , NULL
893: );
894: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
895: , NULL);
896: Ja_Cn_Utility.Add_Child_Node( 'STAFF_POSITION_LEVEL'
897: , NULL
898: );

Line 896: Ja_Cn_Utility.Add_Child_Node( 'STAFF_POSITION_LEVEL'

892: , NULL
893: );
894: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
895: , NULL);
896: Ja_Cn_Utility.Add_Child_Node( 'STAFF_POSITION_LEVEL'
897: , NULL
898: );
899: Ja_Cn_Utility.Add_Child_Node( 'STAFF_TECHNICAL_POSITION'
900: , NULL

Line 899: Ja_Cn_Utility.Add_Child_Node( 'STAFF_TECHNICAL_POSITION'

895: , NULL);
896: Ja_Cn_Utility.Add_Child_Node( 'STAFF_POSITION_LEVEL'
897: , NULL
898: );
899: Ja_Cn_Utility.Add_Child_Node( 'STAFF_TECHNICAL_POSITION'
900: , NULL
901: );
902: Ja_Cn_Utility.Add_Child_Node( 'STAFF_HIGH_EDU_LEVEL'
903: , NULL

Line 902: Ja_Cn_Utility.Add_Child_Node( 'STAFF_HIGH_EDU_LEVEL'

898: );
899: Ja_Cn_Utility.Add_Child_Node( 'STAFF_TECHNICAL_POSITION'
900: , NULL
901: );
902: Ja_Cn_Utility.Add_Child_Node( 'STAFF_HIGH_EDU_LEVEL'
903: , NULL
904: );
905: Ja_Cn_Utility.Add_Child_Node( 'STAFF_DEGREE'
906: , NULL);

Line 905: Ja_Cn_Utility.Add_Child_Node( 'STAFF_DEGREE'

901: );
902: Ja_Cn_Utility.Add_Child_Node( 'STAFF_HIGH_EDU_LEVEL'
903: , NULL
904: );
905: Ja_Cn_Utility.Add_Child_Node( 'STAFF_DEGREE'
906: , NULL);
907: Ja_Cn_Utility.Add_Fixed_Child_Node( 'HIRE_DATE'
908: , NULL
909: , 8

Line 907: Ja_Cn_Utility.Add_Fixed_Child_Node( 'HIRE_DATE'

903: , NULL
904: );
905: Ja_Cn_Utility.Add_Child_Node( 'STAFF_DEGREE'
906: , NULL);
907: Ja_Cn_Utility.Add_Fixed_Child_Node( 'HIRE_DATE'
908: , NULL
909: , 8
910: );
911: Ja_Cn_Utility.Add_Fixed_Child_Node( 'TERMINATION_DATE'

Line 911: Ja_Cn_Utility.Add_Fixed_Child_Node( 'TERMINATION_DATE'

907: Ja_Cn_Utility.Add_Fixed_Child_Node( 'HIRE_DATE'
908: , NULL
909: , 8
910: );
911: Ja_Cn_Utility.Add_Fixed_Child_Node( 'TERMINATION_DATE'
912: , NULL
913: , 8
914: , Ja_Cn_Utility.GV_REQUIRED_NO
915: );

Line 914: , Ja_Cn_Utility.GV_REQUIRED_NO

910: );
911: Ja_Cn_Utility.Add_Fixed_Child_Node( 'TERMINATION_DATE'
912: , NULL
913: , 8
914: , Ja_Cn_Utility.GV_REQUIRED_NO
915: );
916: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
917: , Ja_Cn_Utility.GV_TAG_TYPE_END
918: );

Line 916: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'

912: , NULL
913: , 8
914: , Ja_Cn_Utility.GV_REQUIRED_NO
915: );
916: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
917: , Ja_Cn_Utility.GV_TAG_TYPE_END
918: );
919: --RAISE NO_DATA;
920: --End: Added for bug# 9722570

Line 917: , Ja_Cn_Utility.GV_TAG_TYPE_END

913: , 8
914: , Ja_Cn_Utility.GV_REQUIRED_NO
915: );
916: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_RECORDS'
917: , Ja_Cn_Utility.GV_TAG_TYPE_END
918: );
919: --RAISE NO_DATA;
920: --End: Added for bug# 9722570
921: END IF; --ln_rec_count = 0

Line 1040: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'

1036:
1037: FOR v_row IN cur_employee_category
1038: LOOP
1039: ln_row_count := ln_row_count + 1;
1040: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1041: , Ja_Cn_Utility.GV_TAG_TYPE_START
1042: );
1043: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
1044: , v_row.employee_category

Line 1041: , Ja_Cn_Utility.GV_TAG_TYPE_START

1037: FOR v_row IN cur_employee_category
1038: LOOP
1039: ln_row_count := ln_row_count + 1;
1040: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1041: , Ja_Cn_Utility.GV_TAG_TYPE_START
1042: );
1043: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
1044: , v_row.employee_category
1045: );

Line 1043: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'

1039: ln_row_count := ln_row_count + 1;
1040: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1041: , Ja_Cn_Utility.GV_TAG_TYPE_START
1042: );
1043: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
1044: , v_row.employee_category
1045: );
1046: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_NAME'
1047: , Get_Lookup_Meaning( v_row.employee_category

Line 1046: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_NAME'

1042: );
1043: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
1044: , v_row.employee_category
1045: );
1046: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_NAME'
1047: , Get_Lookup_Meaning( v_row.employee_category
1048: , 'EMPLOYEE_CATG')
1049: );
1050: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'

Line 1050: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'

1046: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_NAME'
1047: , Get_Lookup_Meaning( v_row.employee_category
1048: , 'EMPLOYEE_CATG')
1049: );
1050: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1051: , Ja_Cn_Utility.GV_TAG_TYPE_END
1052: );
1053: END LOOP; -- FOR v_row IN cur_employee_category
1054:

Line 1051: , Ja_Cn_Utility.GV_TAG_TYPE_END

1047: , Get_Lookup_Meaning( v_row.employee_category
1048: , 'EMPLOYEE_CATG')
1049: );
1050: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1051: , Ja_Cn_Utility.GV_TAG_TYPE_END
1052: );
1053: END LOOP; -- FOR v_row IN cur_employee_category
1054:
1055: IF(ln_row_count = 0)

Line 1057: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'STAFF_CATEGORY'

1053: END LOOP; -- FOR v_row IN cur_employee_category
1054:
1055: IF(ln_row_count = 0)
1056: THEN
1057: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'STAFF_CATEGORY'
1058: );
1059: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1060: , Ja_Cn_Utility.GV_TAG_TYPE_START
1061: );

Line 1059: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'

1055: IF(ln_row_count = 0)
1056: THEN
1057: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'STAFF_CATEGORY'
1058: );
1059: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1060: , Ja_Cn_Utility.GV_TAG_TYPE_START
1061: );
1062: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
1063: , NULL

Line 1060: , Ja_Cn_Utility.GV_TAG_TYPE_START

1056: THEN
1057: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'STAFF_CATEGORY'
1058: );
1059: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1060: , Ja_Cn_Utility.GV_TAG_TYPE_START
1061: );
1062: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
1063: , NULL
1064: );

Line 1062: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'

1058: );
1059: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1060: , Ja_Cn_Utility.GV_TAG_TYPE_START
1061: );
1062: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
1063: , NULL
1064: );
1065: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_NAME'
1066: , NULL

Line 1065: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_NAME'

1061: );
1062: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_CODE'
1063: , NULL
1064: );
1065: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_NAME'
1066: , NULL
1067: );
1068: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1069: , Ja_Cn_Utility.GV_TAG_TYPE_END

Line 1068: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'

1064: );
1065: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_NAME'
1066: , NULL
1067: );
1068: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1069: , Ja_Cn_Utility.GV_TAG_TYPE_END
1070: );
1071: END IF; -- (ln_row_count=0)
1072: --logging for debug

Line 1069: , Ja_Cn_Utility.GV_TAG_TYPE_END

1065: Ja_Cn_Utility.Add_Child_Node( 'STAFF_CATEGORY_NAME'
1066: , NULL
1067: );
1068: Ja_Cn_Utility.Add_Sub_Root_Node( 'STAFF_CATEGORY'
1069: , Ja_Cn_Utility.GV_TAG_TYPE_END
1070: );
1071: END IF; -- (ln_row_count=0)
1072: --logging for debug
1073: IF (ln_proc_level >= ln_dbg_level)