DBA Data[Home] [Help]

APPS.JTF_PERZ_PROFILE_PVT dependencies on JTF_PERZ_PROFILE_PUB

Line 58: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

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,

Line 59: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,

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,

Line 102: p_Profile_ATTRIB_Tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,

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,

Line 119: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

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,

Line 120: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,

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,

Line 122: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,

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: );

Line 180: -- ( p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,

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: -- ****************************************************************************