DBA Data[Home] [Help]

APPS.JTF_PERZ_LF_PVT dependencies on JTF_PERZ_PROFILE

Line 976: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(

972: l_profile_name := p_profile_name;
973: l_return_status := FND_API.G_TRUE;
974: if ((p_profile_id is NULL) OR
975: (p_profile_id = FND_API.G_MISS_NUM)) then
976: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(
977: l_profile_name,
978: l_return_status,
979: l_profile_id
980: );

Line 1376: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(

1372: l_profile_name := p_profile_name;
1373: l_return_status := FND_API.G_TRUE;
1374: if ((p_profile_id is NULL) OR
1375: (p_profile_id = FND_API.G_MISS_NUM)) then
1376: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(
1377: l_profile_name,
1378: l_return_status,
1379: l_profile_id
1380: );

Line 1732: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE Optional

1728: -- p_application_id IN NUMBER Required
1729: -- p_profile_id IN NUMBER Required
1730: -- p_profile_name IN VARCHAR2 Optional
1731: -- p_profile_type IN VARCHAR2,
1732: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE Optional
1733: -- p_parent_id IN NUMBER Required
1734: -- p_object_id IN NUMBER Optional
1735: -- p_object_name IN VARCHAR2 Required
1736: -- p_object_description IN VARCHAR2 Optional

Line 1767: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

1763:
1764: p_profile_id IN NUMBER,
1765: p_profile_name IN VARCHAR2,
1766: p_profile_type IN VARCHAR2,
1767: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
1768: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
1769:
1770: p_application_id IN NUMBER,
1771: p_parent_id IN NUMBER,

Line 1768: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,

1764: p_profile_id IN NUMBER,
1765: p_profile_name IN VARCHAR2,
1766: p_profile_type IN VARCHAR2,
1767: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
1768: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
1769:
1770: p_application_id IN NUMBER,
1771: p_parent_id IN NUMBER,
1772: p_object_type_id IN NUMBER,

Line 1797: l_profile_attrib JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

1793: l_return_status VARCHAR2(240) := FND_API.G_TRUE;
1794: l_profile_id NUMBER := NULL;
1795: l_profile_name VARCHAR2(60) := p_profile_name;
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;

Line 1877: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(

1873: l_return_status := FND_API.G_TRUE;
1874:
1875: --dbms_output.put_line (' profile id'|| l_profile_id);
1876: --dbms_output.put_line (' profile name'|| l_profile_name);
1877: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(
1878: l_profile_name,
1879: l_return_status,
1880: l_profile_id
1881: );

Line 1895: JTF_PERZ_PROFILE_PVT.Create_Profile(

1891: l_return_status := FND_API.G_RET_STS_SUCCESS;
1892: l_commit := FND_API.G_FALSE;
1893: l_profile_id := p_profile_id;
1894:
1895: JTF_PERZ_PROFILE_PVT.Create_Profile(
1896: p_api_version_number => l_api_version_number,
1897: p_init_msg_list => l_init_msg_list,
1898: p_commit => l_commit,
1899: p_profile_id => l_profile_id,

Line 2266: jtf_perz_profile p

2262: d.attribute_value, d.active_flag, d.priority
2263: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2264: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2265: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2266: jtf_perz_profile p
2267: where
2268: a.parent_id = p_object_id
2269: and a.application_id = p_application_id
2270: and d.profile_id = p.profile_id

Line 2290: jtf_perz_lf_object o, jtf_perz_profile p

2286: d.attribute_value, d.active_flag, d.priority
2287: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2288: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2289: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2290: jtf_perz_lf_object o, jtf_perz_profile p
2291: where
2292: o.object_name = p_object_name
2293: and o.object_id = a.parent_id
2294: and a.application_id = p_application_id

Line 2361: jtf_perz_profile p

2357: d.attribute_value, d.active_flag, d.priority
2358: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2359: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2360: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2361: jtf_perz_profile p
2362: where
2363: a.object_id = p_object_id
2364: and a.application_id = p_application_id
2365: and d.profile_id = p.profile_id

Line 2385: jtf_perz_profile p

2381: d.attribute_value, d.active_flag, d.priority
2382: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2383: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2384: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2385: jtf_perz_profile p
2386: where
2387: a.object_name = p_object_name
2388: and a.application_id = p_application_id
2389: and d.profile_id = p.profile_id