APPS.CN_REASONS_PUB SQL Statements

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

Line: 25

   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: 35

      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: 63

      SELECT w.payment_worksheet_id,w.role_id,w.worksheet_status,
             p.name,p.payrun_id,p.pay_period_id,p.status,
             ps.period_name,s.salesrep_id,s.resource_id,s.name,
             s.employee_number,pg.pay_group_id,pg.name
        FROM cn_payruns p,
             cn_payment_worksheets w,
             cn_salesreps s,
             cn_period_statuses ps,
             cn_pay_groups pg
       WHERE p.payrun_id = w.payrun_id
         AND w.salesrep_id = s.salesrep_id
         AND p.pay_period_id = ps.period_id
         AND pg.pay_group_id = p.pay_group_id
	 AND w.payment_worksheet_id = p_payment_worksheet_id;

Line: 79

      SELECT r.*, u.user_name,l.meaning
        FROM cn_reasons r,fnd_user u,cn_lookups l
       WHERE upd_table_id 	= p_payment_worksheet_id
         AND r.lookup_type 	= p_lookup_type
	 AND updated_table 	= p_table_name
	 AND r.last_updated_by 	= u.user_id
	 AND r.reason_code 	= l.lookup_code
	 AND l.lookup_type 	= p_lookup_type
       ORDER BY r.last_update_date;

Line: 113

   x_loading_status := 'CN_INSERTED';

Line: 128

         x_notes_tbl(l_tbl_count).updated_table		:= rec.updated_table;

Line: 133

	 x_notes_tbl(l_tbl_count).update_flag		:= rec.update_flag;

Line: 150

         x_notes_tbl(l_tbl_count).last_update_date	:= rec.last_update_date;

Line: 151

         x_notes_tbl(l_tbl_count).last_updated_by	:= rec.last_updated_by;

Line: 152

         x_notes_tbl(l_tbl_count).last_updated_username	:= rec.user_name;

Line: 223

   x_loading_status := 'CN_INSERTED';

Line: 231

	       l_reasons_all_rec.update_flag	:= 'N';

Line: 233

	       l_reasons_all_rec.update_flag	:= 'Y';

Line: 236

            l_reasons_all_rec.updated_table	:= p_notes_tbl(i).updated_table;

Line: 259

	    IF (p_notes_tbl(i).dml_flag = 'INSERT') THEN
               cn_reasons_pvt.insert_row(
      		  p_api_version 	=> l_api_version,
		  p_init_msg_list	=> p_init_msg_list,
     		  p_validation_level	=> p_validation_level,
		  p_commit		=> p_commit,
		  p_reasons_all_rec	=> l_reasons_all_rec,
		  x_return_status	=> x_return_status,
		  x_msg_count		=> x_msg_count,
		  x_msg_data		=> x_msg_data,
		  x_loading_status	=> x_loading_status);

Line: 270

	    ELSIF (p_notes_tbl(i).dml_flag = 'UPDATE') THEN
               cn_reasons_pvt.update_row(
      		  p_api_version 	=> l_api_version,
		  p_init_msg_list	=> p_init_msg_list,
     		  p_validation_level	=> p_validation_level,
		  p_commit		=> p_commit,
		  p_reasons_all_rec	=> l_reasons_all_rec,
		  x_return_status	=> x_return_status,
		  x_msg_count		=> x_msg_count,
		  x_msg_data		=> x_msg_data,
		  x_loading_status	=> x_loading_status);

Line: 352

   x_loading_status := 'CN_INSERTED';

Line: 354

   cn_reasons_pvt.delete_notes(
      	p_api_version 		=> l_api_version,
	p_init_msg_list		=> p_init_msg_list,
     	p_validation_level	=> p_validation_level,
	p_commit		=> p_commit,
	p_reason_id		=> p_reason_id,
	x_return_status		=> x_return_status,
	x_msg_count		=> x_msg_count,
	x_msg_data		=> x_msg_data,
	x_loading_status	=> x_loading_status);

Line: 421

                            p_table_name cn_reasons.updated_table%TYPE)
    IS
        SELECT COUNT(1) cnt
        FROM cn_reasons r
        WHERE r.upd_table_id 	= p_payment_worksheet_id
        AND r.lookup_type 	= p_lookup_type
        AND r.updated_table 	= p_table_name;

Line: 431

                            p_table_name cn_reasons.updated_table%TYPE)
    IS
        SELECT v.*
        FROM
        (
        SELECT r.*, u.user_name,l.meaning
        FROM cn_reasons r,fnd_user u,cn_lookups l
        WHERE upd_table_id 	= p_payment_worksheet_id
        AND r.lookup_type 	= p_lookup_type
        AND updated_table 	= p_table_name
        AND r.last_updated_by 	= u.user_id
        AND r.reason_code 	= l.lookup_code
        AND l.lookup_type 	= p_lookup_type
        ORDER BY r.last_update_date desc
        ) v
        WHERE ROWNUM < 2;

Line: 472

   x_loading_status := 'CN_INSERTED';

Line: 487

         x_notes_tbl(l_tbl_count).updated_table		:= rec.updated_table;

Line: 492

	 x_notes_tbl(l_tbl_count).update_flag		:= rec.update_flag;

Line: 509

         x_notes_tbl(l_tbl_count).last_update_date	:= rec.last_update_date;

Line: 510

         x_notes_tbl(l_tbl_count).last_updated_by	:= rec.last_updated_by;

Line: 511

         x_notes_tbl(l_tbl_count).last_updated_username	:= rec.user_name;