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_PS_GEN_006 dependencies on FND_DATE

Line 515: || ' : ' || fnd_date.date_to_displaydate (gv_start_dt) );

511: || ' : ' || TO_CHAR (gv_uop_rec.version_number) );
512: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
513: || ' : ' || p_dest_cal_type );
514: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
515: || ' : ' || fnd_date.date_to_displaydate (gv_start_dt) );
516: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )
517: || ' : ' || fnd_date.date_to_displaydate (gv_end_dt) );
518: fnd_file.put_line ( fnd_file.LOG, ' ');
519:

Line 517: || ' : ' || fnd_date.date_to_displaydate (gv_end_dt) );

513: || ' : ' || p_dest_cal_type );
514: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
515: || ' : ' || fnd_date.date_to_displaydate (gv_start_dt) );
516: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )
517: || ' : ' || fnd_date.date_to_displaydate (gv_end_dt) );
518: fnd_file.put_line ( fnd_file.LOG, ' ');
519:
520: -- Check that IGS_PS_UNIT version in not inactive, otherwise
521: -- it can't be updated

Line 1029: ||fnd_date.date_to_displaydate(p_new_start_dt)||','

1025: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_ins_us_hist');
1026: IGS_GE_MSG_STACK.ADD;
1027: lv_param_values := p_unit_set_cd||','||to_char(p_version_number)||','||p_new_unit_set_status||','
1028: ||p_old_unit_set_status||','||p_new_unit_set_cat||','||p_old_unit_set_cat||','
1029: ||fnd_date.date_to_displaydate(p_new_start_dt)||','
1030: ||fnd_date.date_to_displaydate(p_old_start_dt)||','||fnd_date.date_to_displaydate(p_new_review_dt)||','
1031: ||fnd_date.date_to_displaydate(p_old_review_dt)||','||
1032: fnd_date.date_to_displaydate(p_new_expiry_dt)||','||fnd_date.date_to_displaydate(p_old_expiry_dt)||','
1033: ||fnd_date.date_to_displaydate(p_new_end_dt)||','||fnd_date.date_to_displaydate(p_old_end_dt)

Line 1030: ||fnd_date.date_to_displaydate(p_old_start_dt)||','||fnd_date.date_to_displaydate(p_new_review_dt)||','

1026: IGS_GE_MSG_STACK.ADD;
1027: lv_param_values := p_unit_set_cd||','||to_char(p_version_number)||','||p_new_unit_set_status||','
1028: ||p_old_unit_set_status||','||p_new_unit_set_cat||','||p_old_unit_set_cat||','
1029: ||fnd_date.date_to_displaydate(p_new_start_dt)||','
1030: ||fnd_date.date_to_displaydate(p_old_start_dt)||','||fnd_date.date_to_displaydate(p_new_review_dt)||','
1031: ||fnd_date.date_to_displaydate(p_old_review_dt)||','||
1032: fnd_date.date_to_displaydate(p_new_expiry_dt)||','||fnd_date.date_to_displaydate(p_old_expiry_dt)||','
1033: ||fnd_date.date_to_displaydate(p_new_end_dt)||','||fnd_date.date_to_displaydate(p_old_end_dt)
1034: ||','||p_new_title||','||p_old_title||','||p_new_short_title||','||p_old_short_title||','||p_new_abbreviation

Line 1031: ||fnd_date.date_to_displaydate(p_old_review_dt)||','||

1027: lv_param_values := p_unit_set_cd||','||to_char(p_version_number)||','||p_new_unit_set_status||','
1028: ||p_old_unit_set_status||','||p_new_unit_set_cat||','||p_old_unit_set_cat||','
1029: ||fnd_date.date_to_displaydate(p_new_start_dt)||','
1030: ||fnd_date.date_to_displaydate(p_old_start_dt)||','||fnd_date.date_to_displaydate(p_new_review_dt)||','
1031: ||fnd_date.date_to_displaydate(p_old_review_dt)||','||
1032: fnd_date.date_to_displaydate(p_new_expiry_dt)||','||fnd_date.date_to_displaydate(p_old_expiry_dt)||','
1033: ||fnd_date.date_to_displaydate(p_new_end_dt)||','||fnd_date.date_to_displaydate(p_old_end_dt)
1034: ||','||p_new_title||','||p_old_title||','||p_new_short_title||','||p_old_short_title||','||p_new_abbreviation
1035: ||','||p_old_abbreviation||','||p_new_responsible_org_unit_cd||','||p_old_responsible_org_unit_cd||','||

Line 1032: fnd_date.date_to_displaydate(p_new_expiry_dt)||','||fnd_date.date_to_displaydate(p_old_expiry_dt)||','

1028: ||p_old_unit_set_status||','||p_new_unit_set_cat||','||p_old_unit_set_cat||','
1029: ||fnd_date.date_to_displaydate(p_new_start_dt)||','
1030: ||fnd_date.date_to_displaydate(p_old_start_dt)||','||fnd_date.date_to_displaydate(p_new_review_dt)||','
1031: ||fnd_date.date_to_displaydate(p_old_review_dt)||','||
1032: fnd_date.date_to_displaydate(p_new_expiry_dt)||','||fnd_date.date_to_displaydate(p_old_expiry_dt)||','
1033: ||fnd_date.date_to_displaydate(p_new_end_dt)||','||fnd_date.date_to_displaydate(p_old_end_dt)
1034: ||','||p_new_title||','||p_old_title||','||p_new_short_title||','||p_old_short_title||','||p_new_abbreviation
1035: ||','||p_old_abbreviation||','||p_new_responsible_org_unit_cd||','||p_old_responsible_org_unit_cd||','||
1036: fnd_date.date_to_displaydate(p_new_responsible_ou_start_dt)||','||

Line 1033: ||fnd_date.date_to_displaydate(p_new_end_dt)||','||fnd_date.date_to_displaydate(p_old_end_dt)

1029: ||fnd_date.date_to_displaydate(p_new_start_dt)||','
1030: ||fnd_date.date_to_displaydate(p_old_start_dt)||','||fnd_date.date_to_displaydate(p_new_review_dt)||','
1031: ||fnd_date.date_to_displaydate(p_old_review_dt)||','||
1032: fnd_date.date_to_displaydate(p_new_expiry_dt)||','||fnd_date.date_to_displaydate(p_old_expiry_dt)||','
1033: ||fnd_date.date_to_displaydate(p_new_end_dt)||','||fnd_date.date_to_displaydate(p_old_end_dt)
1034: ||','||p_new_title||','||p_old_title||','||p_new_short_title||','||p_old_short_title||','||p_new_abbreviation
1035: ||','||p_old_abbreviation||','||p_new_responsible_org_unit_cd||','||p_old_responsible_org_unit_cd||','||
1036: fnd_date.date_to_displaydate(p_new_responsible_ou_start_dt)||','||
1037: fnd_date.date_to_displaydate(p_old_responsible_ou_start_dt)||','||p_new_administrative_ind

Line 1036: fnd_date.date_to_displaydate(p_new_responsible_ou_start_dt)||','||

1032: fnd_date.date_to_displaydate(p_new_expiry_dt)||','||fnd_date.date_to_displaydate(p_old_expiry_dt)||','
1033: ||fnd_date.date_to_displaydate(p_new_end_dt)||','||fnd_date.date_to_displaydate(p_old_end_dt)
1034: ||','||p_new_title||','||p_old_title||','||p_new_short_title||','||p_old_short_title||','||p_new_abbreviation
1035: ||','||p_old_abbreviation||','||p_new_responsible_org_unit_cd||','||p_old_responsible_org_unit_cd||','||
1036: fnd_date.date_to_displaydate(p_new_responsible_ou_start_dt)||','||
1037: fnd_date.date_to_displaydate(p_old_responsible_ou_start_dt)||','||p_new_administrative_ind
1038: ||','||p_old_administrative_ind||','||p_new_authorisation_rqrd_ind||','||p_old_authorisation_rqrd_ind||','||
1039: p_new_update_who||','||p_old_update_who||','||
1040: fnd_date.date_to_displaydate(p_new_update_on)||','||fnd_date.date_to_displaydate(p_old_update_on);

Line 1037: fnd_date.date_to_displaydate(p_old_responsible_ou_start_dt)||','||p_new_administrative_ind

1033: ||fnd_date.date_to_displaydate(p_new_end_dt)||','||fnd_date.date_to_displaydate(p_old_end_dt)
1034: ||','||p_new_title||','||p_old_title||','||p_new_short_title||','||p_old_short_title||','||p_new_abbreviation
1035: ||','||p_old_abbreviation||','||p_new_responsible_org_unit_cd||','||p_old_responsible_org_unit_cd||','||
1036: fnd_date.date_to_displaydate(p_new_responsible_ou_start_dt)||','||
1037: fnd_date.date_to_displaydate(p_old_responsible_ou_start_dt)||','||p_new_administrative_ind
1038: ||','||p_old_administrative_ind||','||p_new_authorisation_rqrd_ind||','||p_old_authorisation_rqrd_ind||','||
1039: p_new_update_who||','||p_old_update_who||','||
1040: fnd_date.date_to_displaydate(p_new_update_on)||','||fnd_date.date_to_displaydate(p_old_update_on);
1041: Fnd_Message.Set_Token('VALUE',lv_param_values);

Line 1040: fnd_date.date_to_displaydate(p_new_update_on)||','||fnd_date.date_to_displaydate(p_old_update_on);

1036: fnd_date.date_to_displaydate(p_new_responsible_ou_start_dt)||','||
1037: fnd_date.date_to_displaydate(p_old_responsible_ou_start_dt)||','||p_new_administrative_ind
1038: ||','||p_old_administrative_ind||','||p_new_authorisation_rqrd_ind||','||p_old_authorisation_rqrd_ind||','||
1039: p_new_update_who||','||p_old_update_who||','||
1040: fnd_date.date_to_displaydate(p_new_update_on)||','||fnd_date.date_to_displaydate(p_old_update_on);
1041: Fnd_Message.Set_Token('VALUE',lv_param_values);
1042: IGS_GE_MSG_STACK.ADD;
1043: App_Exception.Raise_Exception;
1044: END crsp_ins_us_hist;

Line 1337: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||fnd_date.date_to_displaydate(p_last_update_on)||','||fnd_date.date_to_displaydate(p_update_on)||','

1333:
1334: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1335: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_ins_uv_hist');
1336: IGS_GE_MSG_STACK.ADD;
1337: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||fnd_date.date_to_displaydate(p_last_update_on)||','||fnd_date.date_to_displaydate(p_update_on)||','
1338: ||p_last_update_who||','
1339: ||fnd_date.date_to_displaydate(p_start_dt)||','||fnd_date.date_to_displaydate(p_review_dt)||','||fnd_date.date_to_displaydate(p_expiry_dt)||','
1340: ||fnd_date.date_to_displaydate(p_end_dt)||','||p_unit_status||','||p_title||','||p_short_title||
1341: ','||p_title_override_ind||','||p_abbreviation||','||p_unit_level||','||

Line 1339: ||fnd_date.date_to_displaydate(p_start_dt)||','||fnd_date.date_to_displaydate(p_review_dt)||','||fnd_date.date_to_displaydate(p_expiry_dt)||','

1335: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_ins_uv_hist');
1336: IGS_GE_MSG_STACK.ADD;
1337: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||fnd_date.date_to_displaydate(p_last_update_on)||','||fnd_date.date_to_displaydate(p_update_on)||','
1338: ||p_last_update_who||','
1339: ||fnd_date.date_to_displaydate(p_start_dt)||','||fnd_date.date_to_displaydate(p_review_dt)||','||fnd_date.date_to_displaydate(p_expiry_dt)||','
1340: ||fnd_date.date_to_displaydate(p_end_dt)||','||p_unit_status||','||p_title||','||p_short_title||
1341: ','||p_title_override_ind||','||p_abbreviation||','||p_unit_level||','||
1342: p_credit_point_descriptor||','||to_char(p_achievable_credit_points)||','||
1343: to_char(p_enrolled_credit_points)||','||p_supp_exam_permitted_ind||','||

Line 1340: ||fnd_date.date_to_displaydate(p_end_dt)||','||p_unit_status||','||p_title||','||p_short_title||

1336: IGS_GE_MSG_STACK.ADD;
1337: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||fnd_date.date_to_displaydate(p_last_update_on)||','||fnd_date.date_to_displaydate(p_update_on)||','
1338: ||p_last_update_who||','
1339: ||fnd_date.date_to_displaydate(p_start_dt)||','||fnd_date.date_to_displaydate(p_review_dt)||','||fnd_date.date_to_displaydate(p_expiry_dt)||','
1340: ||fnd_date.date_to_displaydate(p_end_dt)||','||p_unit_status||','||p_title||','||p_short_title||
1341: ','||p_title_override_ind||','||p_abbreviation||','||p_unit_level||','||
1342: p_credit_point_descriptor||','||to_char(p_achievable_credit_points)||','||
1343: to_char(p_enrolled_credit_points)||','||p_supp_exam_permitted_ind||','||
1344: to_char(p_points_increment)||','||to_char(p_points_min)||','||to_char(p_points_max)

Line 1346: ||','||fnd_date.date_to_displaydate(p_owner_ou_start_dt)||','||p_award_course_only_ind ||','||p_research_unit_ind

1342: p_credit_point_descriptor||','||to_char(p_achievable_credit_points)||','||
1343: to_char(p_enrolled_credit_points)||','||p_supp_exam_permitted_ind||','||
1344: to_char(p_points_increment)||','||to_char(p_points_min)||','||to_char(p_points_max)
1345: ||','||p_points_override_ind ||','||to_char(p_coord_person_id )||','|| p_owner_org_unit_cd
1346: ||','||fnd_date.date_to_displaydate(p_owner_ou_start_dt)||','||p_award_course_only_ind ||','||p_research_unit_ind
1347: ||','|| p_industrial_ind
1348: ||','||p_practical_ind||','||p_repeatable_ind||','||p_assessable_ind||','||p_unit_int_course_level_cd||','||TO_CHAR(p_billing_credit_points)||','||p_ovrd_wkld_val_flag||','||p_workload_val_code
1349: ||',' || to_char(p_billing_hrs);
1350: