DBA Data[Home] [Help]

APPS.IGS_AU_GEN_003 dependencies on IGS_AU_GEN_003

Line 1: PACKAGE BODY igs_au_gen_003 AS

1: PACKAGE BODY igs_au_gen_003 AS
2: /* $Header: IGSAU03B.pls 115.21 2003/12/09 12:07:35 rvangala ship $ */
3: -- WHO WHEN WHAT
4: -- pradhakr 03/07/2001 Added a function enrp_get_sph_col in this package.
5: -- Changes in the function Audp_Get_scah_col, Audp_Get_Suah_Col.

Line 988: -- passed uoo_id in call of Igs_Au_Gen_003.audp_get_suah_col,

984: -- with HZ_PARTIES table
985: --
986: -- Who When What
987: -- knaraset 29-Apr-03 added p_uoo_id as parameter,also removed the other parameters unit_cd,cal_type and sequence_number
988: -- passed uoo_id in call of Igs_Au_Gen_003.audp_get_suah_col,
989: -- as part of MUS build bug 2829262
990: --
991: ----------------------------------------------
992: CURSOR CUR_RWP IS

Line 1007: p_pers_id_ret := NVL(P_H_rule_waived_person_id, NVL(Igs_Au_Gen_003.audp_get_suah_col('RULE_WAIVED_PERSON_ID', P_person_id, P_course_cd, P_hist_end_dt,p_uoo_id), P_RWP));

1003: -- which will be returned if rule_waived_person_id is null in History table.
1004: --
1005: OPEN CUR_RWP;
1006: FETCH CUR_RWP INTO P_RWP;
1007: p_pers_id_ret := NVL(P_H_rule_waived_person_id, NVL(Igs_Au_Gen_003.audp_get_suah_col('RULE_WAIVED_PERSON_ID', P_person_id, P_course_cd, P_hist_end_dt,p_uoo_id), P_RWP));
1008:
1009: --
1010: -- Return the rule_waived_person_id calculated above.
1011: --

Line 1016: END igs_au_gen_003;

1012: RETURN p_pers_id_ret;
1013:
1014: END ENRP_RET_WAIVE_PERSON_ID;
1015:
1016: END igs_au_gen_003;