eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TXN_JOB_REQUIREMENTS_API dependencies on PQH_TXN_JOB_REQUIREMENTS

Line 1: Package Body PQH_TXN_JOB_REQUIREMENTS_API as

1: Package Body PQH_TXN_JOB_REQUIREMENTS_API as
2: /* $Header: pqtjrapi.pkb 115.2 2002/12/06 23:49:05 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqtjrapi.pkb 115.2 2002/12/06 23:49:05 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PQH_TXN_JOB_REQUIREMENTS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------< CREATE_TXN_JOB_REQUIREMENT >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 57: l_txn_job_requirement_id PQH_TXN_JOB_REQUIREMENTS.TXN_JOB_REQUIREMENT_ID%TYPE;

53: -- Declare cursors and local variables
54: --
55:
56: l_proc varchar2(72) := g_package||'CREATE_TXN_JOB_REQUIREMENT';
57: l_txn_job_requirement_id PQH_TXN_JOB_REQUIREMENTS.TXN_JOB_REQUIREMENT_ID%TYPE;
58: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61: --

Line 58: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;

54: --
55:
56: l_proc varchar2(72) := g_package||'CREATE_TXN_JOB_REQUIREMENT';
57: l_txn_job_requirement_id PQH_TXN_JOB_REQUIREMENTS.TXN_JOB_REQUIREMENT_ID%TYPE;
58: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61: --
62: -- Issue a savepoint

Line 73: PQH_TXN_JOB_REQUIREMENTS_BK1.CREATE_TXN_JOB_REQUIREMENT_b

69: --
70: -- Call Before Process User Hook
71: --
72: begin
73: PQH_TXN_JOB_REQUIREMENTS_BK1.CREATE_TXN_JOB_REQUIREMENT_b
74: (p_effective_date => p_effective_date
75: ,p_business_group_id => p_business_group_id
76: ,p_analysis_criteria_id => p_analysis_criteria_id
77: ,p_position_transaction_id => p_position_transaction_id

Line 170: PQH_TXN_JOB_REQUIREMENTS_BK1.CREATE_TXN_JOB_REQUIREMENT_a

166: --
167: -- Call After Process User Hook
168: --
169: begin
170: PQH_TXN_JOB_REQUIREMENTS_BK1.CREATE_TXN_JOB_REQUIREMENT_a
171: (p_effective_date => p_effective_date
172: ,p_txn_job_requirement_id => l_txn_job_requirement_id
173: ,p_object_version_number => l_object_version_number
174: ,p_business_group_id => p_business_group_id

Line 304: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;

300: -- Declare cursors and local variables
301: --
302:
303: l_proc varchar2(72) := g_package||'UPDATE_TXN_JOB_REQUIREMENT';
304: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
305: begin
306: hr_utility.set_location('Entering:'|| l_proc, 10);
307: --
308: -- Issue a savepoint

Line 319: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_b

315: --
316: -- Call Before Process User Hook
317: --
318: begin
319: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_b
320: (p_effective_date => p_effective_date
321: ,p_business_group_id => p_business_group_id
322: ,p_analysis_criteria_id => p_analysis_criteria_id
323: ,p_position_transaction_id => p_position_transaction_id

Line 418: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_a

414: --
415: -- Call After Process User Hook
416: --
417: begin
418: PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_a
419: (p_effective_date => p_effective_date
420: ,p_txn_job_requirement_id => p_txn_job_requirement_id
421: ,p_object_version_number => l_object_version_number
422: ,p_business_group_id => p_business_group_id

Line 515: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;

511: -- Declare cursors and local variables
512: --
513:
514: l_proc varchar2(72) := g_package||'DELETE_TXN_JOB_REQUIREMENT';
515: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
516: begin
517: hr_utility.set_location('Entering:'|| l_proc, 10);
518: --
519: -- Issue a savepoint

Line 530: PQH_TXN_JOB_REQUIREMENTS_BK3.DELETE_TXN_JOB_REQUIREMENT_b

526: --
527: -- Call Before Process User Hook
528: --
529: begin
530: PQH_TXN_JOB_REQUIREMENTS_BK3.DELETE_TXN_JOB_REQUIREMENT_b
531: (p_effective_date => p_effective_date
532: ,p_txn_job_requirement_id => p_txn_job_requirement_id
533: ,p_object_version_number => l_object_version_number
534: );

Line 561: PQH_TXN_JOB_REQUIREMENTS_BK3.DELETE_TXN_JOB_REQUIREMENT_a

557: --
558: -- Call After Process User Hook
559: --
560: begin
561: PQH_TXN_JOB_REQUIREMENTS_BK3.DELETE_TXN_JOB_REQUIREMENT_a
562: (p_effective_date => p_effective_date
563: ,p_txn_job_requirement_id => p_txn_job_requirement_id
564: ,p_object_version_number => l_object_version_number
565: );

Line 606: end PQH_TXN_JOB_REQUIREMENTS_API;

602: hr_utility.set_location(' Leaving:'||l_proc, 90);
603: raise;
604: end DELETE_TXN_JOB_REQUIREMENT;
605: --
606: end PQH_TXN_JOB_REQUIREMENTS_API;