DBA Data[Home] [Help]

APPS.PV_USER_MGMT_PVT dependencies on PV_USER_RESP_PVT

Line 789: l_role := pv_user_Resp_pvt.G_PRIMARY;

785: RAISE FND_API.G_EXC_ERROR;
786: END IF;
787:
788: IF (is_primary_user) THEN
789: l_role := pv_user_Resp_pvt.G_PRIMARY;
790: ELSE
791: l_role := pv_user_Resp_pvt.G_BUSINESS;
792: END IF;
793:

Line 791: l_role := pv_user_Resp_pvt.G_BUSINESS;

787:
788: IF (is_primary_user) THEN
789: l_role := pv_user_Resp_pvt.G_PRIMARY;
790: ELSE
791: l_role := pv_user_Resp_pvt.G_BUSINESS;
792: END IF;
793:
794: pv_user_Resp_pvt.assign_user_resps(
795: p_api_version_number => p_api_version_number

Line 794: pv_user_Resp_pvt.assign_user_resps(

790: ELSE
791: l_role := pv_user_Resp_pvt.G_BUSINESS;
792: END IF;
793:
794: pv_user_Resp_pvt.assign_user_resps(
795: p_api_version_number => p_api_version_number
796: ,p_init_msg_list => FND_API.g_false
797: ,p_commit => FND_API.G_FALSE
798: ,x_return_status => x_return_status

Line 1006: l_role := PV_USER_RESP_PVT.G_PRIMARY;

1002: /** If G_PARTNER_PERMISSION permission is revoked and user will become non partner user after the role is revoked **/
1003: If(NOT is_partner_user and is_prtnr_perm_revoked) THEN
1004:
1005: if(is_primary_user or is_primary_perm_revoked) THEN
1006: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1007: else
1008: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1009: END IF;
1010:

Line 1008: l_role := PV_USER_RESP_PVT.G_BUSINESS;

1004:
1005: if(is_primary_user or is_primary_perm_revoked) THEN
1006: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1007: else
1008: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1009: END IF;
1010:
1011: PV_USER_RESP_PVT.revoke_user_resps(
1012: p_api_version_number => p_api_version_number

Line 1011: PV_USER_RESP_PVT.revoke_user_resps(

1007: else
1008: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1009: END IF;
1010:
1011: PV_USER_RESP_PVT.revoke_user_resps(
1012: p_api_version_number => p_api_version_number
1013: ,p_init_msg_list => FND_API.g_false
1014: ,p_commit => FND_API.G_FALSE
1015: ,x_return_status => x_return_status

Line 1030: PV_USER_RESP_PVT.switch_user_resp(

1026: END IF;
1027:
1028: /** If partner user and primary user permission is revoked and user will become business user after this **/
1029: elsif (is_partner_user and (NOT is_primary_user) and is_primary_perm_revoked) THEN
1030: PV_USER_RESP_PVT.switch_user_resp(
1031: p_api_version_number => p_api_version_number
1032: ,p_init_msg_list => FND_API.g_false
1033: ,p_commit => FND_API.G_FALSE
1034: ,x_return_status => x_return_status

Line 1038: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

1034: ,x_return_status => x_return_status
1035: ,x_msg_count => x_msg_count
1036: ,x_msg_data => x_msg_data
1037: ,p_user_id => l_user_id
1038: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1039: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1040: );
1041:
1042: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1039: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

1035: ,x_msg_count => x_msg_count
1036: ,x_msg_data => x_msg_data
1037: ,p_user_id => l_user_id
1038: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1039: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1040: );
1041:
1042: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1283: l_role := PV_USER_RESP_PVT.G_PRIMARY;

1279:
1280: FOR X in 1..l_user_names.count loop
1281: IF (is_primary_perm_revoked and (l_user_perm_changed(X) is null or l_user_perm_changed(X) = 'PR')) THEN
1282: IF (l_user_perm_changed(X) = 'PR' or is_primary_perm_revoked) THEN
1283: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1284: else
1285: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1286: END IF;
1287:

Line 1285: l_role := PV_USER_RESP_PVT.G_BUSINESS;

1281: IF (is_primary_perm_revoked and (l_user_perm_changed(X) is null or l_user_perm_changed(X) = 'PR')) THEN
1282: IF (l_user_perm_changed(X) = 'PR' or is_primary_perm_revoked) THEN
1283: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1284: else
1285: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1286: END IF;
1287:
1288: PV_USER_RESP_PVT.revoke_user_resps(
1289: p_api_version_number => p_api_version_number

Line 1288: PV_USER_RESP_PVT.revoke_user_resps(

1284: else
1285: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1286: END IF;
1287:
1288: PV_USER_RESP_PVT.revoke_user_resps(
1289: p_api_version_number => p_api_version_number
1290: ,p_init_msg_list => FND_API.g_false
1291: ,p_commit => FND_API.G_FALSE
1292: ,x_return_status => x_return_status

Line 1305: PV_USER_RESP_PVT.switch_user_resp(

1301: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: ELSIF (is_primary_perm_revoked and l_user_perm_changed(X) = 'PT') THEN
1305: PV_USER_RESP_PVT.switch_user_resp(
1306: p_api_version_number => p_api_version_number
1307: ,p_init_msg_list => FND_API.g_false
1308: ,p_commit => FND_API.G_FALSE
1309: ,x_return_status => x_return_status

Line 1313: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

1309: ,x_return_status => x_return_status
1310: ,x_msg_count => x_msg_count
1311: ,x_msg_data => x_msg_data
1312: ,p_user_id => l_user_ids(X)
1313: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1314: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1315: );
1316:
1317: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1314: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

1310: ,x_msg_count => x_msg_count
1311: ,x_msg_data => x_msg_data
1312: ,p_user_id => l_user_ids(X)
1313: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1314: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1315: );
1316:
1317: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1527: l_role := PV_USER_RESP_PVT.G_PRIMARY;

1523: raise FND_API.G_EXC_ERROR;
1524: END IF;
1525:
1526: IF(is_primary_perm_assigned OR is_primary_user) THEN
1527: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1528: else
1529: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1530: end if;
1531:

Line 1529: l_role := PV_USER_RESP_PVT.G_BUSINESS;

1525:
1526: IF(is_primary_perm_assigned OR is_primary_user) THEN
1527: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1528: else
1529: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1530: end if;
1531:
1532: PV_USER_RESP_PVT.assign_user_resps(
1533: p_api_version_number => p_api_version_number

Line 1532: PV_USER_RESP_PVT.assign_user_resps(

1528: else
1529: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1530: end if;
1531:
1532: PV_USER_RESP_PVT.assign_user_resps(
1533: p_api_version_number => p_api_version_number
1534: ,p_init_msg_list => FND_API.g_false
1535: ,p_commit => FND_API.G_FALSE
1536: ,x_return_status => x_return_status

Line 1551: PV_USER_RESP_PVT.switch_user_resp(

1547: END IF;
1548:
1549: ELSIF (is_partner_user and (NOT is_primary_user) and is_primary_perm_assigned) THEN
1550:
1551: PV_USER_RESP_PVT.switch_user_resp(
1552: p_api_version_number => p_api_version_number
1553: ,p_init_msg_list => FND_API.g_false
1554: ,p_commit => FND_API.G_FALSE
1555: ,x_return_status => x_return_status

Line 1559: ,p_from_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

1555: ,x_return_status => x_return_status
1556: ,x_msg_count => x_msg_count
1557: ,x_msg_data => x_msg_data
1558: ,p_user_id => l_user_id
1559: ,p_from_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1560: ,p_to_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1561: );
1562:
1563: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1560: ,p_to_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

1556: ,x_msg_count => x_msg_count
1557: ,x_msg_data => x_msg_data
1558: ,p_user_id => l_user_id
1559: ,p_from_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1560: ,p_to_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1561: );
1562:
1563: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1827: l_role := PV_USER_RESP_PVT.G_PRIMARY;

1823: FOR X in 1..l_user_names.count loop
1824: IF (is_prtnr_perm_assigned or is_primary_perm_assigned) THEN
1825: IF ((l_user_perm_changed(X) is null or l_user_perm_changed(X) = 'PR') and is_prtnr_perm_assigned) THEN
1826: IF(is_primary_perm_assigned OR l_user_perm_changed(X) = 'PR' or (l_primary_perm_exists and NOT is_primary_perm_revoked)) THEN
1827: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1828: else
1829: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1830: end if;
1831:

Line 1829: l_role := PV_USER_RESP_PVT.G_BUSINESS;

1825: IF ((l_user_perm_changed(X) is null or l_user_perm_changed(X) = 'PR') and is_prtnr_perm_assigned) THEN
1826: IF(is_primary_perm_assigned OR l_user_perm_changed(X) = 'PR' or (l_primary_perm_exists and NOT is_primary_perm_revoked)) THEN
1827: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1828: else
1829: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1830: end if;
1831:
1832: PV_USER_RESP_PVT.assign_user_resps(
1833: p_api_version_number => p_api_version_number

Line 1832: PV_USER_RESP_PVT.assign_user_resps(

1828: else
1829: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1830: end if;
1831:
1832: PV_USER_RESP_PVT.assign_user_resps(
1833: p_api_version_number => p_api_version_number
1834: ,p_init_msg_list => FND_API.g_false
1835: ,p_commit => FND_API.G_FALSE
1836: ,x_return_status => x_return_status

Line 1852: PV_USER_RESP_PVT.switch_user_resp(

1848: ELSIF ((l_user_perm_changed(X) = 'PT'
1849: or (l_prtnr_perm_exists and NOT is_prtnr_perm_revoked))
1850: and is_primary_perm_assigned) THEN
1851:
1852: PV_USER_RESP_PVT.switch_user_resp(
1853: p_api_version_number => p_api_version_number
1854: ,p_init_msg_list => FND_API.g_false
1855: ,p_commit => FND_API.G_FALSE
1856: ,x_return_status => x_return_status

Line 1860: ,p_from_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

1856: ,x_return_status => x_return_status
1857: ,x_msg_count => x_msg_count
1858: ,x_msg_data => x_msg_data
1859: ,p_user_id => l_user_ids(X)
1860: ,p_from_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1861: ,p_to_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1862: );
1863:
1864: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1861: ,p_to_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

1857: ,x_msg_count => x_msg_count
1858: ,x_msg_data => x_msg_data
1859: ,p_user_id => l_user_ids(X)
1860: ,p_from_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1861: ,p_to_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1862: );
1863:
1864: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1876: l_role := PV_USER_RESP_PVT.G_PRIMARY;

1872: IF (is_prtnr_perm_revoked or is_primary_perm_revoked) THEN
1873: /** If G_PARTNER_PERMISSION permission is revoked and user will become non partner user after the role is revoked **/
1874: If((l_user_perm_changed(X) = 'PR' or l_user_perm_changed(X) is null) and is_prtnr_perm_revoked) THEN
1875: IF(l_primary_perm_exists or l_user_perm_changed(X) = 'PR') THEN
1876: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1877: else
1878: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1879: end if;
1880:

Line 1878: l_role := PV_USER_RESP_PVT.G_BUSINESS;

1874: If((l_user_perm_changed(X) = 'PR' or l_user_perm_changed(X) is null) and is_prtnr_perm_revoked) THEN
1875: IF(l_primary_perm_exists or l_user_perm_changed(X) = 'PR') THEN
1876: l_role := PV_USER_RESP_PVT.G_PRIMARY;
1877: else
1878: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1879: end if;
1880:
1881: PV_USER_RESP_PVT.revoke_user_resps(
1882: p_api_version_number => p_api_version_number

Line 1881: PV_USER_RESP_PVT.revoke_user_resps(

1877: else
1878: l_role := PV_USER_RESP_PVT.G_BUSINESS;
1879: end if;
1880:
1881: PV_USER_RESP_PVT.revoke_user_resps(
1882: p_api_version_number => p_api_version_number
1883: ,p_init_msg_list => FND_API.g_false
1884: ,p_commit => FND_API.G_FALSE
1885: ,x_return_status => x_return_status

Line 1902: PV_USER_RESP_PVT.switch_user_resp(

1898: /** If partner user and primary user permission is revoked and user will become business user after this **/
1899: elsif ((l_user_perm_changed(X) = 'PT' or (l_user_perm_changed(X) is null and l_prtnr_perm_exists)) and is_primary_perm_revoked) THEN
1900:
1901:
1902: PV_USER_RESP_PVT.switch_user_resp(
1903: p_api_version_number => p_api_version_number
1904: ,p_init_msg_list => FND_API.g_false
1905: ,p_commit => FND_API.G_FALSE
1906: ,x_return_status => x_return_status

Line 1910: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

1906: ,x_return_status => x_return_status
1907: ,x_msg_count => x_msg_count
1908: ,x_msg_data => x_msg_data
1909: ,p_user_id => l_user_ids(X)
1910: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1911: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1912: );
1913:
1914: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1911: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

1907: ,x_msg_count => x_msg_count
1908: ,x_msg_data => x_msg_data
1909: ,p_user_id => l_user_ids(X)
1910: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY
1911: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS
1912: );
1913:
1914: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;