DBA Data[Home] [Help]

APPS.PV_USER_MGMT_PVT dependencies on PV_USER_RESP_PVT

Line 791: l_role := pv_user_Resp_pvt.G_PRIMARY;

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

Line 793: l_role := pv_user_Resp_pvt.G_BUSINESS;

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

Line 796: pv_user_Resp_pvt.assign_user_resps(

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

Line 1008: l_role := PV_USER_RESP_PVT.G_PRIMARY;

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

Line 1010: l_role := PV_USER_RESP_PVT.G_BUSINESS;

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

Line 1013: PV_USER_RESP_PVT.revoke_user_resps(

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

Line 1032: PV_USER_RESP_PVT.switch_user_resp(

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

Line 1040: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

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

Line 1041: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

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

Line 1285: l_role := PV_USER_RESP_PVT.G_PRIMARY;

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

Line 1287: l_role := PV_USER_RESP_PVT.G_BUSINESS;

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

Line 1290: PV_USER_RESP_PVT.revoke_user_resps(

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

Line 1307: PV_USER_RESP_PVT.switch_user_resp(

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

Line 1315: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

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

Line 1316: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

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

Line 1529: l_role := PV_USER_RESP_PVT.G_PRIMARY;

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

Line 1531: l_role := PV_USER_RESP_PVT.G_BUSINESS;

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

Line 1534: PV_USER_RESP_PVT.assign_user_resps(

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

Line 1553: PV_USER_RESP_PVT.switch_user_resp(

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

Line 1561: ,p_from_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

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

Line 1562: ,p_to_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

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

Line 1829: l_role := PV_USER_RESP_PVT.G_PRIMARY;

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

Line 1831: l_role := PV_USER_RESP_PVT.G_BUSINESS;

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

Line 1834: PV_USER_RESP_PVT.assign_user_resps(

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

Line 1854: PV_USER_RESP_PVT.switch_user_resp(

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

Line 1862: ,p_from_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

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

Line 1863: ,p_to_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

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

Line 1878: l_role := PV_USER_RESP_PVT.G_PRIMARY;

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

Line 1880: l_role := PV_USER_RESP_PVT.G_BUSINESS;

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

Line 1883: PV_USER_RESP_PVT.revoke_user_resps(

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

Line 1904: PV_USER_RESP_PVT.switch_user_resp(

1900: /** If partner user and primary user permission is revoked and user will become business user after this **/
1901: 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
1902:
1903:
1904: PV_USER_RESP_PVT.switch_user_resp(
1905: p_api_version_number => p_api_version_number
1906: ,p_init_msg_list => FND_API.g_false
1907: ,p_commit => FND_API.G_FALSE
1908: ,x_return_status => x_return_status

Line 1912: ,p_from_user_role_code => PV_USER_RESP_PVT.G_PRIMARY

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

Line 1913: ,p_to_user_role_code => PV_USER_RESP_PVT.G_BUSINESS

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