APPS.CSF_DEBRIEF_PUB SQL Statements

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

Line: 40

	l_pvt_Debrief_rec.last_Update_date			:=    p_Debrief_rec.last_update_date;

Line: 58

      l_pvt_Debrief_rec.last_updated_by    :=  p_Debrief_rec.last_updated_by;

Line: 59

      l_pvt_Debrief_rec.last_update_date   :=  p_Debrief_rec.last_update_date;

Line: 60

      l_pvt_Debrief_rec.last_update_login  :=  p_Debrief_rec.last_update_login;

Line: 78

/********************  need to be deleted later

PROCEDURE Convert_Interest_Values_To_Ids (p_interest_type                 IN  VARCHAR2,
                                            p_interest_type_id              IN  NUMBER,
                                            p_primary_interest_code         IN  VARCHAR2,
                                            p_primary_interest_code_id      IN  NUMBER,
                                            p_secondary_interest_code       IN  VARCHAR2,
                                            p_secondary_interest_code_id    IN  NUMBER,
                                            p_return_status                 OUT NOCOPY VARCHAR2,
                                            p_out_interest_type_id          OUT NOCOPY NUMBER,
                                            p_out_primary_interest_code_id  OUT NOCOPY NUMBER,
                                            p_out_second_interest_code_id   OUT NOCOPY NUMBER
                                            ) IS
    Cursor C_Get_Int_Type (X_Int_Type VARCHAR2) IS
      SELECT  interest_type_id
      FROM  as_interest_types
      WHERE nls_upper(X_Int_Type) = nls_upper(interest_type)
      and (interest_type like nls_upper(substr(X_Int_Type, 1, 1) || '%') or
         interest_type like lower(substr(X_Int_Type, 1, 1) || '%'));

Line: 99

      SELECT  interest_code_id
      FROM  as_interest_codes
     WHERE nls_upper(X_Int_Code) = nls_upper(code)
      and   interest_type_id = X_Int_Type_Id;

Line: 297

x_pvt_DEBRIEF_LINE_tbl(l_curr_row).LAST_UPDATE_DATE 	:= P_DEBRIEF_LINE_Rec.LAST_UPDATE_DATE;

Line: 298

x_pvt_DEBRIEF_LINE_tbl(l_curr_row).LAST_UPDATED_BY 	:= P_DEBRIEF_LINE_Rec.LAST_UPDATED_BY;

Line: 301

x_pvt_DEBRIEF_LINE_tbl(l_curr_row).LAST_UPDATE_LOGIN 	:= P_DEBRIEF_LINE_Rec.LAST_UPDATE_LOGIN;

Line: 353

x_pvt_DEBRIEF_LINE_tbl(l_curr_row).IB_UPDATE_STATUS		:= P_DEBRIEF_LINE_Rec.IB_UPDATE_STATUS;

Line: 354

x_pvt_DEBRIEF_LINE_tbl(l_curr_row).IB_UPDATE_MSG_CODE		:= P_DEBRIEF_LINE_Rec.IB_UPDATE_MSG_CODE;

Line: 355

x_pvt_DEBRIEF_LINE_tbl(l_curr_row).IB_UPDATE_MESSAGE 		:= P_DEBRIEF_LINE_Rec.IB_UPDATE_MESSAGE ;

Line: 356

x_pvt_DEBRIEF_LINE_tbl(l_curr_row).SPARE_UPDATE_STATUS	:= P_DEBRIEF_LINE_Rec.SPARE_UPDATE_STATUS;

Line: 357

x_pvt_DEBRIEF_LINE_tbl(l_curr_row).SPARE_UPDATE_MSG_CODE
							:= P_DEBRIEF_LINE_Rec.SPARE_UPDATE_MSG_CODE;

Line: 359

x_pvt_DEBRIEF_LINE_tbl(l_curr_row).SPARE_UPDATE_MESSAGE
								:= P_DEBRIEF_LINE_Rec.SPARE_UPDATE_MESSAGE;

Line: 520

PROCEDURE Update_debrief(
    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_DEBRIEF_Rec             IN   DEBRIEF_Rec_Type ,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_debrief';

Line: 535

      SAVEPOINT UPDATE_DEBRIEF_PUB;

Line: 563

    CSF_DEBRIEF_PVT.Update_debrief(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
    P_DEBRIEF_Rec             	=> l_pvt_DEBRIEF_Rec ,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 593

		    ROLLBACK TO  UPDATE_DEBRIEF_PUB;

Line: 600

		    ROLLBACK TO  UPDATE_DEBRIEF_PUB;

Line: 607

		    ROLLBACK TO  UPDATE_DEBRIEF_PUB;

Line: 621

End Update_debrief;

Line: 738

PROCEDURE Update_debrief_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_Upd_tskassgnstatus        IN VARCHAR2   ,
    P_Task_Assignment_status     IN VARCHAR2  ,
    P_DEBRIEF_LINE_Rec        	IN   DEBRIEF_LINE_Rec_Type,
    X_Return_Status              	OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  	OUT NOCOPY  NUMBER,
    X_Msg_Data                   	OUT NOCOPY  VARCHAR2
    )
 IS
l_api_name                 CONSTANT VARCHAR2(30) := 'Update_debrief_line';

Line: 757

      SAVEPOINT UPDATE_DEBRIEF_LINE_PUB;

Line: 793

    CSF_DEBRIEF_PVT.Update_debrief_line(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Upd_tskassgnstatus        =>  P_Upd_tskassgnstatus         ,
    P_Task_Assignment_status     =>  P_Task_Assignment_status     ,
    P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
    P_DEBRIEF_LINE_Rec        => l_pvt_DEBRIEF_LINE_tbl(1),
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 829

		    ROLLBACK TO  UPDATE_DEBRIEF_LINE_PUB;

Line: 836

		    ROLLBACK TO  UPDATE_DEBRIEF_LINE_PUB;

Line: 843

		    ROLLBACK TO  UPDATE_DEBRIEF_LINE_PUB;

Line: 857

End Update_debrief_line;

Line: 867

         SELECT hook_package, hook_api
           FROM jtf_hooks_data
          WHERE package_name = p_package_name
            AND api_name = p_api_name
            AND execute_flag = 'Y'
            AND processing_type = p_processing_type
          ORDER BY execution_order;