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 92: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;

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

Line 93: l_activity_id ota_activity_definitions.activity_id%TYPE;

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

Line 361: FROM ota_activity_definitions

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

Line 368: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;

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

Line 369: l_activity_id ota_activity_definitions.activity_id%TYPE;

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

Line 609: FROM ota_activity_definitions

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

Line 615: l_act_object_version_number ota_activity_definitions.object_version_number%TYPE;

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

Line 616: l_activity_id ota_activity_definitions.activity_id%TYPE;

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