APPS.ASG_PUB_ITEM_PKG dependencies on FND_ORACLE_USERID

Line 81: from fnd_oracle_userid

77: begin
78:
79: begin
80: select oracle_username into l_base_owner
81: from fnd_oracle_userid
82: where oracle_id = X_BASE_OWNER;
83: exception
84: when others then
85: l_base_owner := x_base_owner;

Line 89: from fnd_oracle_userid

85: l_base_owner := x_base_owner;
86: end;
87: begin
88: select oracle_username into l_inq_owner
89: from fnd_oracle_userid
90: where oracle_id = X_INQ_OWNER;
91: exception
92: when others then
93: l_inq_owner := x_inq_owner;

Line 97: from fnd_oracle_userid

93: l_inq_owner := x_inq_owner;
94: end;
95: begin
96: select oracle_username into l_access_owner
97: from fnd_oracle_userid
98: where oracle_id = X_ACCESS_OWNER;
99: exception
100: when others then
101: l_access_owner := x_access_owner;

Line 280: from fnd_oracle_userid

276:
277: if (l_custom_flag = 'N' ) THEN
278: begin
279: select oracle_username into l_base_owner
280: from fnd_oracle_userid
281: where oracle_id = X_BASE_OWNER;
282: exception
283: when others then
284: l_base_owner := x_base_owner;

Line 288: from fnd_oracle_userid

284: l_base_owner := x_base_owner;
285: end;
286: begin
287: select oracle_username into l_inq_owner
288: from fnd_oracle_userid
289: where oracle_id = X_INQ_OWNER;
290: exception
291: when others then
292: l_inq_owner := x_inq_owner;

Line 296: from fnd_oracle_userid

292: l_inq_owner := x_inq_owner;
293: end;
294: begin
295: select oracle_username into l_access_owner
296: from fnd_oracle_userid
297: where oracle_id = X_ACCESS_OWNER;
298: exception
299: when others then
300: l_access_owner := x_access_owner;