APPS.QPR_DEAL_APPROVALS_PVT dependencies on FND_USER

Line 106: l_fnd_user_id number;

102: function get_approval_record(p_ame_record ame_util.approverRecord2)
103: return approval_record_type
104: is
105: l_approver_rec approval_record_type;
106: l_fnd_user_id number;
107:
108: cursor fnd_user(c_emp_id number) is
109: select user_id
110: from fnd_user

Line 108: cursor fnd_user(c_emp_id number) is

104: is
105: l_approver_rec approval_record_type;
106: l_fnd_user_id number;
107:
108: cursor fnd_user(c_emp_id number) is
109: select user_id
110: from fnd_user
111: where employee_id = c_emp_id;
112: begin

Line 110: from fnd_user

106: l_fnd_user_id number;
107:
108: cursor fnd_user(c_emp_id number) is
109: select user_id
110: from fnd_user
111: where employee_id = c_emp_id;
112: begin
113:
114: --alosh: finding the fnd_user_id

Line 114: --alosh: finding the fnd_user_id

110: from fnd_user
111: where employee_id = c_emp_id;
112: begin
113:
114: --alosh: finding the fnd_user_id
115: if(p_ame_record.orig_system = 'FND_USR')
116: then
117: l_fnd_user_id := p_ame_record.orig_system_id;
118: elsif(p_ame_record.orig_system = 'PER')

Line 117: l_fnd_user_id := p_ame_record.orig_system_id;

113:
114: --alosh: finding the fnd_user_id
115: if(p_ame_record.orig_system = 'FND_USR')
116: then
117: l_fnd_user_id := p_ame_record.orig_system_id;
118: elsif(p_ame_record.orig_system = 'PER')
119: then
120: open fnd_user(p_ame_record.orig_system_id);
121: fetch fnd_user into l_fnd_user_id;

Line 120: open fnd_user(p_ame_record.orig_system_id);

116: then
117: l_fnd_user_id := p_ame_record.orig_system_id;
118: elsif(p_ame_record.orig_system = 'PER')
119: then
120: open fnd_user(p_ame_record.orig_system_id);
121: fetch fnd_user into l_fnd_user_id;
122: close fnd_user;
123: end if;
124:

Line 121: fetch fnd_user into l_fnd_user_id;

117: l_fnd_user_id := p_ame_record.orig_system_id;
118: elsif(p_ame_record.orig_system = 'PER')
119: then
120: open fnd_user(p_ame_record.orig_system_id);
121: fetch fnd_user into l_fnd_user_id;
122: close fnd_user;
123: end if;
124:
125: l_approver_rec.approver_id := l_fnd_user_id;

Line 122: close fnd_user;

118: elsif(p_ame_record.orig_system = 'PER')
119: then
120: open fnd_user(p_ame_record.orig_system_id);
121: fetch fnd_user into l_fnd_user_id;
122: close fnd_user;
123: end if;
124:
125: l_approver_rec.approver_id := l_fnd_user_id;
126: l_approver_rec.approver_name := p_ame_record.name;

Line 125: l_approver_rec.approver_id := l_fnd_user_id;

121: fetch fnd_user into l_fnd_user_id;
122: close fnd_user;
123: end if;
124:
125: l_approver_rec.approver_id := l_fnd_user_id;
126: l_approver_rec.approver_name := p_ame_record.name;
127: l_approver_rec.approval_sequence := p_ame_record.approver_order_number;
128: l_approver_rec.approval_status := p_ame_record.approval_status;
129: l_approver_rec.archive_flag := 'N';

Line 851: from fnd_user

847: l_approval_rec := l_approval_tab(0);
848: else
849: l_approval_rec.approver_id := p_user_id;
850: select user_name into l_approval_rec.approver_name
851: from fnd_user
852: where user_id = p_user_id;
853: end if;
854: l_approval_rec.approval_sequence := -1;
855: l_approval_rec.approval_status := p_action;