APPS.GMD_QC_MIGRATE_TO_1151J dependencies on FND_USER

Line 3979: Cursor fnd_user(l_user Varchar2) IS

3975: and column_name='SAMPLE_TYPE'
3976: and owner = l_gmd;
3977:
3978: -- PK Bug 4898620
3979: Cursor fnd_user(l_user Varchar2) IS
3980: Select User_id from fnd_user where user_name = l_user;
3981:
3982: l_sample_approver varchar2(30);
3983: l_inv_approver varchar2(30);

Line 3980: Select User_id from fnd_user where user_name = l_user;

3976: and owner = l_gmd;
3977:
3978: -- PK Bug 4898620
3979: Cursor fnd_user(l_user Varchar2) IS
3980: Select User_id from fnd_user where user_name = l_user;
3981:
3982: l_sample_approver varchar2(30);
3983: l_inv_approver varchar2(30);
3984:

Line 4520: OPEN fnd_user(smpl_rec.sample_final_approver);

4516:
4517: -- PK Bug 4898620 Approvers in QC are saved as Usernames. Need to find IDs.
4518:
4519: IF ( smpl_rec.sample_final_approver IS NOT NULL) THEN
4520: OPEN fnd_user(smpl_rec.sample_final_approver);
4521: Fetch fnd_user INTO l_inv_approver ;
4522: Close fnd_user ;
4523: ELSE
4524: l_inv_approver := NULL;

Line 4521: Fetch fnd_user INTO l_inv_approver ;

4517: -- PK Bug 4898620 Approvers in QC are saved as Usernames. Need to find IDs.
4518:
4519: IF ( smpl_rec.sample_final_approver IS NOT NULL) THEN
4520: OPEN fnd_user(smpl_rec.sample_final_approver);
4521: Fetch fnd_user INTO l_inv_approver ;
4522: Close fnd_user ;
4523: ELSE
4524: l_inv_approver := NULL;
4525: END IF;

Line 4522: Close fnd_user ;

4518:
4519: IF ( smpl_rec.sample_final_approver IS NOT NULL) THEN
4520: OPEN fnd_user(smpl_rec.sample_final_approver);
4521: Fetch fnd_user INTO l_inv_approver ;
4522: Close fnd_user ;
4523: ELSE
4524: l_inv_approver := NULL;
4525: END IF;
4526:

Line 4528: OPEN fnd_user(smpl_rec.sample_test_approver);

4524: l_inv_approver := NULL;
4525: END IF;
4526:
4527: IF ( smpl_rec.sample_test_approver IS NOT NULL) THEN
4528: OPEN fnd_user(smpl_rec.sample_test_approver);
4529: Fetch fnd_user INTO l_sample_approver ;
4530: Close fnd_user ;
4531: ELSE
4532: l_sample_approver := NULL;

Line 4529: Fetch fnd_user INTO l_sample_approver ;

4525: END IF;
4526:
4527: IF ( smpl_rec.sample_test_approver IS NOT NULL) THEN
4528: OPEN fnd_user(smpl_rec.sample_test_approver);
4529: Fetch fnd_user INTO l_sample_approver ;
4530: Close fnd_user ;
4531: ELSE
4532: l_sample_approver := NULL;
4533: END IF;

Line 4530: Close fnd_user ;

4526:
4527: IF ( smpl_rec.sample_test_approver IS NOT NULL) THEN
4528: OPEN fnd_user(smpl_rec.sample_test_approver);
4529: Fetch fnd_user INTO l_sample_approver ;
4530: Close fnd_user ;
4531: ELSE
4532: l_sample_approver := NULL;
4533: END IF;
4534: