eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_LEASE_PVT dependencies on PO_VENDOR_SITES_ALL

Line 236: P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,

232: -------------------------------------------
233: -- CHECK FOR CHECK LESSOR SITE
234: -------------------------------------------
235: FUNCTION CHECK_LESSOR_SITE_ID (
236: P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
237: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
238: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
239: X_LESSOR_SITE_ORG_ID OUT NOCOPY NUMBER,
240: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

Line 237: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,

233: -- CHECK FOR CHECK LESSOR SITE
234: -------------------------------------------
235: FUNCTION CHECK_LESSOR_SITE_ID (
236: P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
237: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
238: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
239: X_LESSOR_SITE_ORG_ID OUT NOCOPY NUMBER,
240: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
241:

Line 249: ,PO_VENDOR_SITES_ALL PVS

245: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
246: ,PVS.ORG_ID LESSOR_SITE_ORG_ID
247: FROM GL_SETS_OF_BOOKS SOB
248: ,HR_ALL_ORGANIZATION_UNITS HAO
249: ,PO_VENDOR_SITES_ALL PVS
250: ,AP_SYSTEM_PARAMETERS_ALL AP
251: WHERE PVS.VENDOR_ID = P_VENDOR_ID
252: AND PVS.VENDOR_SITE_ID = P_VENDOR_SITE_ID
253: AND PVS.ORG_ID IS NOT NULL

Line 263: ,PO_VENDOR_SITES_ALL PVS

259: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
260: ,PVS.ORG_ID LESSOR_SITE_ORG_ID
261: FROM GL_SETS_OF_BOOKS SOB
262: ,AP_SYSTEM_PARAMETERS_ALL AP
263: ,PO_VENDOR_SITES_ALL PVS
264: WHERE PVS.VENDOR_ID = P_VENDOR_ID
265: AND PVS.VENDOR_SITE_ID = P_VENDOR_SITE_ID
266: AND PVS.ORG_ID IS NULL
267: AND AP.ORG_ID IS NULL

Line 305: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,

301: ------------------------------------------
302: -- CHECK FOR CHECK LESSOR SITE CODE
303: ------------------------------------------
304: FUNCTION CHECK_LESSOR_SITE_CODE (
305: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
306: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
307: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
308: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
309: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

Line 306: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,

302: -- CHECK FOR CHECK LESSOR SITE CODE
303: ------------------------------------------
304: FUNCTION CHECK_LESSOR_SITE_CODE (
305: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
306: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
307: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
308: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
309: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
310: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

Line 307: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,

303: ------------------------------------------
304: FUNCTION CHECK_LESSOR_SITE_CODE (
305: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
306: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
307: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
308: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
309: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
310: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
311:

Line 308: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,

304: FUNCTION CHECK_LESSOR_SITE_CODE (
305: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
306: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
307: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
308: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
309: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
310: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
311:
312: CURSOR C_LESSOR_SITE_CODE IS

Line 318: ,PO_VENDOR_SITES_ALL PVS

314: PVS.VENDOR_SITE_ID
315: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
316: FROM GL_SETS_OF_BOOKS SOB
317: ,HR_ALL_ORGANIZATION_UNITS HAO
318: ,PO_VENDOR_SITES_ALL PVS
319: ,AP_SYSTEM_PARAMETERS_ALL AP
320: WHERE PVS.VENDOR_ID = P_VENDOR_ID
321: AND PVS.VENDOR_SITE_CODE = P_VENDOR_SITE_CODE
322: AND PVS.ORG_ID IS NOT NULL

Line 332: ,PO_VENDOR_SITES_ALL PVS

328: SELECT PVS.VENDOR_SITE_ID
329: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
330: FROM GL_SETS_OF_BOOKS SOB
331: ,AP_SYSTEM_PARAMETERS_ALL AP
332: ,PO_VENDOR_SITES_ALL PVS
333: WHERE PVS.VENDOR_ID = P_VENDOR_ID
334: AND PVS.VENDOR_SITE_CODE = P_VENDOR_SITE_CODE
335: AND PVS.ORG_ID IS NULL
336: AND AP.ORG_ID IS NULL

Line 761: PO_VENDOR_SITES_ALL B

757: L_LESSOR_ID,
758: L_LESSOR_SITE_ID,
759: L_LESSOR_SITE_ORG_ID
760: FROM FA_LEASES A,
761: PO_VENDOR_SITES_ALL B
762: WHERE A.LEASE_ID = P_LEASE_ID
763: AND A.LESSOR_SITE_ID = B.VENDOR_SITE_ID;
764:
765: IF P_LESSOR_SITE_ORG_ID = L_LESSOR_SITE_ORG_ID THEN