54: p_profile_id IN NUMBER,
55: p_profile_name IN VARCHAR2 := NULL,
56: p_profile_type IN VARCHAR2 := NULL,
57: p_profile_desc IN VARCHAR2 := NULL,
58: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
59: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
60:
61: x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
62: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
55: p_profile_name IN VARCHAR2 := NULL,
56: p_profile_type IN VARCHAR2 := NULL,
57: p_profile_desc IN VARCHAR2 := NULL,
58: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
59: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
60:
61: x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
62: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
63: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
98: p_profile_name IN VARCHAR2,
99: p_profile_type IN VARCHAR2 := NULL,
100: p_profile_desc IN VARCHAR2,
101: p_active_flag IN VARCHAR2,
102: p_Profile_ATTRIB_Tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
103:
104: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
105: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
106: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
115:
116: p_profile_id IN NUMBER := NULL,
117: p_profile_name IN VARCHAR2 := NULL,
118: p_profile_type IN VARCHAR2 := NULL,
119: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
120: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
121:
122: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,
123: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
116: p_profile_id IN NUMBER := NULL,
117: p_profile_name IN VARCHAR2 := NULL,
118: p_profile_type IN VARCHAR2 := NULL,
119: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
120: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
121:
122: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,
123: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
124: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
118: p_profile_type IN VARCHAR2 := NULL,
119: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
120: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
121:
122: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,
123: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
124: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
125: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126: );
176: --
177: -- *****************************************************************************
178:
179: -- PROCEDURE check_prof_attrib_duplicates
180: -- ( p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
181: -- x_return_status OUT BOOLEAN,
182: -- x_profile_id OUT NUMBER
183: -- );
184: -- ****************************************************************************