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_LF_PVT dependencies on JTF_PERZ_LF_PUB

Line 740: -- x_attrib_rec_tbl JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE

736: --
737: -- OUT :
738: -- x_object_type_desc VARCHAR2
739: -- x_return_status VARCHAR2
740: -- x_attrib_rec_tbl JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
741: --
742: -- ***************************************************************************
743: procedure get_obj_type_details
744: (

Line 748: x_attrib_rec_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE,

744: (
745: p_Object_type IN VARCHAR2,
746: p_Object_type_Id IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
747: x_object_type_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
748: x_attrib_rec_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE,
749: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
750: )IS
751: l_Object_type_Id NUMBER := NULL;
752: l_count NUMBER := 0;

Line 859: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

855:
856: -- p_object_type_id IN NUMBER Optional
857: -- p_object_type IN VARCHAR2 Optional
858:
859: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
860: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL
861:
862: -- OUT :
863: -- x_object_id OUT NUMBER

Line 860: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL

856: -- p_object_type_id IN NUMBER Optional
857: -- p_object_type IN VARCHAR2 Optional
858:
859: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
860: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL
861:
862: -- OUT :
863: -- x_object_id OUT NUMBER
864: -- x_return_status OUT VARCHAR2(1)

Line 894: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

890:
891: p_object_type_id IN NUMBER,
892: p_object_type IN VARCHAR2,
893:
894: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
895: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
896:
897: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
898: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 895: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,

891: p_object_type_id IN NUMBER,
892: p_object_type IN VARCHAR2,
893:
894: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
895: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
896:
897: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
898: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
899: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 919: l_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

915: l_object_name VARCHAR2(60) := NULL;
916: l_object_description VARCHAR2(240) := NULL;
917: l_count NUMBER := p_attrib_value_tbl.count;
918: l_curr_row NUMBER := NULL;
919: l_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
920: := p_attrib_value_tbl;
921: l_type_map_id NUMBER := NULL;
922: l_obj_map_id NUMBER := NULL;
923: l_active_flag VARCHAR2(1) := 'Y';

Line 1246: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

1242: -- p_active_flag IN VARCHAR2 Optional
1243:
1244: -- p_object_type_id IN NUMBER Optional
1245: -- p_object_type IN VARCHAR2 Optional
1246: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1247: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
1248: --
1249: -- OUT :
1250: -- x_object_id OUT NUMBER

Line 1247: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional

1243:
1244: -- p_object_type_id IN NUMBER Optional
1245: -- p_object_type IN VARCHAR2 Optional
1246: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1247: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
1248: --
1249: -- OUT :
1250: -- x_object_id OUT NUMBER
1251: -- x_return_status OUT VARCHAR2(1)

Line 1283: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

1279:
1280: p_object_type_id IN NUMBER,
1281: p_object_type IN VARCHAR2 := NULL,
1282:
1283: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1284: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
1285:
1286: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1287: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1284: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,

1280: p_object_type_id IN NUMBER,
1281: p_object_type IN VARCHAR2 := NULL,
1282:
1283: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1284: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
1285:
1286: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1287: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1288: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1298: l_Object_Tbl JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE;

1294: l_api_version_number NUMBER := p_api_version_number;
1295:
1296: -- ******* Update_lf_object Local Variables ********
1297: l_return_status VARCHAR2(240) := FND_API.G_TRUE;
1298: l_Object_Tbl JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE;
1299: l_profile_id NUMBER := NULL;
1300: l_profile_name VARCHAR2(60) := NULL;
1301: l_object_type VARCHAR2(60) := p_object_type;
1302: l_object_type_id NUMBER := p_object_type_id;

Line 1309: l_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

1305: l_parent_name VARCHAR2(60) := NULL;
1306: l_object_id NUMBER := p_object_id;
1307: l_parent_id NUMBER := p_parent_id;
1308:
1309: l_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1310: := p_attrib_value_tbl;
1311: l_db_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE;
1312: l_count NUMBER := p_attrib_value_tbl.count;
1313: l_curr_row NUMBER := NULL;

Line 1311: l_db_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE;

1307: l_parent_id NUMBER := p_parent_id;
1308:
1309: l_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1310: := p_attrib_value_tbl;
1311: l_db_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE;
1312: l_count NUMBER := p_attrib_value_tbl.count;
1313: l_curr_row NUMBER := NULL;
1314: l_value_id NUMBER := NULL;
1315: l_active_flag VARCHAR2(1) := upper(p_active_flag);

Line 1741: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

1737: -- p_object_type_id IN NUMBER Optional
1738: -- p_object_type IN VARCHAR2 Required
1739: -- p_active_flag IN VARCHAR2 Optional
1740: -- Default = NO
1741: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1742: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
1743: -- p_commit IN VARCHAR2 Optional
1744: --
1745: -- OUT :

Line 1742: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional

1738: -- p_object_type IN VARCHAR2 Required
1739: -- p_active_flag IN VARCHAR2 Optional
1740: -- Default = NO
1741: -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1742: -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
1743: -- p_commit IN VARCHAR2 Optional
1744: --
1745: -- OUT :
1746: -- x_object_id OUT NUMBER

Line 1780: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

1776: p_object_name IN VARCHAR2,
1777: p_object_description IN VARCHAR2,
1778:
1779: p_active_flag IN VARCHAR2,
1780: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1781: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
1782:
1783: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1784: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1781: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,

1777: p_object_description IN VARCHAR2,
1778:
1779: p_active_flag IN VARCHAR2,
1780: p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1781: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
1782:
1783: x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1784: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1785: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1800: l_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE

1796: l_profile_type VARCHAR2(30) := p_profile_type;
1797: l_profile_attrib JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
1798: := p_profile_attrib_tbl;
1799: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1800: l_attrib_value_tbl JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
1801: := p_attrib_value_tbl;
1802: l_object_type VARCHAR2(60) := p_object_type;
1803: l_object_type_id NUMBER := p_object_type_id;
1804: l_rowid ROWID := NULL;

Line 1812: l_attrib_rec_tbl JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE;

1808: l_curr_row NUMBER := NULL;
1809: l_out_object_id NUMBER := NULL;
1810: l_out_object_type_id NUMBER := p_object_type_id;
1811: l_out_obj_type_map_tbl JTF_PERZ_LF_PVT.OBJ_TYPE_MAP_TBL_TYPE;
1812: l_attrib_rec_tbl JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE;
1813: l_active_flag VARCHAR2(1) := upper(p_active_flag);
1814: l_object_type_desc VARCHAR2(240) := NULL;
1815: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1816:

Line 2182: -- x_Object_Tbl OUT JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,

2178: -- p_get_children_flag IN VARCHAR2 Optional
2179: --
2180: -- OUT :
2181: -- x_object_id OUT Optional
2182: -- x_Object_Tbl OUT JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,
2183: -- x_return_status OUT VARCHAR2(1)
2184: -- x_msg_count OUT NUMBER
2185: -- x_msg_data OUT VARCHAR2(2000)
2186: --

Line 2208: x_Object_Tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,

2204: P_Object_Id IN NUMBER,
2205: p_Object_Name IN VARCHAR,
2206: p_obj_active_flag IN VARCHAR2,
2207: p_get_children_flag IN VARCHAR2,
2208: x_Object_Tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,
2209: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2210: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2211: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2212: )IS

Line 2228: l_object_out_rec JTF_PERZ_LF_PUB.LF_OBJECT_OUT_REC_TYPE := NULL;

2224: l_active_flag VARCHAR2(1) := upper(p_obj_active_flag);
2225: l_count NUMBER;
2226: l_value_id NUMBER;
2227:
2228: l_object_out_rec JTF_PERZ_LF_PUB.LF_OBJECT_OUT_REC_TYPE := NULL;
2229:
2230: l_Object_Tbl JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE;
2231:
2232: Cursor C_get_child_pioi(p_profile_id NUMBER, p_application_id NUMBER,

Line 2230: l_Object_Tbl JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE;

2226: l_value_id NUMBER;
2227:
2228: l_object_out_rec JTF_PERZ_LF_PUB.LF_OBJECT_OUT_REC_TYPE := NULL;
2229:
2230: l_Object_Tbl JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE;
2231:
2232: Cursor C_get_child_pioi(p_profile_id NUMBER, p_application_id NUMBER,
2233: p_object_id NUMBER, p_active_flag VARCHAR2) IS
2234:

Line 2901: -- x_attrib_rec_tbl OUT JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE

2897:
2898: -- OUT :
2899: -- x_object_type_id OUT NUMBER
2900: -- x_object_type_desc OUT VARCHAR,
2901: -- x_attrib_rec_tbl OUT JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
2902: -- x_return_status OUT VARCHAR2(1)
2903: -- x_msg_count OUT NUMBER
2904: -- x_msg_data OUT VARCHAR2(2000)
2905: --

Line 2925: x_attrib_rec_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE,

2921:
2922: x_Object_type_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
2923: x_object_type_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2924:
2925: x_attrib_rec_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE,
2926: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2927: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2928: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2929: )IS

Line 2934: l_attrib_rec_tbl JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE;

2930:
2931: l_api_version_number NUMBER := p_api_version_number;
2932: l_api_name CONSTANT VARCHAR2(30) := 'GET_LF_OBJECT_TYPE';
2933: l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
2934: l_attrib_rec_tbl JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE;
2935: l_Object_type_Id NUMBER := p_Object_type_Id;
2936: l_Object_type VARCHAR2(60) := p_Object_type;
2937: l_object_type_desc VARCHAR2(240) := NULL;
2938:

Line 3014: -- p_attribute_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE Required

3010: -- p_object_type_id IN NUMBER Optional
3011: -- p_object_type IN VARCHAR2 Optional
3012: -- p_object_type_desc IN VARCHAR2 Optional
3013:
3014: -- p_attribute_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE Required
3015: --
3016: -- OUT :
3017: -- x_object_type_id OUT NUMBER
3018: -- x_obj_type_map_tbl OUT JTF_PERZ_LF_PUB.OBJ_TYPE_MAP_TBL_TYPE

Line 3018: -- x_obj_type_map_tbl OUT JTF_PERZ_LF_PUB.OBJ_TYPE_MAP_TBL_TYPE

3014: -- p_attribute_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE Required
3015: --
3016: -- OUT :
3017: -- x_object_type_id OUT NUMBER
3018: -- x_obj_type_map_tbl OUT JTF_PERZ_LF_PUB.OBJ_TYPE_MAP_TBL_TYPE
3019: -- x_return_status OUT VARCHAR2
3020: -- x_msg_count OUT NUMBER
3021: -- x_msg_data OUT VARCHAR2(2000)
3022: --

Line 3040: p_attrib_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE

3036: p_object_type_id IN NUMBER,
3037: p_object_type IN VARCHAR2,
3038: p_object_type_desc IN VARCHAR2,
3039:
3040: p_attrib_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
3041: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_REC_TBL,
3042:
3043: x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3044:

Line 3041: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_REC_TBL,

3037: p_object_type IN VARCHAR2,
3038: p_object_type_desc IN VARCHAR2,
3039:
3040: p_attrib_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
3041: := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_REC_TBL,
3042:
3043: x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3044:
3045: x_obj_type_map_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PVT.OBJ_TYPE_MAP_TBL_TYPE,

Line 3062: l_attrib_rec_tbl JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE

3058: l_rowid ROWID := NULL;
3059: l_OBJECT_TYPE_ID NUMBER := p_object_type_id;
3060: l_OBJECT_TYPE VARCHAR2(60) := p_object_type;
3061: l_OBJECT_TYPE_DESC VARCHAR2(240) := p_object_type_desc;
3062: l_attrib_rec_tbl JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
3063: := p_attrib_rec_tbl;
3064: l_count NUMBER := p_attrib_rec_tbl.count;
3065: l_curr_row NUMBER := NULL;
3066: l_inserted_map NUMBER := 0;