APPS.FA_LEASE_PVT dependencies on FA_LEASES

Line 450: FROM FA_LEASES

446: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
447:
448: CURSOR C_LEASE_LESSOR IS
449: SELECT LEASE_ID
450: FROM FA_LEASES
451: WHERE LEASE_NUMBER = P_LEASE_NUMBER
452: AND LESSOR_ID = P_LESSOR_ID;
453:
454: L_LEASE_ID NUMBER:=NULL;

Line 633: FROM FA_LEASES

629: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
630:
631: CURSOR C_LEASE_LESSOR IS
632: SELECT LEASE_ID
633: FROM FA_LEASES
634: WHERE LEASE_NUMBER = P_LEASE_NUMBER
635: AND LESSOR_ID = P_LESSOR_ID;
636:
637: L_LEASE_ID NUMBER:=NULL;

Line 678: FROM FA_LEASES

674:
675: BEGIN
676:
677: SELECT LEASE_ID INTO L_LEASE_ID
678: FROM FA_LEASES
679: WHERE LEASE_ID = P_LEASE_ID;
680:
681: RETURN (TRUE);
682:

Line 753: FROM FA_LEASES A,

749: L_LEASE_NUMBER,
750: L_LESSOR_ID,
751: L_LESSOR_SITE_ID,
752: L_LESSOR_SITE_ORG_ID
753: FROM FA_LEASES A,
754: PO_VENDOR_SITES_ALL B
755: WHERE A.LEASE_ID = P_LEASE_ID
756: AND A.LESSOR_SITE_ID = B.VENDOR_SITE_ID;
757:

Line 1260: UPDATE FA_LEASES

1256: X_ATTRIBUTE_CATEGORY_CODE IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1257: IS
1258: BEGIN
1259: IF X_ROWID IS NOT NULL THEN
1260: UPDATE FA_LEASES
1261: SET
1262: LESSOR_ID = NVL(X_LESSOR_ID,LESSOR_ID),
1263: DESCRIPTION = NVL(X_DESCRIPTION,DESCRIPTION),
1264: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE,NULL,LAST_UPDATE_DATE,X_LAST_UPDATE_DATE),

Line 1285: UPDATE FA_LEASES

1281: ATTRIBUTE_CATEGORY_CODE = DECODE(X_ATTRIBUTE_CATEGORY_CODE,NULL,ATTRIBUTE_CATEGORY_CODE,FND_API.G_MISS_CHAR,NULL,X_ATTRIBUTE_CATEGORY_CODE),
1282: LESSOR_SITE_ID = NVL(X_LESSOR_SITE_ID,LESSOR_SITE_ID)
1283: WHERE ROWID = X_ROWID;
1284: ELSE
1285: UPDATE FA_LEASES
1286: SET
1287: LESSOR_ID = NVL(X_LESSOR_ID,LESSOR_ID),
1288: DESCRIPTION = NVL(X_DESCRIPTION,DESCRIPTION),
1289: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE,NULL,LAST_UPDATE_DATE,X_LAST_UPDATE_DATE),