APPS.AP_CREDIT_CARD_INVOICE_PKG SQL Statements

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

Line: 92

 	l_debugInfo := 'Get Org ID from card program to pass into InsertInvoice*';

Line: 94

        SELECT org_id
        INTO   l_org_id
        FROM   ap_card_programs
        WHERE  card_program_id = p_cardProgramID;

Line: 196

	        l_debugInfo := 'Inserting into AP_INVOICE_LINES_INTERFACE';

Line: 198

		l_result := AP_WEB_DB_AP_INT_PKG.InsertInvoiceLinesInterface(
				l_invoice_id,
				l_invoice_line_id,
				l_count,
				'ITEM',
				l_billed_amt,
				l_transaction_date,
				l_ccid,
				l_card_trxn_id,
                                l_description,
                                l_org_id );

Line: 216

	      l_debugInfo := 'Update AP_CREDIT_CARD_TRXNS_ALL.COMPANY_PREPAID_INVOICE_ID';

Line: 251

        select party_id
        into   l_party_id
        from   ap_suppliers
        where  vendor_id = l_vendor_id
        and    rownum = 1;

Line: 273

	  SELECT party_site_id, nvl(l_accts_pay_ccid,accts_pay_code_combination_id), terms_id
          INTO l_party_site_id, l_accts_pay_ccid, l_terms_id
	  FROM ap_supplier_sites
	  WHERE  vendor_site_id = l_vendor_site_id;

Line: 289

	    SELECT terms_id
	    INTO l_terms_id
	    FROM ap_suppliers
	    WHERE vendor_id = l_vendor_id;

Line: 304

	l_debugInfo := 'Inserting into AP_INVOICES_INTERFACE';

Line: 307

		l_result := AP_WEB_DB_AP_INT_PKG.InsertInvoiceInterface(
			l_invoice_id,
			l_party_id,
			l_vendor_id,
			l_vendor_site_id,
			l_sum,
			l_invoice_currency_code,
			'SelfService',
			l_pay_group_lookup_code,
                        l_org_id,
                        l_doc_cat_code,-- Bug:7345524, replaced 'PAY REQ INV',
                        'PAYMENT REQUEST',
                        l_accts_pay_ccid,
			l_party_site_id,
                        l_terms_id);

Line: 356

             update ap_credit_card_trxns_all
             set    company_prepaid_invoice_id = null
             where  company_prepaid_invoice_id = l_invoice_id_temp -- Bug 6687752
             and    card_program_id = p_cardProgramID;

Line: 362

             delete from ap_interface_rejections
             where  parent_id = l_invoice_id;

Line: 365

             delete from ap_invoices_interface
             where  invoice_id = l_invoice_id;

Line: 368

             delete from ap_invoice_lines_interface
             where  invoice_id = l_invoice_id;

Line: 470

        AP_WEB_WRAPPER_PKG.insert_dist(
                         p_invoice_id              => p_invoiceId,
			 p_Line_Type               => 'MISCELLANEOUS',
                         p_GL_Date                 => p_glDate,
                         p_Period_Name             => p_periodName,
                         p_Type_1099               => null,
                         p_Income_Tax_Region       => null,
                         p_Amount                  => (l_cCardLineAmt),
			 p_Vat_Code                => null,
			 p_Code_Combination_Id     => l_clearingCCID,
			 p_PA_Quantity             => null,
			 p_Description             => null,
                         p_Project_Acct_Cont       => null,
                       	 p_Project_Id          	   => null,
                       	 p_Task_Id             	   => null,
                       	 p_Expenditure_Type    	   => null,
                       	 p_Expenditure_Org_Id  	   => null,
                       	 p_Exp_item_date       	   => null,
                         p_Attribute_Category      => null,
                         p_Attribute1              => null,
                         p_Attribute2              => null,
                         p_Attribute3              => null,
                         p_Attribute4              => null,
                         p_Attribute5              => null,
                         p_Attribute6              => null,
                         p_Attribute7              => null,
                         p_Attribute8              => null,
                         p_Attribute9              => null,
                         p_Attribute10             => null,
                         p_Attribute11             => null,
                         p_Attribute12             => null,
                         p_Attribute13             => null,
                         p_Attribute14             => null,
                         p_Attribute15             => null,
			 p_invoice_distribution_id => null,
			 p_Tax_Code_Id             => null,
			 p_tax_recoverable_flag    => null,
			 p_tax_recovery_rate	   => null,
			 p_tax_code_override_flag  => null,
			 p_tax_recovery_override_flag => null,
			 p_po_distribution_id	   => null,
                         p_Calling_Sequence        => l_callingSequence,
                         p_company_prepaid_invoice_id => l_prepaidInvId,
                         p_cc_reversal_flag        => 'Y');

Line: 521

        l_debugInfo := 'Update the invoice_amount.';

Line: 602

        INSERT INTO AP_INVOICE_LINES_INTERFACE
          (INVOICE_ID,
           INVOICE_LINE_ID,
           LINE_TYPE_LOOKUP_CODE,
           ACCOUNTING_DATE,
           AMOUNT,
           ASSETS_TRACKING_FLAG,
           DIST_CODE_COMBINATION_ID,
           ORG_ID,
	   CC_REVERSAL_FLAG)
          SELECT p_invoiceId,
                 AP_INVOICE_LINES_INTERFACE_S.nextval,
                 'MISCELLANEOUS',
                 p_gl_date,
                 -l_cCardLineAmt,
                 DECODE(nvl(gcc.account_type, 'x'),
                        'A',
                        'Y',
                        'N'),
                 l_clearingCCID,
                 l_org_id,
		 'Y'
            FROM gl_code_combinations GCC
           WHERE GCC.code_combination_id = l_clearingCCID;

Line: 633

      l_debugInfo := 'Update the invoice_amount.';