APPS.IGI_ITR_APPROVAL_PKG SQL Statements

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

Line: 35

  SELECT nvl(authorization_limit, 0)
  INTO   l_limit
  FROM   GL_AUTHORIZATION_LIMITS
  WHERE  employee_id = p_employee_id
    AND  ledger_id = p_set_of_books_id;

Line: 93

        UPDATE igi_itr_charge_lines
        SET    status_flag = 'W'
              ,submit_date = sysdate
        WHERE  it_header_id = p_cc_id
        AND    it_line_num  = p_cc_line_num;

Line: 102

        SELECT IGI_ITR_APPROVAL_SS_S.nextval
        INTO   l_approval_run_id
        FROM   SYS.DUAL;

Line: 157

	SELECT employee_id
	INTO   l_preparer_id
	FROM   fnd_user
	WHERE  user_id = p_preparer_fnd_user_id;

Line: 207

        	SELECT employee_id
        	INTO   l_sec_approver_id
        	FROM   fnd_user
        	WHERE  user_id = p_sec_apprv_fnd_id;

Line: 323

    SELECT set_of_books_id
      INTO l_set_of_books_id
      FROM igi_itr_charge_headers
     WHERE it_header_id = l_cross_charge_id;

Line: 330

    SELECT currency_Code
    INTO   l_func_currency
    FROM   gl_sets_of_books
    WHERE  set_of_books_id = l_set_of_books_id;

Line: 339

    SELECT nvl(auto_approve_exceed_days,7)
    INTO   l_timeout_days
    FROM   igi_itr_charge_setup
    WHERE  set_of_books_id = l_set_of_books_id;

Line: 434

      SELECT  abs(nvl(itrl.entered_dr, 0) - nvl(itrl.entered_cr, 0))
             ,itrl.it_service_line_id
             ,cc.name
             ,servi.name
       INTO   l_cc_line_tot
             ,l_service_line_id
             ,l_charge_center_name
             ,l_charge_service_name
      FROM    igi_itr_charge_lines itrl
             ,igi_itr_service servi
             ,igi_itr_charge_center cc
             ,igi_itr_charge_service serv
      WHERE  itrl.it_header_id = l_cross_charge_id
        AND  itrl.it_line_num = l_cc_line_num
        AND  cc.charge_center_id = itrl.charge_center_id
        AND  serv.charge_service_id = itrl.charge_service_id
        AND  itrl.service_id = servi.service_id
        AND  servi.service_id = serv.service_id
        AND  serv.charge_center_id = cc.charge_center_id;

Line: 610

PROCEDURE secondary_approver_selected(itemtype	IN VARCHAR2,
		                      itemkey  	IN VARCHAR2,
		                      actid   	IN NUMBER,
		                      funcmode	IN VARCHAR2,
                                      result     OUT NOCOPY VARCHAR2 ) IS
l_sec_approver_fnd_id  NUMBER;

Line: 636

    Wf_Core.Context('IGI_ITR_APPROVAL_PKG', 'secondary_approver_selected', itemtype, itemkey);

Line: 641

               FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.secondary_approver_selected',TRUE);

Line: 644

END secondary_approver_selected;

Line: 727

    SELECT max(sequence_num) + 1
    INTO   l_sequence_num
    FROM   igi_itr_action_history
    WHERE  it_service_line_id = l_service_line_id;

Line: 751

    igi_itr_action_history_ss_pkg.insert_row(
                   X_Service_Line_Id   => l_service_line_id
                  ,X_Sequence_Num      => l_sequence_num
                  ,X_Action_Code       => l_action_code
                  ,X_Action_Date       => sysdate
                  ,X_Employee_Id       => l_performer_id
                  ,X_Use_Workflow_Flag => 'Y'
                  ,X_Note              => null
                  ,X_Created_By        => l_user_id
                  ,X_Creation_Date     => sysdate
                  ,X_Last_Update_Login => l_login_id
                  ,X_Last_Update_Date  => sysdate
                  ,X_Last_Updated_By   => l_user_id);

Line: 814

    UPDATE IGI_ITR_CHARGE_LINES
    SET status_flag  = 'V'
    WHERE  it_header_id = l_cross_charge_id
    AND    it_line_num = l_cc_line_num;

Line: 869

    UPDATE  IGI_ITR_CHARGE_LINES
    SET     status_flag  = 'J'
    WHERE   it_header_id = l_cross_charge_id
    AND     it_line_num = l_cc_line_num;

Line: 938

      SELECT auth.authoriser_id
      INTO   l_rec_fnd_user_id
      FROM   igi_itr_charge_ranges auth
            ,igi_itr_charge_lines itrl
      WHERE  itrl.it_header_id = l_cross_charge_id
      AND    itrl.it_line_num = l_cc_line_num
      AND    itrl.charge_range_id = auth.charge_range_id;

Line: 956

	SELECT employee_id
	INTO   l_receiver_id
	FROM   fnd_user
	WHERE  user_id = l_rec_fnd_user_id;

Line: 1090

    SELECT nvl(use_double_timeout_flag,'N')
    INTO   l_use_double_timeout
    FROM   igi_itr_charge_setup
    WHERE  set_of_books_id = l_set_of_books_id;

Line: 1307

    UPDATE IGI_ITR_CHARGE_LINES
    SET    status_flag  = 'A'
    WHERE  it_header_id = l_cross_charge_id
    AND    it_line_num = l_cc_line_num;

Line: 1320

   IGIGITCH.update_header_status(l_cross_charge_id);

Line: 1367

    UPDATE IGI_ITR_CHARGE_LINES
    SET    status_flag  = 'R'
    WHERE  it_header_id = l_cross_charge_id
    AND    it_line_num = l_cc_line_num;

Line: 1403

  SELECT supervisor_id
  INTO   manager_id
  FROM   GL_HR_EMPLOYEES_CURRENT_V
  WHERE  employee_id =  l_employee_id;

Line: 1690

       SELECT find_approver_method
       INTO   l_find_approver_method
       FROM   igi_itr_charge_setup
       WHERE  set_of_books_id = l_sob_id;