DBA Data[Home] [Help]

APPS.PSB_WORKSHEET dependencies on PSB_CONCURRENCY_CONTROL_PVT

Line 770: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

766: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
767: raise FND_API.G_EXC_ERROR;
768: end if;
769:
770: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
771: (p_api_version => 1.0 ,
772: p_return_status => l_return_status,
773: p_concurrency_class => 'WORKSHEET_CREATION',
774: p_concurrency_entity_name => 'WORKSHEET',

Line 964: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

960: end if;
961:
962: commit work;
963:
964: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
965: (p_api_version => 1.0 ,
966: p_return_status => l_return_status,
967: p_concurrency_class => 'WORKSHEET_CREATION',
968: p_concurrency_entity_name => 'WORKSHEET',

Line 993: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

989:
990: when FND_API.G_EXC_ERROR then
991: p_return_status := FND_API.G_RET_STS_ERROR;
992:
993: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
994: (p_api_version => 1.0 ,
995: p_return_status => l_return_status,
996: p_concurrency_class => 'WORKSHEET_CREATION',
997: p_concurrency_entity_name => 'WORKSHEET',

Line 1003: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

999:
1000: when FND_API.G_EXC_UNEXPECTED_ERROR then
1001: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1002:
1003: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1004: (p_api_version => 1.0 ,
1005: p_return_status => l_return_status,
1006: p_concurrency_class => 'WORKSHEET_CREATION',
1007: p_concurrency_entity_name => 'WORKSHEET',

Line 1013: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1009:
1010: when OTHERS then
1011: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012:
1013: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1014: (p_api_version => 1.0 ,
1015: p_return_status => l_return_status,
1016: p_concurrency_class => 'WORKSHEET_CREATION',
1017: p_concurrency_entity_name => 'WORKSHEET',

Line 1598: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

1594: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1595: raise FND_API.G_EXC_ERROR;
1596: end if;
1597:
1598: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
1599: (p_api_version => 1.0 ,
1600: p_return_status => l_return_status,
1601: p_concurrency_class => 'WORKSHEET_CREATION',
1602: p_concurrency_entity_name => 'WORKSHEET',

Line 1684: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1680:
1681: end;
1682: end if;
1683:
1684: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1685: (p_api_version => 1.0 ,
1686: p_return_status => l_return_status,
1687: p_concurrency_class => 'WORKSHEET_CREATION',
1688: p_concurrency_entity_name => 'WORKSHEET',

Line 1706: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1702:
1703: when FND_API.G_EXC_ERROR then
1704: p_return_status := FND_API.G_RET_STS_ERROR;
1705:
1706: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1707: (p_api_version => 1.0 ,
1708: p_return_status => l_return_status,
1709: p_concurrency_class => 'WORKSHEET_CREATION',
1710: p_concurrency_entity_name => 'WORKSHEET',

Line 1716: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1712:
1713: when FND_API.G_EXC_UNEXPECTED_ERROR then
1714: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1715:
1716: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1717: (p_api_version => 1.0 ,
1718: p_return_status => l_return_status,
1719: p_concurrency_class => 'WORKSHEET_CREATION',
1720: p_concurrency_entity_name => 'WORKSHEET',

Line 1726: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1722:
1723: when OTHERS then
1724: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725:
1726: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1727: (p_api_version => 1.0 ,
1728: p_return_status => l_return_status,
1729: p_concurrency_class => 'WORKSHEET_CREATION',
1730: p_concurrency_entity_name => 'WORKSHEET',

Line 1818: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

1814:
1815: if g_sp2_status = 'I' then
1816: begin
1817:
1818: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
1819: (p_api_version => 1.0 ,
1820: p_return_status => l_return_status,
1821: p_concurrency_class => 'WORKSHEET_CREATION',
1822: p_concurrency_entity_name => 'WORKSHEET',

Line 1856: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1852: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1853: raise FND_API.G_EXC_ERROR;
1854: end if;
1855:
1856: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1857: (p_api_version => 1.0 ,
1858: p_return_status => l_return_status,
1859: p_concurrency_class => 'WORKSHEET_CREATION',
1860: p_concurrency_entity_name => 'WORKSHEET',

Line 1891: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1887:
1888: when FND_API.G_EXC_ERROR then
1889: p_return_status := FND_API.G_RET_STS_ERROR;
1890:
1891: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1892: (p_api_version => 1.0 ,
1893: p_return_status => l_return_status,
1894: p_concurrency_class => 'WORKSHEET_CREATION',
1895: p_concurrency_entity_name => 'WORKSHEET',

Line 1901: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1897:
1898: when FND_API.G_EXC_UNEXPECTED_ERROR then
1899: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1900:
1901: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1902: (p_api_version => 1.0 ,
1903: p_return_status => l_return_status,
1904: p_concurrency_class => 'WORKSHEET_CREATION',
1905: p_concurrency_entity_name => 'WORKSHEET',

Line 1911: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1907:
1908: when OTHERS then
1909: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1910:
1911: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1912: (p_api_version => 1.0 ,
1913: p_return_status => l_return_status,
1914: p_concurrency_class => 'WORKSHEET_CREATION',
1915: p_concurrency_entity_name => 'WORKSHEET',

Line 2051: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

2047: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2048: raise FND_API.G_EXC_ERROR;
2049: end if;
2050:
2051: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
2052: (p_api_version => 1.0 ,
2053: p_return_status => l_return_status,
2054: p_concurrency_class => 'WORKSHEET_CREATION',
2055: p_concurrency_entity_name => 'WORKSHEET',

Line 2079: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2075: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2076: raise FND_API.G_EXC_ERROR;
2077: end if;
2078:
2079: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2080: (p_api_version => 1.0 ,
2081: p_return_status => l_return_status,
2082: p_concurrency_class => 'WORKSHEET_CREATION',
2083: p_concurrency_entity_name => 'WORKSHEET',

Line 2104: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2100:
2101: when FND_API.G_EXC_ERROR then
2102: p_return_status := FND_API.G_RET_STS_ERROR;
2103:
2104: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2105: (p_api_version => 1.0 ,
2106: p_return_status => l_return_status,
2107: p_concurrency_class => 'WORKSHEET_CREATION',
2108: p_concurrency_entity_name => 'WORKSHEET',

Line 2114: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2110:
2111: when FND_API.G_EXC_UNEXPECTED_ERROR then
2112: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2113:
2114: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2115: (p_api_version => 1.0 ,
2116: p_return_status => l_return_status,
2117: p_concurrency_class => 'WORKSHEET_CREATION',
2118: p_concurrency_entity_name => 'WORKSHEET',

Line 2124: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2120:
2121: when OTHERS then
2122: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2123:
2124: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2125: (p_api_version => 1.0 ,
2126: p_return_status => l_return_status,
2127: p_concurrency_class => 'WORKSHEET_CREATION',
2128: p_concurrency_entity_name => 'WORKSHEET',

Line 2264: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

2260: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2261: raise FND_API.G_EXC_ERROR;
2262: end if;
2263:
2264: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
2265: (p_api_version => 1.0 ,
2266: p_return_status => l_return_status,
2267: p_concurrency_class => 'WORKSHEET_CREATION',
2268: p_concurrency_entity_name => 'WORKSHEET',

Line 2291: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2287: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2288: raise FND_API.G_EXC_ERROR;
2289: end if;
2290:
2291: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2292: (p_api_version => 1.0 ,
2293: p_return_status => l_return_status,
2294: p_concurrency_class => 'WORKSHEET_CREATION',
2295: p_concurrency_entity_name => 'WORKSHEET',

Line 2319: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2315:
2316: when FND_API.G_EXC_ERROR then
2317: p_return_status := FND_API.G_RET_STS_ERROR;
2318:
2319: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2320: (p_api_version => 1.0 ,
2321: p_return_status => l_return_status,
2322: p_concurrency_class => 'WORKSHEET_CREATION',
2323: p_concurrency_entity_name => 'WORKSHEET',

Line 2329: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2325:
2326: when FND_API.G_EXC_UNEXPECTED_ERROR then
2327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2328:
2329: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2330: (p_api_version => 1.0 ,
2331: p_return_status => l_return_status,
2332: p_concurrency_class => 'WORKSHEET_CREATION',
2333: p_concurrency_entity_name => 'WORKSHEET',

Line 2339: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2335:
2336: when OTHERS then
2337: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2338:
2339: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2340: (p_api_version => 1.0 ,
2341: p_return_status => l_return_status,
2342: p_concurrency_class => 'WORKSHEET_CREATION',
2343: p_concurrency_entity_name => 'WORKSHEET',

Line 2478: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

2474: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2475: raise FND_API.G_EXC_ERROR;
2476: end if;
2477:
2478: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
2479: (p_api_version => 1.0 ,
2480: p_return_status => l_return_status,
2481: p_concurrency_class => 'WORKSHEET_CREATION',
2482: p_concurrency_entity_name => 'WORKSHEET',

Line 2502: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2498: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2499: raise FND_API.G_EXC_ERROR;
2500: end if;
2501:
2502: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2503: (p_api_version => 1.0 ,
2504: p_return_status => l_return_status,
2505: p_concurrency_class => 'WORKSHEET_CREATION',
2506: p_concurrency_entity_name => 'WORKSHEET',

Line 2527: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2523:
2524: when FND_API.G_EXC_ERROR then
2525: p_return_status := FND_API.G_RET_STS_ERROR;
2526:
2527: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2528: (p_api_version => 1.0 ,
2529: p_return_status => l_return_status,
2530: p_concurrency_class => 'WORKSHEET_CREATION',
2531: p_concurrency_entity_name => 'WORKSHEET',

Line 2537: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2533:
2534: when FND_API.G_EXC_UNEXPECTED_ERROR then
2535: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2536:
2537: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2538: (p_api_version => 1.0 ,
2539: p_return_status => l_return_status,
2540: p_concurrency_class => 'WORKSHEET_CREATION',
2541: p_concurrency_entity_name => 'WORKSHEET',

Line 2547: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2543:
2544: when OTHERS then
2545: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2546:
2547: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2548: (p_api_version => 1.0 ,
2549: p_return_status => l_return_status,
2550: p_concurrency_class => 'WORKSHEET_CREATION',
2551: p_concurrency_entity_name => 'WORKSHEET',