DBA Data[Home] [Help]

APPS.PA_MC_INVOICE_DETAIL_PKG SQL Statements

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

Line: 14

     L_PROG_UPDATE_DATE        PA_PLSQL_DATATYPES.Char30TabTyp;
Line: 217

     	PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Before Insert...');
Line: 233

     L_PROG_UPDATE_DATE(K)
                 := to_char(P_inv_rec_tab(I).PROGRAM_UPDATE_DATE,'YYYY/MM/DD');
Line: 257

PROCEDURE Insert_rows
           ( P_inv_rec_tab          IN   PA_INVOICE_DETAIL_PKG.inv_rec_tab)
IS
 l_tot_count   NUMBER;
Line: 267

 	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert...');
Line: 277

 	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert..'||to_char(l_tot_count));
Line: 280

 /* If MRC records are created, insert in PA_MC_DRAFT_INV_DETAILS */
 if (l_tot_count > 0)
 Then
  IF g1_debug_mode  = 'Y' THEN
  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Before Insert...');
Line: 290

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Details Id'||to_char(L_DRAFT_INV_DET_ID(I)));
Line: 294

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));
Line: 298

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced  Flag'||L_INVOICED_FLAG(I));
Line: 302

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));
Line: 306

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));
Line: 310

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));
Line: 314

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));
Line: 318

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));
Line: 322

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));
Line: 323

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Exchg Rate '||L_ACCT_EXCHANGE_RATE(I));
Line: 330

  /* Array Insert of MRC records */
  FOR  I IN 1..l_tot_count
  LOOP
  /* Added the following if condition to stop inserting into pa_mc_draft_inv_details_all
     table when bill_amount is zero, as we don't insert into pa_draft_invoice_details_all when bill_amount is zero- Bug 2739218  */
     IF L_BILL_AMOUNT(I) <> 0
     THEN
  NULL;
Line: 343

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'End Insert...');
Line: 351

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert Error..'|| to_char(c));
Line: 355

END Insert_rows;
Line: 359

PROCEDURE Insert_rows
           ( P_inv_rec_tab          IN   PA_INVOICE_DETAIL_PKG.inv_rec_tab,
             P_trx_date             IN   PA_PLSQL_DATATYPES.DateTabTyp)
IS
 l_tot_count   NUMBER;
Line: 369

 	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert...');
Line: 378

 	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert..'||to_char(l_tot_count));
Line: 380

 /* If MRC records are created, insert in PA_MC_DRAFT_INV_DETAILS */
 if (l_tot_count > 0)
 Then
  IF g1_debug_mode  = 'Y' THEN
  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Before Insert...');
Line: 391

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Details Id'||to_char(L_DRAFT_INV_DET_ID(I)));
Line: 395

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));
Line: 399

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced  Flag'||L_INVOICED_FLAG(I));
Line: 403

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));
Line: 407

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));
Line: 411

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));
Line: 415

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));
Line: 419

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));
Line: 423

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));
Line: 424

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Exchg Rate '||L_ACCT_EXCHANGE_RATE(I));
Line: 430

  /* Array Insert of MRC records */
  IF g1_debug_mode  = 'Y' THEN
  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'End Insert...');
Line: 440

  	PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert Error..'|| to_char(c));
Line: 444

END Insert_rows;
Line: 446

PROCEDURE Update_rows
           ( P_inv_rec_tab            IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
             P_mrc_reqd_flag          IN PA_PLSQL_DATATYPES.Char1TabTyp)
IS
 l_tot_count  NUMBER;
Line: 455

 	PA_IC_INV_UTILS.log_message('Update_rows: ' || 'In MRC Update...');
Line: 470

END Update_rows;
Line: 472

PROCEDURE Delete_rows
           ( P_inv_rec_tab             IN   PA_INVOICE_DETAIL_PKG.inv_rec_tab)
IS
 l_draft_line_id     PA_PLSQL_DATATYPES.numtabtyp;
Line: 479

 	PA_IC_INV_UTILS.log_message('Delete_rows: ' || 'In MRC Delete...');
Line: 493

END Delete_rows;