APPS.JTF_PERZ_DDF_PVT dependencies on JTF_PERZ_DDF_PUB

Line 164: x_ddf_out_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DDF_PUB.DDF_OUT_TBL_TYPE,

160: p_GUI_OBJECT_NAME IN VARCHAR2,
161: p_GUI_OBJECT_ID IN NUMBER,
162: p_ddf_value IN VARCHAR2,
163: p_ddf_value_type IN VARCHAR2,
164: x_ddf_out_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DDF_PUB.DDF_OUT_TBL_TYPE,
165: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
166: )IS
167:
168: l_count NUMBER := NULL;

Line 169: l_ddf_out_rec_temp JTF_PERZ_DDF_PUB.DDF_OUT_REC_TYPE := NULL;

165: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
166: )IS
167:
168: l_count NUMBER := NULL;
169: l_ddf_out_rec_temp JTF_PERZ_DDF_PUB.DDF_OUT_REC_TYPE := NULL;
170:
171: cursor c_get_ddf_paoc (p_profile_id NUMBER, p_application_id NUMBER,
172: p_gui_object_id NUMBER, p_perz_ddf_context VARCHAR2) is
173: select perz_data_default_id, perz_ddf_context,

Line 1314: -- x_ddf_out_tbl OUT JTF_PERZ_DDF_PUB.DDF_OUT_TBL_TYPE

1310: -- p_ddf_value IN VARCHAR2 Required
1311: -- p_ddf_value_type IN VARCHAR2 Required
1312: --
1313: -- OUT :
1314: -- x_ddf_out_tbl OUT JTF_PERZ_DDF_PUB.DDF_OUT_TBL_TYPE
1315: -- x_return_status OUT VARCHAR2
1316: -- x_msg_count OUT NUMBER
1317: -- x_msg_data OUT VARCHAR2
1318: --

Line 1351: x_ddf_out_tbl OUT NOCOPY /* file.sql.39 change */ jtf_perz_ddf_pub.DDF_OUT_TBL_TYPE,

1347:
1348: p_ddf_value IN VARCHAR2,
1349: p_ddf_value_type IN VARCHAR2,
1350:
1351: x_ddf_out_tbl OUT NOCOPY /* file.sql.39 change */ jtf_perz_ddf_pub.DDF_OUT_TBL_TYPE,
1352: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1353: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1354: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1355: )IS

Line 1365: l_ddf_out_tbl JTF_PERZ_DDF_PUB.DDF_OUT_TBL_TYPE

1361: l_profile_id NUMBER := NULL;
1362: l_profile_name VARCHAR2(60) := NULL;
1363: l_return_status VARCHAR2(240);
1364: l_perz_ddf_id NUMBER := p_perz_ddf_id;
1365: l_ddf_out_tbl JTF_PERZ_DDF_PUB.DDF_OUT_TBL_TYPE
1366: := x_ddf_out_tbl;
1367:
1368:
1369: BEGIN