APPS.IGW_PROP_NARRATIVES_PVT SQL Statements

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

Line: 61

         igw_prop_narratives_tbh.insert_row(
          	 x_rowid			=>	x_rowid
          	,P_PROPOSAL_ID 			=>	P_PROPOSAL_ID
 		,P_MODULE_TITLE			=>	P_MODULE_TITLE
 		,P_MODULE_STATUS		=>	P_MODULE_STATUS
 		,P_CONTACT_NAME			=>	P_CONTACT_NAME
 		,P_PHONE_NUMBER			=>	P_PHONE_NUMBER
 		,P_EMAIL_ADDRESS		=>	P_EMAIL_ADDRESS
 		,P_COMMENTS			=>	P_COMMENTS
    		,p_mode				=>      'R'
    		,x_return_status		=>	x_return_status);

Line: 120

Procedure update_prop_narrative (
 p_init_msg_list                  IN 		VARCHAR2   := FND_API.G_FALSE,
 p_commit                         IN 		VARCHAR2   := FND_API.G_FALSE,
 p_validate_only                  IN 		VARCHAR2   := FND_API.G_FALSE,
 x_rowid 		          IN 		VARCHAR2,
 P_PROPOSAL_ID                    in	 	NUMBER,
 P_MODULE_ID                      in		NUMBER,
 P_MODULE_TITLE                   in		VARCHAR2,
 P_MODULE_STATUS                  in		VARCHAR2,
 P_CONTACT_NAME                   in            VARCHAR2,
 P_PHONE_NUMBER                   in            VARCHAR2,
 P_EMAIL_ADDRESS                  in            VARCHAR2,
 P_COMMENTS                       in            VARCHAR2,
 p_record_version_number          IN 		NUMBER,
 x_return_status                  OUT NOCOPY 		VARCHAR2,
 x_msg_count                      OUT NOCOPY 		NUMBER,
 x_msg_data                       OUT NOCOPY 		VARCHAR2)  is

  STATUS_OF_NARRATIVES       VARCHAR2(1);

Line: 150

        SAVEPOINT update_prop_narrative;

Line: 183

                        igw_prop_narratives_tbh.update_row (
                                    	 x_rowid			 =>	x_rowid
              				,P_PROPOSAL_ID       		 =>	P_PROPOSAL_ID
 					,P_MODULE_ID			 =>	P_MODULE_ID
 					,P_MODULE_TITLE 		 =>	P_MODULE_TITLE
 					,P_MODULE_STATUS            	 =>	P_MODULE_STATUS
 					,P_CONTACT_NAME  		 =>	P_CONTACT_NAME
 					,P_PHONE_NUMBER 		 =>	P_PHONE_NUMBER
 					,P_EMAIL_ADDRESS  		 =>	P_EMAIL_ADDRESS
 					,P_COMMENTS   			 =>	P_COMMENTS
              				,p_mode 			 =>	'R'
              				,p_record_version_number	 =>	p_record_version_number
              				,x_return_status		 =>	x_return_status);

Line: 217

              ROLLBACK TO update_prop_narrative;

Line: 228

              ROLLBACK TO update_prop_narrative;

Line: 234

                            p_procedure_name    =>    'UPDATE_PROP_NARRATIVE',
                            p_error_text        =>     SUBSTRB(SQLERRM,1,240));

Line: 241

END  update_prop_narrative;

Line: 244

Procedure delete_prop_narrative (
  p_init_msg_list                IN   		VARCHAR2   := FND_API.G_FALSE
 ,p_commit                       IN   		VARCHAR2   := FND_API.G_FALSE
 ,p_validate_only                IN   		VARCHAR2   := FND_API.G_FALSE
 ,x_rowid 			 IN 		VARCHAR2
 ,p_proposal_id			 IN             NUMBER
 ,p_record_version_number        IN   		NUMBER
 ,x_return_status                OUT NOCOPY  		VARCHAR2
 ,x_msg_count                    OUT NOCOPY  		NUMBER
 ,x_msg_data                     OUT NOCOPY  		VARCHAR2)  is

  STATUS_OF_NARRATIVES       VARCHAR2(1);

Line: 268

       SAVEPOINT delete_prop_narrative;

Line: 300

      select module_id into l_module_id from igw_prop_narratives where rowid = x_rowid;

Line: 302

     igw_prop_narratives_tbh.delete_row(
      	     x_rowid			=>	x_rowid,
	     p_record_version_number	=>	p_record_version_number,
             x_return_status		=>	x_return_status);

Line: 308

     FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS('IGW_PROP_NARRATIVES',
                                                    p_proposal_id, l_module_id);

Line: 331

              ROLLBACK TO delete_prop_narrative;

Line: 342

              ROLLBACK TO delete_prop_narrative;

Line: 348

                            p_procedure_name    =>    'DELETE_PROP_NARRATIVE',
                            p_error_text        =>     SUBSTRB(SQLERRM,1,240));

Line: 354

END delete_prop_narrative;

Line: 357

Procedure update_narrative_type_code (
 p_init_msg_list                  IN 		VARCHAR2   := FND_API.G_FALSE,
 p_commit                         IN 		VARCHAR2   := FND_API.G_FALSE,
 p_validate_only                  IN 		VARCHAR2   := FND_API.G_FALSE,
 P_PROPOSAL_ID                    in	 	NUMBER,
 P_NARRATIVE_TYPE_CODE            in            VARCHAR2,
 P_NARRATIVE_SUBMISSION_CODE      in            VARCHAR2,
 x_return_status                  OUT NOCOPY 		VARCHAR2,
 x_msg_count                      OUT NOCOPY 		NUMBER,
 x_msg_data                       OUT NOCOPY 		VARCHAR2)  is

  l_return_status            VARCHAR2(1);

Line: 378

        SAVEPOINT update_narrative_type_code;

Line: 404

                  UPDATE IGW_PROPOSALS_ALL
                  SET NARRATIVE_TYPE_CODE = P_NARRATIVE_TYPE_CODE,
                  NARRATIVE_SUBMISSION_CODE = P_NARRATIVE_SUBMISSION_CODE
                  WHERE PROPOSAL_ID = P_PROPOSAL_ID;

Line: 428

              ROLLBACK TO update_narrative_type_code;

Line: 439

              ROLLBACK TO update_narrative_type_code;

Line: 445

                            p_procedure_name    =>    'UPDATE_PROP_NARRATIVE',
                            p_error_text        =>     SUBSTRB(SQLERRM,1,240));

Line: 452

END  update_narrative_type_code;

Line: 461

   select proposal_id
   into l_proposal_id
   from igw_prop_narratives
   where rowid = x_rowid
   and record_version_number = p_record_version_number;