APPS.AP_PA_API_PKG SQL Statements

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

Line: 11

	Cursor select_org_id is
	  SELECT org_id
	  FROM ap_invoices_all
          WHERE invoice_id = P_Invoice_Id;

Line: 16

	OPEN select_org_id;

Line: 17

	FETCH select_org_id INTO l_org_Id;

Line: 18

	close select_org_id;

Line: 33

         SELECT 'Y'
         FROM   ap_invoice_payments_all
         WHERE  invoice_id = P_invoice_id
         AND    nvl(discount_taken,0) <> 0;

Line: 52

     FUNCTION selected_for_payment_flag (P_invoice_id IN number) RETURN varchar2
     IS
       l_flag varchar2(1) := 'N';

Line: 55

       cursor selected_for_payment_cursor is
         SELECT 'Y'
         FROM   ap_selected_invoices_all
         WHERE  invoice_id = P_invoice_id;

Line: 62

        open selected_for_payment_cursor;

Line: 63

        fetch selected_for_payment_cursor into l_flag;

Line: 64

        close selected_for_payment_cursor;

Line: 68

     END selected_for_payment_flag;

Line: 79

         SELECT 'Y'
           FROM ap_invoice_payments_all
          WHERE invoice_id = P_invoice_id;

Line: 134

	SELECT CANCELLED_DATE,
	       CANCELLED_BY,
	       PAYMENT_STATUS_FLAG,
	       ALLOW_PAID_INVOICE_ADJUST,
	       INVOICE_TYPE_LOOKUP_CODE
	INTO   var_cancelled_date,
	       var_cancelled_by,
	       var_payment_status_flag,
	       var_allow_paid_invoice_adjust,
	       var_invoice_type_lookup_code
	FROM   ap_invoices_all, ap_system_parameters_all
	WHERE  nvl(ap_system_parameters_all.org_id,-999) = nvl(AP_PA_API_PKG.get_org_id(X_Invoice_Id),-999)
	AND    invoice_id = X_Invoice_Id;

Line: 148

       SELECT  count(*)
       INTO    accrue_on_receipt_num
       FROM    po_distributions_ap_v POD, ap_invoice_distributions AID
       WHERE   POD.po_distribution_id = AID.po_distribution_id
       AND     AID.invoice_id = X_invoice_id
       AND     POD.accrue_on_receipt_flag = 'Y';

Line: 155

       SELECT  count(*)
       INTO   closed_po_num
       FROM   po_headers POH, po_distributions_ap_v POD, ap_invoice_distributions AID
       WHERE  POH.po_header_id = POD.po_header_id
       AND    POD.po_distribution_id = AID.po_distribution_id
       AND    AID.invoice_id = X_invoice_id
       AND    POH.closed_code = 'FINALLY CLOSED';

Line: 165

      If Selected_for_Payment_Flag(X_invoice_Id) = 'Y' THEN
		Return('PA_INV_SEL_PAYMENT');

Line: 187

	Elsif  Selected_for_Payment_Flag(X_invoice_Id) = 'Y' THEN
	       return('PA_INV_SEL_PAYMENT');

Line: 217

   SELECT account_type
   INTO   l_account_type
   FROM   gl_code_combinations
   WHERE  code_combination_id = p_ccid ;

Line: 269

     SELECT ATC.column_name
     INTO l_column_name
     FROM sys.all_tab_columns ATC
     WHERE ATC.table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
     AND ATC.column_name = 'AMOUNT_VARIANCE';

Line: 290

     'SELECT NVL(amount_variance,0), NVL(base_amount_variance,0)
     FROM ap_invoice_distributions_all
     WHERE invoice_id ='|| p_invoice_id ||
     'AND invoice_distribution_id ='|| p_invoice_distribution_id ;