4: /* ----------------------------------------------------------------------- */
5:
6: -- API name : Enforce_Concurrency_Control
7: -- Type : Public
8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_CONCURRENCY_CONTROL_PVT
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER Required
11: -- p_validation_level IN NUMBER Optional
12: -- Default = FND_API.G_VALID_LEVEL_NONE
8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_CONCURRENCY_CONTROL_PVT
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER Required
11: -- p_validation_level IN NUMBER Optional
12: -- Default = FND_API.G_VALID_LEVEL_NONE
13: -- p_concurrency_class IN VARCHAR2 Optional
14: -- Default = 'MAINTENANCE'
15: -- p_concurrency_entity_name IN VARCHAR2 Required
16: -- p_concurrency_entity_id IN NUMBER Required
34: -- Define Budget Calendar, Define Data Extract, Elements, View Elements,
35: -- Position Assignments and Position Pay Distributions. Concurrency Control
36: -- must be enforced from these Modules during changes (Inserts, Updates and Deletes).
37: -- Check the Return Status from the Procedure Call;
38: -- if p_return_status = FND_API.G_RET_STS_SUCCESS, allow modifications to the Modules;
39: -- otherwise raise an Exception and disallow modifications.
40: --
41: -- Parameter Values :
42: --
60: -- View Elements, Position Assignments and Position Pay Distributions.
61: --
62: -- Return Status :
63: --
64: -- p_return_status is set to FND_API.G_RET_STS_SUCCESS if Concurrency Control is
65: -- successfully enforced. p_msg_count containts the Message Count and p_msg_data
66: -- contains the Message Data if there's exactly 1 Message on the Stack.
67: --
68: --
78:
79:
80: PROCEDURE Enforce_Concurrency_Control
81: ( p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
84: p_return_status OUT NOCOPY VARCHAR2,
85: p_msg_count OUT NOCOPY NUMBER,
86: p_msg_data OUT NOCOPY VARCHAR2,
79:
80: PROCEDURE Enforce_Concurrency_Control
81: ( p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
84: p_return_status OUT NOCOPY VARCHAR2,
85: p_msg_count OUT NOCOPY NUMBER,
86: p_msg_data OUT NOCOPY VARCHAR2,
87: p_concurrency_class IN VARCHAR2 := 'MAINTENANCE',
90: );
91:
92: PROCEDURE Release_Concurrency_Control
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
96: p_return_status OUT NOCOPY VARCHAR2,
97: p_msg_count OUT NOCOPY NUMBER,
98: p_msg_data OUT NOCOPY VARCHAR2,
91:
92: PROCEDURE Release_Concurrency_Control
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
96: p_return_status OUT NOCOPY VARCHAR2,
97: p_msg_count OUT NOCOPY NUMBER,
98: p_msg_data OUT NOCOPY VARCHAR2,
99: p_concurrency_class IN VARCHAR2 := 'MAINTENANCE',