APPS.AP_DUPLICATE_VENDORS_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,

                       X_Entry_Id                       NUMBER DEFAULT NULL,
                       X_Vendor_Id                      NUMBER DEFAULT NULL,
                       X_Duplicate_Vendor_Id            NUMBER DEFAULT NULL,
                       X_Vendor_Site_Id                 NUMBER DEFAULT NULL,
                       X_Duplicate_Vendor_Site_Id       NUMBER DEFAULT NULL,
                       X_Number_Unpaid_Invoices         NUMBER DEFAULT NULL,
                       X_Number_Paid_Invoices           NUMBER DEFAULT NULL,
                       X_Number_Po_Headers_Changed      NUMBER DEFAULT NULL,
                       X_Amount_Unpaid_Invoices         NUMBER DEFAULT NULL,
                       X_Amount_Paid_Invoices           NUMBER DEFAULT NULL,
                       X_Last_Update_Date               DATE DEFAULT NULL,
                       X_Last_Updated_By                NUMBER DEFAULT NULL,
                       X_Process_Flag                   VARCHAR2 DEFAULT NULL,
                       X_Process                        VARCHAR2 DEFAULT NULL,
                       X_Keep_Site_Flag                 VARCHAR2 DEFAULT NULL,
                       X_Paid_Invoices_Flag             VARCHAR2 DEFAULT NULL,
                       X_Last_Update_Login              NUMBER DEFAULT NULL,
                       X_Creation_Date                  DATE DEFAULT NULL,
                       X_Created_By                     NUMBER DEFAULT NULL,
                       X_Org_Id                         NUMBER,
		       X_calling_sequence	IN	VARCHAR2
  ) IS
    CURSOR C IS SELECT rowid FROM AP_DUPLICATE_VENDORS
                 WHERE (   (entry_id = X_Entry_Id)
                        or (entry_id is NULL and X_Entry_Id is NULL));

Line: 38

       current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.INSERT_ROW<-' ||
                                    X_calling_sequence;

Line: 41

       debug_info := 'Insert into AP_DUPLICATE_VENDORS';

Line: 42

       INSERT INTO AP_DUPLICATE_VENDORS(

              entry_id,
              vendor_id,
              duplicate_vendor_id,
              vendor_site_id,
              duplicate_vendor_site_id,
              number_unpaid_invoices,
              number_paid_invoices,
              number_po_headers_changed,
              amount_unpaid_invoices,
              amount_paid_invoices,
              last_update_date,
              last_updated_by,
              process_flag,
              process,
              keep_site_flag,
              paid_invoices_flag,
              last_update_login,
              creation_date,
              created_by,
              org_id
             ) VALUES (

              X_Entry_Id,
              X_Vendor_Id,
              X_Duplicate_Vendor_Id,
              X_Vendor_Site_Id,
              X_Duplicate_Vendor_Site_Id,
              X_Number_Unpaid_Invoices,
              X_Number_Paid_Invoices,
              X_Number_Po_Headers_Changed,
              X_Amount_Unpaid_Invoices,
              X_Amount_Paid_Invoices,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Process_Flag,
              X_Process,
              X_Keep_Site_Flag,
              X_Paid_Invoices_Flag,
              X_Last_Update_Login,
              X_Creation_Date,
              X_Created_By,
              X_Org_Id
             );

Line: 112

  END Insert_Row;

Line: 135

        SELECT *
        FROM   AP_DUPLICATE_VENDORS
        WHERE  rowid = X_Rowid
        FOR UPDATE of Entry_Id NOWAIT;

Line: 157

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 237

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,

                       X_Entry_Id                       NUMBER DEFAULT NULL,
                       X_Vendor_Id                      NUMBER DEFAULT NULL,
                       X_Duplicate_Vendor_Id            NUMBER DEFAULT NULL,
                       X_Vendor_Site_Id                 NUMBER DEFAULT NULL,
                       X_Duplicate_Vendor_Site_Id       NUMBER DEFAULT NULL,
                       X_Number_Unpaid_Invoices         NUMBER DEFAULT NULL,
                       X_Number_Paid_Invoices           NUMBER DEFAULT NULL,
                       X_Number_Po_Headers_Changed      NUMBER DEFAULT NULL,
                       X_Amount_Unpaid_Invoices         NUMBER DEFAULT NULL,
                       X_Amount_Paid_Invoices           NUMBER DEFAULT NULL,
                       X_Last_Update_Date               DATE DEFAULT NULL,
                       X_Last_Updated_By                NUMBER DEFAULT NULL,
                       X_Process_Flag                   VARCHAR2 DEFAULT NULL,
                       X_Process                        VARCHAR2 DEFAULT NULL,
                       X_Keep_Site_Flag                 VARCHAR2 DEFAULT NULL,
                       X_Paid_Invoices_Flag             VARCHAR2 DEFAULT NULL,
                       X_Last_Update_Login              NUMBER DEFAULT NULL,
                       X_Org_Id                         NUMBER,
		       X_calling_sequence	IN	VARCHAR2

  ) IS

    current_calling_sequence    VARCHAR2(2000);

Line: 268

    current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.UPDATE_ROW<-' ||
                                 X_calling_sequence;

Line: 271

    debug_info := 'Update AP_DUPLICATE_VENDORS';

Line: 273

    UPDATE AP_DUPLICATE_VENDORS
    SET
       entry_id                        =     X_Entry_Id,
       vendor_id                       =     X_Vendor_Id,
       duplicate_vendor_id             =     X_Duplicate_Vendor_Id,
       vendor_site_id                  =     X_Vendor_Site_Id,
       duplicate_vendor_site_id        =     X_Duplicate_Vendor_Site_Id,
       number_unpaid_invoices          =     X_Number_Unpaid_Invoices,
       number_paid_invoices            =     X_Number_Paid_Invoices,
       number_po_headers_changed       =     X_Number_Po_Headers_Changed,
       amount_unpaid_invoices          =     X_Amount_Unpaid_Invoices,
       amount_paid_invoices            =     X_Amount_Paid_Invoices,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       process_flag                    =     X_Process_Flag,
       process                         =     X_Process,
       keep_site_flag                  =     X_Keep_Site_Flag,
       paid_invoices_flag              =     X_Paid_Invoices_Flag,
       last_update_login               =     X_Last_Update_Login,
       org_id                          =     X_Org_Id
    WHERE rowid = X_Rowid;

Line: 311

  END Update_Row;

Line: 313

  PROCEDURE Delete_Row(X_Rowid 				VARCHAR2,
		       X_calling_sequence	IN	VARCHAR2
  ) IS

    current_calling_sequence    VARCHAR2(2000);

Line: 324

    current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.DELETE_ROW<-' ||
                                 X_calling_sequence;

Line: 327

    debug_info := 'Delete from AP_DUPLICATE_VENDORS';

Line: 328

    DELETE FROM AP_DUPLICATE_VENDORS
    WHERE rowid = X_Rowid;

Line: 346

  END Delete_Row;