APPS.IGS_CO_S_PERLT_RPTGP_PKG dependencies on IGS_CO_S_PERLT_RPTGP_PKG

Line 1: PACKAGE BODY igs_co_s_perlt_rptgp_pkg AS

1: PACKAGE BODY igs_co_s_perlt_rptgp_pkg AS
2: /* $Header: IGSLI27B.pls 115.2 2002/11/29 01:08:45 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_s_perlt_rptgp_all%ROWTYPE;

Line 162: ELSIF NOT igs_co_s_perlt_rptgp_pkg.get_pk_for_validation (

158: (new_references.spl_sequence_number IS NULL) OR
159: (new_references.sup_repeating_group_cd IS NULL) OR
160: (new_references.sup_splrg_sequence_number IS NULL))) THEN
161: NULL;
162: ELSIF NOT igs_co_s_perlt_rptgp_pkg.get_pk_for_validation (
163: new_references.person_id,
164: new_references.correspondence_type,
165: new_references.letter_reference_number,
166: new_references.spl_sequence_number,

Line 227: igs_co_s_perlt_rptgp_pkg.get_fk_igs_co_s_perlt_rptgp (

223: || (reverse chronological order - newest change first)
224: */
225: BEGIN
226:
227: igs_co_s_perlt_rptgp_pkg.get_fk_igs_co_s_perlt_rptgp (
228: old_references.person_id,
229: old_references.correspondence_type,
230: old_references.letter_reference_number,
231: old_references.spl_sequence_number,

Line 921: END igs_co_s_perlt_rptgp_pkg;

917:
918: END delete_row;
919:
920:
921: END igs_co_s_perlt_rptgp_pkg;