APPS.ONT_ICP_GET_USER_DETAILS dependencies on FND_USER

Line 16: CURSOR c_fnd_user IS

12: out_status OUT NOCOPY VARCHAR2
13:
14: ) IS
15:
16: CURSOR c_fnd_user IS
17: SELECT employee_id,customer_id
18: FROM fnd_user
19: WHERE user_id = in_user;
20:

Line 18: FROM fnd_user

14: ) IS
15:
16: CURSOR c_fnd_user IS
17: SELECT employee_id,customer_id
18: FROM fnd_user
19: WHERE user_id = in_user;
20:
21:
22: CURSOR c_party(in_customer_id IN NUMBER) IS

Line 62: vn_customer_id fnd_user.customer_id%TYPE;

58: vn_party_id hz_parties.party_id%TYPE;
59: vc_party_type hz_parties.party_type%TYPE;
60: e_invalid_party_type EXCEPTION;
61:
62: vn_customer_id fnd_user.customer_id%TYPE;
63: vn_emp_id fnd_user.employee_id%TYPE;
64: vc_last VARCHAR2(50);
65: vc_first VARCHAR2(40);
66:

Line 63: vn_emp_id fnd_user.employee_id%TYPE;

59: vc_party_type hz_parties.party_type%TYPE;
60: e_invalid_party_type EXCEPTION;
61:
62: vn_customer_id fnd_user.customer_id%TYPE;
63: vn_emp_id fnd_user.employee_id%TYPE;
64: vc_last VARCHAR2(50);
65: vc_first VARCHAR2(40);
66:
67: --

Line 73: -- Getting the attached employee and customer to the fnd user

69: --
70: BEGIN
71:
72: --==========================================================
73: -- Getting the attached employee and customer to the fnd user
74: --==========================================================
75: OPEN c_fnd_user;
76: FETCH c_fnd_user
77: INTO vn_emp_id,

Line 75: OPEN c_fnd_user;

71:
72: --==========================================================
73: -- Getting the attached employee and customer to the fnd user
74: --==========================================================
75: OPEN c_fnd_user;
76: FETCH c_fnd_user
77: INTO vn_emp_id,
78: vn_customer_id;
79: CLOSE c_fnd_user;

Line 76: FETCH c_fnd_user

72: --==========================================================
73: -- Getting the attached employee and customer to the fnd user
74: --==========================================================
75: OPEN c_fnd_user;
76: FETCH c_fnd_user
77: INTO vn_emp_id,
78: vn_customer_id;
79: CLOSE c_fnd_user;
80:

Line 79: CLOSE c_fnd_user;

75: OPEN c_fnd_user;
76: FETCH c_fnd_user
77: INTO vn_emp_id,
78: vn_customer_id;
79: CLOSE c_fnd_user;
80:
81: --==========================================================
82: -- if the employee is attached to the fnd_user than we
83: -- select employee first and last name

Line 82: -- if the employee is attached to the fnd_user than we

78: vn_customer_id;
79: CLOSE c_fnd_user;
80:
81: --==========================================================
82: -- if the employee is attached to the fnd_user than we
83: -- select employee first and last name
84: --==========================================================
85: IF vn_emp_id IS NOT NULL THEN
86:

Line 97: -- if the employee is not attached to the fnd_user than we

93: out_contact_id := NULL;
94: out_customer_id := NULL;
95:
96: --==========================================================
97: -- if the employee is not attached to the fnd_user than we
98: -- select the customer and contact details
99: --==========================================================
100: ELSE
101:

Line 104: -- Getting the attached party to the Fnd User

100: ELSE
101:
102:
103: --==========================================================
104: -- Getting the attached party to the Fnd User
105: --==========================================================
106: OPEN c_party(vn_customer_id);
107: FETCH c_party
108: INTO vc_party_name,

Line 162: IF c_fnd_user%ISOPEN THEN

158: WHEN OTHERS THEN
159: IF c_party%ISOPEN THEN
160: CLOSE c_party;
161: END IF;
162: IF c_fnd_user%ISOPEN THEN
163: CLOSE c_fnd_user;
164: END IF;
165: IF c_employee%ISOPEN THEN
166: CLOSE c_employee;

Line 163: CLOSE c_fnd_user;

159: IF c_party%ISOPEN THEN
160: CLOSE c_party;
161: END IF;
162: IF c_fnd_user%ISOPEN THEN
163: CLOSE c_fnd_user;
164: END IF;
165: IF c_employee%ISOPEN THEN
166: CLOSE c_employee;
167: END IF;