DBA Data[Home] [Help]

APPS.ASO_WORKFLOW_QUOTE_PVT dependencies on FND_USER

Line 108: CURSOR c_fnd_user(lc_user_id NUMBER) IS

104: l_UserType VARCHAR2(30) := 'ALL';
105: l_messageName WF_MESSAGES.NAME%TYPE;
106: l_msgEnabled VARCHAR2(3) :='Y';
107:
108: CURSOR c_fnd_user(lc_user_id NUMBER) IS
109: SELECT user_name
110: FROM fnd_user
111: WHERE user_id = lc_user_id;
112:

Line 110: FROM fnd_user

106: l_msgEnabled VARCHAR2(3) :='Y';
107:
108: CURSOR c_fnd_user(lc_user_id NUMBER) IS
109: SELECT user_name
110: FROM fnd_user
111: WHERE user_id = lc_user_id;
112:
113: BEGIN
114:

Line 167: FOR c_fnd_user_rec In c_fnd_user(l_contract_requester_id)

163: l_quote_number := c_quote_rec.quote_number;
164: l_partyId := c_quote_rec.party_id;
165: END LOOP;
166:
167: FOR c_fnd_user_rec In c_fnd_user(l_contract_requester_id)
168: LOOP
169: l_contract_requester := c_fnd_user_rec.user_name;
170: END LOOP;
171:

Line 169: l_contract_requester := c_fnd_user_rec.user_name;

165: END LOOP;
166:
167: FOR c_fnd_user_rec In c_fnd_user(l_contract_requester_id)
168: LOOP
169: l_contract_requester := c_fnd_user_rec.user_name;
170: END LOOP;
171:
172: l_msite_id := null;
173: