APPS.FII_COM_CC_DIM_MAPS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 96

		SELECT BALANCING_OR_COST_CENTER
		INTO G_CO_MAP_SEG
		FROM FII_FINANCIAL_DIMENSIONS
		WHERE DIMENSION_SHORT_NAME = 'FII_COMPANIES';

Line: 108

		SELECT BALANCING_OR_COST_CENTER
		INTO G_CC_MAP_SEG
		FROM FII_FINANCIAL_DIMENSIONS
		WHERE DIMENSION_SHORT_NAME = 'HRI_CL_ORGCC';

Line: 154

		-- Insert records in the com cc mappings GI table
		g_phase := 'Insert into FII_COM_CC_DIM_MAP_GT';

Line: 173

		INSERT INTO FII_COM_CC_DIM_MAPS_GT (PARENT_COMPANY_DIM_ID,
                                   CHILD_COMPANY_ID,
                                   PARENT_COST_CENTER_DIM_ID,
                                   CHILD_COST_CENTER_ID)
	         SELECT
	                h1.parent_company_id,
                        g.company_id,
                        h2.parent_cc_id,
                        g.cost_center_id
                 FROM
	             (select distinct COMPANY_ID, COST_CENTER_ID
                      from FII_GL_CCID_DIMENSIONS
                      UNION
                      select distinct COMPANY_ID, COST_CENTER_ID
                      from FII_BUDGET_BASE
		      )g,

                      (SELECT fh.parent_COMPANY_id, fh.child_COMPANY_id
                       FROM FII_FULL_COMPANY_HIERS fh
                       WHERE fh.parent_company_id IN
                          (SELECT ph.parent_COMPANY_id
                           FROM FII_COMPANY_HIERARCHIES ph
                           WHERE ph.is_leaf_flag = 'Y')) h1,
                     (SELECT fh.parent_cc_id, fh.child_cc_id
                      FROM FII_FULL_COST_CTR_HIERS fh
                      WHERE fh.parent_cc_id IN
                        (SELECT ph.parent_cc_id
                         FROM FII_COST_CTR_HIERARCHIES ph
                         WHERE ph.is_leaf_flag = 'Y')) h2
                WHERE DECODE(G_CO_MAP_SEG,
                             'BALANCING', g.COMPANY_ID,
                             'COST CENTER', g.cost_center_id, G_UNASSIGNED_ID) =
                                    h1.child_company_id
                AND DECODE(G_CC_MAP_SEG,
                           'BALANCING', g.COMPANY_ID,
                           'COST CENTER', g.cost_center_id, G_UNASSIGNED_ID) =
                                         h2.child_cc_id ;

Line: 212

		FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAP_GT');

Line: 258

      Insert into /*+ APPEND */ FII_COM_CC_DIM_MAPS (
         PARENT_COMPANY_DIM_ID,
         CHILD_COMPANY_ID,
         PARENT_COST_CENTER_DIM_ID,
         CHILD_COST_CENTER_ID,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login)
       SELECT
            PARENT_COMPANY_DIM_ID,
            CHILD_COMPANY_ID,
            PARENT_COST_CENTER_DIM_ID,
            CHILD_COST_CENTER_ID,
	    SYSDATE,
            FII_USER_ID,
	    SYSDATE,
	    FII_USER_ID,
	    FII_LOGIN_ID
        FROM FII_COM_CC_DIM_MAPS_GT;

Line: 281

		FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAPS');

Line: 338

   PROCEDURE Incre_Update (errbuf		OUT NOCOPY VARCHAR2,
	 	           retcode		OUT NOCOPY VARCHAR2) IS

      ret_val             BOOLEAN := FALSE;

Line: 346

      FII_MESSAGE.Func_Ent(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

Line: 367

	   DELETE FROM FII_COM_CC_DIM_MAPS
	   WHERE
		(PARENT_COMPANY_DIM_ID,
	         CHILD_COMPANY_ID,
	         PARENT_COST_CENTER_DIM_ID,
	         CHILD_COST_CENTER_ID)IN
	   (SELECT PARENT_COMPANY_DIM_ID,
                   CHILD_COMPANY_ID,
                   PARENT_COST_CENTER_DIM_ID,
                   CHILD_COST_CENTER_ID
  	   FROM FII_COM_CC_DIM_MAPS
	   MINUS
	   SELECT PARENT_COMPANY_DIM_ID,
                  CHILD_COMPANY_ID,
                  PARENT_COST_CENTER_DIM_ID,
                  CHILD_COST_CENTER_ID
	   FROM FII_COM_CC_DIM_MAPS_GT);

Line: 387

		FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAPS');

Line: 391

	Insert into FII_COM_CC_DIM_MAPS (
	         PARENT_COMPANY_DIM_ID,
		 CHILD_COMPANY_ID,
		 PARENT_COST_CENTER_DIM_ID,
		 CHILD_COST_CENTER_ID,
		 creation_date,
		 created_by,
		 last_update_date,
		 last_updated_by,
		 last_update_login)
       (SELECT
            PARENT_COMPANY_DIM_ID,
            CHILD_COMPANY_ID,
            PARENT_COST_CENTER_DIM_ID,
            CHILD_COST_CENTER_ID,
	    SYSDATE,
      	    FII_USER_ID,
	    SYSDATE,
	    FII_USER_ID,
	    FII_LOGIN_ID
        FROM FII_COM_CC_DIM_MAPS_GT
        MINUS
        SELECT
            PARENT_COMPANY_DIM_ID,
            CHILD_COMPANY_ID,
            PARENT_COST_CENTER_DIM_ID,
            CHILD_COST_CENTER_ID,
	    SYSDATE,
	    FII_USER_ID,
	    SYSDATE,
	    FII_USER_ID,
	    FII_LOGIN_ID
       FROM FII_COM_CC_DIM_MAPS);

Line: 426

		FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_CC_DIM_MAPS');

Line: 448

        FII_MESSAGE.Func_Succ(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

Line: 455

       FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Incre_Update'||
                         'User defined error');

Line: 459

       FII_MESSAGE.Func_Fail(func_name	=> 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

Line: 465

       FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line: 467

          'Other error in FII_COM_CC_DIM_MAPS_PKG.Incre_Update: ' || substr(sqlerrm,1,180));

Line: 471

       FII_MESSAGE.Func_Fail(func_name	=> 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');

Line: 476

   END Incre_Update;