DBA Data[Home] [Help]

APPS.PQH_POSITION_TRANSACTIONS_API dependencies on PQH_POSITION_TRANSACTIONS

Line 1: Package Body pqh_position_transactions_api as

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: --

Line 6: g_package varchar2(33) := ' pqh_position_transactions_api.';

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: -- ----------------------------------------------------------------------------

Line 161: l_position_transaction_id pqh_position_transactions.position_transaction_id%TYPE;

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

Line 163: l_object_version_number pqh_position_transactions.object_version_number%TYPE;

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);

Line 181: pqh_position_transactions_bk1.create_position_transaction_b

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

Line 488: pqh_position_transactions_bk1.create_position_transaction_a

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

Line 841: l_object_version_number pqh_position_transactions.object_version_number%TYPE;

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);

Line 861: pqh_position_transactions_bk2.update_position_transaction_b

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

Line 1169: pqh_position_transactions_bk2.update_position_transaction_a

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

Line 1378: l_object_version_number pqh_position_transactions.object_version_number%TYPE;

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);

Line 1399: pqh_position_transactions_bk3.delete_position_transaction_b

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)

Line 1427: pqh_position_transactions_bk3.delete_position_transaction_a

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)

Line 1506: end pqh_position_transactions_api;

1502: hr_utility.set_location(' Leaving:'||l_proc, 70);
1503: --
1504: end lck;
1505: --
1506: end pqh_position_transactions_api;