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.BSC_MIGRATION dependencies on AK_REGIONS

Line 50: g_migrated_ak_regions t_array_of_varchar2;

46: g_no_mig_kpis t_array_of_number; -- array of kpis that cannot be migrated
47: g_num_no_mig_kpis NUMBER := 0;
48:
49: -- Enh#4697749 new global variables
50: g_migrated_ak_regions t_array_of_varchar2;
51: g_num_migrated_ak_regions NUMBER := 0;
52: g_migrated_functions t_array_of_varchar2;
53: g_num_migrated_functions NUMBER := 0;
54:

Line 51: g_num_migrated_ak_regions NUMBER := 0;

47: g_num_no_mig_kpis NUMBER := 0;
48:
49: -- Enh#4697749 new global variables
50: g_migrated_ak_regions t_array_of_varchar2;
51: g_num_migrated_ak_regions NUMBER := 0;
52: g_migrated_functions t_array_of_varchar2;
53: g_num_migrated_functions NUMBER := 0;
54:
55: --BSC-MV Note: variable to store the summarization level from the source.

Line 8390: IF Item_Belong_To_Array_Varchar2(p_region_code, g_migrated_ak_regions, g_num_migrated_ak_regions) THEN

8386: h_order_sequence NUMBER;
8387: h_order_direction VARCHAR2(30);
8388:
8389: BEGIN
8390: IF Item_Belong_To_Array_Varchar2(p_region_code, g_migrated_ak_regions, g_num_migrated_ak_regions) THEN
8391: -- This ak region was migrated before during htis process. No need to migrate it again
8392: RETURN TRUE;
8393: END IF;
8394:

Line 8401: ' FROM ak_regions_vl@'||g_db_link||

8397: ' isform_flag, attribute_category, attribute1, attribute2, attribute3,'||
8398: ' attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,'||
8399: ' attribute10, attribute11, attribute12, attribute13, attribute14,'||
8400: ' attribute15, created_by'||
8401: ' FROM ak_regions_vl@'||g_db_link||
8402: ' WHERE region_code = :1';
8403: OPEN h_cursor FOR h_sql USING p_region_code;
8404: FETCH h_cursor INTO h_region_application_id, h_database_object_name, h_name,
8405: h_description, h_num_rows_display, h_region_style, h_region_object_type,

Line 8413: g_num_migrated_ak_regions := g_num_migrated_ak_regions + 1;

8409: h_attribute15, h_created_by;
8410: IF h_cursor%NOTFOUND THEN
8411: -- The ak region does not exists in the source system
8412: CLOSE h_cursor;
8413: g_num_migrated_ak_regions := g_num_migrated_ak_regions + 1;
8414: g_migrated_ak_regions(g_num_migrated_ak_regions) := p_region_code;
8415: RETURN TRUE;
8416: END IF;
8417: CLOSE h_cursor;

Line 8414: g_migrated_ak_regions(g_num_migrated_ak_regions) := p_region_code;

8410: IF h_cursor%NOTFOUND THEN
8411: -- The ak region does not exists in the source system
8412: CLOSE h_cursor;
8413: g_num_migrated_ak_regions := g_num_migrated_ak_regions + 1;
8414: g_migrated_ak_regions(g_num_migrated_ak_regions) := p_region_code;
8415: RETURN TRUE;
8416: END IF;
8417: CLOSE h_cursor;
8418:

Line 8422: g_num_migrated_ak_regions := g_num_migrated_ak_regions + 1;

8418:
8419: --bug 5099776
8420: IF (h_created_by = 1) OR (h_created_by = 2) or (h_created_by = 120) or (h_created_by = 121)THEN
8421: -- The ak region is pre-seeded. We cannot create a pre-seeded ak region in the target
8422: g_num_migrated_ak_regions := g_num_migrated_ak_regions + 1;
8423: g_migrated_ak_regions(g_num_migrated_ak_regions) := p_region_code;
8424: RETURN TRUE;
8425: END IF;
8426:

Line 8423: g_migrated_ak_regions(g_num_migrated_ak_regions) := p_region_code;

8419: --bug 5099776
8420: IF (h_created_by = 1) OR (h_created_by = 2) or (h_created_by = 120) or (h_created_by = 121)THEN
8421: -- The ak region is pre-seeded. We cannot create a pre-seeded ak region in the target
8422: g_num_migrated_ak_regions := g_num_migrated_ak_regions + 1;
8423: g_migrated_ak_regions(g_num_migrated_ak_regions) := p_region_code;
8424: RETURN TRUE;
8425: END IF;
8426:
8427: -- Check if the ak region exists on the target

Line 8430: from ak_regions

8426:
8427: -- Check if the ak region exists on the target
8428: h_count := 0;
8429: select count(region_code) into h_count
8430: from ak_regions
8431: where region_application_id = h_region_application_id and
8432: region_code = p_region_code;
8433:
8434: IF h_count > 0 THEN

Line 8639: g_num_migrated_ak_regions := g_num_migrated_ak_regions + 1;

8635: CLOSE h_cursor1;
8636: END LOOP;
8637: CLOSE h_cursor;
8638:
8639: g_num_migrated_ak_regions := g_num_migrated_ak_regions + 1;
8640: g_migrated_ak_regions(g_num_migrated_ak_regions) := p_region_code;
8641:
8642: commit;
8643: RETURN TRUE;

Line 8640: g_migrated_ak_regions(g_num_migrated_ak_regions) := p_region_code;

8636: END LOOP;
8637: CLOSE h_cursor;
8638:
8639: g_num_migrated_ak_regions := g_num_migrated_ak_regions + 1;
8640: g_migrated_ak_regions(g_num_migrated_ak_regions) := p_region_code;
8641:
8642: commit;
8643: RETURN TRUE;
8644:

Line 9323: ak_regions

9319: region_application_id
9320: INTO
9321: l_Region_Att_Id
9322: FROM
9323: ak_regions
9324: WHERE
9325: region_code = p_short_name;
9326:
9327: BIS_PMV_REGION_ITEMS_PVT.DELETE_REGION_ITEMS (

Line 9608: FROM ak_regions

9604: SAVEPOINT BscMigSimDataPub;
9605: g_db_link := BSC_DESIGNER_PVT.g_DbLink_Name;
9606: SELECT COUNT(0)
9607: INTO l_count
9608: FROM ak_regions
9609: WHERE region_code = p_Old_Region_Code
9610: AND region_application_id =BSC_MIGRATION.C_BSC_APP_ID;
9611:
9612: IF g_db_link IS NULL THEN

Line 9872: ak_regions

9868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9869: END IF;
9870:
9871: UPDATE
9872: ak_regions
9873: SET
9874: attribute12 = p_Region_Code
9875: WHERE
9876: region_code = p_Region_Code;