APPS.HZ_MGD_MASS_UPDATE_REP_GEN SQL Statements

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

Line: 49

G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_MGD_MASS_UPDATE_REP_GEN';

Line: 63

g_exp_table   HZ_MGD_MASS_UPDATE_REP_GEN.REPORT_EXP_TABLE;

Line: 163

                        ('AR','AR_MGD_MASS_UPDATE_COL1')
            ||add_spaces(52-lengthb(FND_MESSAGE.get_string
                                              ('AR','AR_MGD_MASS_UPDATE_COL1')
                                  )
                        )
            ||FND_MESSAGE.get_string
                         ('AR','AR_MGD_MASS_UPDATE_COL2')
            ||add_spaces(42-lengthb(FND_MESSAGE.get_string
                                              ('AR','AR_MGD_MASS_UPDATE_COL2')
                                  )
                        )
            ||FND_MESSAGE.get_string
                         ('AR','AR_MGD_MASS_UPDATE_COL3')
            ||add_spaces(36-lengthb(FND_MESSAGE.get_string
                                              ('AR','AR_MGD_MASS_UPDATE_COL3')
                                  )
                         )
            );

Line: 201

                        ('AR','AR_MGD_MASS_UPDATE_COL2')
            ||add_spaces(42-lengthb(FND_MESSAGE.get_string
                                              ('AR','AR_MGD_MASS_UPDATE_COL2')
                                  )
                        )
            ||FND_MESSAGE.get_string
                         ('AR','AR_MGD_MASS_UPDATE_COL3')
            );

Line: 232

  SELECT
    meaning
  INTO
    l_meaning
  FROM fnd_lookups
  WHERE lookup_code=p_lookup_code
    AND lookup_type='YES_NO';

Line: 247

    HZ_MGD_MASS_UPDATE_REP_GEN.log ( HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_EXCEPTION
                               , 'SQLERRM '|| SQLERRM) ;

Line: 296

  g_exp_table.DELETE;

Line: 369

 HZ_MGD_MASS_UPDATE_REP_GEN.log
  ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
  , p_msg => '>> Add_Exp_Item ' );

Line: 379

  HZ_MGD_MASS_UPDATE_REP_GEN.log
  ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
  , p_msg => '<< Add_Exp_Item ' );

Line: 420

  HZ_MGD_MASS_UPDATE_REP_GEN.log
  ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
  , p_msg => '>> Generate_Report ' );

Line: 426

  HZ_MGD_MASS_UPDATE_REP_GEN.log
  ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
  , p_msg => '  Getting Profile Class  Name, operating Unit Name '
    );

Line: 432

    SELECT
      name
    INTO
      l_profile_class
    FROM
      hz_cust_profile_classes
    WHERE profile_class_id =p_prof_class_id;

Line: 454

  SELECT
      SUBSTRB(name,1,30)
    INTO
      l_operating_unit
    FROM
      hr_operating_units
    WHERE organization_id=G_ORG_ID;

Line: 462

  HZ_MGD_MASS_UPDATE_REP_GEN.log
  ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
  , p_msg => 'operating Unit Name= '||l_operating_unit
    );

Line: 473

  HZ_MGD_MASS_UPDATE_REP_GEN.log
  ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
  , p_msg => 'NO_DATA_FOUND '
    );

Line: 484

                               ('AR','AR_MGD_MASS_UPDATE_TITLE1'
                               ),' '
                 );

Line: 491

                               ('AR','AR_MGD_MASS_UPDATE_TITLE2'
                               ),' '
                 );

Line: 526

                                                      ('AR','AR_MGD_MASS_UPDATE_PARAM1'
                                                      ),' ')
                       )
            )
            ||NVL(FND_MESSAGE.get_string
                         ('AR','AR_MGD_MASS_UPDATE_PARAM1'
                         ),' '
                 )
            ||add_spaces(1)
            ||l_profile_class
            );

Line: 538

                                                      ('AR','AR_MGD_MASS_UPDATE_PARAM2'
                                                      ),' '
                                              )
                                          )
                       )
            ||NVL(FND_MESSAGE.get_string
                         ('AR','AR_MGD_MASS_UPDATE_PARAM2'
                         ),' '
                 )
            ||add_spaces(1)
            ||p_currency_code
            );

Line: 567

                  ('AR','AR_MGD_MASS_UPDATE_FOOTER2'
                  ),' '
                 )))/2);

Line: 574

                  ('AR','AR_MGD_MASS_UPDATE_FOOTER2'
                  ),' '
                 )
               );

Line: 581

    IF HZ_MGD_MASS_UPDATE_CP.G_RELEASE='NEW'
    THEN
      ---------------Print party----------------

      ---------------Print text-----------------
      Print_line(add_spaces(1)
                 ||FND_MESSAGE.get_string('AR','AR_MGD_MASS_UPDATE_TEXT1'
                                          )
                 );

Line: 591

                 ||FND_MESSAGE.get_string('AR','AR_MGD_MASS_UPDATE_TEXT2'
                                          )
                 );

Line: 595

                 ||FND_MESSAGE.get_string('AR','AR_MGD_MASS_UPDATE_TEXT3'
                                          )
                 );

Line: 620

    ELSIF  HZ_MGD_MASS_UPDATE_CP.G_RELEASE='OLD'
    THEN
      --------------Do not print party---------------


      ---------------Print text-----------------
      -----The following customers/customer sites have not been updated.---

      Print_line(add_spaces(1)
                 ||FND_MESSAGE.get_string('AR','AR_MGD_MASS_UPDATE_TEXT4'
                                          )
                 );

Line: 635

                 ||FND_MESSAGE.get_string('AR','AR_MGD_MASS_UPDATE_TEXT2'
                                          )
                 );

Line: 641

                 ||FND_MESSAGE.get_string('AR','AR_MGD_MASS_UPDATE_TEXT5'
                                          )
                 );

Line: 676

                  ('AR','AR_MGD_MASS_UPDATE_FOOTER1'
                  ),' '
                 )
            ||' ******'
            );

Line: 682

  HZ_MGD_MASS_UPDATE_REP_GEN.log
  ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
  , p_msg => '<< Generate_Report ' );