APPS.PN_REC_EXPCL_DTLACC_PKG SQL Statements

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

Line: 13

PROCEDURE insert_row
      (
             x_org_id                        pn_rec_expcl_dtlacc.org_id%TYPE,
             x_expense_class_line_id         pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
             x_expense_class_line_dtl_id     IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
             x_expense_line_dtl_id           pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
             x_cls_line_dtl_share_pct        pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
             x_cls_line_dtl_share_pct_ovr    pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
             x_cls_line_dtl_fee_bf_ct        pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
             x_cls_line_dtl_fee_bf_ct_ovr    pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
             x_expense_account_id            pn_rec_expcl_dtlacc.expense_account_id%TYPE,
             x_expense_type_code             pn_rec_expcl_dtlacc.expense_type_code%TYPE,
             x_budgeted_amt                  pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
             x_expense_amt                   pn_rec_expcl_dtlacc.expense_amt%TYPE,
             x_recoverable_amt               pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
             x_computed_recoverable_amt      pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
             x_last_update_date              pn_rec_expcl_dtlacc.last_update_date%TYPE,
             x_last_updated_by               pn_rec_expcl_dtlacc.last_updated_by%TYPE,
             x_creation_date                 pn_rec_expcl_dtlacc.creation_date%TYPE,
             x_created_by                    pn_rec_expcl_dtlacc.created_by%TYPE,
             x_last_update_login             pn_rec_expcl_dtlacc.last_update_login%TYPE
       )
IS
   l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.insert_row';

Line: 39

    SELECT org_id
    FROM pn_rec_expcl_dtlln_all
    WHERE expense_class_line_id = x_expense_class_line_id;

Line: 58

   INSERT INTO pn_rec_expcl_dtlacc_all
   (
      org_id,
      expense_class_line_dtl_id,
      expense_class_line_id,
      expense_line_dtl_id,
      cls_line_dtl_share_pct,
      cls_line_dtl_share_pct_ovr,
      cls_line_dtl_fee_bf_contr,
      cls_line_dtl_fee_bf_contr_ovr,
      expense_account_id,
      expense_type_code,
      expense_amt,
      budgeted_amt,
      recoverable_amt,
      computed_recoverable_amt,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login
     )
     VALUES
     (
      l_org_id,
      pn_rec_expcl_dtlacc_s.nextval,
      x_expense_class_line_id,
      x_expense_line_dtl_id,
      x_cls_line_dtl_share_pct,
      x_cls_line_dtl_share_pct_ovr,
      x_cls_line_dtl_fee_bf_ct,
      x_cls_line_dtl_fee_bf_ct_ovr,
      x_expense_account_id,
      x_expense_type_code,
      x_expense_amt,
      x_budgeted_amt,
      x_recoverable_amt,
      x_computed_recoverable_amt,
      x_last_update_date,
      x_last_updated_by,
      x_creation_date,
      x_created_by,
      x_last_update_login
     ) RETURNING expense_class_line_dtl_id INTO x_expense_class_line_dtl_id;

Line: 109

END insert_row;

Line: 119

PROCEDURE update_row(
             x_expense_class_line_dtl_id     pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
             x_expense_line_dtl_id           pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
             x_cls_line_dtl_share_pct        pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
             x_cls_line_dtl_share_pct_ovr    pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
             x_cls_line_dtl_fee_bf_ct        pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
             x_cls_line_dtl_fee_bf_ct_ovr    pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
             x_expense_account_id            pn_rec_expcl_dtlacc.expense_account_id%TYPE,
             x_expense_type_code             pn_rec_expcl_dtlacc.expense_type_code%TYPE,
             x_budgeted_amt                  pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
             x_expense_amt                   pn_rec_expcl_dtlacc.expense_amt%TYPE,
             x_recoverable_amt               pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
             x_computed_recoverable_amt      pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
             x_last_update_date              pn_rec_expcl_dtlacc.last_update_date%TYPE,
             x_last_updated_by               pn_rec_expcl_dtlacc.last_updated_by%TYPE,
             x_creation_date                 pn_rec_expcl_dtlacc.creation_date%TYPE,
             x_created_by                    pn_rec_expcl_dtlacc.created_by%TYPE,
             x_last_update_login             pn_rec_expcl_dtlacc.last_update_login%TYPE)
IS
   l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.update_row';

Line: 143

   UPDATE pn_rec_expcl_dtlacc_all
   SET
      expense_line_dtl_id              = x_expense_line_dtl_id,
      cls_line_dtl_share_pct           = x_cls_line_dtl_share_pct,
      cls_line_dtl_share_pct_ovr       = x_cls_line_dtl_share_pct_ovr,
      cls_line_dtl_fee_bf_contr        = x_cls_line_dtl_fee_bf_ct,
      cls_line_dtl_fee_bf_contr_ovr    = x_cls_line_dtl_fee_bf_ct_ovr,
      expense_account_id               = x_expense_account_id,
      expense_type_code                = x_expense_type_code,
      budgeted_amt                     = x_budgeted_amt,
      expense_amt                      = x_expense_amt,
      recoverable_amt                  = x_recoverable_amt,
      computed_recoverable_amt         = x_computed_recoverable_amt,
      last_update_date                 = x_last_update_date,
      last_updated_by                  = x_last_updated_by,
      creation_date                    = x_creation_date,
      created_by                       = x_created_by,
      last_update_login                = x_last_update_login
   WHERE expense_class_line_dtl_id     = x_expense_class_line_dtl_id;

Line: 169

END update_row;

Line: 179

PROCEDURE delete_row(x_expense_class_line_dtl_id    pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE)
IS
   l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.delete_row';

Line: 186

   DELETE pn_rec_expcl_dtlacc_all
   WHERE  expense_class_line_dtl_id = x_expense_class_line_dtl_id;

Line: 195

END delete_row;