APPS.IGS_OR_GEN_001 dependencies on IGS_OR_UNIT_HIST

Line 25: || igs_or_unit_hist_pkg.insert_row call and call to igs_pe_hz_parties_pkg.update_row

21: || ssawhney 30-apr-2003 V2API OVN implementation, change to call to IGS_OR_GEN_012
22: || gmaheswa 15-sep-2003 changed orgp_get_local_inst to get local active institution from the profile.
23: || Bug No: 2863933
24: || mmkumar 18-Jul-2005 Party_Number impact, inside update_org , modified cursor hz_parties_cur,
25: || igs_or_unit_hist_pkg.insert_row call and call to igs_pe_hz_parties_pkg.update_row
26: */
27:
28: PROCEDURE orgp_del_instn_hist(
29: p_institution_cd IN VARCHAR2 )

Line 51: FROM IGS_OR_UNIT_HIST

47: IS
48: v_other_detail VARCHAR(255);
49: BEGIN
50: DELETE
51: FROM IGS_OR_UNIT_HIST
52: WHERE org_unit_cd = p_org_unit_cd
53: AND ou_start_dt = p_start_dt;
54: EXCEPTION
55: WHEN OTHERS THEN

Line 234: v_name IGS_OR_UNIT_HIST.name%TYPE;

230: p_org_type IN VARCHAR2 ,
231: p_member_type IN VARCHAR2 ,
232: p_institution_cd IN VARCHAR2 )
233: IS
234: v_name IGS_OR_UNIT_HIST.name%TYPE;
235: v_other_detail VARCHAR(255);
236:
237: BEGIN
238: -- Determine the value of the IGS_OR_UNIT_HIST.name

Line 238: -- Determine the value of the IGS_OR_UNIT_HIST.name

234: v_name IGS_OR_UNIT_HIST.name%TYPE;
235: v_other_detail VARCHAR(255);
236:
237: BEGIN
238: -- Determine the value of the IGS_OR_UNIT_HIST.name
239: IF p_institution_cd IS NULL THEN
240: v_name := NULL;
241: ELSE
242: SELECT name

Line 247: -- Insert the IGS_OR_UNIT_HIST record.

243: INTO v_name
244: FROM IGS_OR_INSTITUTION
245: WHERE institution_cd = p_institution_cd;
246: END IF;
247: -- Insert the IGS_OR_UNIT_HIST record.
248: INSERT INTO IGS_OR_UNIT_HIST
249: (org_unit_cd,
250: ou_start_dt,
251: hist_start_dt,

Line 248: INSERT INTO IGS_OR_UNIT_HIST

244: FROM IGS_OR_INSTITUTION
245: WHERE institution_cd = p_institution_cd;
246: END IF;
247: -- Insert the IGS_OR_UNIT_HIST record.
248: INSERT INTO IGS_OR_UNIT_HIST
249: (org_unit_cd,
250: ou_start_dt,
251: hist_start_dt,
252: hist_end_dt,

Line 748: || mmkumar 18-Jul-2005 Party_Number impact, modified cursor hz_parties_cur, igs_or_unit_hist_pkg.insert_row call

744: || skpandey 27-SEP-2005 Bug: 3663505
745: || Description: Added ATTRIBUTES 21 TO 24 to store additional information in IGS_OR_GEN_012_PKG call
746: || pkpatel 25-OCT-2002 Bug No: 2613704
747: || Modified signature of igs_pe_hz_parties_pkg to refer inst_priority_cd instead of inst_priority_code_id
748: || mmkumar 18-Jul-2005 Party_Number impact, modified cursor hz_parties_cur, igs_or_unit_hist_pkg.insert_row call
749: || and call to igs_pe_hz_parties_pkg.update_row
750: || (reverse chronological order - newest change first)
751: */
752:

Line 889: igs_or_unit_hist_pkg.insert_row (

885: -- 1 Second is deducted, to prevent the PK validation. The Hisory Start Date is part of PK.
886: l_hist_start_dt := hz_parties_rec.last_update_date - 1/(60*24*60);
887: l_hist_end_dt := SYSDATE;
888:
889: igs_or_unit_hist_pkg.insert_row (
890: X_ROWID => lv_rowid,
891: X_ORG_UNIT_CD => hz_parties_rec.oss_org_unit_cd,
892: X_OU_START_DT => igs_org_rec.ou_start_dt,
893: X_HIST_START_DT => l_hist_start_dt,