DBA Data[Home] [Help]

APPS.IGF_AP_SS_PKG dependencies on IGS_PE_PERSID_GROUP

Line 763: p_pid_grp IN igs_pe_persid_group.group_id%TYPE,

759: END IF;
760: END set_internal_isir;
761:
762: FUNCTION get_pid (
763: p_pid_grp IN igs_pe_persid_group.group_id%TYPE,
764: p_status OUT NOCOPY VARCHAR2,
765: p_group_type OUT NOCOPY igs_pe_persid_group_v.group_type%TYPE
766: ) RETURN VARCHAR2 IS
767: /*************************************************************

Line 765: p_group_type OUT NOCOPY igs_pe_persid_group_v.group_type%TYPE

761:
762: FUNCTION get_pid (
763: p_pid_grp IN igs_pe_persid_group.group_id%TYPE,
764: p_status OUT NOCOPY VARCHAR2,
765: p_group_type OUT NOCOPY igs_pe_persid_group_v.group_type%TYPE
766: ) RETURN VARCHAR2 IS
767: /*************************************************************
768: Change History
769: Who When What

Line 781: lv_group_type igs_pe_persid_group_v.group_type%TYPE;

777: g_api_version CONSTANT NUMBER := 1.0;
778: g_api_name CONSTANT VARCHAR2(30) := 'get_dynamic_sql';
779: g_pkg_name CONSTANT VARCHAR2(30) := 'igs_dynamic_perid_group';
780: g_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| g_api_name;
781: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
782:
783: BEGIN
784: --Bug #5021084.
785: lv_ret_sql := igs_pe_dynamic_persid_group.get_dynamic_sql