APPS.IGS_AD_PANEL_DTLS_PKG dependencies on IGS_AD_PNL_HIS_DTLS_PKG

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 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 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,