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.PN_DISTRIBUTIONS_PKG SQL Statements

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

Line: 17


PROCEDURE insert_row (
      x_rowid                IN OUT   NOCOPY VARCHAR2
     ,x_distribution_id      IN OUT   NOCOPY NUMBER
     ,x_account_id           IN       NUMBER
     ,x_payment_term_id      IN       NUMBER
     ,x_term_template_id     IN       NUMBER
     ,x_account_class        IN       VARCHAR2
     ,x_percentage           IN       NUMBER
     ,x_line_number          IN OUT   NOCOPY NUMBER
     ,x_last_update_date     IN       DATE
     ,x_last_updated_by      IN       NUMBER
     ,x_creation_date        IN       DATE
     ,x_created_by           IN       NUMBER
     ,x_last_update_login    IN       NUMBER
     ,x_attribute_category   IN       VARCHAR2
     ,x_attribute1           IN       VARCHAR2
     ,x_attribute2           IN       VARCHAR2
     ,x_attribute3           IN       VARCHAR2
     ,x_attribute4           IN       VARCHAR2
     ,x_attribute5           IN       VARCHAR2
     ,x_attribute6           IN       VARCHAR2
     ,x_attribute7           IN       VARCHAR2
     ,x_attribute8           IN       VARCHAR2
     ,x_attribute9           IN       VARCHAR2
     ,x_attribute10          IN       VARCHAR2
     ,x_attribute11          IN       VARCHAR2
     ,x_attribute12          IN       VARCHAR2
     ,x_attribute13          IN       VARCHAR2
     ,x_attribute14          IN       VARCHAR2
     ,x_attribute15          IN       VARCHAR2
     ,x_org_id               IN       NUMBER
   )
   IS
   l_return_status   VARCHAR2 (30) := NULL;

Line: 59


      SELECT term.vendor_site_id AS vendor_site_id,
             term.legal_entity_id AS legal_entity_id,
             term.org_id AS org_id
      FROM  pn_payment_terms_all term
      WHERE term.payment_term_id = x_payment_term_id;

Line: 68


      SELECT org_ID
      FROM pn_payment_terms_all
      WHERE payment_term_id = p_term_ID;

Line: 73


      SELECT org_ID
      FROM pn_term_templates_all
      WHERE term_template_id = p_template_ID;

Line: 88


      SELECT count(*) INTO l_count
      FROM   pn_distributions_all pd
      WHERE  pd.payment_term_id = x_payment_term_id;

Line: 100


            UPDATE pn_payment_terms_all
            SET    legal_entity_id   = l_legal_entity_id,
                   last_update_date  = x_last_update_date,
                   last_updated_by   = x_last_updated_by,
                   last_update_login = x_last_update_login
            WHERE payment_term_id = x_payment_term_id;

Line: 111


         SELECT pn_distributions_s.NEXTVAL
           INTO x_distribution_id
           FROM DUAL;

Line: 139


            SELECT NVL(MAX(line_number),0) + 1
              INTO x_line_number
              FROM pn_distributions_all
             WHERE payment_term_id = x_payment_term_id;

Line: 146


            SELECT NVL(MAX(line_number),0) + 1
              INTO x_line_number
              FROM pn_distributions_all
             WHERE term_template_id = x_term_template_id;

Line: 155


      INSERT INTO pn_distributions_all
        (distribution_id
        ,account_id
        ,payment_term_id
        ,term_template_id
        ,account_class
        ,percentage
        ,line_number
        ,last_update_date
        ,last_updated_by
        ,creation_date
        ,created_by
        ,last_update_login
        ,attribute_category
        ,attribute1
        ,attribute2
        ,attribute3
        ,attribute4
        ,attribute5
        ,attribute6
        ,attribute7
        ,attribute8
        ,attribute9
        ,attribute10
        ,attribute11
        ,attribute12
        ,attribute13
        ,attribute14
        ,attribute15
        ,org_id
        )
      VALUES (x_distribution_id
             ,x_account_id
             ,x_payment_term_id
             ,x_term_template_id
             ,x_account_class
             ,x_percentage
             ,x_line_number
             ,x_last_update_date
             ,x_last_updated_by
             ,x_creation_date
             ,x_created_by
             ,x_last_update_login
             ,x_attribute_category
             ,x_attribute1
             ,x_attribute2
             ,x_attribute3
             ,x_attribute4
             ,x_attribute5
             ,x_attribute6
             ,x_attribute7
             ,x_attribute8
             ,x_attribute9
             ,x_attribute10
             ,x_attribute11
             ,x_attribute12
             ,x_attribute13
             ,x_attribute14
             ,x_attribute15
             ,l_org_id
             );

Line: 226


   END insert_row;

Line: 237


PROCEDURE update_row (
      x_rowid                IN   VARCHAR2
     ,x_distribution_id      IN   NUMBER
     ,x_account_id           IN   NUMBER
     ,x_payment_term_id      IN   NUMBER
     ,x_term_template_id     IN   NUMBER
     ,x_account_class        IN   VARCHAR2
     ,x_percentage           IN   NUMBER
     ,x_line_number          IN   NUMBER
     ,x_last_update_date     IN   DATE
     ,x_last_updated_by      IN   NUMBER
     ,x_last_update_login    IN   NUMBER
     ,x_attribute_category   IN   VARCHAR2
     ,x_attribute1           IN   VARCHAR2
     ,x_attribute2           IN   VARCHAR2
     ,x_attribute3           IN   VARCHAR2
     ,x_attribute4           IN   VARCHAR2
     ,x_attribute5           IN   VARCHAR2
     ,x_attribute6           IN   VARCHAR2
     ,x_attribute7           IN   VARCHAR2
     ,x_attribute8           IN   VARCHAR2
     ,x_attribute9           IN   VARCHAR2
     ,x_attribute10          IN   VARCHAR2
     ,x_attribute11          IN   VARCHAR2
     ,x_attribute12          IN   VARCHAR2
     ,x_attribute13          IN   VARCHAR2
     ,x_attribute14          IN   VARCHAR2
     ,x_attribute15          IN   VARCHAR2
     ,x_lease_change_id      IN   NUMBER
   )
   IS

   CURSOR csr_vendor_info IS
    SELECT term.vendor_site_id AS vendor_site_id,
           term.legal_entity_id AS legal_entity_id,
           term.org_id          AS org_id
    FROM  pn_payment_terms_all term
    WHERE  term.payment_term_id = x_payment_term_id;

Line: 283


      SELECT count(*) INTO l_count
      FROM   pn_distributions_all dist,
             pn_payment_terms_all term
      WHERE  dist.payment_term_id  = term.payment_term_id
      AND    term.payment_term_id  = x_payment_term_id
      AND    dist.distribution_id  <> x_distribution_id;

Line: 299


              UPDATE pn_payment_terms_all
              SET    legal_entity_id   = l_legal_entity_id,
                     last_update_date  = x_last_update_date,
                     last_updated_by   = x_last_updated_by,
                     last_update_login = x_last_update_login
              WHERE payment_term_id = x_payment_term_id;

Line: 309


      UPDATE pn_distributions_all
         SET account_id = x_account_id
            ,payment_term_id = x_payment_term_id
            ,term_template_id = x_term_template_id
            ,account_class = x_account_class
            ,percentage = x_percentage
            ,line_number = x_line_number
            ,last_update_date = x_last_update_date
            ,last_updated_by = x_last_updated_by
            ,last_update_login = x_last_update_login
            ,attribute_category = x_attribute_category
            ,attribute1 = x_attribute1
            ,attribute2 = x_attribute2
            ,attribute3 = x_attribute3
            ,attribute4 = x_attribute4
            ,attribute5 = x_attribute5
            ,attribute6 = x_attribute6
            ,attribute7 = x_attribute7
            ,attribute8 = x_attribute8
            ,attribute9 = x_attribute9
            ,attribute10 = x_attribute10
            ,attribute11 = x_attribute11
            ,attribute12 = x_attribute12
            ,attribute13 = x_attribute13
            ,attribute14 = x_attribute14
            ,attribute15 = x_attribute15
       WHERE distribution_id = x_distribution_id;

Line: 343


         UPDATE pn_payment_terms_all
            SET lease_change_id = x_lease_change_id
         WHERE payment_term_id = x_payment_term_id;

Line: 349


 END update_row;

Line: 388


         SELECT        *
         FROM pn_distributions_all
         WHERE distribution_id = x_distribution_id
         FOR UPDATE OF distribution_id NOWAIT;

Line: 446


   PROCEDURE delete_row (x_rowid IN VARCHAR2)
   IS

    l_term_id         pn_payment_terms.payment_term_id%TYPE;

Line: 453


     SELECT term.vendor_site_id,
            term.legal_entity_id,
            term.org_id,
            dist.account_id
       FROM pn_payment_terms_all term,
            pn_distributions_all dist
      WHERE term.payment_term_id = dist.payment_term_id (+)
        AND term.payment_term_id = p_term_id
        AND rownum < 2;

Line: 466


      DELETE FROM pn_distributions_all
            WHERE ROWID = x_rowid
        RETURNING payment_term_id INTO l_term_id;

Line: 489


                UPDATE pn_payment_terms
                   SET legal_entity_id   = l_legal_entity_id,
                       last_update_date  = SYSDATE,
                       last_updated_by   = fnd_global.user_id,
                       last_update_login = fnd_global.login_id
                 WHERE payment_term_id = l_term_id;

Line: 501


   END delete_row;

Line: 511


   PROCEDURE delete_row (x_distribution_id IN NUMBER)
   IS

    l_term_id         pn_payment_terms.payment_term_id%TYPE;

Line: 518


     SELECT term.vendor_site_id,
            term.legal_entity_id,
            term.org_id,
            dist.account_id
       FROM pn_payment_terms_all term,
            pn_distributions_all dist
      WHERE term.payment_term_id = dist.payment_term_id (+)
        AND term.payment_term_id = p_term_id
        AND rownum < 2;

Line: 531


      DELETE FROM pn_distributions_all
            WHERE  distribution_id = x_distribution_id
        RETURNING payment_term_id INTO l_term_id;

Line: 554


                UPDATE pn_payment_terms
                   SET legal_entity_id   = l_legal_entity_id,
                       last_update_date  = SYSDATE,
                       last_updated_by   = fnd_global.user_id,
                       last_update_login = fnd_global.login_id
                 WHERE payment_term_id = l_term_id;

Line: 566


   END delete_row;