APPS.IGS_AD_PANEL_DTLS_PKG dependencies on IGS_AD_PNL_HIS_DTLS

Line 279: igs_ad_pnl_his_dtls_pkg.get_fk_igs_ad_panel_dtls (

275: || (reverse chronological order - newest change first)
276: */
277: BEGIN
278:
279: igs_ad_pnl_his_dtls_pkg.get_fk_igs_ad_panel_dtls (
280: old_references.panel_dtls_id
281: );
282:
283: igs_ad_pnmembr_dtls_pkg.get_fk_igs_ad_panel_dtls (

Line 536: FROM igs_ad_pnl_his_dtls

532:
533: -- Cursor to get all the history records associated to panel decision.
534: CURSOR c_get_pnl_history IS
535: SELECT rowid
536: FROM igs_ad_pnl_his_dtls
537: WHERE panel_dtls_id = old_references.panel_dtls_id
538: FOR UPDATE OF panel_dtls_id NOWAIT;
539:
540: CURSOR c_panel_type_code IS

Line 880: -- Delete history records from igs_ad_pnl_his_dtls.

876: END IF;
877: END IF;
878:
879: IF NVL(p_deleting,FALSE) THEN
880: -- Delete history records from igs_ad_pnl_his_dtls.
881: FOR v_hist_rec IN c_get_pnl_history LOOP
882: igs_ad_pnl_his_dtls_pkg.delete_row (
883: x_rowid => v_hist_rec.rowid );
884: END LOOP;

Line 882: igs_ad_pnl_his_dtls_pkg.delete_row (

878:
879: IF NVL(p_deleting,FALSE) THEN
880: -- Delete history records from igs_ad_pnl_his_dtls.
881: FOR v_hist_rec IN c_get_pnl_history LOOP
882: igs_ad_pnl_his_dtls_pkg.delete_row (
883: x_rowid => v_hist_rec.rowid );
884: END LOOP;
885: --Application instance cannot be deleted from a closed panel
886: OPEN c_panel_type_code;

Line 959: l_history_date igs_ad_pnl_his_dtls.history_date%TYPE;

955:
956: l_class_meaning igs_lookups_view.meaning%TYPE;
957: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
958:
959: l_history_date igs_ad_pnl_his_dtls.history_date%TYPE;
960:
961: CURSOR c_panel_type IS
962: SELECT panel_type_code
963: FROM igs_ad_intvw_pnls

Line 1044: -- Populate the history Table igs_ad_pnl_his_dtls.

1040: END LOOP;
1041: END IF;
1042:
1043: IF NVL(p_updating,FALSE) THEN
1044: -- Populate the history Table igs_ad_pnl_his_dtls.
1045: IF (NVL(new_references.final_decision_code,'NULL') <> NVL(old_references.final_decision_code,'NULL') OR
1046: NVL(new_references.final_decision_date,SYSDATE) <> TRUNC(NVL(old_references.final_decision_date,SYSDATE))) THEN
1047:
1048: -- When the final screening/interview decision is changed, a record needs to get inserted into the history table.

Line 1053: igs_ad_pnl_his_dtls_pkg.insert_row (

1049: -- The primary key for this tanble is panel_dtls_id, history_date. If a record already exists, then
1050: -- increment the history date by one second and insert a record.
1051: l_history_date := old_references.last_update_date + 1 / (60*24*60);
1052:
1053: igs_ad_pnl_his_dtls_pkg.insert_row (
1054: x_rowid => l_rowid_ad_pnl_history,
1055: x_panel_dtls_id => old_references.panel_dtls_id,
1056: x_history_date => l_history_date,
1057: x_final_decision_code => old_references.final_decision_code,