APPS.CE_XML_HDRS_INF_PKG SQL Statements

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

Line: 34

                       X_Last_Updated_By       IN OUT  NOCOPY  NUMBER,
                       X_Last_Update_Date      IN OUT  NOCOPY DATE,
                       X_Attribute_Category             VARCHAR2,
                       X_Attribute1                     VARCHAR2,
                       X_Attribute10                    VARCHAR2,
                       X_Attribute11                    VARCHAR2,
                       X_Attribute12                    VARCHAR2,
                       X_Attribute13                    VARCHAR2,
                       X_Attribute14                    VARCHAR2,
                       X_Attribute15                    VARCHAR2,
                       X_Attribute2                     VARCHAR2,
                       X_Attribute3                     VARCHAR2,
                       X_Attribute4                     VARCHAR2,
                       X_Attribute5                     VARCHAR2,
                       X_Attribute6                     VARCHAR2,
                       X_Attribute7                     VARCHAR2,
                       X_Attribute8                     VARCHAR2,
                       X_Attribute9                     VARCHAR2,
                       X_Org_Id                IN OUT  NOCOPY NUMBER,
                       X_Bank_Name             IN OUT  NOCOPY VARCHAR2,
		       X_Int_Calc_Balance		NUMBER,
		       X_Cashflow_Balance		NUMBER) IS

  l_temp		NUMBER;

Line: 70

    DELETE FROM ce_statement_headers_int
    WHERE  bank_account_num = ltrim(rtrim(X_Bank_Account_Num,' '),' ')
    AND    statement_number = ltrim(rtrim(X_Statement_Number,' '),' ');

Line: 74

    SELECT count(BA.ACCOUNT_OWNER_org_id),
           count(BB.bank_name),
           count(BB.bank_branch_name),
           count(BA.currency_code)
    INTO   l_temp, l_temp2, l_temp3, l_temp4
    FROM   CE_BANK_ACCOUNTS BA,
           CE_BANK_BRANCHES_V BB
    WHERE  BA.bank_account_num = X_Bank_Account_Num
    AND    BB.branch_party_id = BA.bank_branch_id;

Line: 85

      SELECT ACCOUNT_OWNER_org_id
      INTO   l_org_id
      FROM   CE_BANK_ACCOUNTS
      WHERE  bank_account_num = X_Bank_Account_Num;

Line: 95

        SELECT bb.bank_name
        INTO   l_bank_name
        FROM   CE_BANK_ACCOUNTS BA,
               CE_BANK_BRANCHES_V BB
        WHERE  BA.bank_account_num = X_Bank_Account_Num
        AND    BB.branch_party_id = BA.bank_branch_id;

Line: 110

        SELECT bb.bank_branch_name
        INTO   l_bank_branch_name
        FROM   CE_BANK_ACCOUNTS BA,
               CE_BANK_BRANCHES_V BB
        WHERE  BA.bank_account_num = X_Bank_Account_Num
        AND    BB.branch_party_id = BA.bank_branch_id;

Line: 125

        SELECT currency_code
        INTO   l_curr_code
        FROM   CE_BANK_ACCOUNTS
        WHERE  bank_account_num = X_Bank_Account_Num;

Line: 136

    INSERT INTO CE_STATEMENT_HEADERS_INT(
		statement_number,
		bank_branch_name,
		bank_account_num,
		statement_date,
		check_digits,
		control_begin_balance,
		control_end_balance,
		control_total_dr,
		control_total_cr,
		control_dr_line_count,
		control_cr_line_count,
		control_line_count,
		record_status_flag,
		currency_code,
		created_by,
		creation_date,
		last_updated_by,
		last_update_date,
		attribute_category,
		attribute1,
		attribute10,
		attribute11,
		attribute12,
		attribute13,
		attribute14,
		attribute15,
		attribute2,
		attribute3,
		attribute4,
		attribute5,
		attribute6,
		attribute7,
		attribute8,
		attribute9,
		bank_name,
		org_id,
		int_calc_balance,
		cashflow_balance
	) VALUES (
		ltrim(rtrim(X_Statement_Number,' '),' '),
		l_bank_branch_name,
		ltrim(rtrim(X_Bank_Account_Num,' '),' '),
		ltrim(rtrim(X_Statement_Date,' '),' '),
		X_Check_Digits,
		X_Control_Begin_Balance,
		X_Control_End_Balance,
		X_Control_Total_Dr,
		X_Control_Total_Cr,
		X_Control_Dr_Line_Count,
		X_Control_Cr_Line_Count,
		X_Control_Line_Count,
		X_Record_Status_Flag,
		l_curr_code,
		-1,
		sysdate,
		-1,
		sysdate,
		X_Attribute_Category,
		X_Attribute1,
		X_Attribute10,
		X_Attribute11,
		X_Attribute12,
		X_Attribute13,
		X_Attribute14,
		X_Attribute15,
		X_Attribute2,
		X_Attribute3,
		X_Attribute4,
		X_Attribute5,
		X_Attribute6,
		X_Attribute7,
		X_Attribute8,
		X_Attribute9,
		l_bank_name,
		l_org_id,
		X_Int_Calc_Balance,
		X_Cashflow_Balance
	);