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.IGC_CC_MC_MAIN_PVT SQL Statements

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

Line: 8


                         PROCEDURE Insert_Row => IGC_CC_MC_HEADERS
   ===============================================================================*/

PROCEDURE get_rsobs_Headers (
   p_api_version         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_CC_Header_Id        IN     NUMBER,
   p_Set_Of_Books_Id     IN     NUMBER,
   l_Application_Id      IN     NUMBER,
   p_org_id              IN     NUMBER,
   l_Conversion_Date     IN     DATE,
   l_flag                IN     VARCHAR2
) IS

   l_sob_list            gl_mc_info.r_sob_list := gl_mc_info.r_sob_list();

Line: 41


     SELECT conversion_type
       FROM gl_mc_reporting_options
      WHERE primary_set_of_books_id   = p_Set_Of_Books_Id
        AND reporting_set_of_books_id = l_rsob_id
        AND ORG_ID                    = p_Org_Id
        AND application_id            = l_Application_Id; */

Line: 48


     SELECT ALC_DEFAULT_CONV_RATE_TYPE
       FROM GL_ALC_LEDGER_RSHIPS_V
      WHERE primary_ledger_id   = p_Set_Of_Books_Id
        AND ledger_id = l_rsob_id
        --AND ORG_ID                    = p_Org_Id
        AND application_id            = l_Application_Id;

Line: 146


               IGC_CC_MC_HEADERS_PKG.Insert_Row (
                             l_api_version,
                             FND_API.G_FALSE,
                             FND_API.G_FALSE,
                             FND_API.G_VALID_LEVEL_FULL,
                             l_return_status,
                             X_msg_count,
                             X_msg_data,
                             l_row_id,
                             p_CC_Header_Id,
                             l_sob_list(rec1).r_sob_id,
                             l_Conversion_Type,
                             l_Conversion_Date,
                             l_conversion_Rate
                           );

Line: 178


               SELECT rowid
                 INTO l_row_id
                 FROM igc_cc_mc_headers
                WHERE cc_header_id    = p_CC_Header_Id
                  AND set_of_books_id = l_sob_list(rec1).r_sob_id;

Line: 184


               IGC_CC_MC_HEADERS_PKG.Update_Row (
                             l_api_version,
                             FND_API.G_FALSE,
                             FND_API.G_FALSE,
                             FND_API.G_VALID_LEVEL_FULL,
                             l_return_status,
                             X_msg_count,
                             X_msg_data,
                             l_row_id,
                             p_CC_Header_Id,
                             l_sob_list(rec1).r_sob_id,
                             l_Conversion_Type,
                             l_Conversion_Date,
                             l_conversion_Rate
                            );

Line: 211


            END IF;  -- Insert / Update Flag

Line: 279


                         PROCEDURE Insert_Row => IGC_CC_MC_ACCT_LINES
   ===============================================================================*/

PROCEDURE get_rsobs_Acct_Lines (
   p_api_version            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_CC_Acct_Line_Id        IN     NUMBER,
   p_Set_Of_Books_Id        IN     NUMBER,
   l_Application_Id         IN     NUMBER,
   p_org_id                 IN     NUMBER,
   l_Conversion_Date        IN     DATE,
   p_CC_Acct_Func_Amt       IN     NUMBER,
   p_CC_Acct_Encmbrnc_Amt   IN     NUMBER,
   p_CC_Func_Withheld_Amt   IN     NUMBER,
   l_flag                   IN     VARCHAR2
) IS

   l_sob_list             gl_mc_info.r_sob_list := gl_mc_info.r_sob_list();

Line: 318


     SELECT conversion_type
       FROM gl_mc_reporting_options
      WHERE primary_set_of_books_id   = p_Set_Of_Books_Id
        AND reporting_set_of_books_id = l_rsob_id
        AND ORG_ID                    = p_Org_Id
        AND application_id            = l_Application_Id;*/

Line: 325


     SELECT ALC_DEFAULT_CONV_RATE_TYPE
       FROM GL_ALC_LEDGER_RSHIPS_V
      WHERE primary_ledger_id   = p_Set_Of_Books_Id
        AND ledger_id = l_rsob_id
       -- AND ORG_ID                    = p_Org_Id
        AND application_id            = l_Application_Id;

Line: 440


               IGC_CC_MC_ACCT_LINES_PKG.Insert_Row (
                             l_api_version,
                             FND_API.G_FALSE,
                             FND_API.G_FALSE,
                             FND_API.G_VALID_LEVEL_FULL,
                             l_return_status,
                             X_msg_count,
                             X_msg_data,
                             l_row_id,
                             p_CC_Acct_Line_Id,
                             l_sob_list(rec1).r_sob_id,
                             l_CC_Acct_Func_Amt,
                             l_CC_Acct_Encmbrnc_Amt,
                             l_Conversion_Type,
                             l_Conversion_Date,
                             l_conversion_Rate,
                             l_cc_func_withheld_amt
                           );

Line: 475


               SELECT rowid
                 INTO l_row_id
                 FROM igc_cc_mc_acct_lines
                WHERE cc_acct_line_id = p_CC_Acct_Line_Id
                  AND set_of_books_id = l_sob_list(rec1).r_sob_id;

Line: 481


               IGC_CC_MC_ACCT_LINES_PKG.Delete_Row (
                             l_api_version,
                             FND_API.G_FALSE,
                             FND_API.G_FALSE,
                             FND_API.G_VALID_LEVEL_FULL,
                             l_return_status,
                             X_msg_count,
                             X_msg_data,
                             l_row_id
                           );

Line: 508


               SELECT rowid
                 INTO l_row_id
                 FROM igc_cc_mc_acct_lines
                WHERE cc_acct_line_id = p_CC_Acct_Line_Id
                  AND set_of_books_id = l_sob_list(rec1).r_sob_id;

Line: 514


               IGC_CC_MC_ACCT_LINES_PKG.Update_Row (
                             l_api_version,
                             FND_API.G_FALSE,
                             FND_API.G_FALSE,
                             FND_API.G_VALID_LEVEL_FULL,
                             l_return_status,
                             X_msg_count,
                             X_msg_data,
                             l_row_id,
                             p_CC_Acct_Line_Id,
                             l_sob_list(rec1).r_sob_id,
                             l_CC_Acct_Func_Amt,
                             l_CC_Acct_Encmbrnc_Amt,
                             l_Conversion_Type,
                             l_Conversion_Date,
                             l_conversion_Rate,
                             l_cc_func_withheld_amt
                           );

Line: 544


            END IF;  -- Insert / Update Flag

Line: 614


                         PROCEDURE Insert_Row => IGC_CC_MC_DET_PF
   ===============================================================================*/

PROCEDURE get_rsobs_DET_PF (
   p_api_version             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_CC_DET_PF_Line_Id       IN       NUMBER,
   p_Set_Of_Books_Id         IN       NUMBER,
   l_Application_Id          IN       NUMBER,
   p_org_id                  IN       NUMBER,
   l_Conversion_Date         IN       DATE,
   p_CC_Det_Pf_Func_Amt      IN       NUMBER,
   p_CC_Det_Pf_ENCMBRNC_AMT  IN       NUMBER,
   l_flag                    IN       VARCHAR2
) IS

   l_sob_list                   gl_mc_info.r_sob_list := gl_mc_info.r_sob_list();

Line: 651


     SELECT conversion_type
       FROM gl_mc_reporting_options
      WHERE primary_set_of_books_id   = p_Set_Of_Books_Id
        AND reporting_set_of_books_id = l_rsob_id
        AND ORG_ID                    = p_Org_Id
        AND application_id            = l_Application_Id; */

Line: 658


     SELECT ALC_DEFAULT_CONV_RATE_TYPE
       FROM GL_ALC_LEDGER_RSHIPS_V
      WHERE primary_ledger_id   = p_Set_Of_Books_Id
        AND ledger_id = l_rsob_id
       -- AND ORG_ID                    = p_Org_Id
        AND application_id            = l_Application_Id;

Line: 771


               IGC_CC_MC_DET_PF_PKG.Insert_Row (
                             l_api_version,
                             FND_API.G_FALSE,
                             FND_API.G_FALSE,
                             FND_API.G_VALID_LEVEL_FULL,
                             l_return_status,
                             X_msg_count,
                             X_msg_data,
                             l_row_id,
                             p_CC_Det_PF_Line_Id,
                             l_sob_list(rec1).r_sob_id,
                             l_CC_Det_PF_Func_Amt,
                             l_CC_Det_PF_Encmbrnc_Amt,
                             l_Conversion_Type,
                             l_Conversion_Date,
                             l_conversion_Rate
                           );

Line: 805


               SELECT rowid
                 INTO l_row_id
                 FROM igc_cc_mc_det_pf
                WHERE cc_det_pf_line_id = p_CC_Det_PF_Line_Id
                  AND set_of_books_id   = l_sob_list(rec1).r_sob_id;

Line: 811


               IGC_CC_MC_DET_PF_PKG.Delete_Row (
                             l_api_version,
                             FND_API.G_FALSE,
                             FND_API.G_FALSE,
                             FND_API.G_VALID_LEVEL_FULL,
                             l_return_status,
                             X_msg_count,
                             X_msg_data,
                             l_row_id
                           );

Line: 838


               SELECT rowid
                 INTO l_row_id
                 FROM igc_cc_mc_det_pf
                WHERE cc_det_pf_line_id = p_CC_Det_PF_Line_Id
                  AND set_of_books_id   = l_sob_list(rec1).r_sob_id;

Line: 844


               IGC_CC_MC_DET_PF_PKG.Update_Row (
                             l_api_version,
                             FND_API.G_FALSE,
                             FND_API.G_FALSE,
                             FND_API.G_VALID_LEVEL_FULL,
                             l_return_status,
                             X_msg_count,
                             X_msg_data,
                             l_row_id,
                             p_CC_Det_PF_Line_Id,
                             l_sob_list(rec1).r_sob_id,
                             l_CC_Det_PF_Func_Amt,
                             l_CC_Det_PF_Encmbrnc_Amt,
                             l_Conversion_Type,
                             l_Conversion_Date,
                             l_conversion_Rate
                           );

Line: 873


            END IF;  -- Insert / Update Flag