APPS.FII_LOB_ASSIGNMENTS_PKG SQL Statements

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

Line: 3

   PROCEDURE insert_row(x_rowid IN OUT NOCOPY VARCHAR2,
                        x_line_of_business IN VARCHAR2,
                        x_company_cost_center_org_id IN NUMBER,
                        x_last_update_date IN DATE,
                        x_last_updated_by IN NUMBER,
                        x_created_by IN NUMBER,
                        x_creation_date IN DATE,
                        x_last_update_login IN NUMBER)
     IS
       l_last_update_date date;

Line: 13

       l_last_updated_by number(15);

Line: 16

       l_last_update_login number(15);

Line: 18

      l_last_update_date := nvl(x_last_update_date, sysdate);

Line: 19

      l_last_updated_by := nvl(x_last_updated_by, fnd_global.user_id);

Line: 22

      l_last_update_login := nvl(x_last_update_login, fnd_global.login_id);

Line: 24

      INSERT INTO fii_lob_assignments
        (line_of_business, company_cost_center_org_id,
         creation_date, created_by, last_update_date, last_updated_by, last_update_login)
        VALUES
        (x_line_of_business, x_company_cost_center_org_id,
         l_creation_date, l_created_by, l_last_update_date, l_last_updated_by, l_last_update_login)
        RETURN ROWID INTO x_rowid;

Line: 31

   END insert_row;

Line: 33

   PROCEDURE update_row(x_rowid IN VARCHAR2,
                        x_line_of_business IN VARCHAR2,
                        x_company_cost_center_org_id IN NUMBER,
                        x_last_update_date IN DATE,
                        x_last_updated_by IN NUMBER,
                        x_last_update_login IN NUMBER)
     IS
       l_last_update_date date;

Line: 41

       l_last_updated_by number(15);

Line: 42

       l_last_update_login number(15);

Line: 44

      l_last_update_date := nvl(x_last_update_date, sysdate);

Line: 45

      l_last_updated_by := nvl(x_last_updated_by, fnd_global.user_id);

Line: 46

      l_last_update_login := nvl(x_last_update_login, fnd_global.login_id);

Line: 49

         UPDATE fii_lob_assignments
           SET
           company_cost_center_org_id = x_company_cost_center_org_id,
           last_update_date = l_last_update_date,
           last_updated_by = l_last_updated_by,
           last_update_login = l_last_update_login
           WHERE ROWID = x_rowid;

Line: 57

         UPDATE fii_lob_assignments
           SET
           company_cost_center_org_id = x_company_cost_center_org_id,
           last_update_date = l_last_update_date,
           last_updated_by = l_last_updated_by,
           last_update_login = l_last_update_login
           WHERE line_of_business = x_line_of_business;

Line: 69

   END update_row;

Line: 72

   PROCEDURE delete_row(x_rowid IN VARCHAR2,
                        x_line_of_business IN VARCHAR2)
     IS
   BEGIN
      IF x_rowid  IS NOT NULL THEN
         DELETE FROM fii_lob_assignments
           WHERE ROWID = x_rowid;

Line: 80

         DELETE FROM fii_lob_assignments
           WHERE line_of_business = x_line_of_business;

Line: 87

   END delete_row;

Line: 94

           SELECT *
             FROM fii_lob_assignments
             WHERE ROWID = x_rowid
             FOR UPDATE OF company_cost_center_org_id nowait;

Line: 104

         fnd_message.set_name('FND', 'FORM_RECORD_DELETED');