DBA Data[Home] [Help]

APPS.CN_REASONS_PVT SQL Statements

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

Line: 23

   INSERT INTO cn_process_audit_lines(
   	process_audit_id,process_audit_line_id,
	message_type_code,message_text)
   VALUES(
        cn_process_audits_s.nextval,cn_process_audit_lines_s1.NEXTVAL,
	'cnnotes',i_value);
Line: 33

      INSERT INTO cn_process_audit_lines(
   	process_audit_id,process_audit_line_id,
	message_type_code,message_text)
      VALUES(
        cn_process_audits_s.nextval,cn_process_audit_lines_s1.NEXTVAL,
	'cnnotes',l_error);
Line: 42

PROCEDURE insert_row(
   	p_api_version     	IN	NUMBER,
   	p_init_msg_list         IN      VARCHAR2 	:= FND_API.G_TRUE,
   	p_validation_level      IN      VARCHAR2 	:= FND_API.G_VALID_LEVEL_FULL,
	p_commit	    	IN  	VARCHAR2 	:= CN_API.G_FALSE,
	p_reasons_all_rec 	IN 	CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
	x_return_status         OUT NOCOPY     VARCHAR2,
   	x_msg_count             OUT NOCOPY     NUMBER,
   	x_msg_data              OUT NOCOPY     VARCHAR2,
   	x_loading_status        OUT NOCOPY     VARCHAR2) IS
   --
   l_api_name		CONSTANT VARCHAR2(30) := 'insert_row';
Line: 59

   SAVEPOINT insert_row;
Line: 73

   x_loading_status := 'CN_INSERTED';
Line: 78

      SELECT cn_reasons_s.NEXTVAL
        INTO l_reasons_all_rec.reason_id
	FROM DUAL;
Line: 88

       (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
       (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
      IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
	 FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
Line: 97

      cn_reasons_pkg.insert_row(l_reasons_all_rec);
Line: 101

      ROLLBACK TO insert_row;
Line: 108

      ROLLBACK TO insert_row;
Line: 116

      ROLLBACK TO insert_row;
Line: 129

PROCEDURE update_row(
   	p_api_version     	IN	NUMBER,
   	p_init_msg_list         IN      VARCHAR2 	:= FND_API.G_TRUE,
   	p_validation_level      IN      VARCHAR2 	:= FND_API.G_VALID_LEVEL_FULL,
	p_commit	    	IN  	VARCHAR2 	:= CN_API.G_FALSE,
	p_reasons_all_rec 	IN 	CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
	x_return_status         OUT NOCOPY     VARCHAR2,
   	x_msg_count             OUT NOCOPY     NUMBER,
   	x_msg_data              OUT NOCOPY     VARCHAR2,
   	x_loading_status        OUT NOCOPY     VARCHAR2) IS
   --
   CURSOR reason_cur(l_reason_id NUMBER) IS
      SELECT *
        FROM cn_reasons r
       WHERE r.reason_id = l_reason_id;
Line: 145

   l_api_name		CONSTANT VARCHAR2(30) := 'update_row';
Line: 155

   SAVEPOINT update_row;
Line: 169

   x_loading_status := 'CN_INSERTED';
Line: 176

       (l_reasons_all_rec.updated_table = fnd_api.g_miss_char) OR
       (l_reasons_all_rec.upd_table_id = fnd_api.g_miss_num)) THEN
      IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
	 FND_MESSAGE.SET_NAME ('CN' , 'CN_REQUIRED_FIELDS');
Line: 189

         l_history_rec.updated_table		:= rec.updated_table;
Line: 192

         l_history_rec.dml_flag			:= 'UPDATE';
Line: 194

         l_history_rec.update_flag		:= rec.lookup_type;
Line: 217

	 SELECT cn_reason_history_s.NEXTVAL
	   INTO l_history_rec.reason_history_id
	   FROM dual;
Line: 221

	 cn_reason_history_pkg.insert_row(l_history_rec);
Line: 223

         cn_reasons_pkg.lock_update_row(l_reasons_all_rec);
Line: 229

      ROLLBACK TO update_row;
Line: 236

      ROLLBACK TO update_row;
Line: 244

      ROLLBACK TO update_row;
Line: 257

PROCEDURE delete_notes(
   	p_api_version     	IN	NUMBER,
   	p_init_msg_list         IN      VARCHAR2 	:= FND_API.G_TRUE,
   	p_validation_level      IN      VARCHAR2 	:= FND_API.G_VALID_LEVEL_FULL,
	p_commit	    	IN  	VARCHAR2 	:= CN_API.G_FALSE,
	p_reason_id		IN	NUMBER		:= FND_API.G_MISS_NUM,
	x_return_status         OUT NOCOPY     VARCHAR2,
   	x_msg_count             OUT NOCOPY     NUMBER,
   	x_msg_data              OUT NOCOPY     VARCHAR2,
   	x_loading_status        OUT NOCOPY     VARCHAR2) IS
   --
   CURSOR reason_cur(l_reason_id NUMBER) IS
      SELECT *
        FROM cn_reasons r
       WHERE r.reason_id = l_reason_id;
Line: 273

   l_api_name		CONSTANT VARCHAR2(30) := 'delete_notes';
Line: 282

   SAVEPOINT delete_notes;
Line: 296

   x_loading_status := 'CN_INSERTED';
Line: 310

      l_history_rec.updated_table	:= rec.updated_table;
Line: 313

      l_history_rec.dml_flag		:= 'DELETE';
Line: 315

      l_history_rec.update_flag		:= rec.lookup_type;
Line: 338

      SELECT cn_reason_history_s.NEXTVAL
	INTO l_history_rec.reason_history_id
	FROM dual;
Line: 342

      cn_reason_history_pkg.insert_row(l_history_rec);
Line: 344

      cn_reasons_pkg.delete_row(p_reason_id);
Line: 349

      ROLLBACK TO update_row;
Line: 356

      ROLLBACK TO update_row;
Line: 364

      ROLLBACK TO update_row;
Line: 377

PROCEDURE delete_worksheet_notes(
   	p_api_version     	IN	NUMBER,
   	p_init_msg_list         IN      VARCHAR2 	:= FND_API.G_TRUE,
   	p_validation_level      IN      VARCHAR2 	:= FND_API.G_VALID_LEVEL_FULL,
	p_commit	    	IN  	VARCHAR2 	:= CN_API.G_FALSE,
	p_payment_worksheet_id	IN	NUMBER		:= FND_API.G_MISS_NUM,
	x_return_status         OUT NOCOPY     VARCHAR2,
   	x_msg_count             OUT NOCOPY     NUMBER,
   	x_msg_data              OUT NOCOPY     VARCHAR2,
   	x_loading_status        OUT NOCOPY     VARCHAR2) IS
   --
   CURSOR reason_cur IS
      SELECT reason_id
        FROM cn_reasons
       WHERE upd_table_id = p_payment_worksheet_id;
Line: 394

      SELECT reason_history_id
        FROM cn_reason_history
       WHERE upd_table_id = p_payment_worksheet_id;
Line: 398

   l_api_name		CONSTANT VARCHAR2(30) := 'delete_worksheet_notes';
Line: 403

   SAVEPOINT delete_worksheet_notes;
Line: 417

   x_loading_status := 'CN_INSERTED';
Line: 429

      cn_reason_history_pkg.delete_row(history_rec.reason_history_id);
Line: 434

      cn_reasons_pkg.delete_row(reason_rec.reason_id);
Line: 439

      ROLLBACK TO delete_worksheet_notes;
Line: 446

      ROLLBACK TO delete_worksheet_notes;
Line: 454

      ROLLBACK TO delete_worksheet_notes;