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

Line 232: AK_REGIONS_PKG.INSERT_ROW(

228: P_DATABASE_OBJECT_NAME => X_DATABASE_OBJECT_NAME,
229: P_APPLICATION_ID => X_REGION_APPLICATION_ID);
230: END IF;
231:
232: AK_REGIONS_PKG.INSERT_ROW(
233: X_ROWID => X_ROWID,
234: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
235: X_REGION_CODE => upper(X_REGION_CODE),
236: X_DATABASE_OBJECT_NAME => X_DATABASE_OBJECT_NAME,

Line 335: from ak_regions

331: display_graph_table,
332: disable_header,
333: standalone,
334: auto_customization_criteria
335: from ak_regions
336: where region_code = X_REGION_CODE
337: and region_application_id = X_REGION_APPLICATION_ID;
338:
339: begin

Line 374: AK_REGIONS_PKG.UPDATE_ROW(

370: l_region_rec.standalone,
371: l_region_rec.auto_customization_criteria;
372: CLOSE cRegion;
373:
374: AK_REGIONS_PKG.UPDATE_ROW(
375: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
376: X_REGION_CODE => X_REGION_CODE,
377: X_DATABASE_OBJECT_NAME => X_DATABASE_OBJECT_NAME,
378: X_REGION_STYLE => X_REGION_STYLE,

Line 1027: AK_REGIONS_PKG.INSERT_ROW(

1023: if (p_REGION_STYLE = c_PAGE_LAYOUT_STYLE) then
1024: l_image_file_name := c_IMAGE_FILE_NAME;
1025: end if;
1026:
1027: AK_REGIONS_PKG.INSERT_ROW(
1028: X_ROWID => l_ROWID,
1029: X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
1030: X_REGION_CODE => upper(p_REGION_CODE),
1031: X_DATABASE_OBJECT_NAME => p_DATABASE_OBJECT_NAME,

Line 1108: AK_REGIONS_PKG.INSERT_ROW

1104: P_DATABASE_OBJECT_NAME => p_Report_Region_Rec.Database_Object_Name,
1105: P_APPLICATION_ID => p_Report_Region_Rec.Region_Application_Id);
1106: END IF;
1107:
1108: AK_REGIONS_PKG.INSERT_ROW
1109: ( X_ROWID => l_rowid
1110: , X_REGION_APPLICATION_ID => p_Report_Region_Rec.Region_Application_Id
1111: , X_REGION_CODE => UPPER(p_Report_Region_Rec.Region_Code)
1112: , X_DATABASE_OBJECT_NAME => p_Report_Region_Rec.Database_Object_Name

Line 1251: from ak_regions_vl

1247: attribute12,
1248: attribute13,
1249: attribute14,
1250: attribute15
1251: from ak_regions_vl
1252: where region_code = p_REGION_CODE
1253: and region_application_id = p_REGION_APPLICATION_ID;
1254:
1255: begin

Line 1371: AK_REGIONS_PKG.UPDATE_ROW(

1367: l_region_rec.attribute15 := p_attribute15;
1368: end if;
1369:
1370:
1371: AK_REGIONS_PKG.UPDATE_ROW(
1372: X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
1373: X_REGION_CODE => p_REGION_CODE,
1374: X_DATABASE_OBJECT_NAME => p_DATABASE_OBJECT_NAME,
1375: X_REGION_STYLE => l_region_rec.region_style,

Line 1499: FROM ak_regions_vl

1495: attribute12,
1496: attribute13,
1497: attribute14,
1498: attribute15
1499: FROM ak_regions_vl
1500: WHERE region_code = p_Report_Region_Rec.Region_Code
1501: AND region_application_id = p_Report_Region_Rec.Region_Application_Id;
1502:
1503: BEGIN

Line 1611: AK_REGIONS_PKG.UPDATE_ROW(

1607: IF (p_Report_Region_Rec.Parameter_Layout <> BIS_COMMON_UTILS.G_DEF_CHAR) THEN
1608: l_region_rec.attribute13 := p_Report_Region_Rec.Parameter_Layout;
1609: END IF;
1610:
1611: AK_REGIONS_PKG.UPDATE_ROW(
1612: X_REGION_APPLICATION_ID => p_Report_Region_Rec.Region_Application_Id,
1613: X_REGION_CODE => p_Report_Region_Rec.Region_Code,
1614: X_DATABASE_OBJECT_NAME => p_Report_Region_Rec.Database_Object_Name,
1615: X_REGION_STYLE => l_region_rec.region_style,

Line 1698: AK_REGIONS_PKG.DELETE_ROW(

1694: BEGIN
1695:
1696: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1697:
1698: AK_REGIONS_PKG.DELETE_ROW(
1699: X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
1700: X_REGION_CODE => p_REGION_CODE
1701: );
1702:

Line 3085: from ak_regions

3081:
3082: l_last_update_date date;
3083:
3084: cursor cRegion is select last_update_date
3085: from ak_regions
3086: where region_code = p_region_code
3087: and region_application_id = p_region_application_id
3088: for update of region_application_id nowait;
3089:

Line 3194: p_region_code IN Ak_Regions.REGION_CODE%TYPE

3190: END AK_DATA_SET;
3191:
3192: --return 'T' if given report is view based, 'F' otherwise
3193: FUNCTION IS_VIEW_BASED_REPORT(
3194: p_region_code IN Ak_Regions.REGION_CODE%TYPE
3195: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
3196: ) RETURN VARCHAR2
3197: IS
3198: l_attribute10 Ak_Regions.ATTRIBUTE10%TYPE;

Line 3195: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type

3191:
3192: --return 'T' if given report is view based, 'F' otherwise
3193: FUNCTION IS_VIEW_BASED_REPORT(
3194: p_region_code IN Ak_Regions.REGION_CODE%TYPE
3195: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
3196: ) RETURN VARCHAR2
3197: IS
3198: l_attribute10 Ak_Regions.ATTRIBUTE10%TYPE;
3199: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;

Line 3198: l_attribute10 Ak_Regions.ATTRIBUTE10%TYPE;

3194: p_region_code IN Ak_Regions.REGION_CODE%TYPE
3195: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
3196: ) RETURN VARCHAR2
3197: IS
3198: l_attribute10 Ak_Regions.ATTRIBUTE10%TYPE;
3199: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;
3200: BEGIN
3201: SELECT attribute10 INTO l_attribute10
3202: FROM ak_regions

Line 3202: FROM ak_regions

3198: l_attribute10 Ak_Regions.ATTRIBUTE10%TYPE;
3199: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;
3200: BEGIN
3201: SELECT attribute10 INTO l_attribute10
3202: FROM ak_regions
3203: WHERE region_code = p_region_code
3204: AND region_application_id = p_region_app_id;
3205:
3206: IF (l_attribute10 IS NULL) THEN

Line 3221: p_region_code IN Ak_Regions.REGION_CODE%TYPE

3217:
3218:
3219: --return 'T' if given report is view-by, 'F' otherwise
3220: FUNCTION IS_VIEW_BY_REPORT(
3221: p_region_code IN Ak_Regions.REGION_CODE%TYPE
3222: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
3223: ) RETURN VARCHAR2
3224: IS
3225: l_attribute1 Ak_Regions.ATTRIBUTE1%TYPE;

Line 3222: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type

3218:
3219: --return 'T' if given report is view-by, 'F' otherwise
3220: FUNCTION IS_VIEW_BY_REPORT(
3221: p_region_code IN Ak_Regions.REGION_CODE%TYPE
3222: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
3223: ) RETURN VARCHAR2
3224: IS
3225: l_attribute1 Ak_Regions.ATTRIBUTE1%TYPE;
3226: l_ret_val VARCHAR2(1) := FND_API.G_TRUE;

Line 3225: l_attribute1 Ak_Regions.ATTRIBUTE1%TYPE;

3221: p_region_code IN Ak_Regions.REGION_CODE%TYPE
3222: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
3223: ) RETURN VARCHAR2
3224: IS
3225: l_attribute1 Ak_Regions.ATTRIBUTE1%TYPE;
3226: l_ret_val VARCHAR2(1) := FND_API.G_TRUE;
3227: BEGIN
3228: SELECT attribute1 INTO l_attribute1
3229: FROM ak_regions

Line 3229: FROM ak_regions

3225: l_attribute1 Ak_Regions.ATTRIBUTE1%TYPE;
3226: l_ret_val VARCHAR2(1) := FND_API.G_TRUE;
3227: BEGIN
3228: SELECT attribute1 INTO l_attribute1
3229: FROM ak_regions
3230: WHERE region_code = p_region_code
3231: AND region_application_id = p_region_app_id;
3232:
3233: IF ((l_attribute1 = 'N') OR (l_attribute1 IS NULL)) THEN

Line 3273: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE

3269: END IS_AGGREGATE_DEFINED;
3270:
3271: -- added for Bug#4448994 and as a general utility file.
3272: PROCEDURE Get_Region_Code_TL_Data (
3273: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE

Line 3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE

3270:
3271: -- added for Bug#4448994 and as a general utility file.
3272: PROCEDURE Get_Region_Code_TL_Data (
3273: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE

Line 3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE

3271: -- added for Bug#4448994 and as a general utility file.
3272: PROCEDURE Get_Region_Code_TL_Data (
3273: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE

Line 3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE

3272: PROCEDURE Get_Region_Code_TL_Data (
3273: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE

Line 3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE

3273: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE

Line 3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE

3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
3282: , x_return_status OUT NOCOPY VARCHAR2

Line 3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE

3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
3282: , x_return_status OUT NOCOPY VARCHAR2
3283: , x_msg_count OUT NOCOPY NUMBER

Line 3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE

3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
3282: , x_return_status OUT NOCOPY VARCHAR2
3283: , x_msg_count OUT NOCOPY NUMBER
3284: , x_msg_data OUT NOCOPY VARCHAR2

Line 3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE

3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
3282: , x_return_status OUT NOCOPY VARCHAR2
3283: , x_msg_count OUT NOCOPY NUMBER
3284: , x_msg_data OUT NOCOPY VARCHAR2
3285: ) IS

Line 3297: FROM AK_REGIONS_VL A

3293: , A.CREATION_DATE
3294: , A.LAST_UPDATED_BY
3295: , A.LAST_UPDATE_DATE
3296: , A.LAST_UPDATE_LOGIN
3297: FROM AK_REGIONS_VL A
3298: WHERE A.REGION_CODE = p_Region_Code
3299: AND A.REGION_APPLICATION_ID = p_Region_Application_Id;
3300: BEGIN
3301: FND_MSG_PUB.Initialize;