APPS.IGS_AS_GR_WF_PKG SQL Statements

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

Line: 13

PROCEDURE   Select_Approver (
                                                       Itemtype        IN           VARCHAR2,
                                                       Itemkey         IN           VARCHAR2,
                                                       Actid                IN           NUMBER,
                                                       Funcmode       IN           VARCHAR2,
                                                       Resultout        OUT NOCOPY        VARCHAR2
                                                     )
/*=============================================================================================================+
 |
 | Change History
 | Who	     When			What
 | Aiyer     07-25-2002                 Fix done for the bug 2403814.
 |                                      Populate the workflow requestor item_attribute when a lead instructor record
 |                                      has not set up in the system.
 ===============================================================================================================+*/
IS

CURSOR c_set_requestor (cp_requestor_id FND_USER.person_party_id%TYPE)
IS
     SELECT
             user_name
     FROM
            fnd_user
     WHERE
            person_party_id = cp_requestor_id;

Line: 41

     SELECT
             pur.instructor_id    instructor_id,
	     fu.user_name         user_name
     FROM
            igs_ps_usec_tch_resp  pur,
            fnd_user              fu
     WHERE
	    fu.person_party_id           = pur.instructor_id
     AND
            pur.lead_instructor_flag = 'Y'
     AND
            pur.uoo_id               = cp_uoo_id;

Line: 54

l_api_name                   CONSTANT VARCHAR2(30)       := 'Select_Approver' ;

Line: 63

  SAVEPOINT Select_Approver;

Line: 122

     ROLLBACK TO Select_Approver;

Line: 129

END Select_Approver ;