APPS.OTA_LPC_BUS dependencies on OTA_LP_SECTIONS

Line 32: , ota_lp_sections lpc

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , ota_lp_sections lpc
33: where lpc.learning_path_section_id = p_learning_path_section_id
34: and pbg.business_group_id = lpc.business_group_id;
35: --
36: -- Declare local variables

Line 102: , ota_lp_sections lpc

98: --
99: cursor csr_leg_code is
100: select pbg.legislation_code
101: from per_business_groups_perf pbg
102: , ota_lp_sections lpc
103: where lpc.learning_path_section_id = p_learning_path_section_id
104: and pbg.business_group_id = lpc.business_group_id;
105: --
106: -- Declare local variables

Line 250: ,p_descflex_name => 'OTA_LP_SECTIONS'

246: -- b) During insert.
247: --
248: hr_dflex_utility.ins_or_upd_descflex_attribs
249: (p_appl_short_name => 'OTA'
250: ,p_descflex_name => 'OTA_LP_SECTIONS'
251: ,p_attribute_category => p_rec.attribute_category
252: ,p_attribute1_name => 'ATTRIBUTE1'
253: ,p_attribute1_value => p_rec.attribute1
254: ,p_attribute2_name => 'ATTRIBUTE2'

Line 399: l_lp_id ota_lp_sections.learning_path_id%TYPE;

395: p_learning_path_id in number
396: ) is
397: --
398: v_exists BOOLEAN := FALSE;
399: l_lp_id ota_lp_sections.learning_path_id%TYPE;
400: v_proc varchar2(72) := g_package||'chk_completion_type_valid';
401: --
402: CURSOR get_lp_id IS
403: SELECT learning_path_id

Line 404: FROM ota_lp_sections

400: v_proc varchar2(72) := g_package||'chk_completion_type_valid';
401: --
402: CURSOR get_lp_id IS
403: SELECT learning_path_id
404: FROM ota_lp_sections
405: WHERE learning_path_section_id = p_learning_path_section_id;
406:
407: cursor sel_lps_exists is
408: select 1

Line 409: from ota_lp_sections lps

405: WHERE learning_path_section_id = p_learning_path_section_id;
406:
407: cursor sel_lps_exists is
408: select 1
409: from ota_lp_sections lps
410: where lps.learning_path_id = l_lp_id
411: and lps.completion_type_code IN ('M', 'S')
412: AND (p_learning_path_section_id IS NULL
413: OR ( p_learning_path_section_id IS NOT NULL

Line 449: (p_associated_column1 => 'OTA_LP_SECTIONS.COMPLETION_TYPE_CODE') THEN

445: EXCEPTION
446: WHEN app_exception.application_exception THEN
447:
448: IF hr_multi_message.exception_add
449: (p_associated_column1 => 'OTA_LP_SECTIONS.COMPLETION_TYPE_CODE') THEN
450:
451: hr_utility.set_location(' Leaving:'||v_proc, 92);
452: RAISE;
453:

Line 518: (p_learning_path_section_id in ota_lp_sections.learning_path_section_id%TYPE)

514: -- Description:
515: --
516: --
517: Function is_last_section
518: (p_learning_path_section_id in ota_lp_sections.learning_path_section_id%TYPE)
519: RETURN BOOLEAN is
520: --
521: l_lp_id ota_learning_paths.learning_path_id%TYPE;
522: l_count_sections NUMBER;

Line 528: FROM ota_lp_sections

524: v_proc varchar2(72) := g_package||'is_last_section';
525: --
526: CURSOR get_lp_id IS
527: SELECT learning_path_id
528: FROM ota_lp_sections
529: WHERE learning_path_section_id = p_learning_path_section_id;
530:
531: CURSOR csr_is_last_section IS
532: SELECT count(learning_path_section_id)

Line 533: FROM ota_lp_sections

529: WHERE learning_path_section_id = p_learning_path_section_id;
530:
531: CURSOR csr_is_last_section IS
532: SELECT count(learning_path_section_id)
533: FROM ota_lp_sections
534: WHERE learning_path_id = l_lp_id;
535: --
536: Begin
537: --

Line 634: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_SECTIONS';

630: IF v_path_source_code <> 'CATALOG' THEN
631: -- Ignore dff validation for non-catalog learning paths
632:
633: l_add_struct_d.extend(1);
634: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_SECTIONS';
635:
636: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
637:
638: END IF;

Line 699: (p_associated_column1 => 'OTA_LP_SECTIONS.NO_OF_MANDATORY_COURSES') THEN

695: EXCEPTION
696: WHEN app_exception.application_exception THEN
697:
698: IF hr_multi_message.exception_add
699: (p_associated_column1 => 'OTA_LP_SECTIONS.NO_OF_MANDATORY_COURSES') THEN
700:
701: hr_utility.set_location(' Leaving:'||v_proc, 92);
702: RAISE;
703: