DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_AS_UNIT_CLASS_ALL

Line 688: p_v_unit_class OUT NOCOPY igs_as_unit_class_all.unit_class%TYPE,

684: END finpl_get_uptl;
685:
686:
687: PROCEDURE finpl_get_unit_class_mode( p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
688: p_v_unit_class OUT NOCOPY igs_as_unit_class_all.unit_class%TYPE,
689: p_v_unit_mode OUT NOCOPY igs_as_unit_class_all.unit_mode%TYPE ) AS
690:
691: /*************************************************************
692: Created By : Bhaskar Annamalai

Line 689: p_v_unit_mode OUT NOCOPY igs_as_unit_class_all.unit_mode%TYPE ) AS

685:
686:
687: PROCEDURE finpl_get_unit_class_mode( p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
688: p_v_unit_class OUT NOCOPY igs_as_unit_class_all.unit_class%TYPE,
689: p_v_unit_mode OUT NOCOPY igs_as_unit_class_all.unit_mode%TYPE ) AS
690:
691: /*************************************************************
692: Created By : Bhaskar Annamalai
693: Date Created By : 03-JUN-2005

Line 703: FROM igs_as_unit_class_all uc,

699: Who When What
700: ***************************************************************/
701: CURSOR cur_unit_class_mode (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
702: SELECT uc.unit_class, uc.unit_mode
703: FROM igs_as_unit_class_all uc,
704: igs_ps_unit_ofr_opt_all uoo
705: WHERE uc.unit_class = uoo.unit_class
706: AND uoo.uoo_id = p_n_uoo_id;
707:

Line 708: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;

704: igs_ps_unit_ofr_opt_all uoo
705: WHERE uc.unit_class = uoo.unit_class
706: AND uoo.uoo_id = p_n_uoo_id;
707:
708: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
709: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
710:
711: BEGIN
712: p_v_unit_class := NULL;

Line 709: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;

705: WHERE uc.unit_class = uoo.unit_class
706: AND uoo.uoo_id = p_n_uoo_id;
707:
708: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
709: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
710:
711: BEGIN
712: p_v_unit_class := NULL;
713: p_v_unit_mode := NULL;

Line 5103: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;

5099: l_n_chg_elements igs_fi_fee_as_items.chg_elements%TYPE;
5100: l_n_count NUMBER;
5101: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
5102: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
5103: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
5104: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
5105: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
5106: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;
5107: l_n_amount igs_fi_fee_as_items.amount%TYPE;

Line 5104: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;

5100: l_n_count NUMBER;
5101: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
5102: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
5103: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
5104: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
5105: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
5106: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;
5107: l_n_amount igs_fi_fee_as_items.amount%TYPE;
5108: l_v_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE;

Line 6977: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;

6973: l_n_crs_version_number igs_fi_Fee_as_items.crs_version_number%TYPE;
6974:
6975: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
6976: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
6977: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
6978: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
6979: l_n_count NUMBER;
6980: l_b_rule BOOLEAN;
6981: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;

Line 6978: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;

6974:
6975: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
6976: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
6977: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
6978: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
6979: l_n_count NUMBER;
6980: l_b_rule BOOLEAN;
6981: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
6982: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;