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.OTA_CMB_BUS dependencies on OTA_CMB_BUS

Line 1: Package Body ota_cmb_bus as

1: Package Body ota_cmb_bus as
2: /* $Header: otcmbrhi.pkb 120.5 2005/08/19 17:58 gdhutton noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_cmb_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_cmb_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 122: if ( nvl(ota_cmb_bus.g_certification_member_id, hr_api.g_number)

118: ,p_argument => 'certification_member_id'
119: ,p_argument_value => p_certification_member_id
120: );
121: --
122: if ( nvl(ota_cmb_bus.g_certification_member_id, hr_api.g_number)
123: = p_certification_member_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 129: l_legislation_code := ota_cmb_bus.g_legislation_code;

125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := ota_cmb_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function

Line 153: ota_cmb_bus.g_certification_member_id := p_certification_member_id;

149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --
152: close csr_leg_code;
153: ota_cmb_bus.g_certification_member_id := p_certification_member_id;
154: ota_cmb_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;

Line 154: ota_cmb_bus.g_legislation_code := l_legislation_code;

150: -- available for the next call to this function.
151: --
152: close csr_leg_code;
153: ota_cmb_bus.g_certification_member_id := p_certification_member_id;
154: ota_cmb_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;

Line 809: ota_cmb_bus.chk_act_version_dates(p_activity_version_id => p_rec.object_id

805: -- Validate Dependent Attributes
806: --
807: --
808:
809: ota_cmb_bus.chk_act_version_dates(p_activity_version_id => p_rec.object_id
810: ,p_cmb_start_date => p_rec.start_date_active
811: ,p_cmb_end_date => p_rec.end_date_active);
812:
813: ota_cmb_bus.chk_cert_dates(p_certification_id => p_rec.certification_id

Line 813: ota_cmb_bus.chk_cert_dates(p_certification_id => p_rec.certification_id

809: ota_cmb_bus.chk_act_version_dates(p_activity_version_id => p_rec.object_id
810: ,p_cmb_start_date => p_rec.start_date_active
811: ,p_cmb_end_date => p_rec.end_date_active);
812:
813: ota_cmb_bus.chk_cert_dates(p_certification_id => p_rec.certification_id
814: ,p_cmb_start_date => p_rec.start_date_active
815: ,p_cmb_end_date => p_rec.end_date_active);
816:
817: ota_cmb_bus.chk_dup_cmb_dates(p_activity_version_id => p_rec.object_id

Line 817: ota_cmb_bus.chk_dup_cmb_dates(p_activity_version_id => p_rec.object_id

813: ota_cmb_bus.chk_cert_dates(p_certification_id => p_rec.certification_id
814: ,p_cmb_start_date => p_rec.start_date_active
815: ,p_cmb_end_date => p_rec.end_date_active);
816:
817: ota_cmb_bus.chk_dup_cmb_dates(p_activity_version_id => p_rec.object_id
818: ,p_certification_id => p_rec.certification_id
819: ,p_cmb_start_date => p_rec.start_date_active
820: ,p_cmb_end_date => p_rec.end_date_active
821: ,p_cert_member_id => p_rec.certification_member_id);

Line 823: ota_cmb_bus.chk_df(p_rec);

819: ,p_cmb_start_date => p_rec.start_date_active
820: ,p_cmb_end_date => p_rec.end_date_active
821: ,p_cert_member_id => p_rec.certification_member_id);
822:
823: ota_cmb_bus.chk_df(p_rec);
824: --
825: hr_utility.set_location(' Leaving:'||l_proc, 10);
826: End insert_validate;
827: --

Line 862: ota_cmb_bus.chk_act_version_dates(p_activity_version_id => p_rec.object_id

858: ,p_rec => p_rec
859: );
860: --
861: --
862: ota_cmb_bus.chk_act_version_dates(p_activity_version_id => p_rec.object_id
863: ,p_cmb_start_date => p_rec.start_date_active
864: ,p_cmb_end_date => p_rec.end_date_active);
865:
866: ota_cmb_bus.chk_cert_dates(p_certification_id => p_rec.certification_id

Line 866: ota_cmb_bus.chk_cert_dates(p_certification_id => p_rec.certification_id

862: ota_cmb_bus.chk_act_version_dates(p_activity_version_id => p_rec.object_id
863: ,p_cmb_start_date => p_rec.start_date_active
864: ,p_cmb_end_date => p_rec.end_date_active);
865:
866: ota_cmb_bus.chk_cert_dates(p_certification_id => p_rec.certification_id
867: ,p_cmb_start_date => p_rec.start_date_active
868: ,p_cmb_end_date => p_rec.end_date_active);
869:
870:

Line 871: ota_cmb_bus.chk_df(p_rec);

867: ,p_cmb_start_date => p_rec.start_date_active
868: ,p_cmb_end_date => p_rec.end_date_active);
869:
870:
871: ota_cmb_bus.chk_df(p_rec);
872: --
873: hr_utility.set_location(' Leaving:'||l_proc, 10);
874: End update_validate;
875: --

Line 893: end ota_cmb_bus;

889: --
890: hr_utility.set_location(' Leaving:'||l_proc, 10);
891: End delete_validate;
892: --
893: end ota_cmb_bus;