APPS.XLA_00707_AAD_S_000005_PKG dependencies on FND_ORACLE_USERID

Line 143094: FROM fnd_oracle_userid

143090:
143091: -- select APPS owner
143092: SELECT oracle_username
143093: INTO p_apps_owner
143094: FROM fnd_oracle_userid
143095: WHERE read_only_flag = 'U'
143096: ;
143097:
143098: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 144392: FROM fnd_oracle_userid

144388:
144389: -- select APPS owner
144390: SELECT oracle_username
144391: INTO p_apps_owner
144392: FROM fnd_oracle_userid
144393: WHERE read_only_flag = 'U'
144394: ;
144395:
144396: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 145679: FROM fnd_oracle_userid

145675:
145676: -- select APPS owner
145677: SELECT oracle_username
145678: INTO p_apps_owner
145679: FROM fnd_oracle_userid
145680: WHERE read_only_flag = 'U'
145681: ;
145682:
145683: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 146973: FROM fnd_oracle_userid

146969:
146970: -- select APPS owner
146971: SELECT oracle_username
146972: INTO p_apps_owner
146973: FROM fnd_oracle_userid
146974: WHERE read_only_flag = 'U'
146975: ;
146976:
146977: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 148314: FROM fnd_oracle_userid

148310:
148311: -- select APPS owner
148312: SELECT oracle_username
148313: INTO p_apps_owner
148314: FROM fnd_oracle_userid
148315: WHERE read_only_flag = 'U'
148316: ;
148317:
148318: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 149924: FROM fnd_oracle_userid

149920:
149921: -- select APPS owner
149922: SELECT oracle_username
149923: INTO p_apps_owner
149924: FROM fnd_oracle_userid
149925: WHERE read_only_flag = 'U'
149926: ;
149927:
149928: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 151334: FROM fnd_oracle_userid

151330:
151331: -- select APPS owner
151332: SELECT oracle_username
151333: INTO p_apps_owner
151334: FROM fnd_oracle_userid
151335: WHERE read_only_flag = 'U'
151336: ;
151337:
151338: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 152905: FROM fnd_oracle_userid

152901:
152902: -- select APPS owner
152903: SELECT oracle_username
152904: INTO p_apps_owner
152905: FROM fnd_oracle_userid
152906: WHERE read_only_flag = 'U'
152907: ;
152908:
152909: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 154257: FROM fnd_oracle_userid

154253:
154254: -- select APPS owner
154255: SELECT oracle_username
154256: INTO p_apps_owner
154257: FROM fnd_oracle_userid
154258: WHERE read_only_flag = 'U'
154259: ;
154260:
154261: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 155493: FROM fnd_oracle_userid

155489:
155490: -- select APPS owner
155491: SELECT oracle_username
155492: INTO p_apps_owner
155493: FROM fnd_oracle_userid
155494: WHERE read_only_flag = 'U'
155495: ;
155496:
155497: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 156869: FROM fnd_oracle_userid

156865:
156866: -- select APPS owner
156867: SELECT oracle_username
156868: INTO p_apps_owner
156869: FROM fnd_oracle_userid
156870: WHERE read_only_flag = 'U'
156871: ;
156872:
156873: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 158279: FROM fnd_oracle_userid

158275:
158276: -- select APPS owner
158277: SELECT oracle_username
158278: INTO p_apps_owner
158279: FROM fnd_oracle_userid
158280: WHERE read_only_flag = 'U'
158281: ;
158282:
158283: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 159602: FROM fnd_oracle_userid

159598:
159599: -- select APPS owner
159600: SELECT oracle_username
159601: INTO p_apps_owner
159602: FROM fnd_oracle_userid
159603: WHERE read_only_flag = 'U'
159604: ;
159605:
159606: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 160838: FROM fnd_oracle_userid

160834:
160835: -- select APPS owner
160836: SELECT oracle_username
160837: INTO p_apps_owner
160838: FROM fnd_oracle_userid
160839: WHERE read_only_flag = 'U'
160840: ;
160841:
160842: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 162132: FROM fnd_oracle_userid

162128:
162129: -- select APPS owner
162130: SELECT oracle_username
162131: INTO p_apps_owner
162132: FROM fnd_oracle_userid
162133: WHERE read_only_flag = 'U'
162134: ;
162135:
162136: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 163391: FROM fnd_oracle_userid

163387:
163388: -- select APPS owner
163389: SELECT oracle_username
163390: INTO p_apps_owner
163391: FROM fnd_oracle_userid
163392: WHERE read_only_flag = 'U'
163393: ;
163394:
163395: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 164606: FROM fnd_oracle_userid

164602:
164603: -- select APPS owner
164604: SELECT oracle_username
164605: INTO p_apps_owner
164606: FROM fnd_oracle_userid
164607: WHERE read_only_flag = 'U'
164608: ;
164609:
164610: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 165929: FROM fnd_oracle_userid

165925:
165926: -- select APPS owner
165927: SELECT oracle_username
165928: INTO p_apps_owner
165929: FROM fnd_oracle_userid
165930: WHERE read_only_flag = 'U'
165931: ;
165932:
165933: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 167136: FROM fnd_oracle_userid

167132:
167133: -- select APPS owner
167134: SELECT oracle_username
167135: INTO p_apps_owner
167136: FROM fnd_oracle_userid
167137: WHERE read_only_flag = 'U'
167138: ;
167139:
167140: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 168372: FROM fnd_oracle_userid

168368:
168369: -- select APPS owner
168370: SELECT oracle_username
168371: INTO p_apps_owner
168372: FROM fnd_oracle_userid
168373: WHERE read_only_flag = 'U'
168374: ;
168375:
168376: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 169666: FROM fnd_oracle_userid

169662:
169663: -- select APPS owner
169664: SELECT oracle_username
169665: INTO p_apps_owner
169666: FROM fnd_oracle_userid
169667: WHERE read_only_flag = 'U'
169668: ;
169669:
169670: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 170977: FROM fnd_oracle_userid

170973:
170974: -- select APPS owner
170975: SELECT oracle_username
170976: INTO p_apps_owner
170977: FROM fnd_oracle_userid
170978: WHERE read_only_flag = 'U'
170979: ;
170980:
170981: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 172364: FROM fnd_oracle_userid

172360:
172361: -- select APPS owner
172362: SELECT oracle_username
172363: INTO p_apps_owner
172364: FROM fnd_oracle_userid
172365: WHERE read_only_flag = 'U'
172366: ;
172367:
172368: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 173935: FROM fnd_oracle_userid

173931:
173932: -- select APPS owner
173933: SELECT oracle_username
173934: INTO p_apps_owner
173935: FROM fnd_oracle_userid
173936: WHERE read_only_flag = 'U'
173937: ;
173938:
173939: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 175262: FROM fnd_oracle_userid

175258:
175259: -- select APPS owner
175260: SELECT oracle_username
175261: INTO p_apps_owner
175262: FROM fnd_oracle_userid
175263: WHERE read_only_flag = 'U'
175264: ;
175265:
175266: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 176469: FROM fnd_oracle_userid

176465:
176466: -- select APPS owner
176467: SELECT oracle_username
176468: INTO p_apps_owner
176469: FROM fnd_oracle_userid
176470: WHERE read_only_flag = 'U'
176471: ;
176472:
176473: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 177696: FROM fnd_oracle_userid

177692:
177693: -- select APPS owner
177694: SELECT oracle_username
177695: INTO p_apps_owner
177696: FROM fnd_oracle_userid
177697: WHERE read_only_flag = 'U'
177698: ;
177699:
177700: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 178965: FROM fnd_oracle_userid

178961:
178962: -- select APPS owner
178963: SELECT oracle_username
178964: INTO p_apps_owner
178965: FROM fnd_oracle_userid
178966: WHERE read_only_flag = 'U'
178967: ;
178968:
178969: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 180259: FROM fnd_oracle_userid

180255:
180256: -- select APPS owner
180257: SELECT oracle_username
180258: INTO p_apps_owner
180259: FROM fnd_oracle_userid
180260: WHERE read_only_flag = 'U'
180261: ;
180262:
180263: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 181553: FROM fnd_oracle_userid

181549:
181550: -- select APPS owner
181551: SELECT oracle_username
181552: INTO p_apps_owner
181553: FROM fnd_oracle_userid
181554: WHERE read_only_flag = 'U'
181555: ;
181556:
181557: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 182789: FROM fnd_oracle_userid

182785:
182786: -- select APPS owner
182787: SELECT oracle_username
182788: INTO p_apps_owner
182789: FROM fnd_oracle_userid
182790: WHERE read_only_flag = 'U'
182791: ;
182792:
182793: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 184199: FROM fnd_oracle_userid

184195:
184196: -- select APPS owner
184197: SELECT oracle_username
184198: INTO p_apps_owner
184199: FROM fnd_oracle_userid
184200: WHERE read_only_flag = 'U'
184201: ;
184202:
184203: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 185609: FROM fnd_oracle_userid

185605:
185606: -- select APPS owner
185607: SELECT oracle_username
185608: INTO p_apps_owner
185609: FROM fnd_oracle_userid
185610: WHERE read_only_flag = 'U'
185611: ;
185612:
185613: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 187019: FROM fnd_oracle_userid

187015:
187016: -- select APPS owner
187017: SELECT oracle_username
187018: INTO p_apps_owner
187019: FROM fnd_oracle_userid
187020: WHERE read_only_flag = 'U'
187021: ;
187022:
187023: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 188429: FROM fnd_oracle_userid

188425:
188426: -- select APPS owner
188427: SELECT oracle_username
188428: INTO p_apps_owner
188429: FROM fnd_oracle_userid
188430: WHERE read_only_flag = 'U'
188431: ;
188432:
188433: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 189839: FROM fnd_oracle_userid

189835:
189836: -- select APPS owner
189837: SELECT oracle_username
189838: INTO p_apps_owner
189839: FROM fnd_oracle_userid
189840: WHERE read_only_flag = 'U'
189841: ;
189842:
189843: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 191249: FROM fnd_oracle_userid

191245:
191246: -- select APPS owner
191247: SELECT oracle_username
191248: INTO p_apps_owner
191249: FROM fnd_oracle_userid
191250: WHERE read_only_flag = 'U'
191251: ;
191252:
191253: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 192485: FROM fnd_oracle_userid

192481:
192482: -- select APPS owner
192483: SELECT oracle_username
192484: INTO p_apps_owner
192485: FROM fnd_oracle_userid
192486: WHERE read_only_flag = 'U'
192487: ;
192488:
192489: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 193895: FROM fnd_oracle_userid

193891:
193892: -- select APPS owner
193893: SELECT oracle_username
193894: INTO p_apps_owner
193895: FROM fnd_oracle_userid
193896: WHERE read_only_flag = 'U'
193897: ;
193898:
193899: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 195305: FROM fnd_oracle_userid

195301:
195302: -- select APPS owner
195303: SELECT oracle_username
195304: INTO p_apps_owner
195305: FROM fnd_oracle_userid
195306: WHERE read_only_flag = 'U'
195307: ;
195308:
195309: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 196628: FROM fnd_oracle_userid

196624:
196625: -- select APPS owner
196626: SELECT oracle_username
196627: INTO p_apps_owner
196628: FROM fnd_oracle_userid
196629: WHERE read_only_flag = 'U'
196630: ;
196631:
196632: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 197951: FROM fnd_oracle_userid

197947:
197948: -- select APPS owner
197949: SELECT oracle_username
197950: INTO p_apps_owner
197951: FROM fnd_oracle_userid
197952: WHERE read_only_flag = 'U'
197953: ;
197954:
197955: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 199216: FROM fnd_oracle_userid

199212:
199213: -- select APPS owner
199214: SELECT oracle_username
199215: INTO p_apps_owner
199216: FROM fnd_oracle_userid
199217: WHERE read_only_flag = 'U'
199218: ;
199219:
199220: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 200452: FROM fnd_oracle_userid

200448:
200449: -- select APPS owner
200450: SELECT oracle_username
200451: INTO p_apps_owner
200452: FROM fnd_oracle_userid
200453: WHERE read_only_flag = 'U'
200454: ;
200455:
200456: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 201688: FROM fnd_oracle_userid

201684:
201685: -- select APPS owner
201686: SELECT oracle_username
201687: INTO p_apps_owner
201688: FROM fnd_oracle_userid
201689: WHERE read_only_flag = 'U'
201690: ;
201691:
201692: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 202924: FROM fnd_oracle_userid

202920:
202921: -- select APPS owner
202922: SELECT oracle_username
202923: INTO p_apps_owner
202924: FROM fnd_oracle_userid
202925: WHERE read_only_flag = 'U'
202926: ;
202927:
202928: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 204135: FROM fnd_oracle_userid

204131:
204132: -- select APPS owner
204133: SELECT oracle_username
204134: INTO p_apps_owner
204135: FROM fnd_oracle_userid
204136: WHERE read_only_flag = 'U'
204137: ;
204138:
204139: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 205346: FROM fnd_oracle_userid

205342:
205343: -- select APPS owner
205344: SELECT oracle_username
205345: INTO p_apps_owner
205346: FROM fnd_oracle_userid
205347: WHERE read_only_flag = 'U'
205348: ;
205349:
205350: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 206557: FROM fnd_oracle_userid

206553:
206554: -- select APPS owner
206555: SELECT oracle_username
206556: INTO p_apps_owner
206557: FROM fnd_oracle_userid
206558: WHERE read_only_flag = 'U'
206559: ;
206560:
206561: IF (C_LEVEL_STATEMENT >= g_log_level) THEN