APPS.ASG_PUB_ITEM_PKG dependencies on FND_ORACLE_USERID

Line 82: from fnd_oracle_userid

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

Line 90: from fnd_oracle_userid

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

Line 98: from fnd_oracle_userid

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

Line 284: from fnd_oracle_userid

280:
281: if (l_custom_flag = 'N' ) THEN
282: begin
283: select oracle_username into l_base_owner
284: from fnd_oracle_userid
285: where oracle_id = X_BASE_OWNER;
286: exception
287: when others then
288: l_base_owner := x_base_owner;

Line 292: from fnd_oracle_userid

288: l_base_owner := x_base_owner;
289: end;
290: begin
291: select oracle_username into l_inq_owner
292: from fnd_oracle_userid
293: where oracle_id = X_INQ_OWNER;
294: exception
295: when others then
296: l_inq_owner := x_inq_owner;

Line 300: from fnd_oracle_userid

296: l_inq_owner := x_inq_owner;
297: end;
298: begin
299: select oracle_username into l_access_owner
300: from fnd_oracle_userid
301: where oracle_id = X_ACCESS_OWNER;
302: exception
303: when others then
304: l_access_owner := x_access_owner;