APPS.OTA_CATEGORY_USAGE_API dependencies on OTA_ACTIVITY_DEFINITIONS

Line 22: l_act_def_name ota_activity_definitions_tl.name%type := p_act_def_name;

18: MAX_ACT_DEF_NAME_LEN constant number := 240;
19:
20: l_new_act_def_len number;
21: l_cat_id_len number;
22: l_act_def_name ota_activity_definitions_tl.name%type := p_act_def_name;
23: l_old_act_def_len number := length(l_act_def_name);
24:
25: begin
26: --

Line 91: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;

87: --
88: l_proc varchar2(72) := g_package||'Create_Category';
89: l_category_usage_id number;
90: l_object_version_number number;
91: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;
92: l_activity_id ota_activity_definitions.activity_id%TYPE;
93: l_effective_date date;
94: l_category varchar2(240);
95:

Line 92: l_activity_id ota_activity_definitions.activity_id%TYPE;

88: l_proc varchar2(72) := g_package||'Create_Category';
89: l_category_usage_id number;
90: l_object_version_number number;
91: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;
92: l_activity_id ota_activity_definitions.activity_id%TYPE;
93: l_effective_date date;
94: l_category varchar2(240);
95:
96: begin

Line 359: FROM ota_activity_definitions

355: CURSOR get_activity_id
356: IS
357: SELECT activity_id,
358: object_version_number
359: FROM ota_activity_definitions
360: WHERE category_usage_id = p_category_usage_id;
361:
362: --
363: l_proc varchar2(72) := g_package||'Update_category';

Line 366: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;

362: --
363: l_proc varchar2(72) := g_package||'Update_category';
364: l_effective_date date;
365: l_object_version_number number := p_object_version_number;
366: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;
367: l_activity_id ota_activity_definitions.activity_id%TYPE;
368: l_category varchar2(240);
369:
370: begin

Line 367: l_activity_id ota_activity_definitions.activity_id%TYPE;

363: l_proc varchar2(72) := g_package||'Update_category';
364: l_effective_date date;
365: l_object_version_number number := p_object_version_number;
366: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;
367: l_activity_id ota_activity_definitions.activity_id%TYPE;
368: l_category varchar2(240);
369:
370: begin
371: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 607: FROM ota_activity_definitions

603: CURSOR get_activity_id
604: IS
605: SELECT activity_id,
606: object_version_number
607: FROM ota_activity_definitions
608: WHERE category_usage_id = p_category_usage_id;
609:
610: --
611: l_proc varchar2(72) := g_package||'Delete_category';

Line 613: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;

609:
610: --
611: l_proc varchar2(72) := g_package||'Delete_category';
612: l_budget_version_id number;
613: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;
614: l_activity_id ota_activity_definitions.activity_id%TYPE;
615:
616:
617:

Line 614: l_activity_id ota_activity_definitions.activity_id%TYPE;

610: --
611: l_proc varchar2(72) := g_package||'Delete_category';
612: l_budget_version_id number;
613: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;
614: l_activity_id ota_activity_definitions.activity_id%TYPE;
615:
616:
617:
618: --