APPS.PSB_WS_MATRIX SQL Statements

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

Line: 60

      Update psb_worksheet_context
      Set
    	    stage = p_stage,
	    account_flag = l_account_flag,
	    year1_id = p1_year_id,
	    year2_id = p2_year_id,
	    year3_id = p3_year_id,
	    year4_id = p4_year_id,
	    year5_id = p5_year_id,
	    year6_id = p6_year_id,
	    year7_id = p7_year_id,
	    year8_id = p8_year_id,
	    year9_id = p9_year_id,
	    year10_id = p10_year_id,
	    year11_id = p11_year_id,
	    year12_id = p12_year_id,
	    amount1_type = p1_amount_type,
	    amount2_type = p2_amount_type,
	    amount3_type = p3_amount_type,
	    amount4_type = p4_amount_type,
	    amount5_type = p5_amount_type,
	    amount6_type = p6_amount_type,
	    amount7_type = p7_amount_type,
	    amount8_type = p8_amount_type,
	    amount9_type = p9_amount_type,
	    amount10_type = p10_amount_type,
	    amount11_type = p11_amount_type,
	    amount12_type = p12_amount_type,
	    total_flag = p_total_flag
      Where worksheet_id = p_worksheet_id
            and session_id = p_session_id;

Line: 94

        Insert Into psb_worksheet_context
        (
	  session_id       ,
	  worksheet_id     ,
	  stage            ,
	  account_flag     ,
	  year1_id         ,
	  year2_id         ,
	  year3_id         ,
	  year4_id         ,
	  year5_id         ,
	  year6_id         ,
	  year7_id         ,
	  year8_id         ,
	  year9_id         ,
	  year10_id        ,
	  year11_id        ,
	  year12_id        ,
	  amount1_type     ,
	  amount2_type     ,
	  amount3_type     ,
	  amount4_type     ,
	  amount5_type     ,
	  amount6_type     ,
	  amount7_type     ,
	  amount8_type     ,
	  amount9_type     ,
	  amount10_type    ,
	  amount11_type    ,
	  amount12_type    ,
	  total_flag
        )
        Values
        (
          p_session_id   ,
          p_worksheet_id ,
          p_stage        ,
          p_account_flag ,
	  p1_year_id     ,
	  p2_year_id     ,
	  p3_year_id     ,
	  p4_year_id     ,
	  p5_year_id     ,
	  p6_year_id     ,
	  p7_year_id     ,
	  p8_year_id     ,
	  p9_year_id     ,
	  p10_year_id    ,
	  p11_year_id    ,
	  p12_year_id    ,
	  p1_amount_type ,
	  p2_amount_type ,
	  p3_amount_type ,
	  p4_amount_type ,
	  p5_amount_type ,
	  p6_amount_type ,
	  p7_amount_type ,
	  p8_amount_type ,
	  p9_amount_type ,
	  p10_amount_type,
	  p11_amount_type,
	  p12_amount_type,
	  p_total_flag
        );

Line: 443

 This procedure deletes session information for a
 worksheet from PSB_WORKSHEET_CONTEXT  */

PROCEDURE Delete_Session_Information
 (
    p_worksheet_id IN NUMBER,
    p_session_id   IN NUMBER
 )
 IS
 BEGIN
  SAVEPOINT DELETE_SESSION;

Line: 455

    delete from psb_worksheet_context
      where session_id = p_session_id;

Line: 463

      ROLLBACK to DELETE_SESSION;

Line: 465

 END delete_session_information;