[Home] [Help]
942: AND cat.activity_version_id = p_act_ver_id;
943:
944: cursor csr_equivalent_tad(p_ctu_id number) is
945: select activity_id
946: from ota_activity_definitions
947: where category_usage_id = p_ctu_id;
948:
949: CURSOR csr_dup_act_cat (p_act_ver_id number, p_category_usage_id number) is
950: SELECT 1
952: WHERE cat.category_usage_id =p_category_usage_id
953: AND cat.activity_version_id = p_act_ver_id;
954:
955:
956: l_equivalent_tad ota_activity_definitions.activity_id%type;
957: l_equivalent_ctu ota_category_usages.category_usage_id%type;
958: l_act_ver_id ota_activity_versions.activity_version_id%type;
959: l_count number;
960: l_err_code varchar2(72);
1056: ,p_activity_id in number
1057: ,p_category_usage_id in number)
1058: is
1059: begin
1060: Update Ota_activity_Definitions
1061: Set Category_usage_id = p_category_usage_id
1062: Where Business_group_id = p_business_group_id
1063: and Activity_id = p_activity_id ;
1064: end update_tad_cat_usg_id;
1083: and oct.language = Userenv('LANG')
1084: and ocu.type = 'C'
1085: and ocu.category_usage_id between p_start_pkid and p_end_pkid
1086: and ocu. category_usage_id not in (select category_usage_id
1087: from ota_activity_definitions
1088: where category_usage_id is not null) ;
1089:
1090: l_object_version_number number;
1091: l_category_usage_id number;
1106: l_description := c_activity.description;
1107:
1108: Begin
1109: Select tad.Activity_id into l_activity_id
1110: from ota_activity_definitions tad, ota_activity_definitions_tl adt
1111: Where tad.Business_group_id = l_business_group_id
1112: and tad.activity_id = adt.activity_id
1113: and adt.Name = l_category
1114: -- and Category_usage_id is NULL
1171: -- ----------------------------------------------------------------------------
1172: -- |--------------------< Create_Category_for_Activity >----------------------|
1173: -- ----------------------------------------------------------------------------
1174: -- This procedure does the following
1175: -- 1. Creates a Category for each BG in ota_activity_definitions
1176: -- and ota_category_usages. And this new category will be the
1177: -- parent category for other categories(belongs to that BG).
1178: -- 2. Creates Category for each Activity types, which are not
1179: -- as part of step 3. Attaches the newly created category to
1214: ,TAD_INFORMATION17
1215: ,TAD_INFORMATION18
1216: ,TAD_INFORMATION19
1217: ,TAD_INFORMATION20
1218: FROM ota_activity_definitions tad, ota_activity_definitions_tl adt
1219: WHERE tad.activity_id between p_start_pkid AND p_end_pkid
1220: and tad.activity_id = adt.activity_id
1221: and adt.language = Userenv('LANG')
1222: AND tad.category_usage_id is null ;
1252: l_current_nls_language VARCHAR2(30);
1253: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;
1254: l_parent_category_usage_id number;
1255: l_count number ;
1256: l_act_name ota_activity_definitions_tl.name%type;
1257: l_act_ver_id number;
1258:
1259: l_rows_processed number := 0;
1260: l_err_code varchar2(72);
1364: M.Creation_date,
1365: M.Last_Updated_By,
1366: M.Last_Update_Date,
1367: M.Last_Update_Login
1368: From Ota_activity_definitions_tl M
1369: Where M.activity_id = l_act_id ;
1370: Exception
1371: when others then
1372: l_err_code := SQLCODE;
1399: end loop;
1400: hr_dflex_utility.remove_ignore_df_validation;
1401: select nvl(count(1),0)
1402: into l_rows_processed
1403: from ota_activity_definitions
1404: where activity_id between p_start_pkid and p_end_pkid;
1405:
1406: p_rows_processed := l_rows_processed;
1407:
1460: ,tav.budget_cost
1461: ,tav.budget_currency_code
1462: ,tav.vendor_id
1463: ,tav.rco_id
1464: FROM ota_activity_versions_vl tav, ota_activity_definitions tad
1465: WHERE tav.activity_id =tad.activity_id
1466: AND tav.activity_version_id between p_start_pkid and p_end_pkid ;
1467:
1468: CURSOR c_get_dm(p_act_ver_id number)is
2504: -- ----------------------------------------------------------------------------
2505: Procedure create_ctg_dm_for_act_bg(p_update_id in number default 1 ) is
2506: Cursor Csr_Activity_Bg is
2507: Select tad.business_group_id
2508: From Ota_Activity_definitions tad
2509: Group by tad.business_group_id ;
2510:
2511: Cursor Csr_Bg_name(p_bg_id number) is
2512: Select hou.name Bg_name
2717: Cursor C1 (p_context_code in varchar2)
2718: is Select fcu.*,fvs.flex_value_set_name
2719: From Fnd_Descr_Flex_Col_Usage_Vl fcu, fnd_flex_value_sets fvs
2720: Where fcu.Application_id = 810
2721: and fcu.Descriptive_FlexField_Name = 'OTA_ACTIVITY_DEFINITIONS'
2722: and fcu.Descriptive_Flex_Context_code = p_context_code
2723: and fcu.flex_value_set_id = fvs.flex_value_set_id(+)
2724: and Not exists (SELECT 'Y'
2725: From Fnd_Descr_Flex_Col_Usage_Vl cat_fcu
2739: l_segment_exists Varchar2(1) := 'N' ;
2740:
2741: Cursor Csr_DFF_contexts is Select * from FND_DESCR_FLEX_CONTEXTS_vl
2742: Where Application_id = 810
2743: and Descriptive_FLexfield_Name = 'OTA_ACTIVITY_DEFINITIONS'
2744: and Enabled_Flag = 'Y';
2745:
2746: Cursor Csr_Segment_exists(p_context_name in varchar2) is SELECT 'Y'
2747: FROM fnd_descriptive_flexs