1: Package Body pqh_position_transactions_api as
2: /* $Header: pqptxapi.pkb 120.1 2011/11/17 12:01:19 sidsaxen ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pqptxapi.pkb 120.1 2011/11/17 12:01:19 sidsaxen ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_position_transactions_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_position_transaction >----------------------|
10: -- ----------------------------------------------------------------------------
157: ) is
158: --
159: -- Declare cursors and local variables
160: --
161: l_position_transaction_id pqh_position_transactions.position_transaction_id%TYPE;
162: l_proc varchar2(72) := g_package||'create_position_transaction';
163: l_object_version_number pqh_position_transactions.object_version_number%TYPE;
164: --
165: begin
159: -- Declare cursors and local variables
160: --
161: l_position_transaction_id pqh_position_transactions.position_transaction_id%TYPE;
162: l_proc varchar2(72) := g_package||'create_position_transaction';
163: l_object_version_number pqh_position_transactions.object_version_number%TYPE;
164: --
165: begin
166: --
167: hr_utility.set_location('Entering:'|| l_proc, 10);
177: begin
178: --
179: -- Start of API User Hook for the before hook of create_position_transaction
180: --
181: pqh_position_transactions_bk1.create_position_transaction_b
182: (
183: p_action_date => p_action_date
184: ,p_position_id => p_position_id
185: ,p_availability_status_id => p_availability_status_id
484: begin
485: --
486: -- Start of API User Hook for the after hook of create_position_transaction
487: --
488: pqh_position_transactions_bk1.create_position_transaction_a
489: (
490: p_position_transaction_id => l_position_transaction_id
491: ,p_action_date => p_action_date
492: ,p_position_id => p_position_id
837: --
838: -- Declare cursors and local variables
839: --
840: l_proc varchar2(72) := g_package||'update_position_transaction';
841: l_object_version_number pqh_position_transactions.object_version_number%TYPE;
842: --
843: begin
844: --
845: hr_utility.set_location('Entering:'|| l_proc, 10);
857: begin
858: --
859: -- Start of API User Hook for the before hook of update_position_transaction
860: --
861: pqh_position_transactions_bk2.update_position_transaction_b
862: (
863: p_position_transaction_id => p_position_transaction_id
864: ,p_action_date => p_action_date
865: ,p_position_id => p_position_id
1165: begin
1166: --
1167: -- Start of API User Hook for the after hook of update_position_transaction
1168: --
1169: pqh_position_transactions_bk2.update_position_transaction_a
1170: (
1171: p_position_transaction_id => p_position_transaction_id
1172: ,p_action_date => p_action_date
1173: ,p_position_id => p_position_id
1374: --
1375: -- Declare cursors and local variables
1376: --
1377: l_proc varchar2(72) := g_package||'delete_position_transaction';
1378: l_object_version_number pqh_position_transactions.object_version_number%TYPE;
1379: --
1380: begin
1381: --
1382: hr_utility.set_location('Entering:'|| l_proc, 10);
1395: begin
1396: --
1397: -- Start of API User Hook for the before hook of delete_position_transaction
1398: --
1399: pqh_position_transactions_bk3.delete_position_transaction_b
1400: (
1401: p_position_transaction_id => p_position_transaction_id
1402: ,p_object_version_number => p_object_version_number
1403: ,p_effective_date => trunc(p_effective_date)
1423: begin
1424: --
1425: -- Start of API User Hook for the after hook of delete_position_transaction
1426: --
1427: pqh_position_transactions_bk3.delete_position_transaction_a
1428: (
1429: p_position_transaction_id => p_position_transaction_id
1430: ,p_object_version_number => l_object_version_number
1431: ,p_effective_date => trunc(p_effective_date)
1502: hr_utility.set_location(' Leaving:'||l_proc, 70);
1503: --
1504: end lck;
1505: --
1506: end pqh_position_transactions_api;