eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_AE_LINE_PVT SQL Statements

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

Line: 44


      SELECT OZF_AE_LINES_ALL_s.NEXTVAL
      FROM dual;

Line: 48


      SELECT count(ae_line_id) FROM OZF_AE_LINES_ALL
      WHERE AE_LINE_ID = l_id;

Line: 141


         OZF_AE_LINES_PKG.Insert_Row(
          px_ae_line_id  => l_ae_line_id,
          px_object_version_number  => l_object_version_number,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => SYSDATE,
          p_created_by  => FND_GLOBAL.USER_ID,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          p_request_id  => p_ae_line_tbl(i).request_id,
          p_program_application_id  => p_ae_line_tbl(i).program_application_id,
          p_program_update_date  => p_ae_line_tbl(i).program_update_date,
          p_program_id  => p_ae_line_tbl(i).program_id,
          p_accounted_cr  => p_ae_line_tbl(i).accounted_cr,
          p_accounted_dr  => p_ae_line_tbl(i).accounted_dr,
          p_accounting_error_code  => p_ae_line_tbl(i).accounting_error_code,
          p_ae_header_id  => p_ae_line_tbl(i).ae_header_id,
          p_ae_line_number  => p_ae_line_tbl(i).ae_line_number,
          p_ae_line_type_code  => p_ae_line_tbl(i).ae_line_type_code,
          p_applied_from_trx_hdr_id  => p_ae_line_tbl(i).applied_from_trx_hdr_id,
          p_applied_from_trx_hdr_table  => p_ae_line_tbl(i).applied_from_trx_hdr_table,
          p_applied_to_trx_hdr_id  => p_ae_line_tbl(i).applied_to_trx_hdr_id,
          p_applied_to_trx_hdr_table  => p_ae_line_tbl(i).applied_to_trx_hdr_table,
          p_code_combination_id  => p_ae_line_tbl(i).code_combination_id,
          p_currency_code  => p_ae_line_tbl(i).currency_code,
          p_currency_conversion_date  => p_ae_line_tbl(i).currency_conversion_date,
          p_currency_conversion_rate  => p_ae_line_tbl(i).currency_conversion_rate,
          p_currency_conversion_type  => p_ae_line_tbl(i).currency_conversion_type,
          p_description  => p_ae_line_tbl(i).description,
          p_entered_cr  => p_ae_line_tbl(i).entered_cr,
          p_entered_dr  => p_ae_line_tbl(i).entered_dr,
          p_gl_sl_link_id  => p_ae_line_tbl(i).gl_sl_link_id,
          p_gl_transfer_error_code  => p_ae_line_tbl(i).gl_transfer_error_code,
          px_org_id  => l_org_id,
          p_reference1  => p_ae_line_tbl(i).reference1,
          p_reference2  => p_ae_line_tbl(i).reference2,
          p_reference3  => p_ae_line_tbl(i).reference3,
          p_reference4  => p_ae_line_tbl(i).reference4,
          p_reference5  => p_ae_line_tbl(i).reference5,
          p_reference6  => p_ae_line_tbl(i).reference6,
          p_reference7  => p_ae_line_tbl(i).reference7,
          p_reference8  => p_ae_line_tbl(i).reference8,
          p_reference9  => p_ae_line_tbl(i).reference9,
          p_reference10  => p_ae_line_tbl(i).reference10,
          p_source_id  => p_ae_line_tbl(i).source_id,
          p_source_table  => p_ae_line_tbl(i).source_table,
          p_stat_amount  => p_ae_line_tbl(i).stat_amount,
          p_subledger_doc_sequence_id  => p_ae_line_tbl(i).subledger_doc_sequence_id,
          p_subledger_doc_sequence_value  => p_ae_line_tbl(i).subledger_doc_sequence_value,
          p_taxable_accounted_cr  => p_ae_line_tbl(i).taxable_accounted_cr,
          p_taxable_accounted_dr  => p_ae_line_tbl(i).taxable_accounted_dr,
          p_taxable_entered_cr  => p_ae_line_tbl(i).taxable_entered_cr,
          p_taxable_entered_dr  => p_ae_line_tbl(i).taxable_entered_dr,
          p_tax_code_id  => p_ae_line_tbl(i).tax_code_id,
          p_tax_link_id  => p_ae_line_tbl(i).tax_link_id,
          p_third_party_id  => p_ae_line_tbl(i).third_party_id,
          p_third_party_sub_id  => p_ae_line_tbl(i).third_party_sub_id,
          p_third_party_type  => p_ae_line_tbl(i).third_party_type,
          p_ussgl_transaction_code  => p_ae_line_tbl(i).ussgl_transaction_code,
          p_attribute_category  => p_ae_line_tbl(i).attribute_category,
          p_attribute1  => p_ae_line_tbl(i).attribute1,
          p_attribute2  => p_ae_line_tbl(i).attribute2,
          p_attribute3  => p_ae_line_tbl(i).attribute3,
          p_attribute4  => p_ae_line_tbl(i).attribute4,
          p_attribute5  => p_ae_line_tbl(i).attribute5,
          p_attribute6  => p_ae_line_tbl(i).attribute6,
          p_attribute7  => p_ae_line_tbl(i).attribute7,
          p_attribute8  => p_ae_line_tbl(i).attribute8,
          p_attribute9  => p_ae_line_tbl(i).attribute9,
          p_attribute10  => p_ae_line_tbl(i).attribute10,
          p_attribute11  => p_ae_line_tbl(i).attribute11,
          p_attribute12  => p_ae_line_tbl(i).attribute12,
          p_attribute13  => p_ae_line_tbl(i).attribute13,
          p_attribute14  => p_ae_line_tbl(i).attribute14,
          p_attribute15  => p_ae_line_tbl(i).attribute15);

Line: 286


PROCEDURE Update_Ae_Line(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN  NUMBER       := FND_API.G_VALID_LEVEL_FULL,

    x_return_status              OUT  NOCOPY VARCHAR2,
    x_msg_count                  OUT  NOCOPY NUMBER,
    x_msg_data                   OUT  NOCOPY VARCHAR2,

    p_ae_line_rec               IN    ae_line_rec_type,
    x_object_version_number      OUT  NOCOPY NUMBER
    )

 IS

CURSOR c_get_ae_line(p_ae_line_id NUMBER) IS
    SELECT *
    FROM   OZF_AE_LINES_ALL
    WHERE  ae_line_id = p_ae_line_id;

Line: 307


L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Ae_Line';

Line: 318


      SAVEPOINT UPDATE_Ae_Line_PVT;

Line: 346


        OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 401


        OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

Line: 405


      OZF_AE_LINES_PKG.Update_Row(
          p_ae_line_id  => p_ae_line_rec.ae_line_id,
          p_object_version_number  => p_ae_line_rec.object_version_number,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          p_request_id  => p_ae_line_rec.request_id,
          p_program_application_id  => p_ae_line_rec.program_application_id,
          p_program_update_date  => p_ae_line_rec.program_update_date,
          p_program_id  => p_ae_line_rec.program_id,
          p_accounted_cr  => p_ae_line_rec.accounted_cr,
          p_accounted_dr  => p_ae_line_rec.accounted_dr,
          p_accounting_error_code  => p_ae_line_rec.accounting_error_code,
          p_ae_header_id  => p_ae_line_rec.ae_header_id,
          p_ae_line_number  => p_ae_line_rec.ae_line_number,
          p_ae_line_type_code  => p_ae_line_rec.ae_line_type_code,
          p_applied_from_trx_hdr_id  => p_ae_line_rec.applied_from_trx_hdr_id,
          p_applied_from_trx_hdr_table  => p_ae_line_rec.applied_from_trx_hdr_table,
          p_applied_to_trx_hdr_id  => p_ae_line_rec.applied_to_trx_hdr_id,
          p_applied_to_trx_hdr_table  => p_ae_line_rec.applied_to_trx_hdr_table,
          p_code_combination_id  => p_ae_line_rec.code_combination_id,
          p_currency_code  => p_ae_line_rec.currency_code,
          p_currency_conversion_date  => p_ae_line_rec.currency_conversion_date,
          p_currency_conversion_rate  => p_ae_line_rec.currency_conversion_rate,
          p_currency_conversion_type  => p_ae_line_rec.currency_conversion_type,
          p_description  => p_ae_line_rec.description,
          p_entered_cr  => p_ae_line_rec.entered_cr,
          p_entered_dr  => p_ae_line_rec.entered_dr,
          p_gl_sl_link_id  => p_ae_line_rec.gl_sl_link_id,
          p_gl_transfer_error_code  => p_ae_line_rec.gl_transfer_error_code,
          p_org_id  => p_ae_line_rec.org_id,
          p_reference1  => p_ae_line_rec.reference1,
          p_reference2  => p_ae_line_rec.reference2,
          p_reference3  => p_ae_line_rec.reference3,
          p_reference4  => p_ae_line_rec.reference4,
          p_reference5  => p_ae_line_rec.reference5,
          p_reference6  => p_ae_line_rec.reference6,
          p_reference7  => p_ae_line_rec.reference7,
          p_reference8  => p_ae_line_rec.reference8,
          p_reference9  => p_ae_line_rec.reference9,
          p_reference10  => p_ae_line_rec.reference10,
          p_source_id  => p_ae_line_rec.source_id,
          p_source_table  => p_ae_line_rec.source_table,
          p_stat_amount  => p_ae_line_rec.stat_amount,
          p_subledger_doc_sequence_id  => p_ae_line_rec.subledger_doc_sequence_id,
          p_subledger_doc_sequence_value  => p_ae_line_rec.subledger_doc_sequence_value,
          p_taxable_accounted_cr  => p_ae_line_rec.taxable_accounted_cr,
          p_taxable_accounted_dr  => p_ae_line_rec.taxable_accounted_dr,
          p_taxable_entered_cr  => p_ae_line_rec.taxable_entered_cr,
          p_taxable_entered_dr  => p_ae_line_rec.taxable_entered_dr,
          p_tax_code_id  => p_ae_line_rec.tax_code_id,
          p_tax_link_id  => p_ae_line_rec.tax_link_id,
          p_third_party_id  => p_ae_line_rec.third_party_id,
          p_third_party_sub_id  => p_ae_line_rec.third_party_sub_id,
          p_third_party_type  => p_ae_line_rec.third_party_type,
          p_ussgl_transaction_code  => p_ae_line_rec.ussgl_transaction_code,
          p_attribute_category  => p_ae_line_rec.attribute_category,
          p_attribute1  => p_ae_line_rec.attribute1,
          p_attribute2  => p_ae_line_rec.attribute2,
          p_attribute3  => p_ae_line_rec.attribute3,
          p_attribute4  => p_ae_line_rec.attribute4,
          p_attribute5  => p_ae_line_rec.attribute5,
          p_attribute6  => p_ae_line_rec.attribute6,
          p_attribute7  => p_ae_line_rec.attribute7,
          p_attribute8  => p_ae_line_rec.attribute8,
          p_attribute9  => p_ae_line_rec.attribute9,
          p_attribute10  => p_ae_line_rec.attribute10,
          p_attribute11  => p_ae_line_rec.attribute11,
          p_attribute12  => p_ae_line_rec.attribute12,
          p_attribute13  => p_ae_line_rec.attribute13,
          p_attribute14  => p_ae_line_rec.attribute14,
          p_attribute15  => p_ae_line_rec.attribute15);

Line: 505


     ROLLBACK TO UPDATE_Ae_Line_PVT;

Line: 515


     ROLLBACK TO UPDATE_Ae_Line_PVT;

Line: 525


     ROLLBACK TO UPDATE_Ae_Line_PVT;

Line: 537


End Update_Ae_Line;

Line: 540


PROCEDURE Delete_Ae_Line(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    x_return_status              OUT  NOCOPY VARCHAR2,
    x_msg_count                  OUT  NOCOPY NUMBER,
    x_msg_data                   OUT  NOCOPY VARCHAR2,
    p_ae_line_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Ae_Line';

Line: 559


      SAVEPOINT DELETE_Ae_Line_PVT;

Line: 590


        OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 594


      OZF_AE_LINES_PKG.Delete_Row(
          p_AE_LINE_ID  => p_AE_LINE_ID);

Line: 624


     ROLLBACK TO DELETE_Ae_Line_PVT;

Line: 634


     ROLLBACK TO DELETE_Ae_Line_PVT;

Line: 644


     ROLLBACK TO DELETE_Ae_Line_PVT;

Line: 656


End Delete_Ae_Line;

Line: 680


   SELECT AE_LINE_ID
   FROM OZF_AE_LINES_ALL
   WHERE AE_LINE_ID = p_AE_LINE_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 839


      IF p_ae_line_rec.last_update_date = FND_API.g_miss_date OR p_ae_line_rec.last_update_date IS NULL THEN
         OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );

Line: 846


      IF p_ae_line_rec.last_updated_by = FND_API.g_miss_num OR p_ae_line_rec.last_updated_by IS NULL THEN
         OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );

Line: 924


      IF p_ae_line_rec.last_update_date IS NULL THEN
         OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );

Line: 931


      IF p_ae_line_rec.last_updated_by IS NULL THEN
         OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );

Line: 1073


      SELECT *
      FROM ozf_ae_lines_all
      WHERE ae_line_id = p_ae_line_rec.ae_line_id;

Line: 1102


   IF p_ae_line_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := NULL;

Line: 1105


   IF p_ae_line_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_ae_line_rec.last_update_date;

Line: 1110


   IF p_ae_line_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := NULL;

Line: 1113


   IF p_ae_line_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_ae_line_rec.last_updated_by;

Line: 1134


   IF p_ae_line_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := NULL;

Line: 1137


   IF p_ae_line_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_ae_line_rec.last_update_login;

Line: 1158


   IF p_ae_line_rec.program_update_date = FND_API.g_miss_date THEN
      x_complete_rec.program_update_date := NULL;

Line: 1161


   IF p_ae_line_rec.program_update_date IS NULL THEN
      x_complete_rec.program_update_date := l_ae_line_rec.program_update_date;

Line: 1708


                 p_validation_mode   => JTF_PLSQL_API.g_update,
                 x_return_status     => x_return_status
              );