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_CORPS_EXTRA_INFO_API dependencies on PQH_CORPS_EXTRA_INFO

Line 1: Package body pqh_corps_extra_info_api as

1: Package body pqh_corps_extra_info_api as
2: /* $Header: pqceiapi.pkb 115.8 2004/01/02 01:35:54 svorugan noship $ */
3: g_package varchar2(33) := 'pqh_corps_extra_info_api.';
4: ------------------------------------------------------------------------------
5: -- |------------------------< validate_corps_org_info >------------------------|

Line 3: g_package varchar2(33) := 'pqh_corps_extra_info_api.';

1: Package body pqh_corps_extra_info_api as
2: /* $Header: pqceiapi.pkb 115.8 2004/01/02 01:35:54 svorugan noship $ */
3: g_package varchar2(33) := 'pqh_corps_extra_info_api.';
4: ------------------------------------------------------------------------------
5: -- |------------------------< validate_corps_org_info >------------------------|
6: -- ----------------------------------------------------------------------------
7: PROCEDURE validate_corps_org_info(p_effective_date IN DATE

Line 23: FROM pqh_corps_extra_info

19: CURSOR csr_dup_org_chk IS
20: SELECT 'Y'
21: FROM DUAL
22: WHERE EXISTS (SELECT 1
23: FROM pqh_corps_extra_info
24: WHERE corps_definition_id = p_corps_definition_id
25: AND information_type = 'ORGANIZATION'
26: AND information3 = p_organization_id
27: AND (p_corps_extra_info_id IS NULL OR

Line 70: FROM pqh_corps_extra_info

66: CURSOR csr_dup_prof_field_chk IS
67: SELECT 'Y'
68: FROM dual
69: WHERE EXISTS (SELECT 1
70: FROM pqh_corps_extra_info
71: WHERE corps_definition_id = p_corps_definition_id
72: AND information_type = 'FILERE'
73: AND information3 = p_field_of_prof_activity_id
74: AND (p_corps_extra_info_id IS NULL OR corps_extra_info_id <> p_corps_extra_info_id));

Line 119: FROM pqh_corps_extra_info

115: CURSOR csr_chk_dup_exam IS
116: SELECT 'Y'
117: FROM dual
118: WHERE EXISTS (SELECT 1
119: FROM pqh_corps_extra_info
120: WHERE information_type = 'EXAM'
121: AND corps_definition_id = p_corps_definition_id
122: AND nvl(information3,'#@') = nvl(p_examination_type_cd,'#@')
123: AND nvl(information4,'#@') = nvl(p_institution_id,'#@')

Line 194: FROM pqh_corps_extra_info

190: CURSOR csr_dup_train_dtls IS
191: SELECT 'Y'
192: FROM dual
193: WHERE EXISTS (SELECT 1
194: FROM pqh_corps_extra_info
195: WHERE corps_definition_id = p_corps_definition_id
196: AND information_type = 'TRAINING'
197: AND nvl(information3,'#@') = nvl(p_qualification_id,'#@')
198: AND nvl(information4,'#@') = nvl(p_institution_id,'#@')

Line 271: pqh_corps_extra_info cei

267: SELECT 'Y'
268: FROM dual
269: WHERE EXISTS (SELECT 1
270: FROM pqh_corps_definitions cpd,
271: pqh_corps_extra_info cei
272: WHERE cei.information_type = 'FILERE'
273: AND cei.corps_definition_id = cpd.corps_definition_id
274: AND fnd_number.canonical_to_number(nvl(cei.information4,'-1')) = nvl(primary_prof_field_id,-1)
275: AND corps_extra_info_id = p_corps_extra_info_id);

Line 458: l_corps_extra_info_id pqh_corps_extra_info.corps_extra_info_id%TYPE;

454: ) is
455: --
456: -- Declare cursors and local variables
457: --
458: l_corps_extra_info_id pqh_corps_extra_info.corps_extra_info_id%TYPE;
459: l_proc varchar2(72) := g_package||'create_corps_extra_info';
460: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;
461: --
462: begin

Line 460: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;

456: -- Declare cursors and local variables
457: --
458: l_corps_extra_info_id pqh_corps_extra_info.corps_extra_info_id%TYPE;
459: l_proc varchar2(72) := g_package||'create_corps_extra_info';
460: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;
461: --
462: begin
463: --
464: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 477: pqh_corps_extra_info_bk1.create_corps_extra_info_b

473: --
474: begin
475: --
476: -- Start of API User Hook for the before hook of create_corps_extra_info
477: pqh_corps_extra_info_bk1.create_corps_extra_info_b
478: (
479: p_effective_date => trunc(p_effective_date)
480: ,p_corps_definition_id => p_corps_definition_id
481: ,p_information_type => p_information_type

Line 662: pqh_corps_extra_info_bk1.create_corps_extra_info_a

658:
659: begin
660: --
661: -- Start of API User Hook for the afetr hook of create_corps_extra_info
662: pqh_corps_extra_info_bk1.create_corps_extra_info_a
663: (
664: p_effective_date => trunc(p_effective_date)
665: ,p_corps_definition_id => p_corps_definition_id
666: ,p_information_type => p_information_type

Line 954: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;

950: --
951: -- Declare cursors and local variables
952: --
953: l_proc varchar2(72) := g_package||'update_corps_extra_info';
954: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;
955: --
956: begin
957: --
958: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 972: pqh_corps_extra_info_bk2.update_corps_extra_info_b

968: --
969: begin
970: --
971: -- Start of API User Hook for the before hook of update_corps_extra_info
972: pqh_corps_extra_info_bk2.update_corps_extra_info_b
973: (
974: p_effective_date => trunc(p_effective_date)
975: ,p_corps_extra_info_id => p_corps_extra_info_id
976: ,p_corps_definition_id => p_corps_definition_id

Line 1163: pqh_corps_extra_info_bk2.update_corps_extra_info_a

1159:
1160: begin
1161: --
1162: -- Start of API User Hook for the afetr hook of update_corps_extra_info
1163: pqh_corps_extra_info_bk2.update_corps_extra_info_a
1164: (
1165: p_effective_date => trunc(p_effective_date)
1166: ,p_corps_extra_info_id => p_corps_extra_info_id
1167: ,p_corps_definition_id => p_corps_definition_id

Line 1324: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;

1320: --
1321: -- Declare cursors and local variables
1322: --
1323: l_proc varchar2(72) := g_package||'delete_corps_extra_info';
1324: l_object_version_number pqh_corps_extra_info.object_version_number%TYPE;
1325: --
1326: begin
1327: --
1328: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1345: pqh_corps_extra_info_bk3.delete_corps_extra_info_b

1341: begin
1342: --
1343: -- Start of API User Hook for the before hook of delete_corps_extra_info
1344: --
1345: pqh_corps_extra_info_bk3.delete_corps_extra_info_b
1346: (
1347: p_corps_extra_info_id => p_corps_extra_info_id
1348: ,p_object_version_number => p_object_version_number
1349: );

Line 1377: pqh_corps_extra_info_bk3.delete_corps_extra_info_a

1373: begin
1374: --
1375: -- Start of API User Hook for the after hook of delete_corps_extra_info
1376: --
1377: pqh_corps_extra_info_bk3.delete_corps_extra_info_a
1378: (
1379: p_corps_extra_info_id => p_corps_extra_info_id
1380: ,p_object_version_number => l_object_version_number
1381: );

Line 1457: end pqh_corps_extra_info_api;

1453: hr_utility.set_location(' Leaving:'||l_proc, 70);
1454: --
1455: end lck;
1456: --
1457: end pqh_corps_extra_info_api;