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_CRT_BUS dependencies on OTA_CERTIFICATIONS_B

Line 176: (p_certification_id IN ota_certifications_b.certification_id%TYPE

172: (p_rec in ota_crt_shd.g_rec_type
173: );
174:
175: PROCEDURE chk_should_warn
176: (p_certification_id IN ota_certifications_b.certification_id%TYPE
177: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
178: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
179: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
180: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE

Line 177: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE

173: );
174:
175: PROCEDURE chk_should_warn
176: (p_certification_id IN ota_certifications_b.certification_id%TYPE
177: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
178: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
179: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
180: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
181: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE

Line 178: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE

174:
175: PROCEDURE chk_should_warn
176: (p_certification_id IN ota_certifications_b.certification_id%TYPE
177: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
178: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
179: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
180: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
181: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
182: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE

Line 179: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE

175: PROCEDURE chk_should_warn
176: (p_certification_id IN ota_certifications_b.certification_id%TYPE
177: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
178: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
179: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
180: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
181: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
182: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
183: , p_return_status OUT NOCOPY VARCHAR2);

Line 180: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE

176: (p_certification_id IN ota_certifications_b.certification_id%TYPE
177: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
178: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
179: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
180: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
181: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
182: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
183: , p_return_status OUT NOCOPY VARCHAR2);
184:

Line 181: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE

177: , p_initial_completion_date IN ota_certifications_b.initial_completion_date%TYPE
178: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
179: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
180: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
181: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
182: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
183: , p_return_status OUT NOCOPY VARCHAR2);
184:
185: --

Line 182: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE

178: , p_initial_completion_duration IN ota_certifications_b.initial_completion_duration%TYPE
179: , p_renewal_duration IN ota_certifications_b.renewal_duration%TYPE
180: , p_validity_duration IN ota_certifications_b.validity_duration%TYPE
181: , p_validity_start_type IN ota_certifications_b.validity_start_type%TYPE
182: , p_renewable_flag IN ota_certifications_b.renewable_flag%TYPE
183: , p_return_status OUT NOCOPY VARCHAR2);
184:
185: --
186: end ota_crt_bus;