DBA Data[Home] [Help]

APPS.IGS_AV_GEN_001 dependencies on FND_DATE

Line 743: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

739: v_asu_rec.as_course_cd || '|' ||
740: TO_CHAR(v_asu_rec.as_version_number) || '|' ||
741: v_asu_rec.unit_cd || '|' ||
742: TO_CHAR(v_asu_rec.version_number) || '|' ||
743: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
744: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
745: v_s_log_type,
746: v_creation_dt,
747: v_message_key,

Line 775: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

771: v_asu_rec.as_course_cd || '|' ||
772: TO_CHAR(v_asu_rec.as_version_number) || '|' ||
773: v_asu_rec.unit_cd || '|' ||
774: TO_CHAR(v_asu_rec.version_number) || '|' ||
775: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
776: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
777: v_s_log_type,
778: v_creation_dt,
779: v_message_key,

Line 814: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

810: v_asu_rec.as_course_cd || '|' ||
811: TO_CHAR(v_asu_rec.as_version_number) || '|' ||
812: v_asu_rec.unit_cd || '|' ||
813: TO_CHAR(v_asu_rec.version_number) || '|' ||
814: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
815: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
816: v_s_log_type,
817: v_creation_dt,
818: v_message_key,

Line 845: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

841: v_asu_rec.as_course_cd || '|' ||
842: TO_CHAR(v_asu_rec.as_version_number) || '|' ||
843: v_asu_rec.unit_cd || '|' ||
844: TO_CHAR(v_asu_rec.version_number) || '|' ||
845: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
846: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
847: v_s_log_type,
848: v_creation_dt,
849: v_message_key,

Line 928: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

924: v_asu_rec.as_course_cd || '|' ||
925: TO_CHAR(v_asu_rec.as_version_number) || '|' ||
926: v_asu_rec.unit_cd || '|' ||
927: TO_CHAR(v_asu_rec.version_number) || '|' ||
928: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
929: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
930: v_s_log_type,
931: v_creation_dt,
932: v_message_key,

Line 981: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

977: v_asu_rec.as_course_cd || '|' ||
978: TO_CHAR(v_asu_rec.as_version_number) || '|' ||
979: v_asu_rec.unit_cd || '|' ||
980: TO_CHAR(v_asu_rec.version_number) || '|' ||
981: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
982: -- Insert into messages for reporting
983:
984: fnd_message.set_name('IGS','IGS_AV_GRANTED');
985: cst_granted_ge := fnd_message.get;

Line 1049: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

1045: TO_CHAR(v_asul_rec.as_version_number) || '|' ||
1046: v_asul_rec.unit_level || '|' ||
1047: v_asul_rec.crs_group_ind || '|' ||
1048: v_asul_rec.exemption_institution_cd ||'|' ||
1049: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
1050: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1051: v_s_log_type,
1052: v_creation_dt,
1053: v_message_key,

Line 1082: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

1078: TO_CHAR(v_asul_rec.as_version_number) || '|' ||
1079: v_asul_rec.unit_level || '|' ||
1080: v_asul_rec.crs_group_ind || '|' ||
1081: v_asul_rec.exemption_institution_cd ||'|' ||
1082: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
1083: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1084: v_s_log_type,
1085: v_creation_dt,
1086: v_message_key,

Line 1122: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

1118: TO_CHAR(v_asul_rec.as_version_number) || '|' ||
1119: v_asul_rec.unit_level || '|' ||
1120: v_asul_rec.crs_group_ind || '|' ||
1121: v_asul_rec.exemption_institution_cd ||'|' ||
1122: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
1123: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1124: v_s_log_type,
1125: v_creation_dt,
1126: v_message_key,

Line 1190: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);

1186: TO_CHAR(v_asul_rec.as_version_number) || '|' ||
1187: v_asul_rec.unit_level || '|' ||
1188: v_asul_rec.crs_group_ind || '|' ||
1189: v_asul_rec.exemption_institution_cd ||'|' ||
1190: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
1191: fnd_message.set_name('IGS','IGS_AV_GRANTED');
1192: cst_granted_ge := fnd_message.get;
1193: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1194: v_s_log_type,

Line 1214: FND_DATE.DATE_TO_DISPLAYDATE(p_granted_dt)||p_process_type||p_s_log_type||

1210: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_AS_PE_GRANT');
1211: Igs_Ge_Msg_Stack.Add;
1212:
1213: lv_param_values := To_Char(p_person_id)||p_course_cd||To_Char(p_version_number)||
1214: FND_DATE.DATE_TO_DISPLAYDATE(p_granted_dt)||p_process_type||p_s_log_type||
1215: FND_DATE.DATE_TO_DISPLAYDATE(p_creation_dt);
1216: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1217: Fnd_Message.Set_Token('VALUE',lv_param_values);
1218: Igs_Ge_Msg_Stack.Add;

Line 1215: FND_DATE.DATE_TO_DISPLAYDATE(p_creation_dt);

1211: Igs_Ge_Msg_Stack.Add;
1212:
1213: lv_param_values := To_Char(p_person_id)||p_course_cd||To_Char(p_version_number)||
1214: FND_DATE.DATE_TO_DISPLAYDATE(p_granted_dt)||p_process_type||p_s_log_type||
1215: FND_DATE.DATE_TO_DISPLAYDATE(p_creation_dt);
1216: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1217: Fnd_Message.Set_Token('VALUE',lv_param_values);
1218: Igs_Ge_Msg_Stack.Add;
1219: