eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PERZ_PROFILE_PVT dependencies on JTF_PERZ_PROFILE_PUB

Line 313: p_profile_attrib_rec IN JTF_PERZ_PROFILE_PUB.PROFILE_OUT_REC_TYPE,

309: -- The columns are essentially a mapping of table columns from
310: -- the query to the output record set.
311:
312: PROCEDURE Define_Columns_Profile(
313: p_profile_attrib_rec IN JTF_PERZ_PROFILE_PUB.PROFILE_OUT_REC_TYPE,
314: p_cur_profile IN NUMBER ) IS
315: BEGIN
316:
317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 337: p_profile_attrib_rec OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_REC_TYPE ) IS

333: -- ****************************************************************************
334: -- This procedure defines the return columns for the D-SQL
335:
336: PROCEDURE Get_Columns_Profile(p_cur_profile IN NUMBER,
337: p_profile_attrib_rec OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_REC_TYPE ) IS
338: BEGIN
339: --dbms_output.put_line('JTF_PERZ_PROFILE_PVT Get column values');
340:
341: dbms_sql.column_value(p_cur_profile, 1, p_profile_attrib_rec.PROFILE_ID);

Line 357: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,

353: -- This procedure will bind the variables for the dynamic SQL query
354:
355: PROCEDURE Bind_Variables_Profile(
356: p_cur_profile IN NUMBER,
357: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
358: p_profile_name IN VARCHAR2,
359: p_profile_type IN VARCHAR2,
360: p_profile_id IN NUMBER
361: ) IS

Line 410: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,

406:
407: -- This procedure generates the WHERE clause for Get_Activities
408:
409: PROCEDURE Gen_Where_Profile(
410: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
411: p_profile_name IN VARCHAR2,
412: p_profile_type IN VARCHAR2,
413: p_profile_id IN NUMBER,
414: x_head_where OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 540: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

536: p_profile_id IN NUMBER,
537: p_profile_name IN VARCHAR2 := NULL,
538: p_profile_type IN VARCHAR2 := NULL,
539: p_profile_desc IN VARCHAR2 := NULL,
540: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
541: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
542:
543: x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
544: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 541: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,

537: p_profile_name IN VARCHAR2 := NULL,
538: p_profile_type IN VARCHAR2 := NULL,
539: p_profile_desc IN VARCHAR2 := NULL,
540: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
541: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
542:
543: x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
544: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
545: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 550: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

546: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
547: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
548: )IS
549:
550: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
551: := p_profile_attrib_tbl;
552: l_any_errors BOOLEAN := FALSE;
553: l_any_row_errors BOOLEAN := FALSE;
554: l_rowid ROWID;

Line 718: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

714:
715: p_profile_id IN NUMBER := NULL,
716: p_profile_name IN VARCHAR2 := NULL,
717: p_profile_type IN VARCHAR2 := NULL,
718: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
719: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
720:
721: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,
722: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 719: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,

715: p_profile_id IN NUMBER := NULL,
716: p_profile_name IN VARCHAR2 := NULL,
717: p_profile_type IN VARCHAR2 := NULL,
718: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
719: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
720:
721: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,
722: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
723: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

717: p_profile_type IN VARCHAR2 := NULL,
718: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
719: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
720:
721: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,
722: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
723: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
724: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
725: )IS

Line 727: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

723: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
724: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
725: )IS
726:
727: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
728: := p_profile_attrib_tbl;
729: l_profile_out_tbl JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE;
730: l_profile_out_rec JTF_PERZ_PROFILE_PUB.PROFILE_OUT_REC_TYPE;
731:

Line 729: l_profile_out_tbl JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE;

725: )IS
726:
727: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
728: := p_profile_attrib_tbl;
729: l_profile_out_tbl JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE;
730: l_profile_out_rec JTF_PERZ_PROFILE_PUB.PROFILE_OUT_REC_TYPE;
731:
732: l_any_errors BOOLEAN := FALSE;
733: l_any_row_errors BOOLEAN := FALSE;

Line 730: l_profile_out_rec JTF_PERZ_PROFILE_PUB.PROFILE_OUT_REC_TYPE;

726:
727: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
728: := p_profile_attrib_tbl;
729: l_profile_out_tbl JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE;
730: l_profile_out_rec JTF_PERZ_PROFILE_PUB.PROFILE_OUT_REC_TYPE;
731:
732: l_any_errors BOOLEAN := FALSE;
733: l_any_row_errors BOOLEAN := FALSE;
734: l_rowid ROWID;

Line 1009: p_Profile_ATTRIB_Tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,

1005: p_profile_name IN VARCHAR2,
1006: p_profile_type IN VARCHAR2 := NULL,
1007: p_profile_desc IN VARCHAR2 ,
1008: p_active_flag IN VARCHAR2,
1009: p_Profile_ATTRIB_Tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
1010: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1011: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1012: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1013: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1017: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE;

1013: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1014: ) IS
1015: -- problem is, this API will not check the validity of the p_active_flag
1016:
1017: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE;
1018: l_attributes_from_database JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE;
1019:
1020: l_api_version NUMBER := 1.0;
1021: l_init_msg_list VARCHAR2(240):= FND_API.G_TRUE;

Line 1018: l_attributes_from_database JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE;

1014: ) IS
1015: -- problem is, this API will not check the validity of the p_active_flag
1016:
1017: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE;
1018: l_attributes_from_database JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE;
1019:
1020: l_api_version NUMBER := 1.0;
1021: l_init_msg_list VARCHAR2(240):= FND_API.G_TRUE;
1022: l_msg_count NUMBER;