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.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on FND_GLOBAL

Line 522: FND_GLOBAL.USER_ID,

518: VALUES
519: (
520: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,
521: l_Batch_Desc,
522: FND_GLOBAL.USER_ID,
523: SYSDATE,
524: FND_GLOBAL.USER_ID,
525: SYSDATE,
526: FND_GLOBAL.LOGIN_ID

Line 524: FND_GLOBAL.USER_ID,

520: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,
521: l_Batch_Desc,
522: FND_GLOBAL.USER_ID,
523: SYSDATE,
524: FND_GLOBAL.USER_ID,
525: SYSDATE,
526: FND_GLOBAL.LOGIN_ID
527: ) returning BATCH_ID into l_Batch_Id
528: ;

Line 526: FND_GLOBAL.LOGIN_ID

522: FND_GLOBAL.USER_ID,
523: SYSDATE,
524: FND_GLOBAL.USER_ID,
525: SYSDATE,
526: FND_GLOBAL.LOGIN_ID
527: ) returning BATCH_ID into l_Batch_Id
528: ;
529: commit;
530: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------------------------------------------------------------------');

Line 624: FND_GLOBAL.USER_ID,

620: Act_Assessment_rec.code_id, -- Grade level need to be defined in IGS_AD_CODE_CLASSES
621: --WHERE CLASS ='LEVEL_OF_QUAL' code_id is retrieved from the code_classes table
622: '2',
623: '2',
624: FND_GLOBAL.USER_ID,
625: SYSDATE,
626: FND_GLOBAL.USER_ID,
627: SYSDATE,
628: FND_GLOBAL.LOGIN_ID

Line 626: FND_GLOBAL.USER_ID,

622: '2',
623: '2',
624: FND_GLOBAL.USER_ID,
625: SYSDATE,
626: FND_GLOBAL.USER_ID,
627: SYSDATE,
628: FND_GLOBAL.LOGIN_ID
629: ) returning INTERFACE_ID into l_interface_id;
630:

Line 628: FND_GLOBAL.LOGIN_ID

624: FND_GLOBAL.USER_ID,
625: SYSDATE,
626: FND_GLOBAL.USER_ID,
627: SYSDATE,
628: FND_GLOBAL.LOGIN_ID
629: ) returning INTERFACE_ID into l_interface_id;
630:
631: --debug
632: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id : 1' || l_interface_id);

Line 666: FND_GLOBAL.USER_ID,

662: --'ALBANY', --temp
663: 'US',
664: SYSDATE,
665: '2',
666: FND_GLOBAL.USER_ID,
667: SYSDATE,
668: FND_GLOBAL.USER_ID,
669: SYSDATE,
670: FND_GLOBAL.LOGIN_ID

Line 668: FND_GLOBAL.USER_ID,

664: SYSDATE,
665: '2',
666: FND_GLOBAL.USER_ID,
667: SYSDATE,
668: FND_GLOBAL.USER_ID,
669: SYSDATE,
670: FND_GLOBAL.LOGIN_ID
671: )returning INTERFACE_ADDR_ID into l_interface_addr_id;
672:

Line 670: FND_GLOBAL.LOGIN_ID

666: FND_GLOBAL.USER_ID,
667: SYSDATE,
668: FND_GLOBAL.USER_ID,
669: SYSDATE,
670: FND_GLOBAL.LOGIN_ID
671: )returning INTERFACE_ADDR_ID into l_interface_addr_id;
672:
673: -- akadam Included the below logic for Bug# 4352471
674: --Inserting the Latest Record in to the Child (IGS_AD_ADDRUSAGE_INT_ALL) of Interface Table (IGS_AD_ADDR_INT_ALL).

Line 694: fnd_global.user_id,

690: igs_ad_addrusage_int_s.NEXTVAL,
691: l_interface_addr_id, -- interfaced Id populated in igs_ad_addr_int_all.
692: p_addr_usage_cd,
693: '2',
694: fnd_global.user_id,
695: sysdate,
696: fnd_global.user_id,
697: sysdate,
698: fnd_global.login_id

Line 696: fnd_global.user_id,

692: p_addr_usage_cd,
693: '2',
694: fnd_global.user_id,
695: sysdate,
696: fnd_global.user_id,
697: sysdate,
698: fnd_global.login_id
699: );
700: END IF;

Line 698: fnd_global.login_id

694: fnd_global.user_id,
695: sysdate,
696: fnd_global.user_id,
697: sysdate,
698: fnd_global.login_id
699: );
700: END IF;
701:
702:

Line 730: FND_GLOBAL.USER_ID,

726: 'GEN' ,-- Telephone PHONE_LINE_TYPE
727: SUBSTR(Act_Assessment_rec.home_phone,1,3),
728: SUBSTR(Act_Assessment_rec.home_phone,4,7),
729: '2',
730: FND_GLOBAL.USER_ID,
731: SYSDATE,
732: FND_GLOBAL.USER_ID,
733: SYSDATE,
734: FND_GLOBAL.LOGIN_ID

Line 732: FND_GLOBAL.USER_ID,

728: SUBSTR(Act_Assessment_rec.home_phone,4,7),
729: '2',
730: FND_GLOBAL.USER_ID,
731: SYSDATE,
732: FND_GLOBAL.USER_ID,
733: SYSDATE,
734: FND_GLOBAL.LOGIN_ID
735: );
736: ELSE

Line 734: FND_GLOBAL.LOGIN_ID

730: FND_GLOBAL.USER_ID,
731: SYSDATE,
732: FND_GLOBAL.USER_ID,
733: SYSDATE,
734: FND_GLOBAL.LOGIN_ID
735: );
736: ELSE
737: IF (Act_Assessment_rec.home_phone IS NOT NULL) THEN
738: INSERT

Line 761: FND_GLOBAL.USER_ID,

757: 'PHONE', -- COMMUNICATION_TYPE
758: 'GEN' ,-- Telephone PHONE_LINE_TYPE
759: Act_Assessment_rec.home_phone,
760: '2',
761: FND_GLOBAL.USER_ID,
762: SYSDATE,
763: FND_GLOBAL.USER_ID,
764: SYSDATE,
765: FND_GLOBAL.LOGIN_ID

Line 763: FND_GLOBAL.USER_ID,

759: Act_Assessment_rec.home_phone,
760: '2',
761: FND_GLOBAL.USER_ID,
762: SYSDATE,
763: FND_GLOBAL.USER_ID,
764: SYSDATE,
765: FND_GLOBAL.LOGIN_ID
766: );
767: END IF;

Line 765: FND_GLOBAL.LOGIN_ID

761: FND_GLOBAL.USER_ID,
762: SYSDATE,
763: FND_GLOBAL.USER_ID,
764: SYSDATE,
765: FND_GLOBAL.LOGIN_ID
766: );
767: END IF;
768: END IF;
769: -- Check if the ALTERNATE_ID is SSN or -ACTID

Line 795: FND_GLOBAL.USER_ID,

791: l_interface_id,
792: G_SSN_Person_Id_Type, -- 'SSN', -- {get the person_type having the System Person Type = SSN}
793: Act_Assessment_rec.act_identifier,
794: '2',
795: FND_GLOBAL.USER_ID,
796: SYSDATE,
797: FND_GLOBAL.USER_ID,
798: SYSDATE,
799: FND_GLOBAL.LOGIN_ID

Line 797: FND_GLOBAL.USER_ID,

793: Act_Assessment_rec.act_identifier,
794: '2',
795: FND_GLOBAL.USER_ID,
796: SYSDATE,
797: FND_GLOBAL.USER_ID,
798: SYSDATE,
799: FND_GLOBAL.LOGIN_ID
800: );
801: END IF;

Line 799: FND_GLOBAL.LOGIN_ID

795: FND_GLOBAL.USER_ID,
796: SYSDATE,
797: FND_GLOBAL.USER_ID,
798: SYSDATE,
799: FND_GLOBAL.LOGIN_ID
800: );
801: END IF;
802:
803: --debug

Line 828: FND_GLOBAL.USER_ID,

824: l_interface_id,
825: G_ACT_Person_Id_Type, -- 'ACTID', -- {get the person_type having the System Person Type = ACT}
826: SUBSTR(Act_Assessment_rec.act_identifier,(Decode(SUBSTR(Act_Assessment_rec.act_identifier,1,1),'-',2,1))),
827: '2',
828: FND_GLOBAL.USER_ID,
829: SYSDATE,
830: FND_GLOBAL.USER_ID,
831: SYSDATE,
832: FND_GLOBAL.LOGIN_ID

Line 830: FND_GLOBAL.USER_ID,

826: SUBSTR(Act_Assessment_rec.act_identifier,(Decode(SUBSTR(Act_Assessment_rec.act_identifier,1,1),'-',2,1))),
827: '2',
828: FND_GLOBAL.USER_ID,
829: SYSDATE,
830: FND_GLOBAL.USER_ID,
831: SYSDATE,
832: FND_GLOBAL.LOGIN_ID
833: );
834:

Line 832: FND_GLOBAL.LOGIN_ID

828: FND_GLOBAL.USER_ID,
829: SYSDATE,
830: FND_GLOBAL.USER_ID,
831: SYSDATE,
832: FND_GLOBAL.LOGIN_ID
833: );
834:
835: l_ACT_Exist := Act_Assessment_rec.act_identifier;
836:

Line 875: FND_GLOBAL.USER_ID,

871: G_Score_Source_id,
872: SYSDATE,
873: Act_Assessment_rec.corrected_report_ind, -- if the data is ' ' in Data file value in the Assessments table is NULL
874: '2',
875: FND_GLOBAL.USER_ID,
876: SYSDATE,
877: FND_GLOBAL.USER_ID,
878: SYSDATE,
879: FND_GLOBAL.LOGIN_ID,

Line 877: FND_GLOBAL.USER_ID,

873: Act_Assessment_rec.corrected_report_ind, -- if the data is ' ' in Data file value in the Assessments table is NULL
874: '2',
875: FND_GLOBAL.USER_ID,
876: SYSDATE,
877: FND_GLOBAL.USER_ID,
878: SYSDATE,
879: FND_GLOBAL.LOGIN_ID,
880: 'Y'
881: ) returning INTERFACE_TEST_ID,ADMISSION_TEST_TYPE into l_interface_test_id,l_admission_test_type;

Line 879: FND_GLOBAL.LOGIN_ID,

875: FND_GLOBAL.USER_ID,
876: SYSDATE,
877: FND_GLOBAL.USER_ID,
878: SYSDATE,
879: FND_GLOBAL.LOGIN_ID,
880: 'Y'
881: ) returning INTERFACE_TEST_ID,ADMISSION_TEST_TYPE into l_interface_test_id,l_admission_test_type;
882:
883: -- Enter Test Details into IGS_AD_TEST_SEGS_INT from ACT Statistics

Line 1061: FND_GLOBAL.USER_ID,

1057: DECODE(INSTR(l_state_percentile,'-'),0,to_number(l_state_percentile),NULL), --l_state_percentile
1058: l_score_band_upper,
1059: l_score_band_lower,
1060: '2',
1061: FND_GLOBAL.USER_ID,
1062: SYSDATE,
1063: FND_GLOBAL.USER_ID,
1064: SYSDATE,
1065: FND_GLOBAL.LOGIN_ID

Line 1063: FND_GLOBAL.USER_ID,

1059: l_score_band_lower,
1060: '2',
1061: FND_GLOBAL.USER_ID,
1062: SYSDATE,
1063: FND_GLOBAL.USER_ID,
1064: SYSDATE,
1065: FND_GLOBAL.LOGIN_ID
1066: );
1067:

Line 1065: FND_GLOBAL.LOGIN_ID

1061: FND_GLOBAL.USER_ID,
1062: SYSDATE,
1063: FND_GLOBAL.USER_ID,
1064: SYSDATE,
1065: FND_GLOBAL.LOGIN_ID
1066: );
1067:
1068: END LOOP; --- End Inserting multiple records of Test Details for a Person
1069:

Line 1108: FND_GLOBAL.USER_ID,

1104: DECODE(Act_Assessment_Rec.high_school_graduation,'',NULL,to_date(Act_Assessment_Rec.high_school_graduation||'0501','YYYYMMDD')),
1105: -- changed planned completion date from 01-jan to 01-may bug# 4252413
1106: DECODE(INSTR(Act_Assessment_Rec.high_school_average,'-'),0,Act_Assessment_Rec.high_school_average,NULL),
1107: '2',
1108: FND_GLOBAL.USER_ID,
1109: SYSDATE,
1110: FND_GLOBAL.USER_ID,
1111: SYSDATE,
1112: FND_GLOBAL.LOGIN_ID

Line 1110: FND_GLOBAL.USER_ID,

1106: DECODE(INSTR(Act_Assessment_Rec.high_school_average,'-'),0,Act_Assessment_Rec.high_school_average,NULL),
1107: '2',
1108: FND_GLOBAL.USER_ID,
1109: SYSDATE,
1110: FND_GLOBAL.USER_ID,
1111: SYSDATE,
1112: FND_GLOBAL.LOGIN_ID
1113: ) returning INTERFACE_ACADHIS_ID into l_interface_acadhis_id;
1114:

Line 1112: FND_GLOBAL.LOGIN_ID

1108: FND_GLOBAL.USER_ID,
1109: SYSDATE,
1110: FND_GLOBAL.USER_ID,
1111: SYSDATE,
1112: FND_GLOBAL.LOGIN_ID
1113: ) returning INTERFACE_ACADHIS_ID into l_interface_acadhis_id;
1114:
1115: l_High_School_Code := Act_Assessment_Rec.high_school_code;
1116: l_High_School_Graduation := Act_Assessment_Rec.high_school_graduation;

Line 1160: FND_GLOBAL.USER_ID,

1156: '2',
1157: G_Grading_Scale, -- User Defined '4 POINT' Transcript Info Code Class 'Grading Scale Types'
1158: G_Grading_Scale, -- User Defined '4 POINT' Transcript Info Code Class 'Grading Scale Types'
1159: 'S', -- Term Type is Defined as 'S' for Semister in lookup for TERM_TYPE
1160: FND_GLOBAL.USER_ID,
1161: SYSDATE,
1162: FND_GLOBAL.USER_ID,
1163: SYSDATE,
1164: FND_GLOBAL.LOGIN_ID,

Line 1162: FND_GLOBAL.USER_ID,

1158: G_Grading_Scale, -- User Defined '4 POINT' Transcript Info Code Class 'Grading Scale Types'
1159: 'S', -- Term Type is Defined as 'S' for Semister in lookup for TERM_TYPE
1160: FND_GLOBAL.USER_ID,
1161: SYSDATE,
1162: FND_GLOBAL.USER_ID,
1163: SYSDATE,
1164: FND_GLOBAL.LOGIN_ID,
1165: to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD')
1166: ) returning INTERFACE_TRANSCRIPT_ID into l_Interface_Transcript_Id ;

Line 1164: FND_GLOBAL.LOGIN_ID,

1160: FND_GLOBAL.USER_ID,
1161: SYSDATE,
1162: FND_GLOBAL.USER_ID,
1163: SYSDATE,
1164: FND_GLOBAL.LOGIN_ID,
1165: to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD')
1166: ) returning INTERFACE_TRANSCRIPT_ID into l_Interface_Transcript_Id ;
1167:
1168: --debug

Line 1194: FND_GLOBAL.USER_ID,

1190: to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD'),
1191: to_date( Act_Assessment_rec.TEST_DATE_TXT||'02','YYYYMMDD'),
1192: 'ACT - '||to_char(to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD'),'Mon DD, YYYY'), -- 'ACT Test Date - '||to_char(to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD'),'Month DD, YYYY'),
1193: '2',
1194: FND_GLOBAL.USER_ID,
1195: SYSDATE,
1196: FND_GLOBAL.USER_ID,
1197: SYSDATE,
1198: FND_GLOBAL.LOGIN_ID

Line 1196: FND_GLOBAL.USER_ID,

1192: 'ACT - '||to_char(to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD'),'Mon DD, YYYY'), -- 'ACT Test Date - '||to_char(to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD'),'Month DD, YYYY'),
1193: '2',
1194: FND_GLOBAL.USER_ID,
1195: SYSDATE,
1196: FND_GLOBAL.USER_ID,
1197: SYSDATE,
1198: FND_GLOBAL.LOGIN_ID
1199: )returning INTERFACE_TERM_DTLS_ID into l_interface_term_dtls_id;
1200:

Line 1198: FND_GLOBAL.LOGIN_ID

1194: FND_GLOBAL.USER_ID,
1195: SYSDATE,
1196: FND_GLOBAL.USER_ID,
1197: SYSDATE,
1198: FND_GLOBAL.LOGIN_ID
1199: )returning INTERFACE_TERM_DTLS_ID into l_interface_term_dtls_id;
1200:
1201: END IF; -- END IF of Graduation School Detials
1202:

Line 1248: FND_GLOBAL.USER_ID,

1244: G_Unit_Difficulty,
1245: l_Statistic_Category_desc,
1246: l_grade,
1247: '2',
1248: FND_GLOBAL.USER_ID,
1249: SYSDATE,
1250: FND_GLOBAL.USER_ID,
1251: SYSDATE,
1252: FND_GLOBAL.LOGIN_ID

Line 1250: FND_GLOBAL.USER_ID,

1246: l_grade,
1247: '2',
1248: FND_GLOBAL.USER_ID,
1249: SYSDATE,
1250: FND_GLOBAL.USER_ID,
1251: SYSDATE,
1252: FND_GLOBAL.LOGIN_ID
1253: ) ;
1254:

Line 1252: FND_GLOBAL.LOGIN_ID

1248: FND_GLOBAL.USER_ID,
1249: SYSDATE,
1250: FND_GLOBAL.USER_ID,
1251: SYSDATE,
1252: FND_GLOBAL.LOGIN_ID
1253: ) ;
1254:
1255: END IF;
1256: ELSIF Act_Statistic_HS_Rec.course_status IN ('1','2') THEN

Line 1287: FND_GLOBAL.USER_ID,

1283: G_Unit_Difficulty,
1284: l_Statistic_Category_desc,
1285: Decode(trim(l_grade),'4','A','3','B','2','C','1','D','0','F','','P',l_grade),
1286: '2',
1287: FND_GLOBAL.USER_ID,
1288: SYSDATE,
1289: FND_GLOBAL.USER_ID,
1290: SYSDATE,
1291: FND_GLOBAL.LOGIN_ID

Line 1289: FND_GLOBAL.USER_ID,

1285: Decode(trim(l_grade),'4','A','3','B','2','C','1','D','0','F','','P',l_grade),
1286: '2',
1287: FND_GLOBAL.USER_ID,
1288: SYSDATE,
1289: FND_GLOBAL.USER_ID,
1290: SYSDATE,
1291: FND_GLOBAL.LOGIN_ID
1292: ) ;
1293:

Line 1291: FND_GLOBAL.LOGIN_ID

1287: FND_GLOBAL.USER_ID,
1288: SYSDATE,
1289: FND_GLOBAL.USER_ID,
1290: SYSDATE,
1291: FND_GLOBAL.LOGIN_ID
1292: ) ;
1293:
1294: END IF;
1295: END LOOP;