APPS.BSC_COPY_INDICATOR_PUB dependencies on BSC_KPI_DIM_GROUPS

Line 1590: l_dim_set_id bsc_kpi_dim_groups.dim_set_id%TYPE;

1586: TYPE c_cur_type IS REF CURSOR;
1587: c_Dim_Group_Info c_cur_type;
1588: l_Short_Name bsc_sys_dim_groups_vl.short_name%TYPE;
1589:
1590: l_dim_set_id bsc_kpi_dim_groups.dim_set_id%TYPE;
1591: l_dim_group_id bsc_kpi_dim_groups.dim_group_id%TYPE;
1592: l_dim_group_index bsc_kpi_dim_groups.dim_group_index%TYPE;
1593:
1594: BEGIN

Line 1591: l_dim_group_id bsc_kpi_dim_groups.dim_group_id%TYPE;

1587: c_Dim_Group_Info c_cur_type;
1588: l_Short_Name bsc_sys_dim_groups_vl.short_name%TYPE;
1589:
1590: l_dim_set_id bsc_kpi_dim_groups.dim_set_id%TYPE;
1591: l_dim_group_id bsc_kpi_dim_groups.dim_group_id%TYPE;
1592: l_dim_group_index bsc_kpi_dim_groups.dim_group_index%TYPE;
1593:
1594: BEGIN
1595:

Line 1592: l_dim_group_index bsc_kpi_dim_groups.dim_group_index%TYPE;

1588: l_Short_Name bsc_sys_dim_groups_vl.short_name%TYPE;
1589:
1590: l_dim_set_id bsc_kpi_dim_groups.dim_set_id%TYPE;
1591: l_dim_group_id bsc_kpi_dim_groups.dim_group_id%TYPE;
1592: l_dim_group_index bsc_kpi_dim_groups.dim_group_index%TYPE;
1593:
1594: BEGIN
1595:
1596: FND_MSG_PUB.Initialize;

Line 1631: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT dim_set_id,dim_group_id,dim_group_index FROM bsc_kpi_dim_groups');

1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: END IF;
1629:
1630: ELSE
1631: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT dim_set_id,dim_group_id,dim_group_index FROM bsc_kpi_dim_groups');
1632: l_sql := l_sql || 'WHERE indicator = :1 ORDER BY dim_set_id,dim_group_index';
1633: OPEN c_Dim_Group_Info FOR l_sql USING p_Source_Indicator;
1634: LOOP
1635: FETCH c_Dim_Group_Info INTO l_dim_set_id, l_dim_group_id, l_dim_group_index;